MySQL

Being a website developer, I always wanted a control in which I can find visitor’s country name, country code, region or state name and city name. I wanted to redirect users based on their country and region. Now we have a script that let’s your visitor choose or set location so that he can perform […]

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 }

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 }

This example describes that how we can find that database and mySQL connections are established or not and what to do if one of the connections is not established. First we define dbuser, dbpassword and database name and then create a db connection and mysql connection and then check these if these are established and […]

{ 0 comments }

After execution of mysql query its appropriate (even essential) to close mySQL connection. Use the following script to close mySQL connection.

{ 1 comment }