Mysql command to PHP

Question

so basically I am trying to write a php script that can be uploaded to a server and be located somewhere on my site to click. Then when it's clicked, it runs the mysql query and displays the information needed....This is what I have so far.

--Connect.php--

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

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

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

?>

--the mysql command I need to have the php file run is

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

So how do I write the php script to run this file within my website?

Thanks

Are those values constant in your WHERE clause?

Blake
– Blake

2012-05-05 18:13:53 +00:00
Commented May 5, 2012 at 18:13 — Blake
– Blake, Commented May 5, 2012 at 18:13

DanRedux · Accepted Answer · 2012-05-05 18:14:32Z

1

Store your query in a php variable $query='That String'

Then use this to execute it:

$res=mysql_query($qry);

Then to look through every result:

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

:)

answered May 5, 2012 at 18:14

DanRedux

9,4096 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

h3tr1ck Over a year ago

Can I do this inside of the connect.php file or should I make another file that just includes connect and then does this command?

DanRedux Over a year ago

You could include the "connect" stuff in a file and include it anywhere you'll be needing MySQL, however, you should try to only use mysql_connect and mysql_select_db one time per page. :)

knurdy · Accepted Answer · 2012-05-05 18:22:10Z

I guess you are looking for something like this..

$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);

Collectives™ on Stack Overflow

Mysql command to PHP

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related