Entering into MySQL Database with PHP? Or just a simple 'post' form?

[MatthewBOnline]

Hi,

I have designed a login page at our web site which requires a username and password.

What is the best way for users to add content to a database? May be a simple form using 'post' will be fine? I could design 30 boxes asking for

- product name
- product price
- product code
- content
- In stock/Out of Stock
- etc., etc.

Essentially I just need to recreate on a web page the "Insert" part of PHPMyAdmin.

Is there a way that PHP can be used to enter info. into a database from a web page?

How will my form used for data-entry know to auto-increment the entries?

Look forward to your comments,
Matt.

[StarLion]

Essentially I just need to recreate on a web page the "Insert" part of PHPMyAdmin.

Is there a way that PHP can be used to enter info. into a database from a web page?

answered your own question here. What do you think phpMyAdmin is?

How will my form used for data-entry know to auto-increment the entries?

Your query should not submit auto_increment fields. auto_increment fields will automatically (hence the 'auto') get filled by mySQL when you do an insert without that field.

[MatthewBOnline]

ok - i understand about the auto-increment.

Are you suggesting i should only use PHPMyAdmin?

I do want an online form instead. Can it be done with PHP?

Matt.

[StarLion]

My point was that phpMyAdmin IS a PHP web-page... so of course it can be done in php

[MatthewBOnline]

What is the function I should be using to add data using PHP?

I thought about using a form and the function 'post'. But this is not PHP and I think PHP would be a more sensible method for adding data.

What is the main function to use to add content to a MySQL table? Then I can read up on it.

Matt.

[StarLion]

mysqli_connect
mysqli_query

probably a good place to start looking.