Difference between revisions of "PHP Example for Subscriber List"
Jump to navigation
Jump to search
ELQ Homewood (talk | contribs) |
ELQ Homewood (talk | contribs) |
||
Line 1: | Line 1: | ||
Something like.. | Something like.. | ||
<?php | <?php | ||
//db connect variables | //db connect variables | ||
$host = "mysql server address"; | $host = "mysql server address"; | ||
Line 26: | Line 27: | ||
mysql_query("INSERT INTO tbl_News VALUES ('$uuid')"); | mysql_query("INSERT INTO tbl_News VALUES ('$uuid')"); | ||
} | } | ||
//return to script | |||
echo $cm." complete."; | |||
break; | break; | ||
case "rem": | case "rem": | ||
mysql_query("DELETE FROM tbl_News WHERE uuid='$uuid'"); | mysql_query("DELETE FROM tbl_News WHERE uuid='$uuid'"); | ||
//return to script | |||
echo $cm." complete."; | |||
break; | 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 | This isn't tested or anything but it should be pretty close, to give an idea what you're | ||
function script will be. |
Revision as of 19:30, 1 November 2009
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.