2 Replies - 359 Views - Last Post: 22 January 2013 - 10:49 AM Rate Topic: -----

#1 PrivT  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 9
  • Joined: 16-February 09

How would I go about making this?

Posted 17 January 2013 - 09:01 AM

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!

Is This A Good Question/Topic? 0
  • +

Replies To: How would I go about making this?

#2 andrewsw  Icon User is online

  • It's just been revoked!
  • member icon

Reputation: 3619
  • View blog
  • Posts: 12,475
  • Joined: 12-December 12

Re: How would I go about making this?

Posted 17 January 2013 - 09:36 AM

*
POPULAR

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

Was This Post Helpful? 5
  • +
  • -

#3 rpgmaker  Icon User is offline

  • D.I.C Head

Reputation: 2
  • View blog
  • Posts: 224
  • Joined: 02-October 11

Re: How would I go about making this?

Posted 22 January 2013 - 10:49 AM

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

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1