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

[Michel]

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!

[tnhoe]

"Michel" ,

Hi, I am new starter in Php+MySQL too.

I recently rececomended to a tool call easyPhp which includes the
webserver,php,MySQL and it's really easy to understand and working.

You can download it from www.download.com

Regards
Hoe

[Fritzoune]

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" <mi***********@mail.com> a écrit dans le message de news:
a9**************************@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!

[Nikolai Chuvakhin]

mi***********@mail.com (Michel) wrote in message
news:<a9**************************@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

[Jochen Daum]

Hi Michel!

On 10 Sep 2003 13:51:19 -0700, mi***********@mail.com (Michel) wrote:

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?
PHP can pretty much do everything, have a look at the extensions at
www.php.net
Can I make a link on the site to download some requested data like the
sales-log in 1 text or Excel-file?
Sure, or have it send by email regularly.
How much data can MYSQL with PHP handle? What about 1.000.000 sales
and finding a product within 100.000 products?

This is more a database question. I'm sure MySQL can handle this with
an appropriate server, but there are other problems that may arise,
which might point you to another database.
HTH, Jochen
--
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/

[Matthias Esken]

mi***********@mail.com (Michel) schrieb:

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?
Yes, of course. PHP is running on the server, so accessing the database
should be no problem. Which database do you want to use: Oracle, MySQL,
Postgres, MS-SQL, ... ? PHP works with all of them.
Can I make a link on the site to download some requested data like the
sales-log in 1 text or Excel-file?
Yes.
How much data can MYSQL with PHP handle? What about 1.000.000 sales
and finding a product within 100.000 products?

I just started do add data warehouse funtionality to a very small
application. My script and the MySQL database ran on a 1GHz Celeron and
INSERTed 1.7 million records in one table in less than 90 minutes. It
could have been faster but the script did some million SELECTs on the
same database to gather the data. The time the database needs to find a
record in this table is far below one second.

Regards,
Matthias

[Barry B]

Yep, php + mysql can do all this quite efficiently

"Michel" <mi***********@mail.com> wrote in message
news:a9**************************@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!