drupal 7 , drupal 6 solutions: 2013

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'

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

Wednesday, February 27, 2013

Drupal 7 how can i change logo

It’s easy to change the graphics in a SymphonyThemes theme. There are two specific graphics that are especially easy to change: • Logo: the clickable site logo in the upper-left corner. • Favicon: and the 16-by-16-pixel “shortcut” icon next to the URL in your browser’s address bar. For these changes, you don’t even need access to the server, just a few clicks in Drupal’s web-based interface. Change logo

1. Go to the theme administration page at Admin > Appearance or /admin/build/themes, then click the “Configure” link next to your theme.

2. In the “Toggle display” section, make sure the "Logo" checkbox is checked.

3. In the “Logo image settings” section, uncheck the “Use the default logo” checkbox.

4. If you’ve already uploaded the graphic to your server, you can type in its path directly in the “Path to custom logo” box. Otherwise, click the Browse button, find the graphic you want to use on your computer, then scroll to the bottom of the screen and click “Save configuration”. Drupal uploads that graphic to your default file location – usually /sites/default/files/ , unless you’ve changed it on the File system administration screen at /admin/settings/file-system.

5. Don’t immediately see a change? Try doing a “power refresh” (holding down shift or command) in your browser to throw away the old version in your browser’s cache. - See more at: http://www.symphonythemes.com/master-drupal-in-7-hours/change-logo-and-favicon#sthash.aVX8y0NQ.dpuf

Drupal 7 how can i change logo

It’s easy to change the graphics in a SymphonyThemes theme. There are two specific graphics that are especially easy to change:

Logo: the clickable site logo in the upper-left corner.
Favicon: and the 16-by-16-pixel “shortcut” icon next to the URL in your browser’s address bar.

For these changes, you don’t even need access to the server, just a few clicks in Drupal’s web-based interface.

Change logo

Go to the theme administration page at Admin > Appearance or /admin/build/themes, then click the “Configure” link next to your theme.
In the “Toggle display” section, make sure the "Logo" checkbox is checked.
In the “Logo image settings” section, uncheck the “Use the default logo” checkbox.
If you’ve already uploaded the graphic to your server, you can type in its path directly in the “Path to custom logo” box. Otherwise, click the Browse button, find the graphic you want to use on your computer, then scroll to the bottom of the screen and click “Save configuration”. Drupal uploads that graphic to your default file location – usually /sites/default/files/ , unless you’ve changed it on the File system administration screen at /admin/settings/file-system.
Don’t immediately see a change? Try doing a “power refresh” (holding down shift or command) in your browser to throw away the old version in your browser’s cache.

- See more at: http://www.symphonythemes.com/master-drupal-in-7-hours/change-logo-and-favicon#sthash.aVX8y0NQ.dpuf

It’s easy to change the graphics in a SymphonyThemes theme. There are two specific graphics that are especially easy to change:

Logo: the clickable site logo in the upper-left corner.
Favicon: and the 16-by-16-pixel “shortcut” icon next to the URL in your browser’s address bar.

For these changes, you don’t even need access to the server, just a few clicks in Drupal’s web-based interface.

Change logo

Go to the theme administration page at Admin > Appearance or /admin/build/themes, then click the “Configure” link next to your theme.
In the “Toggle display” section, make sure the "Logo" checkbox is checked.
In the “Logo image settings” section, uncheck the “Use the default logo” checkbox.
If you’ve already uploaded the graphic to your server, you can type in its path directly in the “Path to custom logo” box. Otherwise, click the Browse button, find the graphic you want to use on your computer, then scroll to the bottom of the screen and click “Save configuration”. Drupal uploads that graphic to your default file location – usually /sites/default/files/ , unless you’ve changed it on the File system administration screen at /admin/settings/file-system.
Don’t immediately see a change? Try doing a “power refresh” (holding down shift or command) in your browser to throw away the old version in your browser’s cache.

- See more at: http://www.symphonythemes.com/master-drupal-in-7-hours/change-logo-and-favicon#sthash.aVX8y0NQ.dpuf

It’s easy to change the graphics in a SymphonyThemes theme. There are two specific graphics that are especially easy to change:

Logo: the clickable site logo in the upper-left corner.
Favicon: and the 16-by-16-pixel “shortcut” icon next to the URL in your browser’s address bar.

For these changes, you don’t even need access to the server, just a few clicks in Drupal’s web-based interface.

Change logo

Go to the theme administration page at Admin > Appearance or /admin/build/themes, then click the “Configure” link next to your theme.
In the “Toggle display” section, make sure the "Logo" checkbox is checked.
In the “Logo image settings” section, uncheck the “Use the default logo” checkbox.
If you’ve already uploaded the graphic to your server, you can type in its path directly in the “Path to custom logo” box. Otherwise, click the Browse button, find the graphic you want to use on your computer, then scroll to the bottom of the screen and click “Save configuration”. Drupal uploads that graphic to your default file location – usually /sites/default/files/ , unless you’ve changed it on the File system administration screen at /admin/settings/file-system.
Don’t immediately see a change? Try doing a “power refresh” (holding down shift or command) in your browser to throw away the old version in your browser’s cache.

Note that Drupal will display the logo exactly as it is uploaded, at full size. It’s a good idea to keep logo graphics fairly short, i.e. under 120 pixels high.

Change favicon

You can create the favicon from you logo by using this service http://www.favicongenerator.com/. Then follow these steps:

In the “Shortcut icon settings” section, uncheck the “Use the default shortcut icon” checkbox.
If you’ve already uploaded the graphic to your server, you can type in its path directly in the “Path to custom icon” box. Otherwise, click the Browse button, find the graphic you want to use on your computer, then scroll to the bottom of the screen and click “Save configuration”. (PNG and GIF graphics are best, as some versions of Internet Explorer don’t recognize JPG shortcut icons.)
Don’t immediately see a change? Try doing a “power refresh” in your browser to throw away the old version in your browser’s cache.

Master Drupal in 7 hours - Basic Customization - Shortcut icon

Unlike the logo, visitors will see the favicon in its proper size in the address bar. Drupal does not actually shrink the graphic itself, it is stored at full size. So it is s a good idea to shrink the logo manually to 16 pixels square using a graphic software or the Favicon Generator.
- See more at: http://www.symphonythemes.com/master-drupal-in-7-hours/change-logo-and-favicon#sthash.aVX8y0NQ.dpuf

Drupal 7 how can i change logo

It’s easy to change the graphics in a SymphonyThemes theme. There are two specific graphics that are especially easy to change:

Logo: the clickable site logo in the upper-left corner.
Favicon: and the 16-by-16-pixel “shortcut” icon next to the URL in your browser’s address bar.

For these changes, you don’t even need access to the server, just a few clicks in Drupal’s web-based interface.

Change logo

Go to the theme administration page at Admin > Appearance or /admin/build/themes, then click the “Configure” link next to your theme.
In the “Toggle display” section, make sure the "Logo" checkbox is checked.
In the “Logo image settings” section, uncheck the “Use the default logo” checkbox.
If you’ve already uploaded the graphic to your server, you can type in its path directly in the “Path to custom logo” box. Otherwise, click the Browse button, find the graphic you want to use on your computer, then scroll to the bottom of the screen and click “Save configuration”. Drupal uploads that graphic to your default file location – usually /sites/default/files/ , unless you’ve changed it on the File system administration screen at /admin/settings/file-system.
Don’t immediately see a change? Try doing a “power refresh” (holding down shift or command) in your browser to throw away the old version in your browser’s cache.

- See more at: http://www.symphonythemes.com/master-drupal-in-7-hours/change-logo-and-favicon#sthash.aVX8y0NQ.dpuf

It’s easy to change the graphics in a SymphonyThemes theme. There are two specific graphics that are especially easy to change:

Logo: the clickable site logo in the upper-left corner.
Favicon: and the 16-by-16-pixel “shortcut” icon next to the URL in your browser’s address bar.

For these changes, you don’t even need access to the server, just a few clicks in Drupal’s web-based interface.

Change logo

Go to the theme administration page at Admin > Appearance or /admin/build/themes, then click the “Configure” link next to your theme.
In the “Toggle display” section, make sure the "Logo" checkbox is checked.
In the “Logo image settings” section, uncheck the “Use the default logo” checkbox.
If you’ve already uploaded the graphic to your server, you can type in its path directly in the “Path to custom logo” box. Otherwise, click the Browse button, find the graphic you want to use on your computer, then scroll to the bottom of the screen and click “Save configuration”. Drupal uploads that graphic to your default file location – usually /sites/default/files/ , unless you’ve changed it on the File system administration screen at /admin/settings/file-system.
Don’t immediately see a change? Try doing a “power refresh” (holding down shift or command) in your browser to throw away the old version in your browser’s cache.

- See more at: http://www.symphonythemes.com/master-drupal-in-7-hours/change-logo-and-favicon#sthash.aVX8y0NQ.dpuf

It’s easy to change the graphics in a SymphonyThemes theme. There are two specific graphics that are especially easy to change:

Logo: the clickable site logo in the upper-left corner.
Favicon: and the 16-by-16-pixel “shortcut” icon next to the URL in your browser’s address bar.

For these changes, you don’t even need access to the server, just a few clicks in Drupal’s web-based interface.

Change logo

Go to the theme administration page at Admin > Appearance or /admin/build/themes, then click the “Configure” link next to your theme.
In the “Toggle display” section, make sure the "Logo" checkbox is checked.
In the “Logo image settings” section, uncheck the “Use the default logo” checkbox.
If you’ve already uploaded the graphic to your server, you can type in its path directly in the “Path to custom logo” box. Otherwise, click the Browse button, find the graphic you want to use on your computer, then scroll to the bottom of the screen and click “Save configuration”. Drupal uploads that graphic to your default file location – usually /sites/default/files/ , unless you’ve changed it on the File system administration screen at /admin/settings/file-system.
Don’t immediately see a change? Try doing a “power refresh” (holding down shift or command) in your browser to throw away the old version in your browser’s cache.

Note that Drupal will display the logo exactly as it is uploaded, at full size. It’s a good idea to keep logo graphics fairly short, i.e. under 120 pixels high.

Change favicon

You can create the favicon from you logo by using this service http://www.favicongenerator.com/. Then follow these steps:

In the “Shortcut icon settings” section, uncheck the “Use the default shortcut icon” checkbox.
If you’ve already uploaded the graphic to your server, you can type in its path directly in the “Path to custom icon” box. Otherwise, click the Browse button, find the graphic you want to use on your computer, then scroll to the bottom of the screen and click “Save configuration”. (PNG and GIF graphics are best, as some versions of Internet Explorer don’t recognize JPG shortcut icons.)
Don’t immediately see a change? Try doing a “power refresh” in your browser to throw away the old version in your browser’s cache.

Tuesday, February 26, 2013

Fixed Header jQuery Mobile on top when i scroll the page

Fixed Header jQuery Mobile on top when i scroll the page

http://adf.ly/732311/pkflower.com

Fixed Header jQuery Mobile

<!DOCTYPE html> 
<html> 
    <head> 
    <link rel="stylesheet" href="http://code.jquery.com/mobile/1.1.1/jquery.mobile-1.1.1.min.css" />
    <script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
 <script src="http://code.jquery.com/mobile/1.1.1/jquery.mobile-1.1.1.min.js"></script>
    <script>
        $(document).on("pageshow","#page",function(){
            $(this).css("top","100px");
        })

$(window).scroll(function(event){
           if($(window).scrollTop() >= 100){
                $("#menu").css("position","fixed");
           }
           else{
                $("#menu").css("position","absolute");
           }
        });
    </script>
    <style>
 #menu{ height:50px; background-color:red; width:100%; line-height:8px; text-align:center; top:0; }
 </style>
</head> 
<body> 
<div data-role="page" id="page">

<div id="menu" >
        <h1>
Page Title</h1>
</div>

<div data-role="content" style="height:1500px;">
    
        <p>
Lorem ipsum dolor</p>
</div>

</div>

</body>
</html>

Mysql big size dabase upload script

<?php
/*
 * Restore MySQL dump using PHP
 * (c) 2006 Daniel15
 * Last Update: 9th December 2006
 * Version: 0.2
 * Edited: Cleaned up the code a bit.
 *
 * Please feel free to use any part of this, but please give me some credit :-)
 */
  
// Name of the file
$filename = 'hil.sql';
// MySQL host
$mysql_host = 'localhost';
// MySQL username
$mysql_username = 'hfingen';
// MySQL password
$mysql_password = 'pRgXxWVEQu';
// Database name
$mysql_database = 'hfingen';
 
//////////////////////////////////////////////////////////////////////////////////////////////
 
// Connect to MySQL server
mysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());
// Select database
mysql_select_db($mysql_database) or die('Error selecting MySQL database: ' . mysql_error());
 
// Temporary variable, used to store current query
$templine = '';
// Read in entire file
$lines = file($filename);
// Loop through each line
foreach ($lines as $line)
{
    // Skip it if it's a comment
    if (substr($line, 0, 2) == '--' || $line == '')
        continue;
 
    // Add this line to the current segment
    $templine .= $line;
    // If it has a semicolon at the end, it's the end of the query
    if (substr(trim($line), -1, 1) == ';')
    {
        // Perform the query
        mysql_query($templine) or print('Error performing query \'<b>' . $templine . '\': ' . mysql_error() . '<br /><br />');
        // Reset temp variable to empty
        $templine = '';
    echo 'successful installation';
	}
}
 
?>

how can we increase ckeditor file uplod size limit

Anserwer

Question No-1

First of all Go to xampp server file open php folder then open php.ini file then changes

1- post_max_size = Here increase this size. example 100M or 200M etc.

2- upload_max_filesize = Here increase this size. example 100M or 200M etc.

Question No-2

Go to drupal folder -> sites->all->Modules->ckeditor->ckfinder then open config.php then changes.

1-

$config['ResourcesType'][]=Array(

   'name'=>'Files',
   'url' => '',

   'maxSize' => "it is increase this size", ex. 100M or 200M etc.

2-

$config['ResourcesType'][]=Array(

   'name'=>'Images',
   'url' => '',

   'maxSize' => "it is increase this size", ex. 100M or 200M etc.

drupal 7 Where i can set my ckeditor css with my theme?

drupal 7 Where i can set my ckeditor css with my theme?

Anserwer: please folow below steps

1. go this link with your domain name
http://mvzaugsburg.baucom.eu/#overlay-context=&overlay=admin/config/content/ckeditor

2. then edit full html as defalt

3. then click css link

4. set Editor CSS as use theme css

Monday, February 25, 2013

drupal 7 how can we increase drupal 7 file upload limit?

drupal 7 how can we increase drupal 7 file upload limit?

Anserwer:

please download this rar file and view docs. i hope it's help full you
and please after that comment my blog.

Sunday, February 24, 2013

drupal 7 langauge change according to user

drupal6 or 7 where i can change the upload file path

i found the path where we can change upload file path

http://mvzaugsburg.baucom.eu/#overlay=admin/config/media/file-system

try this