PHP Example for Subscriber List

From Second Life Wiki
Revision as of 20:30, 1 November 2009 by ELQ Homewood (talk | contribs)
Jump to navigation Jump to search

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.