need advise about web database.

freemind

hi...
i m new to php and mysql. currently i m sufferring the pain from asp+ms access. i have spent some time on the php web site and forum. finally i decide to convert my asp to php.

i have two pages, let's called user page and admin page.
user page will have about 50 users to view the page at the same time, and it will be auto refresh at certain interval. The content of the page is a html table which list out about 30row n 12 column of records. these record retrieved from the mysql database for read-only purpose.
The admin page, which needs to modify the data in table or grid style format. after modify some data, user click a button and submit the changes at one time.

1> because of the user page will auto refresh at certain interval,
and might have simultaneous connections to the database. which method should i use to build the database connection? mysql_connect or mysql_pconnect? my webhost is running window 2000, support php4 and mysql.

2.> i have tried several methods for the admin page to update the data. currently i m using html table and form with textfield, looping througth the records and write the data as the value to each textfield. each textfield assign an id. after submit, update the changes to the database. i found this alternative from the internet, and it works. but it takes time to loop throught the records. please advise me that what is the best alternatives that i can use for the admin page?

thanks

MadGhigno

Originally posted by freemind
hi...
i m new to php and mysql. currently i m sufferring the pain from asp+ms access. i have spent some time on the php web site and forum. finally i decide to convert my asp to php.

i have two pages, let's called user page and admin page.
user page will have about 50 users to view the page at the same time, and it will be auto refresh at certain interval. The content of the page is a html table which list out about 30row n 12 column of records. these record retrieved from the mysql database for read-only purpose.
The admin page, which needs to modify the data in table or grid style format. after modify some data, user click a button and submit the changes at one time.

1> because of the user page will auto refresh at certain interval,
and might have simultaneous connections to the database. which method should i use to build the database connection? mysql_connect or mysql_pconnect? my webhost is running window 2000, support php4 and mysql.

I suggest to you to use the mysql_pconnect it should preserve resources on the server by re-using existing connections.
For more info: http://www.php.net/manual/en/function.mysql-pconnect.php

2.> i have tried several methods for the admin page to update the data. currently i m using html table and form with textfield, looping througth the records and write the data as the value to each textfield. each textfield assign an id. after submit, update the changes to the database. i found this alternative from the internet, and it works. but it takes time to loop throught the records. please advise me that what is the best alternatives that i can use for the admin page?

thanks

Why don't you open the table on the db filtering only the records you have to update ?

A thing like: SELECT * FROM <my table> WHERE ID = <id of the record to update>

freemind

Originally posted by MadGhigno

I suggest to you to use the mysql_pconnect it should preserve resources on the server by re-using existing connections.
For more info: http://www.php.net/manual/en/function.mysql-pconnect.php

Why don't you open the table on the db filtering only the records you have to update ?

A thing like: SELECT * FROM <my table> WHERE ID = <id of the record to update>

Thanks for your advise.
about the admin page, because of my client business requirements. i need to show the data in table/grid format for them to update the data in the fastest and easier way. so, the filtering sql command is not suitable for them.