Closed Warning: mysqli_num_row & mysqli_query : help please sakit na po ulo ko di ko mahilot na

[T_T Ellaaaa T_T]

<?php
session_start();
include('includes/dbcon.php');

$id = $_SESSION['id'];
$venue = $_POST['venue'];
$date = $_POST['date'];
$time = $_POST['time'];
$motif = $_POST['motif'];
$pax = $_POST['pax'];
$type = $_POST['type'];
$ocassion = $_POST['ocassion'];
$cid = $_POST['combo_id'];
$date=date("Y-m-d",strtotime($date));

$query = mysqli_query($con, "SELECT * FROM 'reservation' WHERE r_date='".$date."' AND r_status = 'Approved'");
if(mysqli_num_rows($query) > 0)
{

echo "<script>alert ('Date is already reserved');
window.history.back(); </script>";
}
else{
// do something
if (!mysqli_query($con,$query))
{
$query = mysqli_query($con, "SELECT * FROM combo WHERE combo_id='$cid'");
$row=mysqli_fetch_array($query);
$price=$row['combo_price'];
$payable=$pax*$price;

mysqli_query($con,"UPDATE reservation SET payable='$payable',balance='$payable',r_venue='$venue',r_date='$date',r_time='$time',r_motif='$motif'
,r_ocassion='$ocassion',r_type='$type',pax='$pax',combo_id='$cid',price='$price' where rid='$id'")or die(mysqli_error($con));

$_SESSION['id']=$id;


echo "<script>document.location='payment.php'</script>";
}}

?>


Result.

Warning: mysqli_num_row() expects parameter 1 to be mysqli_rsult, boolean given in C:\xampp\htdocs\catering\reservation\details_save.php on line 17

Warning: mysqli_query(): Empty query in C:\xampp\htdocs\catering\reservation\details_save.php on line 15



Line:

17 if(mysqli_num_rows($query) > 0)

25 if (!mysqli_query($con,$query))

 

[_GRANDMASTER_]

ano po yan?

 

[T_T Ellaaaa T_T]

ano po yan?

Website po. Para sa thesis ko

 

[mavs666]

first of all: this is not a JQuery issue.
second: use or die function in your $query para makits mo ung mysql error if meron.

 

[T_T Ellaaaa T_T]

first of all: this is not a JQuery issue.
second: use or die function in your $query para makits mo ung mysql error if meron.

wala ibang tags po, wala php ,mysql eh

meron naman die function nsa loob n ng else if

 

[greyzen]

Sana matapos na to te visit ko na lang site mo kung sakali. Hahaha

 

[Funyarinpa]

yung mysqli_query mo yung mali kaya nagkakaganyan
may mali sa sql statement
tanggalin mo yung single quote nung table ng reservation

 

[anjum12345678]

php version is the problem

 

[mavs666]

"SELECT * FROM 'reservation' WHERE r_date='".$date."' AND r_status = 'Approved'"

ung 'reservation' mo gawin mong `reservation`

 

[mavs666]

wala namang die function sa una mong query e.
ung una mong query ang me error.

pano mo malalaman kung tama ung SQL statement mo kung di nya irerender ung error sa screen?

 

[T_T Ellaaaa T_T]

Closed thread na po na resolve ko na yung problem.

 

[T_T Ellaaaa T_T]

wala namang die function sa una mong query e.
ung una mong query ang me error.

pano mo malalaman kung tama ung SQL statement mo kung di nya irerender ung error sa screen?

Salamat sa idea

 

[T_T Ellaaaa T_T]

Pero may error pa den na nalabas pero working yung function nya .

warning: mysqli_query() expect parameter 2 to be string,object given in

Line : if (!mysqli_query($con,$query))

 

[Futility]

Pero may error pa den na nalabas pero working yung function nya .

warning: mysqli_query() expect parameter 2 to be string,object given in

Line : if (!mysqli_query($con,$query))

Yung $query variable niyo po dapat SQL statement(string) lang at hindi mysqli_query function.

 

[T_T Ellaaaa T_T]

Yung $query variable niyo po dapat SQL statement(string) lang at hindi mysqli_query function.

Pm kita kuya pa tulong naman please.

 

[mavs666]

ung qoute no ng reservation kahiy Alison mo na un

 

[Patriiiick]

naka laravel ka po? or native php?

 

[Game_Guardian18]

oK na po ba to ?? may mali ata sa query..

 

[japorms40]

note po:
ahmmm
basta num_rows po ay sa query na row at sa database mo na row ay hindi equal baka kulang row mo sa query oh kulang paki check po...

 

[eugcar]

$DB_host = 'localhost';
$DB_user = 'root';
$DB_pass = '';
$DB_name = 'database';

$mysqli = new MySQLi($DB_host,$DB_user,$DB_pass,$DB_name);
if($mysqli->connect_error){
die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}

$id = $_SESSION['id'];
$venue = $_POST['venue'];
$date = $_POST['date'];
$time = $_POST['time'];
$motif = $_POST['motif'];
$pax = $_POST['pax'];
$type = $_POST['type'];
$ocassion = $_POST['ocassion'];
$cid = $_POST['combo_id'];
$date=date("Y-m-d",strtotime($date));

$query = $mysqli->query("SELECT * FROM reservation WHERE r_date='".$date."' AND r_status = 'Approved'");
if($query->num_rows > 0)
{
echo "<script>alert ('Date is already reserved');
window.history.back(); </script>";
}else{
// do something
if (!query)
{
$qry = $mysqli->query("SELECT * FROM combo WHERE combo_id='".$cid."'");
$row=$qry->fetch_array();
$price=$row['combo_price'];
$payable=$pax*$price;
$mysqli->query("UPDATE reservation
SET
payable='".$payable."',
balance='".$payable."',
r_venue='".$venue."',
r_date='".$date."',
r_time='".$time."',
r_motif='".$motif."',
r_ocassion='".$ocassion."',
r_type='".$type."',
pax='".$pax."',
combo_id='".$cid."',
price='".$price."'
where
rid='".$id."' ") or die();
echo "<script>document.location='payment.php'</script>";
}
}