NYCPHP Meetup

Mon Jul 23 11:24:23 EDT 2007

I have been having real difficulties try to insert a 20 column record into a 
table (using PHP not MySQL monitor). If I hardcode I can add a record 
.Taking the script that works I then doctor it substituting the hardcoding 
with $_POST values and then fall over (meaning no record is written). I know 
I have got to the point of writing away a record by putting a checkpoint 
just before the write. I have tested the insert-record-into-database with a 
smaller database of 4 columns and it all works fine, but with my MySQL 20 
columns it just doesn't work can anybody see what I am doing wrong?

This works
 <html>
<head>
  <title>Insert Entry Results</title>
</head>
<body>
<h1>Entry Results</h1>
<?php
# WORKING STORAGE
  // create short variable names
 $A         = 1;
 $B         = 12345678;
 $C         = 1234;
 $D         = 001;
 $E         = TESTA;
 $F         = TESTB;
 $G         = 2007-07-21;
 $H         = TESTC;
 $J         = TESTD;
 $K         = TESTE;
 $L         = TESTG;
 $M         = TESTH;
 $N         = TESTJ;
 $P         = TESTK;
 $Q         = TESTL;
 $R         = TESTM;
 $S         = TESTN;
 $T         = TESTP;
 $U         = TESTQ;
 $V         = TESTR;
#                                "environment"  "user"  "password" 
"database name"
    $db = new mysqli( "localhost",       "paul", "enter",        "test_db" )
      or die( "Sorry - could not connect to MySQL" );

  if (mysqli_connect_errno())
  {
     echo 'Error: Could not connect to database.  Please try again later.';
     exit;
  }
#
      echo ' CHECKPOINT ';
      echo $A.$B.$C.$D.$E.$F.$G.$H.$J.$K.$L.$M.$N.$P.$Q.$R.$S.$T.$U.$V;
#
     $query = "insert into testdata_table values
            (  '".$A."',  '".$B."',  '".$C."',  '".$D."',  '".$E."', 
'".$F."',   '".$G."',  '".$H."',    '".$J."',   '".$K."',  '".$L."', 
'".$M."',
               '".$N."',  '".$P."',  '".$Q."',  '".$R."',  '".$S."', 
'".$T."',   '".$U."',  '".$V."' )";
  $result = $db->query($query);

  if ($result)
      echo  $db->affected_rows.' record inserted into database.';

  $db->close();
?>
</body>
</html>

==========================THIS DOESN'T 
WORK===============================================
<html>
<head>
  <title>insert into testdata_table</title>
</head>
<body>
<h1>test_db - testdata_table</h1>

<?php
# WORKING STORAGE
 $A         = 1;
 $B         = 12345678;
 $C         = 1234;
#
 $D         = $_POST['D'];
 $E         = $_POST['E'];
 $F         = $_POST['F'];
 $G         = $_POST['datum'];
 $H         = $_POST['H'];
 $J         = $_POST['J'];
 $K         = $_POST['K'];
 $L         = $_POST['L'];
 $M         = $_POST['M'];
 $N         = $_POST['N'];
 $P         = $_POST['P'];
 $Q         = $_POST['Q'];
 $R         = $_POST['R'];
 $S         = $_POST['S'];
 $T         = $_POST['T'];
 $U         = $_POST['U'];
 $V         = $_POST['testnote'];

 #                              "environment", "user", "password", "database 
name" )
    $db = new mysqli( "localhost",      "paul", "enter",        "test_db" )
      or die( "Sorry - could not connect to MySQL" );

  if (mysqli_connect_errno())
  {
     echo 'Error: Could not connect to database.  Please try again later.';
     exit;
  }
#    TEMP TESTING CHECKPOINT is record correct?
     echo $A.$B.$C." ".$D.$E.$F.$G.$H.$J.$K.$L.$M.$N.$P.$Q.$R.$S.$T.$U.$V;

#    write "testdata_table
     $query = "insert into testdata_table values
     ('".$A."', '".$B."', '".$C."', '".$D."', '".$E."', '".$F."', '".$G."', 
'".$H."', '".$J."', '".$K."',
      '".$L."', '".$M."', '".$N."', '".$P."', '".$Q."', '".$R."'; '".$S."', 
'".$T."', '".$U."', '".$V."')";

     $result = $db->query($query);
  if ($result)
            echo  $db->affected_rows.'  inserted into test_db.';
    $db->close();
?>
</body>
</html>

NYCPHP Meetup

NYPHP.org

[nycphp-talk] inserting data into MySQL table.