PHP的Mysql命令

Question

所以基本上我正在尝试写一个php脚本，它可以上传到服务器上，并定位在我的网站上的某个地方点击。然后当它被点击时，它运行mysql查询并显示信息needed....This就是我到目前为止所拥有的。

--Connect.php

$dbhost = 'localhost';
$dbuser = '******';
$dbpass = '******';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die
        ('Error connecting to mysql');

$dbname = '*****';
mysql_select_db($dbname);

?>

--运行php文件所需的mysql命令是

SELECT jsfdName.baseData AS Name, 
jsfdAddr.baseData as Address, 
jsfdZip.baseData AS Zip,      
jsfdCity.baseData AS City, 
sfdCounty.baseData AS County, 
jsfdState.baseData AS State
FROM jos_sobipro_field_data AS jsfdName
JOIN jos_sobipro_field_data AS jsfdAddr USING( sid )
JOIN jos_sobipro_field_data AS jsfdZip USING(sid)
JOIN jos_sobipro_field_data AS jsfdCity USING(sid)
JOIN jos_sobipro_field_data AS jfsdCounty USING(sid)
JOIN jos_sobipro_field_data AS jfsdState USING(sid)
WHERE jsfdName.fid = 36 AND jsfdAddr.fid = 37 AND jsfdZip.fid=38 AND jsfdCity.fid = 39 
AND jsfdCounty.fid = 40 AND jsfdState.fid = 41 AND sid > 329

那么我该如何编写php脚本来在我的网站中运行这个文件呢？

谢谢

Answer 1

将查询存储在php变量$query='That String'中

然后使用下面的代码执行它：

$res=mysql_query($qry);

然后查看每一个结果：

while($row=mysql_fetch_assoc($res)) {
    print $row['Name']; }

:)

Answer 2

我猜你正在寻找像这样的东西..

$dbhost = 'localhost';
$dbuser = '******';
$dbpass = '******';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die
    ('Error connecting to mysql');

$dbname = '*****';
mysql_select_db($dbname);

$sql = "SELECT jsfdName.baseData AS Name, 
jsfdAddr.baseData as Address, 
jsfdZip.baseData AS Zip,      
jsfdCity.baseData AS City, 
sfdCounty.baseData AS County, 
jsfdState.baseData AS State
FROM jos_sobipro_field_data AS jsfdName
JOIN jos_sobipro_field_data AS jsfdAddr USING( sid )
JOIN jos_sobipro_field_data AS jsfdZip USING(sid)
JOIN jos_sobipro_field_data AS jsfdCity USING(sid)
JOIN jos_sobipro_field_data AS jfsdCounty USING(sid)
JOIN jos_sobipro_field_data AS jfsdState USING(sid)
WHERE jsfdName.fid = 36 AND jsfdAddr.fid = 37 AND jsfdZip.fid=38 AND jsfdCity.fid = 39 
AND jsfdCounty.fid = 40 AND jsfdState.fid = 41 AND sid > 329
";

$result = mysql_query($sql);

if (!$result) {

echo "An error occurred in processing your    submission."; 
}   
$row=mysql_fetch_array($result);