loadid.php3

来自「flash 源码」· PHP3 代码 · 共 67 行

<?
// Script by Rob Stanfield http://www.shockwavenz.co.nz

$count= "$No";


      



// connect to db

                      $db = mysql_connect("servername","username","password"); mysql_select_db("yourDB",$db);

	$get_date = "SELECT date FROM guest WHERE id = '$count'";
	$date_result = mysql_query($get_date) or die ("Couldn't get quote.");
	$return = mysql_result($date_result, 0, "date");
	$send_date = "&date=";
	$send_date .= rawurlencode($return );


	echo "$send_date";



	$get_name = "SELECT name FROM guest WHERE id = '$count'";
	$name_result = mysql_query($get_name) or die ("Couldn't get quote.");
	$return = mysql_result($name_result, 0, "name");
	$send_name = "&name=";
	$send_name .= rawurlencode($return);


	echo "$send_name";



	$get_quote = "SELECT email FROM guest WHERE id = '$count'";
	$quote_result = mysql_query($get_quote) or die ("Couldn't get quote.");
	$return = mysql_result($quote_result, 0, "email");
	$send_email = "&email=";
	$send_email .= rawurlencode($return);


	echo "$send_email";


	$get_url = "SELECT url FROM guest WHERE id = '$count'";
	$url_result = mysql_query($get_url) or die ("Couldn't get quote.");
	$return = mysql_result($url_result, 0, "url");
	$send_url = "&url=";
	$send_url .= rawurlencode($return);


	echo "$send_url";;

	$get_details = "SELECT details FROM guest WHERE id = '$count'";
	$details_result = mysql_query($get_details) or die ("Couldn't get quote.");
	$return = mysql_result($details_result, 0, "details");
	$send_details = "&details=";
	$send_details .= rawurlencode($return);


	echo "$send_details";


?>