PHP - Insert Update Delete Search Data in MySQL

Question

Seem to be having a problem. As line 52 if (mysqli_num_rows{$search_Result}) is giving me the Parse error: syntax error, unexpected.

<?php

$host = "localhost";
$user = "root";
$password = "";
$database ="zebase";
$id="";
$name="";
$address="";
$actnum="";
$status="";
$remarks="";

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
function getPosts()
{

$Post =  array();
$POST[0]= $_POST['id'];
$POST[1]= $_POST['name'];
$POST[2]= $_POST['address'];
$POST[3]= $_POST['actnum'];
$POST[4]= $_POST['status'];
$POST[5]= $_POST['remarks'];
return $posts;
}

if(isset($_POST['search']))
{
$data = getPosts();

$search_Query = "SELECT * FROM thetable WHERE id = $data[o]";

$search_Result = mysqli_query($conn, $search_Query);
}

if ($search_Result)
{

if (mysqli_num_rows{$search_Result})
{
while($row = mysqli_fetch_array($search_Result)}
{

$id =$row['id'];
$name =$row['name'];
$address =$row['address'];
$status =$row['status'];
$remarks =$row['remarks'];

}else {

echo 'No Data For This Id');
}

}else {

echo 'Result Error';
}
}
?>

`mysqli_num_rows{$search_Result}` should be `mysqli_num_rows($search_Result)` — Nick, Nov 28 '18 at 04:37

score 0 · Answer 1 · answered Nov 28 '18 at 04:37

0

I think you need to change that line to

if (mysqli_num_rows($search_Result))

If hope this will fix the error

answered Nov 28 '18 at 04:37

HOSSAIN AZAD

104
4

Well it did fix it but led to another error. Still working on it. Tnx tho. – Davis Reinhart Nov 28 '18 at 07:09

PHP - Insert Update Delete Search Data in MySQL

1 Answers1