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 : 61

PHP Example : 67

PHP Tutorials : 21

PHP News : 93

Total Coupon : 36

Visitor Online : 3

Today Visit: 216

Total Visitor : 229493

Most Online : 31

::: 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

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

::: New Templates :::

::: Other Tutorials :::

Program Design