使用PHP从MySQL数据库获取价值 [英] get value from MySQL database with PHP
本文介绍了使用PHP从MySQL数据库获取价值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
$from = $_POST['from'];
$to = $_POST['to'];
$message = $_POST['message'];
$query = "SELECT * FROM Users WHERE `user_name` = '$from' LIMIT 1";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$fromID = $row['user_id'];
}
我尝试让$ formID成为我的用户的user_id数据库。 Users表中的每一行如下:
I'm trying to have $formID be the user_id for a user in my database. Each row in the Users table is like:
user_id | user_name | user_type
1 | Hristo | Agent
所以我想要 $ from = 1
但上面的代码不工作。
So I want $from = 1
but the above code isn't working. Any ideas why?
推荐答案
尝试:
$from = mysql_real_escape_string($_POST['from']);
$to = mysql_real_escape_string($_POST['to']);
$message = mysql_real_escape_string($_POST['message']);
$query = "SELECT * FROM Users WHERE user_name = '$from' LIMIT 1";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_assoc($result)) {
$fromID = $row['user_id'];
}
此外,请确保:
- 您已连接到数据库
- 您从帖子获取数据,请尝试
var_dump
与您的varsvar_dump($ from)
- You have connected to the database
- You do get data from the post, try
var_dump
with your vars egvar_dump($from)
这篇关于使用PHP从MySQL数据库获取价值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文