drupal 7 , drupal 6 solutions

Wednesday, October 23, 2013

Drupal 7 increase file upload size by .htaccess

please opein your front .htaccess file and find below code

# PHP 5, Apache 1 and 2.
<IfModule mod_php5.c>
php_flag magic_quotes_gpc                 off
php_flag magic_quotes_sybase              off
php_flag register_globals                 off
php_flag session.auto_start               off
php_value mbstring.http_input             pass
php_value mbstring.http_output            pass
php_flag mbstring.encoding_translation    off
</IfModule>

replace with this below code

# PHP 5, Apache 1 and 2.
<IfModule mod_php5.c>
php_flag magic_quotes_gpc                 off
php_flag magic_quotes_sybase              off
php_flag register_globals                 off
php_flag session.auto_start               off
php_value mbstring.http_input             pass
php_value mbstring.http_output            pass
php_flag mbstring.encoding_translation    off
php_value post_max_size                   500M
php_value upload_max_filesize             500M
</IfModule>

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'

drupal 7 , drupal 6 solutions

Wednesday, October 23, 2013

Drupal 7 increase file upload size by .htaccess

Drupal 7 increase file upload size by .htaccess

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'

Translate

About Me

My Blog List

Blog Archive