topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

basic-php-07-create-images-table.php / php



  <?php
  
  //connect to the database
  link = mysql_connect("localhost", "bp5am", "bp5ampass")
    or die("Could not connect: " . mysql_error());
  mysql_select_db("moviesite", link) 
    or die (mysql_error());
  
  //create images table
  sql = "CREATE TABLE IF NOT EXISTS images (
          image_id INT(11) NOT NULL AUTO_INCREMENT,
          image_caption VARCHAR(255) NOT NULL,
          image_username VARCHAR(255) NOT NULL,
          image_date DATE NOT NULL,
          PRIMARY KEY (image_id)
          )";
  results = mysql_query(sql) 
    or die(mysql_error());
  
  echo "Image table successfully created.";
  
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.