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-11-db-insertpics.php / php



  <?php
  require("./includes/conn_comic.php");
  
  sql = "CREATE DATABASE postcard";
  success = mysql_query(sql, conn) or die(mysql_error());
  echo "Database Created. . .";
  
  mysql_select_db("postcard", conn);
  
  sql = "CREATE TABLE images (id int NOT NULL primary key
    auto_increment, img_url VARCHAR(255) NOT NULL,
    img_desc text)";
  success = mysql_query(sql, conn) or die(mysql_error());
  echo "'images' table created. . .";
  
  path = "http://" . _SERVER['SERVER_NAME'] . 
    strrev(strstr(strrev(_SERVER['PHP_SELF']),"/"));
  
  imagepath = path . "postcards/";
  
  imgURL = array('punyearth.gif', 'grebnok.gif', 'sympathy.gif',
    'congrats.gif');
  imgDESC = array('Wish you were here!', 'See you soon!', 
    'Our Sympathies', 'Congratulations!');
  
  for (i=0; i<4; i++) {
    sql = "INSERT INTO images ( images.img_url , images.img_desc ) 
            VALUES ( 'imagepathimgURL[i]', 'imgDESC[i]')";
    success = mysql_query(sql, conn) or die(mysql_error());
  }
  echo "Data entered. . ."
  ?>
[] 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.