Fatal error: Uncaught mysqli_sql_exception: Duplicate entry '2020' for key 'PRIMARY' in C:\xampp\htdocs\register.php:94 Stack trace: #0 C:\xampp\htdocs\register.php(94): mysqli->query('insert into DATA...') #1 {main} thrown in C:\xampp\htdocs\register.php on line 94
Mga sir ano po kayang problema? Ayaw po mag print nung else, tinry ko po kasi yung duplicate user. Yung error po lumabas. Pero yung unang query is gumana naman po, nag aalert po sya if unique yung nilagay na info, thanks po!
before 94 ang error nyan dol. Cguro yang $sql na variable.
Meron ka na input na "2020" na naka existed. Cguro ID yan na insert mo, kailangan unique lahat basta primary key.
before 94 ang error nyan dol. Cguro yang $sql na variable.
Meron ka na input na "2020" na naka existed. Cguro ID yan na insert mo, kailangan unique lahat basta primary key.
Boss one error pa pala, may reject.php ako using if-else din, eto yung code ko, ngayon ayaw mag insert ni $sql1 kapag pinindot yung reject, error din lumalabas tulad nung sa post
PHP:
if($conn->query($sql) === TRUE)
{
$sql1="insert into DATA.message (Username,Msg,Date,Time) values ('$Username','Your request for issue of $game has been rejected',curdate(),curtime())";
$result=$conn->query($sql1);
echo "<script type='text/javascript'>alert('Success')</script>";
header( "Refresh:0.01; url="requests.php", true, 303);
}
else
{
echo "<script type='text/javascript'>alert('Error')</script>";
header( "Refresh:0.01; url="requests.php", true, 303);
}
Boss one error pa pala, may reject.php ako using if-else din, eto yung code ko, ngayon ayaw mag insert ni $sql1 kapag pinindot yung reject, error din lumalabas tulad nung sa post
PHP:
if($conn->query($sql) === TRUE)
{
$sql1="insert into DATA.message (Username,Msg,Date,Time) values ('$Username','Your request for issue of $game has been rejected',curdate(),curtime())";
$result=$conn->query($sql1);
echo "<script type='text/javascript'>alert('Success')</script>";
header( "Refresh:0.01; url="requests.php", true, 303);
}
else
{
echo "<script type='text/javascript'>alert('Error')</script>";
header( "Refresh:0.01; url="requests.php", true, 303);
}
nag try catch ako boss, kaso ang nag pprint sa kanya e yung error lang, yung supposedly dapat na $sql1 yung magffunction, yung nasa baba. although nag rereject naman, hindi nga lang nag iinsert sa DATA.message yung function
idk, kung anong purpose ng "if($conn->query($sql) === TRUE)" line na yan.
Try mo muna e debug, mag lagay ka nang print_r($e) sa catch() part, lalabas kung anong error dyan.
Yan kasi problema sa Exception, generic sya, lahat possible error papasok dyan.
Meron naman mysqli_errno(), for specific error handling sa mysqli yan.
idk, kung anong purpose ng "if($conn->query($sql) === TRUE)" line na yan.
Try mo muna e debug, mag lagay ka nang print_r($e) sa catch() part, lalabas kung anong error dyan.
Yan kasi problema sa Exception, generic sya, lahat possible error papasok dyan.
Meron naman mysqli_errno(), for specific error handling sa mysqli yan.