database

I was working with the admin of a website and client needed to save Google Analytic code into the database. So I created a panel where he could save JavaScript code into database table to retrieve it in footer of website on every page. And then I created a section to save meta code for […]

{ 0 comments }

This is tricky one. At-least for me. I could make use of the following script but it has a problem as well. After much research, you find few scripts and many of those do not work properly. I want to share with you what is working for me. This database backup script will create a […]

{ 0 comments }

Actually I was having hard time in setting up a database backup script. It was using a function and it was not being controlled easily. If I implemented a simple check that if form was posted then run that db-backup script, it was simply giving call to undefined function. By reloading page backup copies are […]

{ 0 comments }

Just tried another one and it is more effective because it selects a given Database in mySQL host, and optimizes it. Best about it is, it also provides results for every table in the database that how much of size was that table and how much it was optimized. Great PHP script to optimize single […]

{ 0 comments }

Just tried it and its great. Give this script hostname, user and password and it will optimize all the databases in given host. Here it is:

{ 0 comments }

Setting up a database connection can be a difficult task if you google through different codes present online. Here is the easy most method to create a dbconnection for PHP and mysql.

{ 0 comments }

Create a file index.php and insert.php. Also create a DataBase with some name lets say mydb in mysql. After creating database named as mydb add a table named as mydbtb in it with four fields. If you do not know about mysql then just open it and create a database mydb in it and run […]

{ 0 comments }