NYCPHP Meetup

Wed Jul 11 12:02:52 EDT 2007

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>

NYCPHP Meetup

NYPHP.org

[nycphp-talk] Creating a MySQL DataBase using/through php script.Can anybody help??