Anyone here know php!!!?

hey jim

welcome to the php world !

i have started learning php for real about 4 weeks now
so basically in 2005 i started learning php and mysql also

i am doing a project of a cinema
so far i have been able to creat all this dynamically



all this code is generated via php

and all the information for each div that shows the movie information is gathered from a mysql page

let me show u some code

<?php

   include ( 'menu.html' );

   // set your infomation.
   $dbhost='localhost';
   $dbusername='root';
   $dbuserpass='';
   $dbname='film';
   
   // connect to the mysql database server.
   $link_id = mysql_connect ($dbhost, $dbusername, $dbuserpass);
   
   // select the specific database name we want to access.
   $dbname=$dbusername."_".$dbname;
   if (!mysql_select_db($dbname)) die(mysql_error());

   $result = mysql_query("SELECT * FROM films");
   
   if ($result === false)
   {
      echo 'Could not run query: ' . mysql_error();
      exit;
   }
   
   echo "\t <div id=\"film\">\n \n";
      
      echo "\t <h2>Film Information:</h2>\n \n";
      
      while ($row = mysql_fetch_row($result))
         {
         echo "\t \t <div id=\"filmdetails\">\n";
         echo "\t \t \t<img src=\"$row[2]\" alt=\"$row[1]\" align=\"left\">\n";   
         echo "\t \t \t<p></p>\n";
         echo "\t \t \t<p>Name: $row[1]</p>\n";
         echo "\t \t \t<p></p>\n";
         echo "\t \t \t".$row[3]."\n";
         echo "\t \t \t<p>Cast:$row[5]</p>\n";
         echo "\t \t \t<p>Book at: <a href=\"book.php?id=assault19\"> 19:00 [/url] <a href=\"book.php?id=assault21\"> 21:00 [/url] <a href=\"book.php?id=assault23\"> 23:00 [/url]  </p>\n";
         echo "\t \t</div>\n";
         echo "\t <p></p> \n \n";
         }
   echo "\t </div>\n";

?>

the thing i am going to do now is when u see book at

<a href=\"book.php?id=assault19\">

i want to get the id assault19 from a database also

should be done by tonight

 ;)

well done in 2min

if i combine the unique key of the movie plus the hours
i can identify the movie and the time it will play

echo "\t \t \t<p>Book at: <a href=\"book.php?id=$row[0]19\"> 19:00 [/url] <a href=\"book.php?id=$row[0]21\"> 21:00 [/url] <a href=\"book.php?id=$row[0]23\"> 23:00 [/url]  </p>\n";

so when i go on book.php

i can just use $_GET['id'] format this toget the 1st to digit out and the last to digit out
run against the mysql database and identify the time and the movie the guy has click

damn this one was easy to figure out

Yea you should use the addslashes() function as well. Heres a snippet:


$query = "SELECT * FROM table1 WHERE name = '".addslashes($name1)."'";
$result = mysql_query($query) or die ("$query
".mysql_error());

Do people not look at when the last post was posted....

« Reply #6 on: February 25, 2005, 05:52:08 PM »

« Reply #7 on: May 12, 2005, 12:51:27 AM »

« Reply #8 on: Today at 01:17:11 AM »

 

yo know for every post i have posted someone has managed to rag on it.... what do you gus do sit there jumping from forum to forum raggin on peeps, its a forum who cares the date and time,  i didnt know we were running on a time limit every one reads them till the forum shuts down its a update on the conversation. because you might know the meaning of life and everything in it dont mean everyone else dose. When i browse forums i dont pay attention to the time if  you do ok but like i said not everyone else dose