Error querying database when inserting into cpanel phpmyadmin

Question

<?php
    $fname=$_POST['fname'];
    $mname=$_POST['mname'];
    $lname=$_POST['lname'];
    $college_name=$_POST['college_name'];
    $semester=$_POST['semester'];
    $contact=$_POST['contact'];
    $email=$_POST['email'];


    $dbc = mysql_connect('localhost','XXXX',"XXXX",'XXXXX')
            or die('error connecting to MYSQL server');
    echo kkk;
    $query = "INSERT INTO tab_m_registration(fname, mname, lname, college_name, semester, contact, email)".
            "VALUES(`$fname`, `$mname`, `$lname`, `$college_name`, `$semester`, `$contact`, `$email`)";
            echo $query;
            $result=mysql_query($query,$dbc) or die('error querying database');

            echo $result;

            echo 'Thanx for submitting the form. <br/>';
            mysql_close($dbc);

        ?>

Actually I don't understand where is the problem.

$result = mysql_query($query, $dbc)

is not working I think.

I first tried mysqli_query() and it got problem. Then I tried this

$result = mysql_query($dbc, $query)

and I get an error "argument 1 should be string" in mysql_query().

I swapped the values and finally used this mysql_query($query, $dbc).

It shows the value passing through echo.

But still there's a problem inserting the data in the database table. Please help me out.

Try enclosing your query variables in quotes instead of back ticks — Hexana, Nov 22 '15 at 09:24
Thank you for the clue.But actually i am not getting the thing what are you telling about.Can you please show me an example? — Partha Pratim Deb, Nov 22 '15 at 09:34
I have replaced the backticks with single quotes but,problem still exists. — Partha Pratim Deb, Nov 22 '15 at 09:42
Once upon a time the `mysql_` functions have been deprecated... — Jan, Nov 22 '15 at 09:45
You need to do some reading my friend. http://www.w3schools.com/php/php_mysql_insert.asp. By passing un-sanitised variables you are leaving yourself open to injections !! — Hexana, Nov 22 '15 at 09:46
Thank you for idea of un-sanitised variables.But how can i solve the problem of mysql_ .If it is deprecated,what are the alternatives??Please help. — Partha Pratim Deb, Nov 22 '15 at 10:00
There have actually two problems.1st one is user privilege and 2nd one is that backticks.Thank you.it is solved now. — Partha Pratim Deb, Nov 22 '15 at 13:31

score 1 · Accepted Answer · answered Nov 22 '15 at 09:54

1

You will need to investigate the error further (get some error messages). You could use a try/catch block to get more error messages (are the fields all set up, etc.). Consider the following code but bear in mind that it is still wide open to SQL injection (just to get an error message):

try {
    $db = mysqli_connect("host", "user", "password", "database");
    if ($db->connect_errno)
        throw new Exception("Connection to the database failed: " . $db->connect_error);

    $sql = "INSERT INTO tab_m_registration (`fname`, `mname`, `lname`, `college_name`, `semester`, `contact`, `email`) ";
    $sql .= "VALUES(`$fname`, `$mname`, `$lname`, `$college_name`, `$semester`, `$contact`, `$email`)";

    if (!$db->query($sql))
        throw new Exception("Error Inserting Data " . $db->error);

    mysqli_close($db);
} catch (Exception $e) {
    echo $e->getMessage();
}

answered Nov 22 '15 at 09:54

Jan

42,290
8
54
79

Warning: mysqli_connect(): (42000/1044): Access denied for user 'isoftech_ppd'@'localhost' to database 'isoftech_coaching' in /home/isoftech/public_html/reginsert_interest.php on line 53
Here line 53 means:$db = mysqli_connect("localhost", "isoftech_ppd", "XXXX", "isoftech_coaching");

Fatal error: Call to a member function query() on a non-object in /home/isoftech/public_html/reginsert_interest.php on line 60

Here line 60 means:if (!$db->query($sql))
– Partha Pratim Deb Nov 22 '15 at 10:07
Well, there you go, you are lacking permissions. This needs to be fixed first! – Jan Nov 22 '15 at 11:09
Please tell me how??I already selected all privileges in the database. – Partha Pratim Deb Nov 22 '15 at 12:08
@ParthaPratimDeb This is a site for programming and code not a site to find people doing your work :-) – Jan Nov 22 '15 at 13:17
Its solved.Actually i there have no privilege for the user.I set it.Thank you. – Partha Pratim Deb Nov 22 '15 at 13:30
@ParthaPratimDeb: Consider accepting an answer then. – Jan Nov 22 '15 at 15:36

Error querying database when inserting into cpanel phpmyadmin

1 Answers1