Difference between revisions of "PHP Example for Subscriber List"

From Second Life Wiki
Jump to navigation Jump to search
Line 1: Line 1:
Something like..
Something like..
<pre>
 
<?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);


//return to script
echo $cm." complete.";
?>
?>
</pre>
 
This isn't tested or anything but it should be pretty close, to give an idea what your list-building functions would look like.
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 20: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.