PHP Problem Solutions

Git interview questions and answers - Problem and Solutions

Question: How to delete a Git branch both locally and remotely? To remove a local branch from your local system. git branch -d the_local_branch To remove a remote branch from the server. git push origin :the_remote_branch Question: How do you undo the last...
How to import csv file to database through phpmyadmin

To import csv file in database though phpmyadmin, Follow the following steps. You must have valid CSV File. EXCEL file will not work. you must have a table in database Number of Colums in CSV file must be equal to Number of column in table Now login to phpmyamdin. Make sure you server allow...
How to export mysql query results to csv?

To Learn OR understand the exporting mysql results in CSV. Lets have below simple example. Step 1: Create a employee table CREATE TABLE IF NOT EXISTS `employee` ( `id` int(11) unsigned NOT NULL, `first_name` varchar(100) DEFAULT NULL, ...
MySql replace NULL values with empty string without effecting Rowset

Question: What is NULL Value in MySQL? NULL values means don't have any value. It is neither empty NOR it have any value. Question: Give an Example which is give NULL Values in Query? NULL values means don't have any value. It is neither empty NOR...
How to fix Headers already sent error in PHP?

We are here to fix below error in PHP Warning: Cannot modify header information - headers already sent by (output started at E:\wamp\www\testp\public_html\ram.php:2) in E:\wamp\www\testp\public_html\ram.php on line 4 Question: Why this Error...
Twitter login failed leads to Page not found

I have integration Twitter Sign and Its working fine. :) Problem: When any user sign in with wrong credentials, It redirect to "Sorry, that page doesnâ€™t exist!" I am assuming, It should remain on same page, so that user can retry!. Please see screenshot below: I am...
How to send an email using Email Template in Zend Framework

Email functionalities in websites is very common and used in mostly in all web application. Whether it is registration process or Order detail, we need to send an email to your valuable client. To send the email using Email Template follow the following steps 1....
How do I get wordpress global variable and functions in custom file [SOLVED]

Problem: I have create a file i.e mytestfile.php in root folder of wordpress blog. Full path of mytestfile.php is http://www.example.com/blog/mytestfile.php. Now, I want to access all global variables, functions like $wp_query, query_posts. Solution: As you have...
How to convert php array into javascript array

Converting PHP Array into java-script Â array can be done by using json_ecode functions in php. See, Following how to convert PHP Array into JavaScript Array. $phpArray = array( 'web','web technology','web technology experts', 'web technology experts notes' ); echo ''; ...
How to store array in Cookie and retrieve array from cookie

How to store array in Cookie We need to json_encode the array then save the data with setcookie function. $arrayData=array( 'web technology experts', 'web technology experts Notes', 'web technology experts Notes php technology' ...
Synchronous XMLHttpRequest on the main thread is deprecated

Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. If you are getting above issue, It means in Ajax call ( May be using xmlHttpRequest, jQuery.js OR prototype.js etc), Somewhere you...
Send Email from Gmail SMTP using Zend Framework

In Website we need to send email on Registration, Forget , Order email to our Clients/Customer. We want email should be deliver timely in inbox folder not in junk/spam folder. For this we have to use SMTP Server. GMAILÂ SMTPÂ Server is free to use, if you...
HTML formatted email not showing up correctly in mail clients (Gmail-Outlook-Hotmail-Iphone-Android) [SOLVED]

When we send a email to users from our application, many times we see html email is distorted in Gmail, Yahoo, Iphone and Ipad etc. If you want to removed such type of issue, then keep following points in mind while creating html template.Â Â Use tables for layout <!---...
How to change the author of a post in Wordpress

There are number of methods to change the author ofÂ word-pressÂ postÂ and are following. Method 1: Change Author by manually edit the POST, Follow the simple steps.Â Login as Administrator. Go to Posts. Edit the post which's author you want to change. Now you...
How to clear Facebook image cache

Following are way to clear the facebook's image from cache. Step 1, Update the Image URL with version in Meta Tags Step 2:...
Google trends api php - How to get hot trends

Google Trends is a public web facility of Google Inc., based on Google Search, that shows how often a particular search-term is entered relative to the total search-volume across various regions of the world, and in various languages.Â From: en.wikipedia.org/wiki/Google_Trends Use following code to get the hot trends from google. try { ...
How can delete a user without deleting the post and comments in wordpress?

In this blog, I will expalin how to delete a user/Editor/Subscriber/Author/Administor without deleting the post and comments. When you start deleting the post application will be prompt that you want to assign the post to another user. To keep the user's post,...
Using mysqli and parameterized statements in PHP with Example

Here I will provide code snippet for the followings How to make Database Connection with PHP-MysQLI. How to fetch the records from database usingÂ MysQLIÂ parameterized/prepared statements. How to insert the record in...
Wordpress redirect https to http with htaccess [SOLVED]

You can redirect all website pages from https to http. It will be redirect only when you open the page...
Advanced PHP Interview Questions and Answers

Question: What is PEAR in php? PEAR means PHP Extension and Application Repository. PEAR is a framework and distribution system for reusable PHP components. PEAR can be installed by bringing an automated wizard. Following are...
PHP Technical Interview Questions and Answers for Fresher and Experienced

Question: How to convert string to array in php? $string="cakephp and zend"; $array =explode('and',$string); print_r($array); Question: How to convert array to string in php? $array =...
Wordpress Website title repeated two times in browser header [SOLVED]

I add the post from wordpress admin section (http://www.example.com/wp-admin/),Â After publishing the post it start displaying in website. In Post detail page, Every information like post title, post description and post date etc is correct except meta title. Issue: Meta title have post name...
How can I prevent SQL-injection in PHP [SOLVED]

Following are different 3 ways to prevent from SQL Injection. 1. Using PHP inbuilt Functions. $name = mysql_real_escape_string($_POST["name"]); mysql_query("INSERT INTO users VALUES($name)"); 2. Use...
Htaccess RewriteRule Flags by Code Example

A RewriteRule can be modified by flag. Flags are included in square brackets at the end of the rule. We can also and multiple flags are separated by commas. For Example: [Flag1] //for 1...
Multiple column ordering in Zend Framework

There are different ways to multiple column ordering in Zend. Following are two different ways to do multiple column ordering in Zend Framework. you can use either First way OR Second...
Strtolower - Returns string with all alphabetic characters converted to lowercase

string strtolower ( string $str ) Make a string lowercase Returns string...
Enabling the openssl in Wamp-Xampp

If you have any of following issue, then you are on right page. How to enable SSL Enabling the openssl in WampServer/xampp How to enable openssl support in XAMPP Unable to Connect to...
How do I get a YouTube video thumbnail from the YouTube

How to get youtube video thumbnail 1. First Get the Video URL (Video URL is like https://www.youtube.com/v/J0Qu6eyyr4c) 2. Get the youtube...
How to find day of week in php in a specific timezone

$timestamp = strtotime(date('2014-10-25')); $dw = date( "w", $timestamp);// $dw will be 0 (for Sunday) through 6 (for Saturday) $days = array('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'); echo "today is...
Download Videos from Amazon S3 - PHP

$newFileName = "download_filename.mp4"; header('Content-Type: video/mp4'); header('Content-Disposition: attachment; filename="' . $newFileName . '"'); $my_aws_key = 'AWS_KEY'; $my_aws_secret_key = 'AWS_SCRET_KEY'; ...
Calculate a Sum of Time using MySQL

We have Following Table Structure of myvideos CREATE TABLE IF NOT EXISTS `myvideos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `time` time NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB...
Paypal Sandbox do-Directpayment, Authorization, Capture and Mass-payment - Example with Code Snippets

Different Paypal Payment with APIÂ example (NVP Operation). DoDirect Payment - Sale Authorization - PayPal /Â Capture -...
Image not displaying uploaded by CKeditor

Uploaded Image Not uploading/Not showing can have might reasons: Upload image path is not correct. Tmp folderÂ have not write permission to upload image. Because when have submit form after selecting image, It first move to tmp folder then to target...
Parse XML in PHP By example [Solved]

The DOMÂ XML parserÂ functions are part of theÂ CoreÂ PHP. To parse xml data you need not to install anythings. there are different functions available in php that can help you to add, update, delete...
jQuery multi column sorting with jQuery - Live Demo

tablesorter is a jQuery plugin used for turning a standard HTML table with THEAD and TBODY tags into a sortable table without page refreshes also no ajax call. tablesorter can successfully parse and sort many types of data including linked data in a cell. ...
How to Select / Deselect All Checkboxes using jQuery

If you are developer and looking for a jQuery code-snippet that selects and de-selects multiple checkboxes by clicking â€œSelect Allâ€ checkbox, like in Gmail.com, rediffmail.com and yahoo.com. Then you are at right place.Â This is very simple...