Re: Am I missing something?

I'm using PHP 5, I'm running this off of my personal laptop so I downloaded ApacheTriad2 ----- Original Message ----- From: "Stephen Johnson" <maillists@thelonecoder.com> To: "Alexander" <kurokawa@tds.net>; "PHP-DB" <php-db@lists.php.net> Sent: Saturday, January 27, 2007 8:24 PM Subject: Re: [PHP-DB] Am I missing something?

What version of php are using? It is odd that mysql_real_escape_string is undefined.. Alternately you could addslashes... Hope this helps <?php /* Stephen Johnson c | eh The Lone Coder http://www.ouradoptionblog.com Join our journey of adoption http://www.thelonecoder.com stephen@thelonecoder.com continuing the struggle against bad code */ ?>

From: Alexander <kurokawa@tds.net> Date: Sat, 27 Jan 2007 20:17:54 -0600 To: PHP-DB <php-db@lists.php.net> Subject: Re: [PHP-DB] Am I missing something? Alright, this may be the problem: Fatal error: Call to undefined function mysql_real_escape_string() in C:\apache2triad\htdocs\gallery.php on line 10 which is refering to : $picture = mysql_real_escape_string($picture); /* never again use direct code from an example in a book, there's always an error */ ----- Original Message ----- From: "Alexander" <kurokawa@tds.net> To: "PHP-DB" <php-db@lists.php.net> Sent: Saturday, January 27, 2007 8:13 PM Subject: Re: [PHP-DB] Am I missing something?

No change. I echod my insert statement and got : INSERT INTO domains ( picture, thumbnail ) values( "$picture", "$thumbnail" ) excatly like that. Shouldn't the values echo as what should be inserted into the database? ----- Original Message ----- From: "Stephen Johnson" <maillists@thelonecoder.com> To: "Alexander" <kurokawa@tds.net>; "PHP-DB" <php-db@lists.php.net> Sent: Saturday, January 27, 2007 8:01 PM Subject: Re: [PHP-DB] Am I missing something?

My first thought is that your values in your insert statement are not in quotes..

         $insert = 'INSERT INTO domains ( picture, thumbnail ) values(

$picture, $thumbnail )';

Should be $insert = 'INSERT INTO domains ( picture, thumbnail ) values( "$picture", "$thumbnail")'; Hope that helps. <?php /* Stephen Johnson c | eh The Lone Coder http://www.ouradoptionblog.com Join our journey of adoption http://www.thelonecoder.com stephen@thelonecoder.com continuing the struggle against bad code */ ?>

From: Alexander <kurokawa@tds.net> Date: Sat, 27 Jan 2007 19:55:17 -0600 To: PHP-DB <php-db@lists.php.net> Subject: [PHP-DB] Am I missing something? I fixed my code and it shows up fine now. It says it supposedly enters the data when I input the fields but when I check the MySQL database, the info isn't there. Here's the fixed code if you wish to test it: <html> <body> <?php function add_to_table( $picture, $thumbnail ) {

         $picture = mysql_real_escape_string($picture);
         $thumbnail = mysql_real_escape_string($thumbnail);

         $user = "user";
         $pass = "password";
         $database = "mydata";

$link = mysql_connect("localhost", $user, $pass);

        if(!$link) {
          echo 'Error in linking';
        }

         $db = mysql_select_db($database, $link);

         $insert = 'INSERT INTO domains ( picture, thumbnail ) values(

$picture, $thumbnail )';

         $indata = mysql_query( $insert, $link );

    }

    function write_form() {
         echo "<form method='post' action='{$_SERVER['PHP_SELF']}'>";

         echo "<p>Enter url of large picture: <input type='text'

name='picture' />";

         echo "<p>Enter url of thumbnail: <input type='text'

name='thumbnail' />";

         echo "<p><input type='submit' value='Add to Database' />";

         echo "</form>";
    }

         if ( !empty( $_REQUEST['picture'] ) && !empty(

$_REQUEST['thumbnail'] ) ) {

           $input = add_to_table( $_REQUEST['picture'],

$_REQUEST['thumbnail'] );

             if(!input) {
               echo 'Error\!';
             }
             else {
      echo 'Data enter successfully\!';
      $idreturn = mysql_insert_id($input);
      echo 'Image inserted to ID ' . $idreturn;
    }

}

         else {
           write_form();

} ?> </body> </html> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php