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]

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

"Michel" ,

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

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

You can download it from www.download.com

Regards
Hoe

[Fritzoune]

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

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.030910 1251.1f70b5f4@p osting.google.c om...[color=blue]
> 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![/color]

[Nikolai Chuvakhin]

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

michelratipho@m ail.com (Michel) wrote in message
news:<a9ee3bbf. 0309101251.1f70 b5f4@posting.go ogle.com>...[color=blue]
>
> 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?[/color]

Yes. Easily. Read the PHP Manual:

http://www.php.net/mysql

[color=blue]
> How much data can MYSQL with PHP handle?[/color]

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]

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

Hi Michel!

On 10 Sep 2003 13:51:19 -0700, michelratipho@m ail.com (Michel) wrote:
[color=blue]
>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?[/color]

PHP can pretty much do everything, have a look at the extensions at

https://www.php.net

[color=blue]
>Can I make a link on the site to download some requested data like the
>sales-log in 1 text or Excel-file?[/color]

Sure, or have it send by email regularly.
[color=blue]
>How much data can MYSQL with PHP handle? What about 1.000.000 sales
>and finding a product within 100.000 products?[/color]

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]

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

michelratipho@m ail.com (Michel) schrieb:
[color=blue]
> 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?[/color]

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.
[color=blue]
> Can I make a link on the site to download some requested data like the
> sales-log in 1 text or Excel-file?[/color]

Yes.
[color=blue]
> How much data can MYSQL with PHP handle? What about 1.000.000 sales
> and finding a product within 100.000 products?[/color]

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]

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

Yep, php + mysql can do all this quite efficiently

"Michel" <michelratipho@ mail.com> wrote in message
news:a9ee3bbf.0 309101251.1f70b 5f4@posting.goo gle.com...[color=blue]
> 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![/color]