drupal 7 , drupal 6 solutions

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.

Wednesday, August 14, 2013

drupal 7 create tpl.php file

first insert below code in template.php file

function garland_preprocess_page(&$vars) {

if(arg(1) == 17){
$vars['theme_hook_suggestions'][] = "page__homepage";
}

and create page--homepage.tpl.php file

then it will work and give if condition node 17 and please change on which page you want to show here

Thursday, July 18, 2013

phpmyadmin password reset UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root'

php mysql phpmyadmin password reset query

UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root'

Sunday, March 17, 2013

drupl 6 open_basedir restriction in effect

drupl 6 open_basedir restriction in effect
i got this problem many time but now m get the solution

warning: tempnam(): open_basedir restriction in effect. File() is not within the allowed path(s): (/var/www/vhosts/hiltenfingen.de/:/tmp/) in /var/www/vhosts/hiltenfingen.de/httpdocs/includes/file.inc on line 815.

answer: go admin->site cofiguration->setting and set the site/default/fils

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

Wednesday, August 14, 2013

drupal 7 create tpl.php file

Thursday, July 18, 2013

phpmyadmin password reset UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root'

Sunday, March 17, 2013

drupl 6 open_basedir restriction in effect

Translate

About Me

My Blog List

Blog Archive