Nrthugu

The below query wont insert to database, I had tried this query on my database so I am quite sure that the query is working. I also added the dbcon.php below.

<?php

require '../api/dbcon.php';



$stmt=$conn->prepare("INSERT INTO joborder (AirCondition,

                                           CarpentryMasonry,

                                           ElectricalWorks,

                                           Plumbing,

                                           Welding,

                                           Campus,

                                           priorityId, 

                                           RequestorName,

                                           UserJobDescription,

                                           SerialCode

                                           ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" );



 $stmt->bind_param('ssssssssss',

                $airConditioning,

                $masonryCarpentry,

                $electrical,

                $plumbing,

                $welding,

                $campus,

                $priority,

                $requester,

                $userJobDescription,

                $serialCode);



$airConditioning = "check";

$masonryCarpentry = "check";

$electrical = "check";

$plumbing = "check";

$welding = "check";

$campus =  'NA';

$priority =  '1';

$requester = "m";

$userJobDescription ="test";

//create serial code

$serialCode= "na12321";



?>

dbcon.php

      <?php

     $dbhost = 'localhost';

     $dbuser = 'root';

     $dbpass = '';

     $dbtable = "table";

     $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbtable);



     if(!$conn ){

        die('Could not connect: ' . mysqli_error());

     }

  ?>

you're using a bad error reporting mode, and thus need to meticulously check for errors everywhere, but you're not.

on not-dbcon.php on line 4 you're not checking that $conn->prepare succeeded, do that, it returns bool(false) if there was an error. on line 16 you're not checking that $stmt->bind_param succeeded, do that, it returns bool(false) if there was an error. or better yet, don't do that, just convert return-value-error-reporting into exception-error-reporting, by running $conn->report_mode = MYSQLI_REPORT_ALL; immediately after creating the object.

... and most importantly, seems you forgot to run $stmt->execute(), which actually executes the query, which obviously explains why you're not inserting anything.

<?php



$servername = "localhost";

$username = "root";

$password = "123456";

$database = "inventory";

// Create connection

$conn = new mysqli($servername, $username, $password, $database);



$stat = $conn->prepare("INSERT INTO salary (name, salary, job) values (?, ?, ?)");



$name = 'test';

$salary = '21123';

$job = 'demo';



$stat->bind_param($name,$salary, $job );



// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}



// prepare and bind

$stmt = $conn->prepare("INSERT INTO salary (name, salary, job) VALUES (?, ?, ?)");

$stmt->bind_param("sss", $firstname, $lastname, $email);



// set parameters and execute

$firstname = "Johnqqq";

$lastname = "123123";

$email = "sdadsad";

$stmt->execute();



echo "New records created successfully";



$stmt->close();

$conn->close();



?>