PHP Form with array of fields

In this tip you will learn how to create an array of input type fields on PHP form when you do not know in advance how many records exist in the table. Records from a table or query will be displayed on the editable form. User may edit all fields data at once and save changes in the database.

create table credit_cards(
cardid INT NOT NULL AUTO_INCREMENT,
name varchar(20),
type varchar(20),
expired date,
card_num INT,
credit float,
phone varchar(12),
address varchar(100),
city varchar(20),
state varchar(2),
zip varchar(10),
PRIMARY KEY(cardid)
);

Read MySQL Manual to learn how to use command prompt to start MySQL server and client, and create database and table

"insert into credit_cards(cardid, name, type, expired, card_num, credit,
phone, address, city, state, zip) values (0, 'CHASE', 'Visa', '2008-01-01',
123456789, 10000, '123-345-6789', '12 West 19 Street', 'New York','NY','10021')";

"insert into credit_cards(cardid, name, type, expired, card_num, credit,
phone, address, city, state, zip) values (0, 'CITI', 'Mastercard', '2010-01-01',
192837465, 5000, '123-345-1234', '18 West 69 Street', 'New York','NY','10028')";

"insert into credit_cards(cardid, name, type, expired, card_num, credit,
phone, address, city, state, zip) values (0, 'American Express', 'Mastercard', '2010-01-01',
987654321, 8000, '123-345-4321', '8 West 9 Street', 'New York','NY','10028')";

PHP form with array of input type fields is almost the same as an regular PHP form. the difference is that input type name must have square brackets. For example:

You have to count number of records and pass it to the next page in hidden input type like that:

print('<input type="hidden" name="rec_count" value="'.$rec_count.'">);

In the template that inserts or updates records you have to execute query in the loop like that:

for($i=0; $i<$rec_count; $i++)

$sql="update mytable set myfield='".$myfield[$i]."'";

    if(!mysql_query($sql))
    {
    echo mysql_errno() . ": ";
    echo mysql_error() . "<br>";
    }

Edit mysql access variables on both php files. Type your hostname if it is not localhost, type your user name (it is not recomended to use root user), type your password, and your database name.

$hostname="localhost";
$dbuser="root";
$dbpassword="aspirin";
$dbname="credit";

Copy these files in arrayfields folder in htdocs directory on your PC and to start example type in the browser ulr:

Form with data from credit_cards table displays. Edit fields value and press Update button All records will be updated and displayed on the form. Play with the code.

mysql_connect()[function.mysql-connect] Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Apache2\htdocs\examples\fieldsarray.php on line 10 Unable to connect

Register to add comments ( 1000 char ) for arrayoffields.php.

Computer Programming Web programming Tips

PHP Form with array of fields