Unable to call php function if sql record exists

Question

I have this code:

<?php
$mysql_host='localhost';
$mysql_user='root';
$mysql_password='you cant know mypassword';

mysql_connect($mysql_host,$mysql_user,$mysql_password);
@mysql_select_db('attempt');



?>


<?php
$sql="IF NOT EXISTS ( SELECT person FROM kid WHERE Subs=45 )
BEGIN
    echo 'hey'
END"

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


if ($conn->query($sql) === TRUE) {
    echo "Done";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}


?>

The php page is supposed to echo'hey' because no such record exists but the page itself is not even loading at all but returning a HTTP localhost 500 error saying that localhost cannot handle the request.

I know I'm doing something wrong but I'm not sure exactly what.Please help

the `mysql` api is deprecated and has been removed from PHP 7+ — Professor Abronsius, Jul 23 '18 at 10:02
If you are developing new code you should consider not using [obsolete/deprecated functions](http://php.net/manual/en/function.mysql-connect.php) — Cleptus, Jul 23 '18 at 10:10

score 1 · Answer 1 · answered Jul 23 '18 at 10:04

1

Use following code as mysql_connect is deprecated

$connection = mysqli_connect('localhost', 'username', 'password', 'database');
mysqli_query($connection, 'Your query');

answered Jul 23 '18 at 10:04

Rajinder

1,131
1
14
29

score 0 · Accepted Answer · 2018-07-23T10:29:35.093

0

Okay so delete all and use like that:

<?php

$mysqli_host = 'localhost';
$mysqli_user = 'root';
$mysqli_password = 'yourPassword';
$mysqli_database = 'yourDatabase';

$mysqli = new mysqli($mysqli_host, $mysqli_user, $mysqli_password, $mysqli_database);

if ($mysqli->connect_errno) {
    die("Connection failed: " . $conn->connect_error);
}

$query = mysqli_query($mysqli, "SELECT person FROM kid WHERE Subs=45");
$result = mysqli_num_rows($query);

if($result > 0) {
    echo("Exist");     
} else {
    echo("Doesn't exist");
}

?>

edited Jul 23 '18 at 10:29

answered Jul 23 '18 at 10:03

https 500 error localhost cannot handle this request – Jul 23 '18 at 10:15
So i think there is some syntax problem in your functions – Jul 23 '18 at 10:18

Unable to call php function if sql record exists

2 Answers2