content top

List of MySQL Functions in PHP

List of MySQL Functions in PHP

Name – Descriptions mysql_affected_rows — Get number of affected rows in previous MySQL operation mysql_client_encoding — Returns the name of the character set mysql_close — Close MySQL connection mysql_connect — Open a connection to a MySQL Server mysql_create_db — Create a MySQL database mysql_data_seek — Move internal result pointer mysql_db_name — Get result data mysql_db_query — Send a MySQL query mysql_drop_db...

Read More

Chained Select Box Generator

Chained Select Box Generator

Well everyone, I’m almost done with the generator!! Watch this short clip to see it in action. Features: Generate on the fly 3 tier chained selects. View the chain after its created. Edit an existing chain as easy as you made it. Delete chains. Export chain files. Export chain CSV database file. Build unlimited chains and unlimited options. Upload the generator, create a database, edit 1 file and your ready to make chains! A...

Read More

Ajax with jQuery in 3 easy steps

Ajax with jQuery in 3 easy steps

I figured I would make this small tutorial for all of you curious about it. Pulling data from a database with ajax should not be feared. It is actually very simple. The majority of the work is in the server side part of the ajax. So for this tutorial I will show you how to check if a username exists in a database. DEMO Step 1 So lets start by adding the jQuery into the head of the page where the form is. $(document).ready(function()...

Read More

jQuery: Filter Select box with php and mysql

jQuery: Filter Select box with php and mysql

Lets filter a select box with jQuery, Sack, PHP and MySQL….. You may or may not need this, but it could come in handy at one point in time. So lets start.. I will show you the basics here, you may download the source at the bottom of the page. View the DEMO index.html include these into the head section of the page. ajax.js is the Sack js functions. I will get into Sack later. this goes into the head as well. var ajax = new...

Read More

5 Minute Flex Data Grid

5 Minute Flex Data Grid

So you want a quick solution for a data grid with inline edit, add, delete, search and sorting? I’ve got just the answer for you. …..Adobe Flex. Finished Data Grid: Demo So lets start, The data used for the grid will be pulled from a MySQL database. If you don’t have one ready, use this to get an idea. CREATE DATABASE `flex_grid` ; CREATE TABLE `flex_grid`.`grid_data` ( `user_id` INT( 11 ) NOT NULL AUTO_INCREMENT...

Read More

PHP Percentage Bar

PHP Percentage Bar

Source Files: DOWNLOAD View working examples here: DEMO MySQL Table, used for example. CREATE TABLE IF NOT EXISTS `percent` ( `per_id` int(11) NOT NULL auto_increment, `per_num` varchar(255) NOT NULL, PRIMARY KEY (`per_id`) ) ENGINE=InnoDB; 1. Lets start with the MySQL Connection, I named this file dbcommon.php. Besure to change the username, password and database to your own. mysql_connect("localhost", "username", "password") or...

Read More
content top