Re: [PHP-DB] Inventory Management for ecommerce store
From: Aaron Wolski [EMAIL PROTECTED] Friday, May 21, 2004 12:21 PM Subject: RE: [PHP-DB] Inventory Management for ecommerce store All cart records are stored to the database with a timestamp. On each call to the cart_script, I check to see if any records are older than 24 hours and if they are, I dump the quantity back into inventory and remove the entry from the DB. If your updates to the inventory counts are in two separate sql statements, then you should use transactions. That's because if I hit the stop or back button, the php script will stop executing, and some of the script and sql won't get executed. So, you may find that you are updating all of the tables when you scan your code, but site visitors can interrupt that process -- especially those that hit back and forward quick. If you're using mysql, you need to use inno_db tables in order to use transactions. --- The future will be better tomorrow --- http://www.spiceplace.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Informix and PHP
El Vie 21 May 2004 14:48, D. Sandmann escribió: Any help would be appreciated on this. I have already asked this question on the regular PHP and Informix news groups and have not had any luck. Maybe one of you can resolve my problem. I have had this problem in the past on another machine and fixed it by setting the environment variables for INFORMIXDIR and INFORMIXSERVER. When adding the same lines on the new machine I still get the following message: Warning: ifx_pconnect(): E [SQLSTATE=IX 001 SQLCODE=-1829] in C:\webroot\PHPinclude\db_vars.inc on line 7 Maybe it's becuase Informix has some problems. I don't know how it works on windows, but on UNIX I would run: $ finderr -1829 That would give me a discription of the error that Informix gave Apache. Try it. -- 09:20:02 up 7 days, 19:31, 1 user, load average: 0.60, 0.49, 0.37 - Martín Marqués| select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] DB Error: no such table
I am experiencing a strange problem whilw using DB.php. I am getting the no such table error from my php script, but I can echo the sql statement to the browser and copy paste it into psql and it works fine. At first I thought maybe I wasn't connecting to the DB, but I am not getting any error returned from the $db = DB::connect($dsn); Any help troubleshooting will be greatly appreciated. --Richard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] DB Error: no such table
(embarrassed and hiding) sorry for the trouble. It would help if I could spell things the same twice. --Richard On 22 May 2004 at 11:35, Richard B. Pyne wrote: I am experiencing a strange problem whilw using DB.php. I am getting the no such table error from my php script, but I can echo the sql statement to the browser and copy paste it into psql and it works fine. At first I thought maybe I wasn't connecting to the DB, but I am not getting any error returned from the $db = DB::connect($dsn); Any help troubleshooting will be greatly appreciated. --Richard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] [Php]como saber la resolucion de pantalla del usario
buneo tengo el siguiente problema nesesito aser que el php guarde en una variable llamada $resolucion la resolucion del usario. la reason por la que quiero al reolucion es pa luego aser una simple comparasicon y saber que archivo debo jalar por un require. para que las tablas de mi web luscan bien en cualquier resolucion. asi que si alguien sabe como peudo aser que una variable tome el tamaño de la resolucion diganmelo profa.