Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Array of Programs to be Displayed
- //For loop to iterate through the database, i=0, i<mysql_num_rows
- $server = "209.237.150.200";
- $username = "116539_web2";
- $password = "alpaca88";
- $conn = mysql_connect($server, $username, $password);
- if ($conn)
- {
- mysql_select_db("116539_web2spring2010", $conn);
- $result = mysql_query("SELECT pid, name, descrip, rating, channel, startTime, lengthMinutes, FROM TivoAlan");
- print ("<script type=\"text/javascript\">");
- print ("function build()");
- print ("{");
- print ("var shows = new Array();");
- for ($i = 0; $i < mysql_num_rows($result); ++$i)
- {
- $channel = mysql_result($result, $i, "channel");
- $starttime = mysql_result($result, $i, "starttime");
- $pid = mysql_result($result, $i, "pid");
- $name = mysql_result($result, $i, "name");
- $descrip = mysql_result($result, $i, "descrip");
- $rating = mysql_result($result, $i, "rating");
- $lengthMinutes = mysql_result($result, $i, "lengthMinutes");
- print ("shows[$i] = new Program('$i', '$name', '$channel', '$rating', '$starttime', '$lengthMinutes', '$descrip');");
- }
- mysql_free_result($result);
- mysql_close($conn);
- print ("}");
- }
- else
- {
- print( 'Could not connect: ' . mysql_error() );
- }
- print "</script>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement