ajaxCRUD.com

» a PHP class to create / read / update / delete from a database table using AJAX

Quick Links:

Quick Examples:

www.allthewebsites.org

File Upload Example

Consider the following table:

	CREATE TABLE tblMyMp3CollectionDemo(
	pkMP3ID INT PRIMARY KEY AUTO_INCREMENT,
	fldFilename VARCHAR(150),
	fldTitle VARCHAR(60),
	fldArtist VARCHAR(60),
	fldGenre VARCHAR(40)
	);

File uploading for this demo has been disabled due to repeated hacking attempts.

fldFilename	fldTitle	fldArtist	fldGenre
1 (edit delete)	1 Saving...	1 Saving...	Rock
Add File	Saving...	Saving...	Rock
test (edit delete)	mp Saving...	aman Saving...	Country
Add File	Saving...	alex sintek Saving...	Pop
Add File	Saving...	Saving...	Pop
ad (edit delete)	ad Saving...	ad Saving...	Country
ad (edit delete)	sd Saving...	f3 Saving...	Rock
1.mp3 (edit delete)	come together Saving...	hale Saving...	Blues
2 (edit delete)	2 Saving...	2 Saving...	Trance
ad (edit delete)	sd Saving...	hola Saving...	Pop
Add File	dasdsa Saving...	asdadasd Saving...	Rock
Add File	f Saving...	f Saving...	Rock
Add File	hvj Saving...	bkbkbbk Saving...

Class Implementation:


#include the class
include ('ajaxCRUD.class.php');

#this one line of code is how you implement the class
$tblDemo = new ajaxCRUD("MP3 File",
     "tblMyMp3CollectionDemo", "pkMP3ID");

$tblDemo->omitPrimaryKey();
$tblDemo->setFileUpload("fldFilename", "uploads/");

$allowable_vals = array("Rock", "Euro Pop", "Trance", "HipHop");
$tblDemo->defineAllowableValues("fldGenre", $allowable_vals);

#actually show to the table
$tblDemo->showTable();

View Example by Itself

Click here to view example outside of the template.

Recent Feedback

"OMG! This is just what I was looking for. Thanks so much. This is amazing!" - Posted by Simone on Friday Jul 11^th, 2008 at 4:34pm

"Sorry all -- had to disable uploading due to hacking attempts. Feel free to try out on your own server though!" - Posted by Sean Dempsey on Sunday Sep 14^th, 2008 at 7:23pm

"comment2, " - Posted by jonn2 on Sunday Nov 9^th, 2008 at 6:21am

"awesome it is best
working fine
thanks" - Posted by fakhru on Tuesday Dec 16^th, 2008 at 5:28am

"ajaxCRUD.class.php on line 1238" - Posted by Juan Carlos on Monday Jan 19^th, 2009 at 4:32pm

"just what i looked for..." - Posted by Sergey on Wednesday Mar 25^th, 2009 at 11:02am

"I can`t wait to give this a try." - Posted by Fortin on Thursday Mar 26^th, 2009 at 3:58pm

"I can`t wait to give this a try." - Posted by Fortin on Thursday Mar 26^th, 2009 at 3:59pm

"Brilliant. Saved insane amounts of time. `nuff said."
~Soule