PHP Example for Subscriber List
Revision as of 19:30, 1 November 2009 by ELQ Homewood (talk | contribs)
Something like..
<?php
//db connect variables $host = "mysql server address"; $user = "mysql username"; $pw = "mysql password"; $db = "mysql database name";
//connect to db $con = mysql_connect($host,$user,$pw); if (!$con)
{ die('Could not connect: ' . mysql_error()); }
mysql_select_db($db, $con);
//get variables from script $uuid = $_REQUEST['UUID']; $cm = $_REQUEST['command'];
//process variables switch($cm) {
case "add": if(!mysql_query("SELECT * FROM tbl_News WHERE uuid = '$uuid'")) { mysql_query("INSERT INTO tbl_News VALUES ('$uuid')"); }
//return to script echo $cm." complete."; break;
case "rem": mysql_query("DELETE FROM tbl_News WHERE uuid='$uuid'");
//return to script echo $cm." complete."; break;
case "tot": if($uuid = "") { //place your key between the quotes here $q = mysql_query("SELECT * FrOM tbl_News"); $tot = mysql_num_rows($q); //get the total entries in the table } //return to script echo $cm."|".$tot; break;
case "dist": $dist = mysql_query("SELECT * FROM tbl_News"); while($row = mysql_fetch_array($dist)) { echo $row['uuid']; sleep(20); } break;
}
mysql_close($con);
?>
This isn't tested or anything but it should be pretty close, to give an idea what you're
function script will be.