PHP CSV IMPORT AND DELETE ENTRIESE

<form action="<?php $_SERVER['PHP_SELF']; ?>
" method="post"
enctype="multipart/form-data">
<label for="file">Filename:</label>
<input type="file" name="file" id="file"><br>
<label for="file">SELECT ACTION:</label>
<select type="file" name="action" >
<option value="ADD" >ADD</option>
<option value="DELETE" >DELETE</option>
<option value="UPDATE" >UPDATE</option>
</select>

<input type="submit" name="submit" value="Submit">
</form>
</body>
</html>
<?php
if ($_FILES["file"]["error"] > 0)
  {
  echo "Error: " . $_FILES["file"]["error"] . "<br>";
  }
else
  {
  $path =  $_FILES["file"]["tmp_name"];
  }
  
?>

<?php
mysql_connect('localhost','root','admin');
mysql_select_db('ajax');

$row = 1;
if (($handle = fopen($path, "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
       
    $id = $data[0];
    $com_name = $data[1];
    $com_date = $data[2];
    $com_docate_no = $data[3];
    $com_states = $data[4];
    $com_orderid = $data[5];
    if($_POST['action'] == 'ADD'){
    mysql_query("INSERT INTO `pkplutin` SET `com_name` = '$com_name', `com_date` = '$com_date', `com_docate_no` = '$com_docate_no', `com_states` = '$com_states', `com_orderid` = '$com_orderid' ");
    }elseif($_POST['action'] == 'DELETE'){
    mysql_query("DELETE FROM `pkplutin` WHERE `com_name` = '$com_name' and `com_date` = '$com_date' and `com_docate_no` = '$com_docate_no' and `com_states` = '$com_states' and `com_orderid` = '$com_orderid' ");
    }elseif($_POST['action'] == 'UPDATE'){
    mysql_query("UPDATE `pkplutin` SET `com_name` = '$com_name', `com_date` = '$com_date', `com_docate_no` = '$com_docate_no', `com_states` = '$com_states', `com_orderid` = '$com_orderid' WHERE `id` = $id ");
    };
    }
    fclose($handle);
}

drupal 7 , drupal 6 solutions

Tuesday, September 10, 2013

PHP CSV IMPORT AND DELETE ENTRIESE

PHP CSV IMPORT AND DELETE ENTRIESE

No comments:

Post a Comment

Translate

About Me

My Blog List

Blog Archive