PHP Example for Subscriber List
Revision as of 18:53, 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($command) { case "add": if(!mysql_query("SELECT * FROM tbl_News WHERE uuid = '$uuid'")) { mysql_query("INSERT INTO tbl_News VALUES ('$uuid')"); } break; case "rem": mysql_query("DELETE FROM tbl_News WHERE uuid='$uuid'"); break; } //return to script echo $cm." complete."; ?>
This isn't tested or anything but it should be pretty close, to give an idea what your list-building functions would look like.