Chapter 15

sql.txt

CREATE TABLE `mytest`.`queue` (
`id` INT( 6 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`message` TEXT NOT NULL ,
`status` INT( 1 ) NOT NULL DEFAULT '0'
) ENGINE = MYISAM ;

config.php

<?
# change all lines but the last line (Twitter status update link)
#database
$username="your-db-username";
$password="your-db-password";
$database="your-database-name";

#twitter
$tusrid = 'your-twitter-userid';
$tpasswd = 'your-twitter-password';
$tURL = 'http://twitter.com/statuses/update.xml';

?>

index.php

<html> <head> <title>Home</title> <script> function limitText(limitField, limitNum) { if (limitField.value.length > limitNum) { limitField.value = limitField.value.substring(0, limitNum); } } </script> </head> <body> <h3> What will you be doing? <br>(or what do you want others to think you are doing) </h3><br> <form name=mainform method=post action=add.php onSubmit="return checkLength(this)"> <textarea name="message" rows="3" cols="80" onKeyDown="limitText(this,140);" onKeyUp="limitText(this,140);"> </textarea> <br> <input type=submit value='Add Future Tweet'> </form> <br> <?php include("config.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select my database"); $query="SELECT * FROM queue where status=0 order by id desc"; $result=mysql_query($query); $numOfRecords=mysql_numrows($result); mysql_close(); echo "<b>My Future Tweets</center></b><br><hr>"; ?> <table border="1" cellspacing="2" cellpadding="2"> <tr> <td><b>id</b></td> <td><b>Tweet</b></td> ...

Get SEO Warrior now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial