[RESOLVED] No data inserted?

php_devv

Hi all , this code is very simple but make me crazy, it is not inserting any data !!

this file named insert.php, database is ok , i don't know how to solve this problem.

<?php
include ("connect.php");

if(isset($_POST['submit'])) 
  {
  $topic=$_POST['topic'];
  $subject=$_POST['subject'];

$sql="INSERT INTO magazine (topic, subject) VALUES ('$topic','$subject')";
         mysql_query($sql) or die("Could not update Category");
         print "topic and subject has been Added<br>";
   }
  else
  {
     print "<form action='insert.php' method='post'>";
     print "Topic:<br>";
     print "<input type='text' name='topic' size='20' id='topic'><br>";
     print "subject:<br>";
     print "<input type='text' name='subject' size='20' id='subject'><br>";
     print "<input type='submit' name='submit' value='submit'></form>"; 
     } ?>

bradgrafelman

EDIT: Welcome to PHPBuilder! When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

Are you getting the 'Could not update Category' message?

Do you have display_errors set to On and error_reporting set to E_ALL?

Finally, have you tried echo'ing out $sql and copying-and-pasting the resulting output into something like phpMyAdmin in order to manually execute the SQL query and observe the results?

php_devv

Are you getting the 'Could not update Category' message?

Do you have display_errors set to On and error_reporting set to E_ALL?

Yes , i get (Notice: Undefined index: topic) and (Notice: Undefined index: subject)

Finally, have you tried echo'ing out $sql and copying-and-pasting the resulting output into something like phpMyAdmin in order to manually execute the SQL query and observe the results?

Database working fine.

So can any body know where the problem area?

bradgrafelman

php_devv;10996242 wrote:
So can any body know where the problem area?

Of course! You said it yourself:

php_devv;10996242 wrote:
(Notice: Undefined index: topic) and (Notice: Undefined index: subject)

which makes me think this:

php_devv;10996242 wrote:
Database working fine.

is utter nonsense since you never really did this:

bradgrafelman wrote:
Finally, have you tried echo'ing out $sql and copying-and-pasting the resulting output into something like phpMyAdmin in order to manually execute the SQL query and observe the results?

Going back to your two errors, can you do a [man]print_r/man on the $_POST array and show us the output?

Weedpacket

php_devv wrote:
Yes , i get (Notice: Undefined index: topic) and (Notice: Undefined index: subject)

That means that the form submission you're receiving does not contain fields named 'topic' or 'subject'. what does print_r($_POST) say is contained in that array?

php_devv

Thanks dear bradgrafelman and Weedpacket for fast replay.

i make change from :

$topic=$_POST['topic'];

to:

 $_POST['topic']=$topic;

and the output for print_r() are :

Array ( [topic] => [subject] => )

still notice error?

php_devv

Originally Posted by bradgrafelman
Finally, have you tried echo'ing out $sql and copying-and-pasting the resulting output into something like phpMyAdmin in order to manually execute the SQL query and observe the results?

Yes , i put this script to view what happend fast ( it is in the same page insert.php)

$result = mysql_query("SELECT * FROM magazine");


  print "<table border='1'>
    <tr>
      <th>topic</th>
      <th>subject</th>
      <
    </tr>";
    while ($row = mysql_fetch_array($result)) {
      print "<tr>";
      print "<td>" . $row['topic'] . "</td>";
      print "<td>" . $row['subject'] . "</td>";

  print "</tr>";


}
  print "</table>";

please see the attachment.

php_devv

I make some modified :

<?php
include ("connect.php");

if (!empty($_POST['topic'])) 
{
        $topic=$_POST['topic'];
}

if (!empty( $_POST['subject'])) 
{
        $subject=$_POST['subject'];
}



 print_r($_POST);
if(isset($_POST['submit'])) 
  {

$sql="INSERT INTO magazine (topic, subject) VALUES ('$topic','$subject')";
         mysql_query($sql) or die("Could not update Category");
         print "topic and subject has been Added<br>";

  }
  else
  {

 print "<form action='insert.php' method='post'>";
 print "Topic:<br>";
 print "<input type='text' name='topic' size='20' id='topic'><br>";
 print "subject:<br>";
 print "<input type='text' name='subject' size='20' id='subject'><br>";
 print "<input type='submit' name='submit' value='submit'></form>"; 

  }

Now i remove notice but still can't insert data , see the attachment please.

Weedpacket

And what is the result when you type something in the fields and submit the form?

php_devv

There is nothing !!

Weedpacket

You mean you get a blank page?
What happens when you put print_r($_POST) in insert.php, as for example

<?php
include ("connect.php");

print_r($_POST);

if(isset($_POST['submit']))
  {
  $topic=$_POST['topic'];
  $subject=$_POST['subject'];

Then type something in the fields and submit the form?

php_devv

Yes it is blank, the result of print_r is nothing either , please see the attachmnent in above.

johanafm

What is the result of the call to mysql_query?

Derokorian

Using your exact code, and typing in the boxes and hitting submit, printr on $_POST gives me Array ( [topic] => Test topic [subject] => subject for test [submit] => submit ) however since the print_r is before the if submit statement it does show up as an empty array( ) BEFORE submitting the form. Are you sure you're submitting the form? because my screen looks exactly like your screenshot BEFORE I submit the form, and I get Array ( [topic] => Test topic [subject] => subject for test [submit] => submit ) topic and subject has been Added after submitting..

Weedpacket

Weedpacket wrote:
You mean you get a blank page?

php_devv wrote:
Yes it is blank, the result of print_r is nothing either , please see the attachmnent in above.

The attachment doesn't show a blank page. It's got a dump from print_r() of an empty array, a form, a stray "<", and a table.

See also the rest of my post, and compare it with Derokorian's.

php_devv

Finally, I resolve this problem by upgrading the easyphp from version (5.3.9 ) to version (5.4.0 RC4)

I would like to thanks all guys that’s help me especially the great master bradgrafelman and Weedpacket , no word will value your simple and fast help thanks a lot again.

who want to download latest version here (http://www.easyphp.org/download.php)

php_devv

Sorry i forget johanafm and Derokorian thanks alot.