Basically, you can delete rows in MySQL table by using below two queries, which are explained as : Example: I have createded a “user” table with some sample data. Now if run delete query as below, it will delete all rows in it but structure and next auto increment value will remain unchange. DELETE FROM `user` When you insert ...Read more..
##Singleton The single pattern is an often used pattern in many applications when only a single instance of a resource is required. The most obvious type of resource for PHP web pages is a database connection, although other resource types can be used. When fetching of dynamically creating a web page several database calls may need ...Read more..
If you do not do any activity in your PHPMyAdmin it will log out automatically after 1440 seconds or say 24 minutes and shows error as “No activity within 1440 seconds, please log in again”. This feature is not available in old versions of PHPMyAdmin. If you are working on your local environment it is very ...Read more..
Follow below steps to configure/install Laravel 5.4 on WAMP or XAMPP servers. To install you need composer and wamp (for XAMPP also you can follow the same steps) running in your local system. Step 1. Download the composer from official composer site. You can also get the composer link from Laraval documentation page here. Step 2. Install ...Read more..
Follow the below steps to integrate PayUMoney into Codeigniter: To download the complete code click here. For core php integration Click here. View More:Payumoney integration in Core PHP Step 1: Login to PayUMoney.com as a merchant and get merchant key and salt which we need while integration. Step 2: Update constant.php file, located inside “application/config” folder, with below code: //PayUMoney ...Read more..
Today i have integrated PayUMoney to my website, thought of sharing. Here i am sharing how a developer can integrate PayUMoney payment getway to the website. View More:Payumoney integration using Codeigniter Step 1: Login to PayUMoney.com as an merchant and get activated your account. Be ready with your PAN card and Bank account details for registration. After ...Read more..
Some reason, I am not able to access the admin and server is not supporting SEO friendly urls and I need to make website up and running. So I need to access database and update the table to change the url structure of wordpress so that pages can be access using ids. Here how you can ...Read more..
Here I am sharing, how you can update theme from database. Step 1: Go to database and browse the “wp_options” table and try to locate “template” and “stylesheet” in “option_name” fields. You can also run below query: SELECT * FROM wp_options WHERE option_name IN ("template","stylesheet") see the screen shot below: Step 2: In result you can observe the ...Read more..
Sometime it happens, you create field name or table name with reserve keywords in mysql. And than try to run query using that keyword, you will get some SQL syntax error like below: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to ...Read more..
I have already posted a blog (Event Scheduler an alternative to cronjob) with different advantages of Even scheduler over cron job, here I am sharing how you can configure MySql server to enable or disable scheduler and writing a sample event scheduler. You can check with below query as your server is up for event scheduler ...Read more..