Submit data to MySQL

Question

It is 3rd day I am unable to send data to MySQL.
here are the resources db name: school table name: staff connection.php contains

<?php
$db = mysqli_connect('localhost', 'root', '', 'school') or die("Unable to connect to MySQL");
?>

and add-teacher.php contains

<form method="post" action="add-teacher.php" >
    <input type="text" name="firstname"  />
    <input type="text" name="lastname"   />

    <input type="submit" name="submit" value="Confirm" />
</form>

<?php
if (isset($_POST['submit'])) {
    $firstname = $_POST['firstname'];
    $lastname = $_POST['lastname'];

    $query = "INSERT INTO `staff` (`fname`, `lname`) VALUES ('$firstname', '$lastname')";

    if (!mysql_query($query)) {
        die("DAMMIT");
    } else {
        echo "Success";
    }
}
?>

I could not fins any error despite no row found at phpmyadmin.
add-teacher.php:

post the error with the description you are getting while submitting the data. check with the connection you are creating. — shishir, Oct 05 '17 at 07:32

score 1 · Accepted Answer · answered Oct 05 '17 at 07:29

1

You are establish connection using mysqli and use mysql in run query. As mysql is totally removed in current version.

Use

if(!mysqli_query($db,$query))

Instead of

if(!mysql_query($query))

answered Oct 05 '17 at 07:29

Ajay Korat

716
4
14

sorry no success... – Cheeta Oct 05 '17 at 07:37
Can you please post error? – Ajay Korat Oct 05 '17 at 07:38
i removed "i" from mysqli_connect and tried no error found but no success too.. – Cheeta Oct 05 '17 at 07:41
if(!mysqli_query($dbObj,$query)) – Cheeta Oct 05 '17 at 07:43
No. no. you should go with mysqli. can you please echo $query and put outout direct in phpmyadmin and tell me success or not? – Ajay Korat Oct 05 '17 at 07:43
has two parameters ut i have not declared $dbObj anywhere – Cheeta Oct 05 '17 at 07:43
here is the error – Cheeta Oct 05 '17 at 07:44
Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\Xenon\add-teacher.php on line 43 – Cheeta Oct 05 '17 at 07:45
but you are passing two parameters then how can this error occur? – Ajay Korat Oct 05 '17 at 07:46
and when i use if(!mysqli_query($dbObj,$query)) it says Notice: Undefined variable: dbObj in C:\xampp\htdocs\Xenon\add-teacher.php on line 43 Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\Xenon\add-teacher.php on line 43 – Cheeta Oct 05 '17 at 07:46
Please not use $dbObj its nothing. please go with $db and make sure your connection.php file is included in add-teacher.php – Ajay Korat Oct 05 '17 at 07:47
yes it has two parameters but it says undefined variable $dbObj – Cheeta Oct 05 '17 at 07:48
but why you usgin $dbObj please use $db. – Ajay Korat Oct 05 '17 at 07:49
you made it... thanks... – Cheeta Oct 05 '17 at 07:49
Always happy to help. :) – Ajay Korat Oct 05 '17 at 07:50

Submit data to MySQL

1 Answers1