Search code examples
phphtmlwordpressparse-error

Parse error: syntax error, unexpected end of file Issue


I am getting the Parse error: syntax error, unexpected end of file regardless of what I change/add to my code, the error constantly tells me that there is something wrong with my last line.

My PHP file should be saving form input to the database but this error seems to be getting in the way and I cannot figure out what is causing it.

PHP Code

<?php

function so56917978_upload_callback() {  

    //Register variables

    $adddate = $_POST['adddate'];
    $addcontact = $_POST['addcontact'];
    $adda = $_POST['adda'];
    $addb = $_POST['addb'];
    $addincome = $_POST['addincome'];
    $addpayment = $_POST['adddate'];
    $addsubbie = $_POST['addsubbie'];
    $addcust = $POST['addcust'];

    //connect with Database

    $host_name = 'zzz.hosting-data.io';
    $database = 'zzz';
    $user_name = 'zysql_connect($host_name, $user_name, $password);

    if(!$connect) {
        die('Not Connected To Server');
    }

    //Connection to database
    if(!mysql_select_db($connect, $database)) {
        echo 'Database Not Selected';
    }
    $query = mysql_query($connect,"SELECT * FROM table WHERE adddate = '$adddate' OR addcontact = '$addcontact' OR adda= '$adda' OR addb = '$addb' OR addincome = '$addincome' OR addpayment = '$addpayment' OR addsubbie = '$addsubbie' OR addcust = '$addcust'");
    $sql = "INSERT INTO table (adddate, addcontact, adda, addb, addincome, addpayment, addsubbie, addcust) VALUES ('$adddate', '$addcontact', '$adda', '$addb', '$addincome', '$addpayment', '$addsubbie', '$addcust')";

    if (!mysql_query($connect,$sql)) {
        die('Error: ' . mysql_error($connect));
    }
    echo "1 record added";

    mysql_close($connect);

Solution

  • <?php
    
    function so56917978_upload_callback() {  
    
        //Register variables
    
        $adddate = $_POST['adddate'];
        $addcontact = $_POST['addcontact'];
        $adda = $_POST['adda'];
        $addb = $_POST['addb'];
        $addincome = $_POST['addincome'];
        $addpayment = $_POST['adddate'];
        $addsubbie = $_POST['addsubbie'];
        $addcust = $POST['addcust'];
    
        //connect with Database
    
        $host_name = 'zzz.hosting-data.io';
        $database = 'zzz';
        $user_name = 'zysql_connect($host_name, $user_name, $password);
    
        if(!$connect) {
            die('Not Connected To Server');
        }
    
        //Connection to database
        if(!mysql_select_db($connect, $database)) {
            echo 'Database Not Selected';
        }
        $query = mysql_query($connect,"SELECT * FROM table WHERE adddate = '$adddate' OR addcontact = '$addcontact' OR adda= '$adda' OR addb = '$addb' OR addincome = '$addincome' OR addpayment = '$addpayment' OR addsubbie = '$addsubbie' OR addcust = '$addcust'");
        $sql = "INSERT INTO table (adddate, addcontact, adda, addb, addincome, addpayment, addsubbie, addcust) VALUES ('$adddate', '$addcontact', '$adda', '$addb', '$addincome', '$addpayment', '$addsubbie', '$addcust')";
    
        if (!mysql_query($connect,$sql)) {
            die('Error: ' . mysql_error($connect));
        }
        echo "1 record added";
    
        mysql_close($connect);
    }
    

    You forgot the closing }