Missing something

[Double_M]

Anyone know whats wrong with this? it says that the records have been entered.
But there are no records in the database.

Any ideas why?

<?php 
 //require_once('./Includes/host.php');

$db_url = 'localhost';
$db_user = '****';
$db_pass = '*****';
$db_name = '****';

/* END CONFIGURATION */

/* PROCESS */

$dbh = mysql_connect($db_url, $db_user, $db_pass);
mysql_select_db($db_name, $dbh);

$sql = "SELECT * FROM TEST
        ORDER BY ID";
$sth = mysql_query($sql, $dbh);


 function create_record($table_name,$recid) {
    $fields = getfieldinfo(strtolower($table_name));
    $autofieldname = ''; $autovalue = '';
    $found = false;
    for($i=0;$i<count($fields);$i++) {
      $fielddata = trim($fields[$i]);
      $fielddata = explode(':',$fielddata);
      if($fielddata[2]=='AUTODATE') {
        $autofieldname .= ','.$fielddata[1];
        $autovalue .= ','.time();
        $found = true;
      }
      if($fielddata[2]=='AUTOTIME') {
        $autofieldname .= ','.$fielddata[1];
        $autovalue .= ','.time();
        $found = true;
      }
      if($fielddata[2]=='PASSWORD') {
        $autofieldname .= ','.$fielddata[1];
        $autovalue .= ",'".randomPassword()."'";
        $found = true;
      }
    }
    //$dbh = connect();
    $sql = "INSERT INTO ".strtoupper($table_name)." (RECORDID".strtoupper($autofieldname).") VALUES ('$recid'".$autovalue.")";
    //query($dbh,$sql);
    //disconnect($dbh);
  }

  function getfieldinfo($table_name) {
    global $debug,$doc_root,$dbfiles_universe,$anytime_universe,$db;
    /*! read FLD file */
    /*! @note Convert FLD file to a XML file */
    /*! return field array */
    $fname = $table_name.'.fld';
    $table_fields = @file($doc_root.$anytime_universe[1].$dbfiles_universe[1].$db.$fname);
    return $table_fields;
  }




 if(($HTTP_POST_FILES['csvfile'] != 'none') && ($HTTP_POST_FILES['csvfile'] != ''))
          {
            $entries = 0;
            $table_name = 'TEST';
            $dbh = mysql_pconnect($db_url, $db_user, $db_pass); //mysql_select_db($db_name, $dbh) or die('Could not select database');
            // Remove existing products
            $sql = 'DELETE FROM ' . $table_name;
            //$result = query($dbh, $sql);
            //disconnect($dbh);
            $fp = fopen ($HTTP_POST_FILES['csvfile']['tmp_name'],'r');
            $row = 0;
            $fields = array();
            while ($data = fgetcsv($fp, 1000, ','))
            {
              if (count($fields) == 0)
              {
                for ($i = 0, $num = count($data); $i < $num; $i++)
                {
                  switch (strtoupper($data[$i]))
                  {
                                                case 'ID':
                      $fields['ID'] = $i;
                    break;

                case 'COMPANY_NAME':
                  $fields['COMPANY_NAME'] = $i;
                break;

                case 'CUSTOMER_NAME':
                  $fields['CUSTOMER_NAME'] = $i;
                break;


                default:
                break;
              }
            }
          } // END Get headers
          else
          {
            $recid = uniqid('any');
            create_record($table_name, $recid);
            $sql = "UPDATE " . $table_name . "
                    SET ID                           = '" . addslashes($data[$fields['ID']]) . "',
                        COMPANY_NAME    = '" . addslashes($data[$fields['COMPANY_NAME']]) . "',
                        CUSTOMER_NAME   = '" . addslashes($data[$fields['CUSTOMER_NAME']]) . "',
                    WHERE RECORDID   = '" . $recid . "'";
            //$result = query($dbh, $sql);
            $entries++;
          }
        }


        fclose ($fp);
      } // CHECK UPLOAD FILE
      //display_message("Finished importing $entries entries into $table_name");
              print ("Finished importing $entries entries into $table_name");



              ?>

[halojoy]

I can see no such mesaage in your script:
the records have been entered

maybe you submitted wrong script ???

[Double_M]

Says at bottom of script "finished importing blablabla", it should of been entered by then?

[halojoy]

Try put in some 'checkpoints' in your script
this way you can track what is happening
and also see what values variables have.

Can be simple echo like:
echo $variable;
or
echo 'here1';
echo 'here2';

When you have figured out What happens / Not happens,
you remove those TESTING-echos.
I do this very often myself,
to see if an
if( condition)
part of script was run.