 |
ช่วยด้วยครับ #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE article_ID = '3'' at line 1 |
| |
 |
|
|
 |
 |
|
code นะครับ
Code (PHP)
$conn = mysql_pconnect($host,$username,$passwd)or die("Can't connect to server");
mysql_select_db($dbname)or die("Can't connect to Database");
$sql = "UPDATE article SET ";
$sql .= "name = '".$_POST["aname"]."'";
$sql .= ",picture = '".$_POST["file"]."'";
$sql .= ",detail = '".$_POST["detail"]."'";
$sql .= ",WHERE article_ID = '".$_GET["article_ID"]."'";
echo $sql;
$objquery = mysql_query($sql)or die("Can't query");
|
 |
 |
 |
 |
| Date :
2011-02-20 22:23:36 |
By :
zimmpooh |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
$sql = "UPDATE article SET ";
$sql .= "name = '".$_POST["aname"]."'";
$sql .= ",picture = '".$_POST["file"]."'";
$sql .= ",detail = '".$_POST["detail"]."'";
$sql .= ",WHERE article_ID = '".$_GET["article_ID"]."'";
|
| |
|
|
| |
| Date :
2011-02-20 22:25:01 |
By :
PlaKriM |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
มันเป็นปัญหาจิงๆ เวลาเขียนโปรเกรมนานๆ แล้วจะเบลอ แล้วก็จะหาส่วนที่ผิดไม่เจอ ผมก็เจอบ่อย สู้ๆ ขอบ่นหน่อยอากาศร้อน คิดไรไม่ออก
|
| |
|
|
| |
| Date :
2011-02-20 23:48:47 |
By :
pipop1150 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
- - ผิดไปได้เรา
ขอบคุณมากๆเลยครับ ^^
|
| |
|
|
| |
| Date :
2011-02-21 09:18:58 |
By :
zimmpooh |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
สายตาพี่เขาดีจริง ๆ ครับ มันบ่งบอกถึงอะไรหลาย ๆ อย่าง 
|
| |
|
|
| |
| Date :
2011-02-21 09:28:52 |
By :
ไวยวิทย์ |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code
mysql_connect($host,$user,$password)or die("ติดต่อ Host ไม่ได้");
mysql_select_db($dbname)or die("ต่อต่อฐานข้อมูลไม่ได้");
$sql= "insert into 'user_info'('logname','pw','name','address','tel','email')
values('$logname','$pw','$name','$address','$tel','$email')";
mysql_query("set NAMES tis620");
$sqlquery=mysql_db_query($dbname,$sql);
$checkadd= "select * from'user_info' where logname='$logname'";
$result=mysql_db_query($dbname,$checkadd);
$num=mysql_num_rows($result);
*ผิดตรงไหนบอกด้วยนะคับ
|
| |
|
|
| |
| Date :
2011-08-29 20:38:58 |
By :
^^ |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
$sql= "insert into 'user_info'('logname','pw','name','address','tel','email')
values('$logname','$pw','$name','$address','$tel','$email')";
user_info ไม่มี ' ครับ
|
| |
|
|
| |
| Date :
2011-08-29 20:48:46 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
<?php
$host="127.0.0.1";
$user="root";
$passwd="root";
$dbname="register";
mysql_connect($host,$user,$passwd) or die("ติดต่อ Host ไม่ได้");
mysql_select_db($dbname) or die("ติดต่อฐานข้อมูลได้แล้ว");
$sql="insert into 'userinfo'('logname','pw','email','name','address','age','gender','ads','hobby','hobby2','hobby3','hobby4')
values('$logname','$psswd','$name','$email','$address','$age','$gender','$Uknow','$hobby','hobby2','hobby3','hobby4')";
mysql_query("set NAMES tis620");
$sqlquery=mysql_db_query($dbname,$sql);
$checkadd="select*from'userinfo'where logname='$logname'";
$result=mysql_db_query($dbname,$checkadd);
$num=mysql_num_rows($result);
if($num==1)
{
print"<br>เพิ่มข้อมูลผู้ใช้ลงในฐานข้อมูลเรียบร้อยแล้ว";
}elseif($num>=1)
{
print"<br>ชื่อผู้ใช้งานซ้ำกรุณาใช้ชื่ออื่น";
}else
{
print"ERROR !!!";
};
mysql_close();
?>
*พอกดF12 มันก็ขึ้น Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\test\adddata1.php on line 14
ERROR !!!
ไม่รู้จะลองทุกอย่างก็ยังไม่หายขึ้นไม่รู้จะแก้ปัญหายังไงแล้วคับ
ช่วยบอกหน่อยนะคับ
ขอบคุณคับ...
|
| |
|
|
| |
| Date :
2011-08-29 23:56:33 |
By :
เด็กหัดใหม่ |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
$sql="insert into 'userinfo'('logname','pw','email','name','address','age','gender','ads','hobby','hobby2','hobby3','hobby4')
ตอบไปหลายรอบ แล้วก็ตอบไปหลายคน ให้คุณเอา ' ออก ซะ คุณกลับไปอ่านกระทู้เดิมคุณอะครับ มีคนเขียนให้ใหม่ด้วยซ้ำนะ
|
| |
|
|
| |
| Date :
2011-08-30 00:02:08 |
By :
ikikkok |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
$objConnect = mysql_connect("localhost","root","") or die(mysql_error());
$objDB = mysql_select_db("mydatabase1") or die(mysql_error());
$strSQL = "SELECT * FROM user WHERE Email = ".$_POST['email']."'";
$objQuery = mysql_query($strSQL or die(mysql_error()));
$objResult = mysql_fetch_array($objQuery);
ผิดตรงไหนอะ
|
| |
|
|
| |
| Date :
2015-08-02 11:41:57 |
By :
Tape |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
$strSQL = "SELECT * FROM user WHERE Email = '".$_POST['email']."'";
สีแดงหายไป
|
| |
|
|
| |
| Date :
2015-08-02 12:05:59 |
By :
NewbiePHP |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
INSERT INTO fish (Fname,FEName,FDetail,) VALUES ('ปลา','fish','sdasdasd');
#1064 - 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 ') VALUES ('ปลา','fish','sdasdasd')' at line 1
ผิดตรงไหนครับ
|
| |
|
|
| |
| Date :
2017-02-10 10:24:58 |
By :
... |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
มันขึ้นว่า Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\shopping_cart\cart.php on line 28
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 ทำเว็บเกี่ยวกับการขายของส่งอาจารย์อะค่ะ หนูไปต่อไม่ได้เลย ส่งพรุ้งนี้แล้ว ใครรู้ช่วยหน่อยนะค่ะ
<?php
session_start();
require 'connect.php';
$action = isset($_GET['a']) ? $_GET['a'] : "";
$itemCount = isset($_SESSION['cart']) ? count($_SESSION['cart']) : 0;
if (isset($_SESSION['qty']))
{
$meQty = 0;
foreach ($_SESSION['qty'] as $meItem)
{
$meQty = $meQty + $meItem;
}
} else
{
$meQty = 0;
}
if (isset($_SESSION['cart']) and $itemCount > 0)
{
$itemIds = "";
foreach ($_SESSION['cart'] as $itemId)
{
$itemIds = $itemIds . $itemId . ",";
}
$inputItems = rtrim($itemIds,$itemId . ",");
$meSql = "SELECT * FROM add_pro WHERE pro_id in ({$inputItems})";
$meQuery = mysql_query($meSql);
$meCount = mysql_num_rows($meQuery);
mysql_error();
} else
{
$meCount = 0;
}
?>
<?
echo mysql_error();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>itoffside.com shopping cart</title>
<!-- Bootstrap -->
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet">
<link href="bootstrap/css/nava.css" rel="stylesheet">
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<div class="container">
<!-- Static navbar -->
<div class="navbar navbar-default" role="navigation">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Shopping kkwind.com</a>
</div>
<div class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li class="active"><a href="index.php">หน้าแรกสินค้า</a></li>
<li><a href="cart.php">ตะกร้าสินค้าของฉัน <span class="badge"><?php echo $meQty; ?></span></a></li>
</ul>
</div><!--/.nav-collapse -->
</div><!--/.container-fluid -->
</div>
<h3>ตะกร้าสินค้าของฉัน</h3>
<!-- Main component for a primary marketing message or call to action -->
<?php
if ($action == 'removed')
{
echo "<div class=\"alert alert-warning\">ลบสินค้าเรียบร้อยแล้ว</div>";
}
if ($meCount == 0)
{
echo "<div class=\"alert alert-warning\">ไม่มีสินค้าอยู่ในตะกร้า</div>";
} else
{
?>
<form action="updatecart.php" method="post" name="fromupdate">
<table class="table table-striped table-bordered">
<thead>
<tr>
<th>#</th>
<th>รหัสสินค้า</th>
<th>ชื่อสินค้า</th>
<th>รายละเอียด</th>
<th>จำนวน</th>
<th>ราคาต่อหน่วย</th>
<th>จำนวนเงิน</th>
<th> </th>
</tr>
</thead>
<tbody>
<?php
$total_price = 0;
$num = 0;
while ($meResult = mysql_fetch_assoc($meQuery))
{
$key = array_search($meResult['pro_id'], $_SESSION['cart']);
$total_price = $total_price + ($meResult['pro_price'] * $_SESSION['qty'][$key]);
?>
<tr>
<td><img src="../admin-pages/img/<?php echo $meResult['pro_img']; ?>" border="0"></td>
<td><?php echo $meResult['pro_id']; ?></td>
<td><?php echo $meResult['pro_name']; ?></td>
<td><?php echo $meResult['pro_detail']; ?></td>
<td>
<input type="text" name="qty[<?php echo $num; ?>]" value="<?php echo $_SESSION['qty'][$key]; ?>" class="form-control" style="width: 60px;text-align: center;">
<input type="hidden" name="arr_key_<?php echo $num; ?>" value="<?php echo $key; ?>">
</td>
<td><?php echo number_format($meResult['pro_price'],2); ?></td>
<td><?php echo number_format(($meResult['pro_price'] * $_SESSION['qty'][$key]),2); ?></td>
<td>
<a class="btn btn-danger btn-lg" href="removecart.php?itemId=<?php echo $meResult['pro_id'];?>" role="button">
<span class="glyphicon glyphicon-trash"></span>
ลบทิ้ง</a>
</td>
</tr>
<?php
$num++;
}
?>
<tr>
<td colspan="8" style="text-align: right;">
<h4>จำนวนเงินรวมทั้งหมด <?php echo number_format($total_price,2); ?> บาท</h4>
</td>
</tr>
<tr>
<td colspan="8" style="text-align: right;">
<button type="submit" class="btn btn-info btn-lg">คำนวณราคาสินค้าใหม่</button>
<a href="order.php" type="button" class="btn btn-primary btn-lg">สังซื้อสินค้า</a>
</td>
</tr>
</tbody>
</table>
</form>
<?php
}
?>
</div> <!-- /container -->
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="bootstrap/js/jquery.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="bootstrap/js/bootstrap.min.js"></script>
</body>
</html>
<?php
mysql_close();
|
| |
|
|
| |
| Date :
2019-02-19 14:01:15 |
By :
rattamanee13 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
เอา tag php ครอบด้วย จะได้อ่านง่าย
|
| |
|
|
| |
| Date :
2019-02-19 16:34:17 |
By :
Chaidhanan |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Executing SQL script in server
ERROR: Error 1064: 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 ') VIRTUAL,
PRIMARY KEY (`Stafftype`))
ENGINE = InnoDB' at line 6
SQL Code:
-- -----------------------------------------------------
-- Table `Staff_DB`.`Stafftype`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Staff_DB`.`Stafftype` (
`Stafftype` INT NOT NULL,
`Descripton` VARCHAR(45) GENERATED ALWAYS AS () VIRTUAL,
PRIMARY KEY (`Stafftype`))
ENGINE = InnoDB
SQL script execution finished: statements: 6 succeeded, 1 failed
Fetching back view definitions in final form.
2 views were read back.
ต้องแก้ยังไงคะ
|
| |
|
|
| |
| Date :
2020-03-25 15:01:05 |
By :
tttt |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
Quote:
