Database Functions - PHP Example


HOME \| HOSTING COUPON \| TEMPLATE \| PHP SCRIPTS \| LINK TO US \| LINK \| REGISTER \| CONTACT

::: Member Login :::

::: PHP Tutotal :::

PHP Basic (7)

PHP Advanced (4)

PHP Database (2)

Coding Step By Step (8)

PHP and AJAX (0)

::: PHP Example :::

Arrays (1)

Code Highlighters (3)

Database Functions (12)

Date & Time (5)

E-Mail (6)

Forms (5)

Guestbooks (1)

Logging (2)

Miscellaneous (10)

Password Generators (3)

Randomizers (3)

String Manipulation (10)

User Authentication (6)

::: Search On T4VN :::

::: T4VN Statistics :::

PHP Scripts : 65

PHP Example : 67

PHP Tutorials : 21

PHP News : 93

Total Coupon : 36

Other Tutorials :

Member : 266

::: Sponsored Links :::

Home / Database Functions	Today :

Creating a Members List This will simply display the ID and Username of the members in your database.

Get data from multiple fields - tables You can use this function to grab data from your database by creating an array and calling the function. You should be able to make each parameter an array (the table, field, etc) but I have only tested the field parameter. The require include.php contains the database info: $DBhost, $DBuser, $DBpass, $DBname, etc...

Check if a table exists Checks whether a table exists in the specified database. Returns true if the table does exist and false if it doesn't. Aslo returns false if the login information is incorrect and/or the database being called isn't present. If you have variables or constants set up for the your mysql login information, they can easily be integrated into this function. This eliminates the need to several arguements in the function.

SQL script import function Sometimes you might need a function that imports an entire .sql file into the MySQL database. This function will help you do that.

I have two functions:

1. mysql_import_file : simply imports a file as is
2. mysql_install_db : creates a given DB as well as imports a given SQL file for that DB

1 2 3 Next

::: Resources :::

Links Directory

Suc Khoe Viet

Programming 2 3

Webmaster 2 3

Web Design 2 3

Web Hosting 2 3

Other Links 2 3

Asian ShowBiz News

Teach Seo For You

Đào Tạo PHP

Thai Cuc Quyen

::: New Templates :::

::: Other Tutorials :::

Program Design