Skip to Main Content
SEO Warrior
book

SEO Warrior

by John I Jerkovic
November 2009
Beginner content levelBeginner
496 pages
13h 46m
English
O'Reilly Media, Inc.
Content preview from SEO Warrior

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> ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

The SEO Battlefield

The SEO Battlefield

Anne Ahola Ward

Publisher Resources

ISBN: 9780596804749Errata Page