@ 2014-08-18T18:08:06Z <?php
$con=mysqli_connect("localhost","root","Krishna19942","newhopehospital");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// escape variables for security
$fname = mysqli_real_escape_string($con, $_POST['fname']);
$lname = mysqli_real_escape_string($con, $_POST['lname']);
$address= mysqli_real_escape_string($con, $post['address']);
$pnum= mysqli_real_escape_string($con, $post['pnum']);
$emptype= mysqli_real_escape_string($con, $post['emptype']);
$wardname= mysqli_real_escape_string($con, $post['wardname']);
$speciality= mysqli_real_escape_string($con, $post['speciality']);
$sql="INSERT INTO doctordetails values ('','$fname','$lname','$address','$pnum','$emptype','$wardname','$speciality')";
$sql="update warddetails set Ward_Charge='$fname' where WardName='$wardname'";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
echo "1 record added";
echo "<br><br>";
//$sql="select * from kr.personal";
//testing 2.......//
//if($_POST["fname"] && $_POST["lname"] && $_POST["address"] && $_POST["pnum"] && $_POST["emptype"] && $_POST["wardname"] && $_POST["speciality"] )
//{
// $servername="localhost";
// $username="root";
// $password="Krishna19942";
// $conn= mysql_connect($servername,$username,$password)or die(mysql_error());
// mysql_select_db("newhopehospital",$conn);
// $sql="insert into doctordetails values ('$fname','$lname','$address','$pnum','$emptype','$wardname','$speciality')";
// $result=mysql_query($sql,$conn) or die(mysql_error());
//}
//else print"invaild input data";
mysqli_close($con);
header("Location: ../new_doctor.php");
exit;
?>
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 7.0.0 - 7.0.20 , 7.1.0 - 7.1.25 , 7.2.0 - 7.2.33 , 7.3.0 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.28 , 8.2.0 - 8.2.18 , 8.3.0 - 8.3.7 Fatal error: Uncaught Error: Call to undefined function mysqli_connect() in /in/f65IR:2
Stack trace:
#0 {main}
thrown in /in/f65IR on line 2
Process exited with code 255 . Output for 5.0.0 - 5.0.5 , 5.1.0 - 5.1.6 , 5.2.0 - 5.2.17 , 5.3.0 - 5.3.29 , 5.4.0 - 5.4.45 , 5.5.24 - 5.5.35 , 5.6.8 - 5.6.28 Fatal error: Call to undefined function mysqli_connect() in /in/f65IR on line 2
Process exited with code 255 . Output for 4.4.5 - 4.4.9 Fatal error: Call to undefined function: mysqli_connect() in /in/f65IR on line 2
Process exited with code 255 . Output for 4.3.2 - 4.3.11 , 4.4.0 - 4.4.4 Fatal error: Call to undefined function: mysqli_connect() in /in/f65IR on line 2
Process exited with code 255 . Output for 4.3.0 - 4.3.1 Fatal error: Call to undefined function: mysqli_connect() in /in/f65IR on line 2
preferences:dark mode live preview
204.17 ms | 401 KiB | 328 Q