[PHP-DB] Can DBA(Database Abstract) function can work under Win2k?
My PHP runs under: Windows 2000 Professional + Apache/1.3.20 + PHP4.0.6 + MySql3.23.32 when i compile the following code: There is the error: Fatal error: Call to undefined function: dba_open() in D:\Inetpub\WebSite/dba_test.php on line 2 Thank you! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Komodo?
Anyone use Komodo to do remote debugging? I can't get the remote debugger feature to work. I have Linux Red Hat 7.1, apache, php 4.0.6. When I start Komodo IDE, and load a web-page in my browser, the Komodo IDE never seems to get connected. It just sits in the "listening" mode indefinitely. The web page loads as normal BAH! -- == Grant Boggs http://www.cornersonesoftware.ws -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: TopSpeed
"Guilherme Bresser" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have one problem.. TopSpeed don't support ODBC.. > :-\ This is the only method I've seen for languages other than Clarion. http://www.softclaim.com/odbc_interface.htm If there ARE any other methods, I'd love to hear about them! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Store Procedures
on slashdot.org today... ;) http://software.tangent.org/article.pl?sid=01/08/23/0817244&mode=thread&threshold= MySQL Gets Perl Stored Procedures (Embedded image moved to file: pic22355.gif)Posted by CmdrTaco on Friday August 24, @11:52AM from the well-isn't-that-special dept. ryarger writes "Woo Hoo! After a seeming eternity of wait, there is finally an implementation of stored procedures for MySQL. It uses Perl as the stored proc language, too!" Also note that this piece of work was done by OSDNs own Krow. Very cool work I must say. ( Read More... | 155 of 221 comments ) Rick Emery , .com>"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: 08/23/2001 Subject: RE: [PHP-DB] Store Procedures 10:08 PM no -Original Message- From: Francisco Carvalho [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 4:20 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Store Procedures Newbie question. I've been developing web application in IIS using ASP and Microsoft SQL Server 7.0. I use "Stored Procedures" quite extensible is there an equivalent in MySQL Thanks. Francisco Carvalho -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] IMPORTANT NOTICE The information in this e-mail is confidential and should only be read by those persons to whom it is addressed and is not intended to be relied upon by any person without subsequent written confirmation of its contents. Furthermore, the content of this e-mail is the personal view of the sender and does not represent the advice, views or opinion of our company. Accordingly, our company disclaim all responsibility and accept no liability (including in negligence) for the consequences of any person acting, or refraining from acting, on such information prior to the receipt by those persons of subsequent written confirmation. In particular (but not by way of limitation) our company disclaims all responsibility and accepts no liability for any e-mails which are defamatory, offensive, racist or in any other way are in breach of any third party's rights, including breach of confidence, privacy or other rights. If you have received this e-mail message in error, please notify me immediately by telephone. Please also destroy and delete the message from your computer. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message is strictly prohibited. Trinity Mirror plc is the holding company for the Trinity Mirror group of companies and is registered in England No. 82548, with its address at Kingsfield Court, Chester Business Park, Chester CH4 9RE. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addition
[PHP-DB] SAPDB
Hi all, I've been using SAPDB and PHP, but it doesn't have functions of it own. It uses the Unified ODBC. Is it something bad? MySql, Postgres, Oracle and others have functions for that particular DB. Will it be slower? Alex -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Extensions on SuSE
Ridai Govinda Pombo wrote: > > Does anyone know how to get the _binary_ extensions for PHP installed with > SuSE 7.2 ? > > I think it needs to recompile... But I wanted a easier way to solve it... > > Thanks, > > Ridai Govinda Do you mean doing in Linux the same as in Windows? Only doing some comment in php.ini and another extension installed? I installed the SAPDB extension recompiling the source code... Alex -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Access tables to PostgreSQL
Grant wrote: > > On Wed, 22 Aug 2001, Tim O'Brien wrote: > > > What is the best method to move data from access tables to postgreSQL? > > > > Are there are php functions that are available? > > > Unfortunately, only Access reads Access very well, but you can use ODBC > and linked tables in Access to copy it to PostgreSQL. I copied tables from Access to Postgres using this method: 1. Install the ODBC Driver in your Windows Box. 2. Export the tables to Postgres. If the second pass doesn't work, create the tables in POstgres and then link them in Access and build a append query that copies all the information from the acess tables to the postgres tables. Alex -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: Photo Album Schema
Hi, By saying id.gif, I obviously didn't mean the id of the user, I meant the unique id of the image. I assumed the person making this was going to have one table setup like so: id (unique id) owner name description jpg_or_gif, etc Then a table with authors.. id name pass email etc with author.id = picture.owner I see no downside to doing that and it seems to be a relatively effecient way to ensure the uniqueness of all image names. Best Regards, Bill Zeller --- Sheridan Saint-Michel <[EMAIL PROTECTED]> wrote: > I don't know if having multiple users associated > with a single image is > at all beneficial, and I can see where it might > cause all sorts of problems. > > For example, you and I both have the same image in > our album (we are > both assciated with it in the DB). What happens > when I change the > description? Do you change the description field, > thus changing the > description on both our pages? Do you now have to > create another entry > in your Image table? In effect anytime I change the > description either both > of us have to live with my new description or you > have to do a lot of work > around code (checking to see if more than one person > is associated with the > image, Adding a new entry into image, changing all > my info to reflect the > new > Image_Name) to avoid this. > > Therefore, I think for this project, the original DB > structure works much > better. > > Sheridan Saint-Michel > Website Administrator > FoxJet, an ITW Company > www.foxjet.com > > - Original Message - > From: "grant" <[EMAIL PROTECTED]> > To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]> > Cc: "Bill Zeller" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Thursday, August 23, 2001 1:48 PM > Subject: Re: [PHP-DB] Re: Photo Album Schema > > > > The most useful schema would be to have the name > of the document be system > > generated, like i123456789.img and make the > database as follows: > > > > Image > > Image_Name varchar(50) primary key > > Original_Name varchar(50) > > Description text > > > > User > > User_ID int8 primary key > > Login char(8) uniques index > > password varchar(50) encrypted > > > > relation > > User_ID > > Image_Name > > > > Now you have duplicate anems OK, multiple users > associated with any > > picture. You just rename the file as it comes and > goes. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] I am really stuck
I don't believe anybody answered this, but here's an option: 1) Assumes table "mytable" has defined a field as: article_date date. The following will purge anything before today. $query = "DELETE FROM mytable WHERE article_date < ".date("Y-m-d",time()); 2) $query = "SELECT DISTINCT article_date FROM mytable ORDER BY article_date"; $result = mysql_query($query) or die("Error message"); while( $ddrec = mysql_fetch_array($result)) { $dd = $ddrec['article_date']; print $dd; # you'll have to format this date print statement $query = "SELECT * FROM mytable WHERE article_date = $dd"; $dresult = mysql_fetch_array($query) or die("error message"); while( $irec = mysql_fetch_array($dresult) ) { print $irec['item_text'].""; } mysql_free_result($dresult); } mysql_free_result($result); May require some additional tweaking -Original Message- From: Matt C [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 6:36 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] I am really stuck I am extremely stuck with trying to do two things. 1) I would like to pull all entries out of a table that have dates that haven't occured yet. Basically forget anything before the current day. How do I do that? 2) I enter news into a table and would like to display a summary page. Basically it has a list of headlines under the date they were added. Monday 10th August *Item 1 *Item 2 Tuesday 11th August *Item 1 etc How do I do that? Any help much appreciated, Thanks, Matt _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] oracle 9i + apache
Hi As anyone sucesfully compiled php4 with OCI suport as an apache module on a Oracle 9i database ? if so i would be very intersted by some tips on how make it work. i couldnt make it , on a linux Suse7.2, kernel 2.4.4 i have been able to suceffuly compile php statically, making a symlink from libclntsh.so.9.0 to libclntsh.so.8.0 if i run "php" as a comand interpreter for a script ,the script will sucefully use OCI8 function. hoever this does not seam to work for a php apache module. apache wont start (at least for me) i tried on the oracle apache java server, or on the suse pre installed one .. i olso tried to compile php on this sytem, but using withOCI="dir to an old copy of oracle8" so it would really link with the v8 librarys ... it dont works neither. i havent tried yet to make php as static lib to build apache with it as a static build-in module. but this is not really an option i can have on production for that system.(i have to use a third-party apache binary) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: TopSpeed
I have one problem.. TopSpeed don't support ODBC.. :-\ Guilherme Bresser "Hugh Bothwell" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > "Guilherme Bresser" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi... I'm from Brazil my english is bad!!! > > > > Can I connect one Script PHP with a TopSpeed Database (*.tps)?? > > Use ODBC drivers. > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Zend IDE anyone?
"Grant Boggs" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "Steve Brett" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > no need to recompile. > > > > the debug server is a .so and only needs added lines php.ini Woohoo!!! I had a typo in my php.ini file! Works like a charm. Very cool. I think this is what I might be needing. Was testing some stuff with it. I like it so far! Thanks for the helpful pointers and saving me the headaches of recompiling!!! -- == Grant Boggs http://www.cornersonesoftware.ws -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Variables in MySQL Insert Queries
plague -- unfortunately i don't have the beginnings of this thread, but if your code below is verbatim, it looks as though you are missing the mysql_query() statement. that should drop your information. kate > -Original Message- > From: plague [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 24, 2001 12:57 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Variables in MySQL Insert Queries > > > I am using this code to connect to my database and insert form data from > a > user: > > $connect = mysql_connect("myhost","user","pass") or die (" not > connected"); > @mysql_select_db("dbname"); > $sql="INSERT INTO tablename > (id,first,last,age,email,sfuser,sfship,icq,ac,loca,ref) > Values(,`$first`,`$last`,'$age',`$email`,`$sfuser`,`$sfship`,`$icq`,`$ac`,`$ > loca`,`$ref`)"; > echo (mysql_affected_rows()?"success":"failure"); > mysql_close($connect); > > The script returns "success" except for it doesn't insert the data ( > from a > form ). > > The age column is BLOB, not INT. > > I would really appreciate the help of someone, as this has really > stumped > me. > > Thanks, > > plague > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase transaction question
On Friday 24 August 2001 16:55, Balak, Frank wrote: > yves, > > Start the transaction with ibase_trans() before you call > ibase_execute. > > As to how is it possible, I don't really know for sure. I would > presume it has to do with how Interbase handles transactions. > > Frank Frank, thank you, I've tried it, and even found something similar in the phpbuilder.com mailing list archives, but it sill doesn't work This is my new code: $dbh = connectdb(); $sth = ibase_prepare('INSERT INTO LOG (DATETIME,REMOTE_ADDR,HTTP_HOST,REQUEST_URI,HTTP_REFERER,HTTP_USER_AGENT) VALUES (?,?,?,?,?,?)'); $trans=ibase_trans(); ibase_execute($sth, $now, substr(get_var('REMOTE_ADDR',' '),0,24), substr(get_var('HTTP_HOST',' '),0,24), substr(get_var('REQUEST_URI',' '),0,99), substr(get_var('HTTP_REFERER',' '),0,99), substr(get_var('HTTP_USER_AGENT',' '),0,99)); ibase_commit($trans); ibase_close($dbh); The code I found on phpbuilder.com said the following: $trans = ibase_trans(); ibase_query ($c, $sql); ibase_commit( $trans); heck, what do I do wrong? > -- > Franklin J. Balak Jr. > Quality Assurance Data Analyst > Brown Printing Company > Waseca Division > Waseca, MN. 56093 > Voice: 507-835-0253 > Fax: 507-835-0293 > -- > > -Original Message- > From: Yves Glodt [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 14:11 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Another Interbase question > > > Look at this: > > include('include.php'); > > $dbh = connectdb(); > $sth = ibase_prepare('INSERT INTO LOG > (DATETIME,REMOTE_ADDR,HTTP_HOST,QUERY_STRING,HTTP_USER_AGENT,REQUEST_ >URI,HTT P_REFERER) > VALUES (?,?,?,?,?,?,?)'); > ibase_execute($sth, > $now, > $HTTP_SERVER_VARS['REMOTE_ADDR'], > $HTTP_SERVER_VARS['HTTP_HOST'], > $HTTP_SERVER_VARS['QUERY_STRING'], > $HTTP_SERVER_VARS['HTTP_USER_AGENT'], > $HTTP_SERVER_VARS['REQUEST_URI'], > $HTTP_SERVER_VARS['HTTP_REFERER']); > ibase_commit(); > ibase_close($dbh); > > ?> > > when it gets called, and I do a select in isql, I do not see any of > the records. Only after doing a "manual" commit in isql, I can see > the new data. > > How is that possible? > > yves -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Zend IDE anyone?
"Steve Brett" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > no need to recompile. > > the debug server is a .so and only needs added lines php.ini > > we used the windoze ide clients whihc install easily if you have JRE. if not > you need to downoad/install. > > def no need to recompile though ... > > hop i'm not too late :-) > > Steve Not too late... hmmm Let me check a few things. What should show up in the phpinfo() page? checking some stuff now... Thanks for tip.. was having problems compiling anyways! heh brb... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Variables in MySQL Insert Queries
If this is an exact copy of your script, then you've surrounded each variable name in the VALUES(...) with back-ticks. Why? -Original Message- From: plague [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 12:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Variables in MySQL Insert Queries I am using this code to connect to my database and insert form data from a user: $connect = mysql_connect("myhost","user","pass") or die (" not connected"); @mysql_select_db("dbname"); $sql="INSERT INTO tablename (id,first,last,age,email,sfuser,sfship,icq,ac,loca,ref) Values(,`$first`,`$last`,'$age',`$email`,`$sfuser`,`$sfship`,`$icq`,`$ac`,`$ loca`,`$ref`)"; echo (mysql_affected_rows()?"success":"failure"); mysql_close($connect); The script returns "success" except for it doesn't insert the data ( from a form ). The age column is BLOB, not INT. I would really appreciate the help of someone, as this has really stumped me. Thanks, plague -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Zend IDE anyone?
no need to recompile. the debug server is a .so and only needs added lines php.ini we used the windoze ide clients whihc install easily if you have JRE. if not you need to downoad/install. def no need to recompile though ... hop i'm not too late :-) Steve "Grant Boggs" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > "Steve Brett" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I have used the Zend IDE for php dev and found it to be superb. > > > > unfortunately the company i work for takes an age to get license > agreements > > arranged so our eval period had run out. > > > > it's very easy to set up - try the eval version first. > > > > Steve > > Great! Thanks! I'm working on installing it now. > > I'm a relative newbie to Linux, but it looks like because I use PHP with > Apache and mySQL, I have to recompile both of these products to get the Zend > debugger installed? > > Recompiling now... heh > > -- > == > Grant Boggs > http://www.cornersonesoftware.ws > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] [PHP-ORACLE] a lot of errors!!!
Can you show us your OCIConnect statement? It returns a handle to a variable that you should use as your connection resource... > From: "Matteo" <[EMAIL PROTECTED]> > Date: Fri, 24 Aug 2001 10:03:46 +0200 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] [PHP-ORACLE] a lot of errors!!! > > I have a server with Linux 6.2 kernel 2.2.19 with apache 1.3.20 > > i configure php in this mode > > './configure' '--with-apache=/home/apache/apache_1.3.20' '--with-mysql' > '--with-gd' '--enable-track-vars' '--enable-force-cgi-redirect' > '--enable-discard-path' '--enable-safe-mode' '--enable-calendar' > '--with-gdbm' '--enable-ftp' '--with-regex=php' '--with-gnu-ld' > '--with-oci8' '--with-imap' '--with-kerberos' > '--with-openssl=/usr/local/ssl' > > i have installed Oracle 8.1.7. server and client and i configure correctly > listener.ora e tnsnames.ora. It works > > But when i try an SQL test, it displays this messages: > > > Warning: _oci_open_server: Error while trying to retrieve text for error > ORA-12154 in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 180 > > Warning: Supplied argument is not a valid OCI8-Connection resource in > /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 181 > > Warning: Supplied argument is not a valid OCI8-Statement resource in > /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 183 > Error: Oracle Error: --- > > Fatal error: Call to undefined function: blu_log() in > /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 187 > > > What is the problem? > > Thankx very much for answers. > > Matteo > ITALY > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: Photo Album Schema
"Sheridan Saint-Michel" <[EMAIL PROTECTED]> wrote in message 00f601c12ca3$8bb26420$[EMAIL PROTECTED]">news:00f601c12ca3$8bb26420$[EMAIL PROTECTED]... > From: "Hugh Bothwell" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > > > > "Sheridan Saint-Michel" <[EMAIL PROTECTED]> wrote in message > > 03a901c12c02$c60d4640$[EMAIL PROTECTED]">news:03a901c12c02$c60d4640$[EMAIL PROTECTED]... > > > I don't know if having multiple users associated with a single image is > > > at all beneficial, and I can see where it might cause all sorts of > > problems. > > > > > > For example, you and I both have the same image in our album (we are > > > both assciated with it in the DB). What happens when I change the > > > description? Do you change the description field, thus changing the > > > description on both our pages? Do you now have to create another entry > > > in your Image table? > > > > Just to be nitpicky: I don't see where this would be > > useful - allowing users to share/transfer pictures? - but > > it's not overly difficult either. Just split the information > > between an Image table and an ImageOwner > > table. > > He suggested a DB redesign to allow a Many to > Many relationship between users and images. > I was trying to show that there was no reason to > do so and at least one good reason not to do so =) Yes, I followed that - I'm just playing Devil's Advocate here. I would rephrase your conclusion as 'no reason to do so, but no reason not to if you really feel the need'. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Zend IDE anyone?
"Steve Brett" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have used the Zend IDE for php dev and found it to be superb. > > unfortunately the company i work for takes an age to get license agreements > arranged so our eval period had run out. > > it's very easy to set up - try the eval version first. > > Steve Great! Thanks! I'm working on installing it now. I'm a relative newbie to Linux, but it looks like because I use PHP with Apache and mySQL, I have to recompile both of these products to get the Zend debugger installed? Recompiling now... heh -- == Grant Boggs http://www.cornersonesoftware.ws -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] How to show table???
http://www.php.net/manual/en/function.mysql-list-tables.php > -Original Message- > From: kelvin [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 24, 2001 5:09 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] How to show table??? > > > Hi there, > > I just wonder how to list all the table when using PHP script. > I know how to call when I in linux system. (show table) > or (mysqlshow > db_name) > > But don't know how to do it in PHP Please Help... > > Many Thanks. > kelvin. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: TopSpeed
"Guilherme Bresser" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi... I'm from Brazil my english is bad!!! > > Can I connect one Script PHP with a TopSpeed Database (*.tps)?? Use ODBC drivers. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Zend IDE anyone?
I have used the Zend IDE for php dev and found it to be superb. unfortunately the company i work for takes an age to get license agreements arranged so our eval period had run out. it's very easy to set up - try the eval version first. Steve "Grant Boggs" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Does anyone use the Zend IDE for development? > > My code is getting complicated enough that I need a step-execute capable > debugger. Where I can set breakpoints, watches, etc. The normal type stuff > with any other language's IDE. > > Zend IDE looks to fill the gap. Any other recommendations? > > -- > == > Grant Boggs > http://www.cornersonesoftware.ws > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] How to show table???
Hmmm try something like: "$sql = "EXPLAIN dbame.table_name"; This will show something like: +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| smallint(3) | | PRI | 0 | auto_increment | | firstName | varchar(30) | | | || | lastName | varchar(30) | | | || | email | varchar(30) | | | || | username | varchar(12) | | | || | password | varchar(12) | | | || +---+-+--+-+-++ 6 rows in set (0.00 sec) I hope this is what you wanted, can't think why though... Russ On Fri, 24 Aug 2001 11:09:06 -0400 kelvin <[EMAIL PROTECTED]> wrote: > Hi there, > > I just wonder how to list all the table when using PHP script. > I know how to call when I in linux system. (show table) or (mysqlshow > db_name) > > But don't know how to do it in PHP Please Help... > > Many Thanks. > kelvin. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] How to show table???
Hi there, I just wonder how to list all the table when using PHP script. I know how to call when I in linux system. (show table) or (mysqlshow db_name) But don't know how to do it in PHP Please Help... Many Thanks. kelvin. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Another Interbase question
yves, Start the transaction with ibase_trans() before you call ibase_execute. As to how is it possible, I don't really know for sure. I would presume it has to do with how Interbase handles transactions. Frank -- Franklin J. Balak Jr. Quality Assurance Data Analyst Brown Printing Company Waseca Division Waseca, MN. 56093 Voice: 507-835-0253 Fax: 507-835-0293 -- -Original Message- From: Yves Glodt [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 14:11 To: [EMAIL PROTECTED] Subject: [PHP-DB] Another Interbase question Look at this: when it gets called, and I do a select in isql, I do not see any of the records. Only after doing a "manual" commit in isql, I can see the new data. How is that possible? yves -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP development with PostgreSQL
This does not sound like a MySQL problem, but more likely a poor indexes problem. PostgreSQL does scale bigger than MySQL (more users) but you are probably nowhere near that limit. When you have more than 25 concurrent users (remember that the web server is probably only one or 2 unless it is really getting slammed) then start thinking about switching. __ Your mouse has moved. You must restart Windows for your changes to take effect. #!/usr/bin/perl print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Zend IDE anyone?
"Grant Boggs" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Does anyone use the Zend IDE for development? > > My code is getting complicated enough that I need a step-execute capable > debugger. Where I can set breakpoints, watches, etc. The normal type stuff > with any other language's IDE. > > Zend IDE looks to fill the gap. Any other recommendations? I guess I should also note that I'm using Red Hat 7.1, Apache, mySQL, and PHP 4.0.6. -- == Grant Boggs http://www.cornersonesoftware.ws -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Installation problem w MySQL
"George Pitcher" <[EMAIL PROTECTED]> wrote in message 01e501c12c7d$e9c831f0$[EMAIL PROTECTED]">news:01e501c12c7d$e9c831f0$[EMAIL PROTECTED]... > I'm trying to compile PHP 4.0.6 on LinuxPPC and I keep tripping over the > MySQL part. It just won't compile (can't find headers during the MySQL bit). > > All the documentation points to there being a /usr/local/mysql/ folder but > after my MySQL install (rpm) I don't have such a folder. The nearest I have > is: > > /usr/bin/which seems to have all the client stuff; > /usr/bin/include which has several files with '.h' extensions (headers?) > /var/lib/mysqlwhich has the server/engine stuff > /usr/local/php-4.0.6/ext/libmysql/ which appears to have more '.h' files. Do a locate mysqld And see what that pops up. If you did it by rpm, mysql is probably in a /etc/mysql directory. -- == Grant Boggs http://www.cornersonesoftware.ws -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Zend IDE anyone?
Does anyone use the Zend IDE for development? My code is getting complicated enough that I need a step-execute capable debugger. Where I can set breakpoints, watches, etc. The normal type stuff with any other language's IDE. Zend IDE looks to fill the gap. Any other recommendations? -- == Grant Boggs http://www.cornersonesoftware.ws -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: Photo Album Schema
He suggested a DB redesign to allow a Many to Many relationship between users and images. I was trying to show that there was no reason to do so and at least one good reason not to do so =) Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: "Hugh Bothwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 8:02 PM Subject: Re: [PHP-DB] Re: Photo Album Schema > > "Sheridan Saint-Michel" <[EMAIL PROTECTED]> wrote in message > 03a901c12c02$c60d4640$[EMAIL PROTECTED]">news:03a901c12c02$c60d4640$[EMAIL PROTECTED]... > > I don't know if having multiple users associated with a single image is > > at all beneficial, and I can see where it might cause all sorts of > problems. > > > > For example, you and I both have the same image in our album (we are > > both assciated with it in the DB). What happens when I change the > > description? Do you change the description field, thus changing the > > description on both our pages? Do you now have to create another entry > > in your Image table? > > Just to be nitpicky: I don't see where this would be > useful - allowing users to share/transfer pictures? - but > it's not overly difficult either. Just split the information > between an Image table and an ImageOwner > table. > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP development with PostgreSQL
i use postgresql at work and the reson we chose it baove mysql (which i also use for developement @ home) was scalability. from our investigations mysql does not scale well wehn having 100+ users. BUT before i start a pointless debate on the merits of either both DB's seem to have 'converged' over thelast year or so. the db we run at work has 500K+ records and runs very quickly. i'm not so sure mysql would perform like this for the 100+ users that are connected most of the time. postgresql has a better feel to it as well, and has better SQL support (inner selects are 'mising' in mysql) Steve "Miles Thompson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Lester, > > Are you querying on indexed fields? That's the key to speed; check the > MySQL docs on how it uses indexes. 20k records is not a large database. > > Miles > > At 04:06 PM 8/24/01 +0800, Lester June Cabrera wrote: > >Hi, > > > >We've been using MySQL for 2 years now in all the PHP systems we have > >developed for our clients. We're thinking of using PostgreSQL now. What is > >your experience with PostgreSQL? Any comments? The reason why we want to > >shift is because we have encountered some problems with one of our > >databases whose table contains more than 20K records. Somehow, it took so > >long to query the database. Is PosgtreSQL a good substitute? We're > >expecting a million records for our new project. > > > > > >Thanks, > >Lester > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > >To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: how should i test my php program performance?
have a look at the excellent DBG PHP Debugger by Dmitri Dmitrienko. it comes with a profiler, which lets you track down bottlenecks far easier than with normal output. you can find it at http://dd.cron.ru hint: in usual php/mysql applications almost always the database is the bottleneck, which means you should put most effort in optimizing the queries. regards, mike. -- mfG, Michael Kumar (michael.kumar_at_nme.at, m.kumar_at_hushmail.com) PGP: 30FE 3AB9 5077 C554 5D9E B5CC 0B0F CFB2 55D6 AA75 .: know your nme :. In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Dear all: > > I have wrote a php program and use mysql database. > Is there a way to test its performance? > Thanks. > > haheho > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] TopSpeed
Hi... I'm from Brazil my english is bad!!! Can I connect one Script PHP with a TopSpeed Database (*.tps)?? How can I do Thank's Guilherme Bresser Sao Paulo - Brazil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: pg_exec question.
i don't thing <99% sure> that it can be done. you can decalre a transaction and then [begin commit] <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >Hello, > >I'm new with PHP and PostgreSQL, and can't find a solution to the > following problem. I'd like to combine multiple SQL commands into one > pg_exec call. For example, I've tried "delete ...; insert ...; insert > ..;" with the appropriate values in the "...", but I'm receiving this > error: > >Warning: Supplied argument is not a valid PostgreSQL link resource > >Does anyone have any suggestions for this problem? Thanks in advance. > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: OT (slightly): recommended procedure for backing up Postrgesql 7.0.3
yup, the postmaster should be running all the time in any case. 30 7-19/4,23 * * * /backup/dumpit is the line i have in cron ( 30 mins past the hour between 7am and 7pm every 4 hours and again at 11pm ) and #!/bin/sh backdate=$(date +%Y%m%d%H%M.gz) /usr/local/pgsql/bin/pg_dump edb | gzip > /backup/edb-backup_$backdate cp /backup/edb-backup_$backdate /var/autofs/misc/ecalnet/ are the contents of the file dumpit. this creates a gzipped dump of the database with a name of edb-backup_200108240730 for example, then copies it to another directory. HTH Steve "Steve Brett" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > you can set up a job using cron that pg_dumps the date anywhere you need. > > we use an automounted dir that links to a windoze server ... > > Steve > > "Brad Hubbard" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Well, the subject really says it all. What procedures are people using to > > back up their Postgres databases? > > > > TIA, > > Brad > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP development with PostgreSQL
Lester, Are you querying on indexed fields? That's the key to speed; check the MySQL docs on how it uses indexes. 20k records is not a large database. Miles At 04:06 PM 8/24/01 +0800, Lester June Cabrera wrote: >Hi, > >We've been using MySQL for 2 years now in all the PHP systems we have >developed for our clients. We're thinking of using PostgreSQL now. What is >your experience with PostgreSQL? Any comments? The reason why we want to >shift is because we have encountered some problems with one of our >databases whose table contains more than 20K records. Somehow, it took so >long to query the database. Is PosgtreSQL a good substitute? We're >expecting a million records for our new project. > > >Thanks, >Lester > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] the most simple i have found...
$obj->{"0"} or $obj->{'0'} works... if you find more simple, please tell me. regards, rashkatsa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: mysql_fetch_object() with MYSQL_NUM or MYSQL_BOTH
well... $zero = "0"; $one = "1"; $obj->$zero and $obj->$one works... but $obj->"0" or $obj->'0' doesn't... :(( esthetically, it is not great ! you have to provide vars to access properties' object ! $zero, $one, ... $ten, $eleven, ... something more simple or easier to access these kind of properties's object ? regards, rashkatsa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: OT (slightly): recommended procedure for backing up Postrgesql 7.0.3
you can set up a job using cron that pg_dumps the date anywhere you need. we use an automounted dir that links to a windoze server ... Steve "Brad Hubbard" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Well, the subject really says it all. What procedures are people using to > back up their Postgres databases? > > TIA, > Brad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] mysql_fetch_object() with MYSQL_NUM or MYSQL_BOTH
hello ! mysql_fetch_object() is like mysql_fetch_array() but it returns an object and not an array. so you can access field through this syntax : $obj->fieldname (i.e $obj->amount) you can provide a second parameter to this function : MYSQL_ASSOC, MYSQL_NUM or MYSQL_BOTH. if you use MYSQL_NUM or MYSQL_BOTH, you should be able to access fields through the column number... but how since in an PHP object a variable could not begin by a numerical character (i.e $obj->0, $obj->1... is forbidden) ? if you use get_object_vars($obj) and print the object's properties, you could see this for example (MYSQL_BOTH used) : 0 = 'titi' columnName1 = 'titi' 1 = 2 columnName2 = 2 so here $obj->columnName1 returns 'titi' and $obj->columnName2 returns 2 but if i want to use numerical entries how to keep the object access behavior like $obj->... ? is it possible ? if not we should use a loop with get_object_vars($obj) ? nothing more simple and beautiful ? thanks for your feeebacks. regards, rashkatsa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] it was simple
the "satanic" sql.safe_mode was On... :( put it Off and it's works... rashkatsa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP/MySQl Consultation
I am in need of someone that is very good at PHP and MySQL to view my scripts and discuss with me in detail on how to speed up my scripts and how to speed up mysql some. if you are interested please send me credentials and rates ASAP please send them to [EMAIL PROTECTED] Thank you, Randy --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.268 / Virus Database: 140 - Release Date: 8/7/2001 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: RE: [PHP-DB] Fatal error
>Try to include your files with the command include_once() ... and not >include() ... Well Br me! Cheers.. That did the job... I thank you sir! Cheers Russ On Fri, 24 Aug 2001 13:04:15 +0200 "Walter, Marcel" <[EMAIL PROTECTED]> wrote: > Try to include your files with the command include_once() ... and not > include() ... > Maybe this solves your problem... because you ARE trying to declare > a function which is already declared ... > > > -Original Message- > > From: Russ Michell [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, August 24, 2001 13:48 > > To: [EMAIL PROTECTED] > > Subject:[PHP-DB] Fatal error > > > > Hi there folks - this isn't *entirley* a DB question so I'm putting on my > > flack Jacket right now: > > > > I keep getting this error and have never seen it before: > > "Fatal error: Cannot redeclare parse_dir() in > > intranet/bin/includes/functions.php on line 47" > > > > It gives me this error for every function I have (written). I know for a > > fact that this function > > ('parse_dir') has only been declared once, so why is php lying to me!!? > > > > Feel free *not to answer* instead of wasting your own time giving me jip > > for an off topic query. > > Cheers > > > > Russ > > > > #---# > > > > "Believe nothing - consider everything" > > > > Russ Michell > > Anglia Polytechnic University Webteam > > > > e: [EMAIL PROTECTED] > > w: www.apu.ac.uk/webteam > > t: +44 (0)1223 363271 x 2331 > > > > www.theruss.com > > > > #---# > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] OT (slightly): recommended procedure for backing up Postrgesql 7.0.3
Well, the subject really says it all. What procedures are people using to back up their Postgres databases? TIA, Brad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP development with PostgreSQL
On Friday 24 August 2001 12:27, Jason Brooke wrote: > > This seems more like a problem in database design like in the > > database > > itself. > > > yves > > how come? I would suggest that you give details about the table that is slow, or maybe post it to a mysql mailing-list directly. Slowness on large tables is often index-related. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Fatal error
---< Original message >--- From: Russ Michell <[EMAIL PROTECTED]> Date: Fri, Aug 24, 2001 at 12:47:42PM +0100 Message-ID: Subject: [PHP-DB] Fatal error > Hi there folks - this isn't *entirley* a DB question so I'm putting on my flack >Jacket right now: > > I keep getting this error and have never seen it before: > "Fatal error: Cannot redeclare parse_dir() in intranet/bin/includes/functions.php on >line 47" > > It gives me this error for every function I have (written). I know for a fact that >this function > ('parse_dir') has only been declared once, so why is php lying to me!!? > > Feel free *not to answer* instead of wasting your own time giving me jip for an off >topic query. > Cheers > > Russ > > #---# > > "Believe nothing - consider everything" > > Russ Michell > Anglia Polytechnic University Webteam > > e: [EMAIL PROTECTED] > w: www.apu.ac.uk/webteam > t: +44 (0)1223 363271 x 2331 > > www.theruss.com > > #---# ---< End of original message >--- Do you include these functions? If you do, you might want to check if you include it more than once. You can then best use include_once() instead of include(). That makes sure that the file will only be included once and so your function will not be redeclared. -- * R&zE: -- -- Renze Munnik -- DataLink BV -- -- E: [EMAIL PROTECTED] -- W: +31 23 5326162 -- F: +31 23 5322144 -- M: +31 6 21811143 -- -- Stationsplein 82 -- 2011 LM HAARLEM -- Netherlands -- -- http://www.datalink.nl -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Fatal error
show us some lines around the line 47 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Russ > Michell > Sent: Freitag, 24. August 2001 13:48 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Fatal error > > > Hi there folks - this isn't *entirley* a DB question so I'm > putting on my flack Jacket right now: > > I keep getting this error and have never seen it before: > "Fatal error: Cannot redeclare parse_dir() in > intranet/bin/includes/functions.php on line 47" > > It gives me this error for every function I have (written). I > know for a fact that this function > ('parse_dir') has only been declared once, so why is php lying to me!!? > > Feel free *not to answer* instead of wasting your own time giving > me jip for an off topic query. > Cheers > > Russ > > #---# > > "Believe nothing - consider everything" > > Russ Michell > Anglia Polytechnic University Webteam > > e: [EMAIL PROTECTED] > w: www.apu.ac.uk/webteam > t: +44 (0)1223 363271 x 2331 > > www.theruss.com > > #---# > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Fatal error
Hi there folks - this isn't *entirley* a DB question so I'm putting on my flack Jacket right now: I keep getting this error and have never seen it before: "Fatal error: Cannot redeclare parse_dir() in intranet/bin/includes/functions.php on line 47" It gives me this error for every function I have (written). I know for a fact that this function ('parse_dir') has only been declared once, so why is php lying to me!!? Feel free *not to answer* instead of wasting your own time giving me jip for an off topic query. Cheers Russ #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP development with PostgreSQL
> This seems more like a problem in database design like in the database itself. > > yves how come? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP development with PostgreSQL
On Friday 24 August 2001 10:06, you wrote: > Hi, > > We've been using MySQL for 2 years now in all the PHP systems we have > developed for our clients. We're thinking of using PostgreSQL now. > What is your experience with PostgreSQL? Any comments? The reason why > we want to shift is because we have encountered some problems with > one of our databases whose table contains more than 20K records. > Somehow, it took so long to query the database. Is PosgtreSQL a good > substitute? We're expecting a million records for our new project. > > > Thanks, > Lester This seems more like a problem in database design like in the database itself. yves -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Installation problem w MySQL
Hi all, I'm trying to compile PHP 4.0.6 on LinuxPPC and I keep tripping over the MySQL part. It just won't compile (can't find headers during the MySQL bit). All the documentation points to there being a /usr/local/mysql/ folder but after my MySQL install (rpm) I don't have such a folder. The nearest I have is: /usr/bin/which seems to have all the client stuff; /usr/bin/include which has several files with '.h' extensions (headers?) /var/lib/mysqlwhich has the server/engine stuff /usr/local/php-4.0.6/ext/libmysql/ which appears to have more '.h' files. Obviously the files are there somewhere but I'm stuck as to how to do the './configure'. I cannot use the prescribed '--with-mysql=/usr/local/mysql' coz that won't point to anything. So what do i use? Please help this newbie get started. George P in Edinburgh _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP development with PostgreSQL
I've been using MySQL with database about 600k records... and it's running good. Dont think PostgreSQL can help if you're concern about size. Dreamvale - Original Message - From: "Lester June Cabrera" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 24, 2001 4:06 PM Subject: [PHP-DB] PHP development with PostgreSQL > Hi, > > We've been using MySQL for 2 years now in all the PHP systems we have > developed for our clients. We're thinking of using PostgreSQL now. What is > your experience with PostgreSQL? Any comments? The reason why we want to > shift is because we have encountered some problems with one of our > databases whose table contains more than 20K records. Somehow, it took so > long to query the database. Is PosgtreSQL a good substitute? We're > expecting a million records for our new project. > > > Thanks, > Lester > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP development with PostgreSQL
Hi, We've been using MySQL for 2 years now in all the PHP systems we have developed for our clients. We're thinking of using PostgreSQL now. What is your experience with PostgreSQL? Any comments? The reason why we want to shift is because we have encountered some problems with one of our databases whose table contains more than 20K records. Somehow, it took so long to query the database. Is PosgtreSQL a good substitute? We're expecting a million records for our new project. Thanks, Lester -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] [PHP-ORACLE] a lot of errors!!!
I have a server with Linux 6.2 kernel 2.2.19 with apache 1.3.20 i configure php in this mode './configure' '--with-apache=/home/apache/apache_1.3.20' '--with-mysql' '--with-gd' '--enable-track-vars' '--enable-force-cgi-redirect' '--enable-discard-path' '--enable-safe-mode' '--enable-calendar' '--with-gdbm' '--enable-ftp' '--with-regex=php' '--with-gnu-ld' '--with-oci8' '--with-imap' '--with-kerberos' '--with-openssl=/usr/local/ssl' i have installed Oracle 8.1.7. server and client and i configure correctly listener.ora e tnsnames.ora. It works But when i try an SQL test, it displays this messages: Warning: _oci_open_server: Error while trying to retrieve text for error ORA-12154 in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 180 Warning: Supplied argument is not a valid OCI8-Connection resource in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 181 Warning: Supplied argument is not a valid OCI8-Statement resource in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 183 Error: Oracle Error: --- Fatal error: Call to undefined function: blu_log() in /home/httpd/html/blu/lib/db/oracle.db.inc.php3 on line 187 What is the problem? Thankx very much for answers. Matteo ITALY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]