NYCPHP Meetup

[PaulCheung]

Thanks everybody it is all working now. 

Paul
----- Original Message ----- 
  From: Jon Baer 
  To: NYPHP Talk 
  Sent: Wednesday, July 11, 2007 3:54 PM
  Subject: Re: [nycphp-talk] Creating a MySQL DataBase using/through php script.Can anybody help??


  You would also need to set special GRANT privileges for user "paul".


  http://dev.mysql.com/doc/refman/5.1/en/create-database.html
  http://dev.mysql.com/doc/refman/5.1/en/grant.html


  Also of note ...


  -snip-
  If you manually create a directory under the data directory (for example, with mkdir), the server considers it a database directory and it shows up in the output of SHOW DATABASES.
  -snip-


  - Jon


  On Jul 11, 2007, at 9:59 AM, Jake McGraw wrote:


    Ah, you may need to modify the @mysql_query() command like so:


    @mysql_query('CREATE DATABASE '.$_REQUEST['db']);


    So that the final submitted query looks like (for $_REQUEST['db'] =
    'myDatabase'):


    CREATE DATABASE myDatabase


    Whereas before you were issuing the query:


    myDatabase


    Which makes no sense and would have resulted in an error, except that
    you were using an the error control (@) operator. See
    http://us2.php.net/@ for more information.


    - jake


    On 7/11/07, PaulCheung <paulcheung at tiscali.co.uk> wrote:
      Can anybody see what I am doing wrong?


      Using Mike McGrath's book "PHP 5 in easy steps" I have been trying to get
      both his textbook example on page 144 "Creating a database" and the example
      from the www.ineasysteps.com website to work. Not being able to get either
      the textbook example or "create_db.php" to work and in pure frustration I
      contacted the publishers and got a reply from Mike and implemented his
      suggested changes; Using the MySQL "show databases;" line command to verify
      database creation, it shows no database was created. Here is the code
      including the Mike's suggested changes. It all appears to work on the
      surface; but you will need to check a little deeper under the surface to see
      what I mean.


      Paul


      <!-- example for PHP 5.0.0 final release -->
      <?php
      $conn = @mysql_connect( "localhost", "paul", "enter" )
       or die( "Sorry - could not connect to MySQL" );


      $rs1 = @mysql_query( $_REQUEST['db'] );
      $rs2=  @mysql_list_dbs($conn);


      $list = "";


      for( $row=0; $row < mysql_num_rows( $rs2 ); $row++ )
      {
        $list .= mysql_tablename( $rs2, $row ) . " | ";
      }
      ?>


      <html>
       <head>
        <title>Creating databases</title>
       </head>
       <body>
       <form action="<?php echo( $_SERVER['PHP_SELF'] ); ?> " method="post">


       Current databases: <?php echo( $list ); ?>
       <hr>
       Name:<input type = "text" name = "db">
       <input type = "submit" value = "Create database">
       </form>
       </body>
      </html>
      _______________________________________________
      New York PHP Community Talk Mailing List
      http://lists.nyphp.org/mailman/listinfo/talk


      NYPHPCon 2006 Presentations Online
      http://www.nyphpcon.com


      Show Your Participation in New York PHP
      http://www.nyphp.org/show_participation.php


    _______________________________________________
    New York PHP Community Talk Mailing List
    http://lists.nyphp.org/mailman/listinfo/talk


    NYPHPCon 2006 Presentations Online
    http://www.nyphpcon.com


    Show Your Participation in New York PHP
    http://www.nyphp.org/show_participation.php




------------------------------------------------------------------------------


  _______________________________________________
  New York PHP Community Talk Mailing List
  http://lists.nyphp.org/mailman/listinfo/talk

  NYPHPCon 2006 Presentations Online
  http://www.nyphpcon.com

  Show Your Participation in New York PHP
  http://www.nyphp.org/show_participation.php
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070711/15b5663c/attachment.html>