Connecting to SQL database

[dmccabe]

I have used PHP a little to connect to a mySQL database, but I wondered if it is possible to connect and update a SQL database.

 

The reason for this is on the Sage Accounting system we use at work, the typists occasionally make errors in the PO number field, the only way we have at the moment to correct this error is to go in to the database server manually and find the invoice and update the field.

 

Obviously we dont let the typists do this in case they bugger something up.

 

So I want to create a simple PHP form for them to use to update the field.

 

If it is possible, then are there any special considerations I should make when creating this script?

[rhodesa]

Sure, do you have anything started yet?

 

Step 1...you need a way for them to pick which record they want to edit.

Step 2...now that you know which record, select the PO number from the table

Step 3...display a form with a text box, put the current PO number in the text box

Step 4...have the form submit to a PHP script that does an UPDATE command. here is where you will want to validate the information they put in

 

here is a site to some tutorials about PHP. they have stuff in there about submitting forms, reading/writting to DBs, etc:

http://devzone.zend.com/node/view/id/627

 

hope that helps