ajaxCRUD.com

» a PHP API 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
Add File	asd Saving...	asdasd Saving...	Pop
Add File	Saving...	Saving...	Pop
Add File	Saving...	Saving...	Rock
Add File	2 Saving...	3 Saving...	Rock
Add File	Saving...	Saving...	Blues
Add File	Saving...	Saving...	Rock
Add File	tt Saving...	tt Saving...	Rock
Add File	TitleS Saving...	Britney Tops Saving...	Rock
Add File	Saving...	Saving...	Rock
Add File	aaa Saving...	zzz Saving...	Country
Add File	Saving...	Saving...	Rock
Add File	sss Saving...	sss Saving...	Euro Pop
Add File	Saving...	Saving...	Rock
Add File	fdgfd Saving...	fdgfdgf Saving...	Euro Pop
dd (edit delete)	dd Saving...	d Saving...	Country
sdfdsf (edit delete)	sdf Saving...	sdfsdf Saving...	Country
Add File	title Saving...	artist Saving...	Rock
gdsfg (edit delete)	sdfg Saving...	sdfg Saving...	Rock
Add File	Saving...	Saving...	Country
Add File	Saving...	Saving...	Blues
asdfasdf (edit delete)	asdfasdf Saving...	asdfasdf Saving...	Rock
teste (edit delete)	tset Saving...	tsets Saving...	Rock
Add File	Saving...	Saving...	Country
folky.mp3 (edit delete)	folky Saving...	charrito Saving...	Country
folky.mp3 (edit delete)	folky Saving...	charrito Saving...	Country
poppy.mp3 (edit delete)	sdffffffffffffffffffffffffffffffffffffffffffffffffff Saving...	gsdfgsdfgsdfgsdfgsdfg Saving...	Pop

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

"I love AjaxCRUD! It's saved me hours upon hours of typing!"
~Eric Duwenhoegger

"AjaxCRUD is wonderful."
~Peter Barone