Can I use PHP for selecting and writing data into a server-database?

Hi,

I like to build a small simple dinamic website: Point-of-sale
(detail-shop), So entering stock, logging all sales, print out
invoices and download the logs to be imported into Excel.

I once could write a bit in ASP/SQL/HTML/JAVASCRIPT and even some
Excel-VBA but have lost most knowledge about that and I never know a
lot nor did I know how to set up a simulating PC to write and test the
website.

I don't want to spend much money buying Microsoft product, so I've
heard that PHP with MySQL can do it for free, right? But all I find is
that PHP can look up data in a file on the server and send dinamicly
changed HTML, but can it also write data on the servers data-bases?
Can I make a link on the site to download some requested data like the
sales-log in 1 text or Excel-file?
How much data can MYSQL with PHP handle? What about 1.000.000 sales
and finding a product within 100.000 products?

Thanks already for reading this!

Everything is possible !!
with PHP and MYSQL !
Maybe try to buy a book , plenty of books talk about PHP with MYSQL.
but you'll have to learn. it's not that complicated.
It's free, it can insert, read, move, ... data into/from your BD
handle many connexions.
just browse the net about this.


--
Salutations,

Fred !
ICQ: 46063572
"Michel" <michelratipho@mail.com> a écrit dans le message de news:
a9ee3bbf.0309101251.1f70b5f4@posting.google.com...
> Hi,
>
> I like to build a small simple dinamic website: Point-of-sale
> (detail-shop), So entering stock, logging all sales, print out
> invoices and download the logs to be imported into Excel.
>
> I once could write a bit in ASP/SQL/HTML/JAVASCRIPT and even some
> Excel-VBA but have lost most knowledge about that and I never know a
> lot nor did I know how to set up a simulating PC to write and test the
> website.
>
> I don't want to spend much money buying Microsoft product, so I've
> heard that PHP with MySQL can do it for free, right? But all I find is
> that PHP can look up data in a file on the server and send dinamicly
> changed HTML, but can it also write data on the servers data-bases?
> Can I make a link on the site to download some requested data like the
> sales-log in 1 text or Excel-file?
> How much data can MYSQL with PHP handle? What about 1.000.000 sales
> and finding a product within 100.000 products?
>
> Thanks already for reading this!

michelratipho@mail.com (Michel) wrote in message
news:<a9ee3bbf.0309101251.1f70b5f4@posting.google. com>...
>
> PHP can look up data in a file on the server and send dinamicly
> changed HTML, but can it also write data on the servers data-bases?

Yes. Easily. Read the PHP Manual:

http://www.php.net/mysql

> How much data can MYSQL with PHP handle?

This question really has nothing to do with PHP. MySQL will handle
the data as long as the data file size is within the limits imposed
by the operating system it is running on. Read the MySQL Manual:

http://www.mysql.com/doc/en/Table_size.html

Cheers,
NC

Yep, php + mysql can do all this quite efficiently

"Michel" <michelratipho@mail.com> wrote in message
news:a9ee3bbf.0309101251.1f70b5f4@posting.google.c om...
> Hi,
>
> I like to build a small simple dinamic website: Point-of-sale
> (detail-shop), So entering stock, logging all sales, print out
> invoices and download the logs to be imported into Excel.
>
> I once could write a bit in ASP/SQL/HTML/JAVASCRIPT and even some
> Excel-VBA but have lost most knowledge about that and I never know a
> lot nor did I know how to set up a simulating PC to write and test the
> website.
>
> I don't want to spend much money buying Microsoft product, so I've
> heard that PHP with MySQL can do it for free, right? But all I find is
> that PHP can look up data in a file on the server and send dinamicly
> changed HTML, but can it also write data on the servers data-bases?
> Can I make a link on the site to download some requested data like the
> sales-log in 1 text or Excel-file?
> How much data can MYSQL with PHP handle? What about 1.000.000 sales
> and finding a product within 100.000 products?
>
> Thanks already for reading this!