PHP Magic Book – Free PHP Scripts, Tutorials and Downloads

Archive for the ‘ php mySQL ’ Category

Date Object For Future or Past – Easy Monthwise or Datewise Records Selection Using PHP

Monday, October 20th, 2008 | Posted in Date & Time, Select, Tricks, Useful Scripts, php mySQL | 1 Comment

If you have to create a date object of future or past, you can do it by using the second parameter of PHP date function. This is extremely useful when doing BETWEEN comparison in MySQL. You can build the date and bind it to query.

(more…)

Tags: date, month, Select, time
Posted in: Date & Time, Select, Tricks, Useful Scripts, php mySQL
Post's RSS » RSS 2.0
Post's Comments RSS » RSS 2.0
Respond: Post A Comment

PHP Easy Most Database Connection

Monday, June 23rd, 2008 | Posted in MySQL, connection, database, php mySQL | No 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.

(more…)

Tags: database, db
Posted in: MySQL, connection, database, php mySQL
Post's RSS » RSS 2.0
Post's Comments RSS » RSS 2.0
Respond: Post A Comment

Adding Record In Database Using PHP

Thursday, June 19th, 2008 | Posted in MySQL, php mySQL | No 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 this query in it from query window.

(more…)

Tags: add, connection, database, insert, MySQL, php mySQL
Posted in: MySQL, php mySQL
Post's RSS » RSS 2.0
Post's Comments RSS » RSS 2.0
Respond: Post A Comment

Detecting Database And MySQL Connections in PHP – PHP DBConnection

Thursday, June 19th, 2008 | Posted in MySQL, php mySQL | No 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 script can find the database and mysql. In case it can not locate any of these then we just tell the script to exit and stop proceeding.

(more…)