Very Simply: 1.) Create database table with all of the columns you need. 2.) Create HTML form (name the HTML form elements the same as your column names). 3.) Point form
action to the Echelon Script with the appropriate table name & action to perform (insert, update, or delete). And you're done! Echelon takes care of all of the SQL
scripting for you. It will connect to the database, it will either insert, update or delete the appropriate data, then it will redirect back to the file of your choice. This
allows the web developer to modify database information very quickly when using HTML forms. Echelon cuts out the time consuming, repetitive, and hand written modification
Name: K.Palani, email: firstname.lastname@example.org It is a simple form wizard. The form contains all basic database functions and is styled like Visual Basic/FoxPro environment. The
form is not using any external libraries. It is pure PHP and HTML. The code is very simple to understand and can be used by beginners and intermediate programmers. It has lot
of scope for improvement. The beauty of the form is that it is a single form and it is not like clicking somewhere and viewing somewhere else. The form has navigation buttons
like MoveFirst, Next, Previous, MoveLast, Search, Delete. Also, there are buttons for inserting and updating records. Primary key values can be searched using the search
button. Values are fetched from table using the primary key value. It is ideal for creating table master forms and can be included in the project. Step 1: The user may copy
these files including /lib sub folder in the place understood by PHP and Apache web server. Step 2: The user may copy the billunit.php and name it differently. Connection
parameters may be set in 'lib/conn.php'. Step 3: The table name may be passed to the '$tablename' variable. Primary key field name may be passed to the '$pk' variable. Step 4:
A table template may be created/modified suitably according to your table requirements like label for the field and text input. The sample 'billunit.php' contains 3 fields.
Step 5: The names of the text input may be passed in the action buttons of 'Insert' and 'Update' as shown in the example. That is all. Save it and run from your browser.
Comments/criticisms/suggestions are welcome. I am at email@example.com .
A class for very basic MySQL database connectivity. Written to reduce redundant code in my own projects aswell as aid in debugging and error reporting during the developement
phase. Currently connects to a database, execute external files containing SQL commands, insert and update from an array of key => value pairs, insert and update with sql
command, query (one result), query (multiple rows), and dump a select query to a table. The zip file contains the class aswell as a demonstration script. See a screenshot
and/or download the example file at http://www.micahcarrick.com/v2/content/view/3/3/
This class is the missing link between an html form and its associated database table. It is designed to accept posted form data and input it directly into a database, without
having to manually type a list of each form field in the traditional manner.
Hi folks I have searched many sites for storing a picture into a database and retrieve the same. But I got some tutorials when I searched the web. Using the tutorials I have a
made one for me. It was implemented using Php and Mysql. I will tell you want is the job of each files. 1). index.php This files links all the files in the project. 2).
store.php This does the job of storing the picture into the database. 3). viewadd.php This file shows the entire picture stored in the database. 4). getpicture.php This file
actually gets the file from file in the form of picture 5). mdbc.inc.php This is a class file for Mysql feel free to use. I got this over net. Here is the table description Id
- > has the picture id Description -> has the picture description bin_data -> picture data filename -> picture file name filetype -> picture file type. Like gif
or jpeg etc link -> you can store the link incase if you want to use this for ad exchange showno - > no of time ad show etc clickcount -> no of time the ad being
clicked etc Query for the table. CREATE TABLE ads ( id varchar(15), description varchar(255), bin_data LONGBLOB, filename varchar(50), filesize varchar(50), filetype
varchar(50), link varchar(255), shownno integer(5), clickcount integer(5), unique(id) ); If you want to see a site where I have implemented please have a look at the site
http://www.asksathia.com/ Feel free to change anything in the code. If you developed a better version than this please send me the source code so that I may update myself. It
took me much time when commenting the code of ease of understanding. Please vote for me. Regards Imthiaz Rafiq firstname.lastname@example.org Msn id: email@example.com Yahoo id:
imthiazrafiq ICQ: 24294947 URL: http://high-flyer.da.ru
ZBase is an object framework written in PHP4 allowing to develop the www frontend of a database very quickly and simply. In ZBase, each entry in the database can be considered
as an object, and ZBase provides standard methods to modify or display its content.