info@dpinkpear.in

Blog

Posted by dpinkpear

Before After Image Slider WordPress plugin

Business, Local SEO, PHP, Technology, Wordpress 0

Using Before After Image Slider plugin you can create draggeable slider to wordpress page or post. This is only two image slider which contains before image and after image. and this slider is also responsive.it has a complete easy-to-use slide editor with different layers. Don’t hesitate install the Before After Image Slider and enjoy the next generation plugin experience!

Demo sliders | Documentation | Support

FEATURES:

  • Before After Image Slider integrated with WordPress – media manager, shortcode, widget, post permalinks, post editor
  • Before After Image Slider is responsive and touch friendly – Sliders can be enjoyed in any environment, be it a mobile, tablet or desktop.
  • Before After Image Slider displayed with the shortcode – [bais_before_after before_image=”before_image_url” after_image=”after_image_url”]
Posted by dpinkpear

WordPress Redirect a user on first login

Local SEO, PHP, SEO, Social Media Marketing, Technology, Wordpress 0

Suppose you have some information you want to direct first time users to, such as a term and condition  page, or a list of certain posts, etc. You would like to do that the first time they login as a new user.  You can do that with the below code . In this example, I will show you how to redirect the user to the specific page if it is the first time they have logged in.

Add the below code in functions.php of your active theme, or a custom plugin. or You can download the plugin from wordpress directory .

//hook when user registers
add_action( ‘user_register’, ‘myplugin_registration_save’, 10, 1 );

function myplugin_registration_save( $user_id ) {

// insert meta that user not logged in first time
update_user_meta($user_id, ‘prefix_first_login’, ‘1’);

}

// hook when user logs in
add_action(‘wp_login’, ‘your_function’, 10, 2);

function your_function($user_login, $user) {

$user_id = $user->ID;
// getting prev. saved meta
$first_login = get_user_meta($user_id, ‘prefix_first_login’, true);
// if first time login
if( $first_login == ‘1’ ) {
// update meta after first login
update_user_meta($user_id, ‘prefix_first_login’, ‘0’);
// redirect to given URL
wp_redirect( ‘http://www.example.com/’ );
exit;
}

Posted by dpinkpear

Backup MySQL Database Using PHP

Email Marketing, Local SEO, PHP, Technology, Wordpress 0

If your site stores its sensitive data in a MySQL database, you will most definitely want to backup that information so that it can be restored in case of any disaster (we all have been there).Some web hosts do offer such backup feature, you can also backup things using PHP exec() function (if supported by host) but if not, you can use this PHP functions to back up your entire database tables.Here is a little PHP script that I use to backup MySQL databases.


if (isset($_POST['name'])) {
/* backup the db OR just a table */
function backup_tables($host,$user,$pass,$name,$tables = '*')
{

$link = mysqli_connect($host,$user,$pass);
mysqli_select_db($link,$name);

//get all of the tables
if($tables == '*')
{
$tables = array();
$result = mysqli_query($link, 'SHOW TABLES');
while($row = mysqli_fetch_row($result))
{
$tables[] = $row[0];
}
}
else
{
$tables = is_array($tables) ? $tables : explode(',',$tables);
}

//cycle through
$return = '';
foreach($tables as $table)
{
$result = mysqli_query($link, 'SELECT * FROM '.$table);
$num_fields = mysqli_field_count($link);

$return.= 'DROP TABLE '.$table.';';
$row2 = mysqli_fetch_row(mysqli_query($link, 'SHOW CREATE TABLE '.$table));
$return.= "\n\n".$row2[1].";\n\n";

for ($i = 0; $i < $num_fields; $i++) { while($row = mysqli_fetch_row($result)) { $return.= 'INSERT INTO '.$table.' VALUES('; for($j=0; $j < $num_fields; $j++) { $row[$j] = addslashes($row[$j]); $row[$j] = preg_replace("/\n/","\\n",$row[$j]); if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; } if ($j < ($num_fields-1)) { $return.= ','; } } $return.= ");\n"; } } $return.="\n\n\n"; } $time = time(); //save file to the browser header("Content-Type: text/plain"); header("Content-Disposition: attachment; filename=\"$name-backup-$time.sql\""); header("Content-Length: " . strlen($return)); header("Content-Transfer-Encoding: binary"); echo $return; } backup_tables($_POST['host'], $_POST['user'], $_POST['pass'], $_POST['name']); } else { ?>



Backup database

Backup database