drupal 7 , drupal 6 solutions: September 2013

Thursday, September 26, 2013

join table delete result msyql query

DELETE FROM `node_revisions`
WHERE   vid IN (
            SELECT vid
            FROM    node
            WHERE   type = 'features_test'
        )

Tuesday, September 10, 2013

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);
}

PHP Magic methods

In oops Magic Methods

oops auto function like __construct(), __destruct(), __call(), __callStatic(), __get(), __set(), __isset(), __unset(), __sleep(), __wakeup(), __toString(), __invoke(), __set_state() and __clone(6) are called magical in PHP classes. You cannot create functions with these names in any of your classes unless you want the magic functionality associated with them.

Monday, September 9, 2013

php post data script

this is php post script, with this script you can send data to other server easly mostly this script used in payment getway and sms getway.

drupal 7 , drupal 6 solutions

Thursday, September 26, 2013

join table delete result msyql query

Tuesday, September 10, 2013

PHP CSV IMPORT AND DELETE ENTRIESE

PHP CSV IMPORT AND DELETE ENTRIESE

PHP Magic methods

In oops Magic Methods

Monday, September 9, 2013

php post data script

Translate

About Me

My Blog List

Blog Archive