Help[php] sql syntax error

Unknown027 · Nov 5, 2017

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

<?php include "db.php" ?>
<?php include "functions.php" ?>
<?php

if(isset($_POST['submit'])) {

$username = $_POST['username'];
$password = $_POST['password'];
$id = $_POST['id'];

$query = "UPDATE users SET ";
$query .= "username = '$username', ";
$query .= "password = '$password' ";
$query .= "WHERE id = $id";

$result = mysqli_query($connection, $query);

if(!$result) {

die(mysqli_error($connection));

}
}

?>

<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>update</title>
<body>

<form action="update.php" method="post">
<div>
<label for="username">Username: </label>
<input type="text" name="username" placeholder="Enter Username">
</div>
<div>
<label for="password">Password: </label>
<input type="password" name="password" placeholder="Enter Password">
</div>
<div>
<select name="id" id="id">
<?php displayResult(); ?>
</select>
</div>
<input type="submit" name="submit" value="Update">
</form>

</body>
</head>
</html>
=================================
yan po yung lahat nung codes na try ko na po yung ibang solution pero ayaw parin pong gumana patulong naman po mga ka symbs salamat

bdalina54 · Nov 5, 2017

Try mo lang, tapos pag ayaw parin, tingan mo sa <?php include "db.php" ?> baka dyan ang may mali

$query = "UPDATE `users` SET "
. "`users`.username = {$username}, "
. "`users`.password = {$password} "
. " WHERE `users`.id = {$id}";

$query = "UPDATE users SET username = {$username}, password = {$password} WHERE id = {$id}";

jskhulitz · Nov 6, 2017

Try this code first. I-display mo muna kung ano yung content ng $query variable mo. Tapos paste mo sa kung anumang query browser ang meron ka at tignan mo yung result. I-reply mo dito yung content ng $query at yung result set.

Code:

<?php include("db.php"); ?>
<?php include("functions.php"); ?>
<?php
	// kailangan lang muna natin i-identify kung nasaan ang mali. Kung sa variable values ba, or mismong sql structure mo
	$username = 'sample'; // replace with a valid value
	$password = 'sample'; // replace with a valid value
	$id = 1; // replace with a valid value

	$query = "UPDATE users SET ";
	$query .= "username = '$username', ";
	$query .= "password = '$password' ";
	$query .= "WHERE id = $id";

	echo $query; die();
	// copy the displayed content of $query then paste it in a query browser (phpmyadmin or mysql query browser)
	// kung ano man yung result or error, ipost mo uli dito
?>

judasin123 · Nov 6, 2017

bdalina54 said:
Try mo lang, tapos pag ayaw parin, tingan mo sa <?php include "db.php" ?> baka dyan ang may mali

$query = "UPDATE `users` SET "
. "`users`.username = {$username}, "
. "`users`.password = {$password} "
. " WHERE `users`.id = {$id}";

$query = "UPDATE users SET username = {$username}, password = {$password} WHERE id = {$id}";

yes this one pwede ito

phuldhing30 · Nov 7, 2017

$query = "UPDATE users SET ";
$query .= "username = '$username', ";
$query .= "password = '$password' ";
$query .= "WHERE id = '$id'"; // apostrophe bes sa line na to.

bdalina54 · Nov 7, 2017

FYI

valid po sa mysql_query ang walang apostrophe basta integer ang value or boolean

A) $query = "UPDATE users SET username = '$username', password = '$password' WHERE id = $id";

B) $query = "UPDATE users SET username = 'user01', password = 'secret' WHERE id = 1";

same result with

C) $query = "UPDATE users SET username = 'user01', password = 'secret' WHERE id = '1'";

if you are confused gamit ka ng curly brace to escaped quote

D) $query = "UPDATE users SET username = {$username}, password = {$password} WHERE id = {$id}";

Help[php] sql syntax error

More options

Unknown027

Recruit

bdalina54

Professional

jskhulitz

Symbianize Shaman

judasin123

Proficient

phuldhing30

The Fanatic

bdalina54

Professional

Similar threads