[PrivT]

How would I go about making a PHP script that gets data from a MYSQL DB and places the information within a Listview type table.. for example.

Column 1 | Column 2 | Column 3 |
Data1 | Data1 | Data 1 |
Data2 | Data2 | Data 2 |


etc.. etc..

but I want to also be able to go to say ?page=AddNew
and be able to submit data to the database as well.

I have a general understanding of how to do it but I'm honestly confused on where to begin :\.

Any bit of help is appreciated!

[andrewsw]

1. You need to know PHP to a reasonable level, and understand how it works. Handling POST and GET data in particular.
2. Build the database perhaps using PHPMyAdmin
3. Understand enough of the MySql statement syntax (SELECT, INSERT, UPDATE).
3. Study the MySqli or PDO libraries to know how to retrieve and update data from PHP. PDO is more flexible as it will work with any database system.
4. Understand security implications and how to use prepared statements.

Look through the many tutorials on this site. For example.

This post has been edited by andrewsw: 17 January 2013 - 09:41 AM

[rpgmaker]

Take a look at this pdo tut
http://webdevrefiner...sql-code-sucks/
I would get the hang of pdo be for trying anything with POST and GET data .

This post has been edited by rpgmaker: 22 January 2013 - 10:50 AM