[PHP-DB] Re: storing binary data in mysql
I have tested it in the source installation MySQL server with PHP and found that the image can only be stored and retrival from mysql using PHP when the image's size is smaller that 1K. Although, I increase the size of mysql's max_allowed_packet, net_buffer, table_cache. "Fred" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó·s»D :[EMAIL PROTECTED] > Why do you think it cannot store binary data? Are you recieving an error > message. If so, what it is? > > Fred > > Fai <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I use MySQL rpm to install in RedHat 7.2 in one of > > my pc. Then I store binary data such as image in > > MySQL and it works normally. > > > > However, I install source MySQL in RedHat 7.2 in > > another pc. But it cannot store binary data. > > > > Does anybody know the reason? Is that it need some > > special configure option when compiling MySQL from source? > > > > Thank you very much! > > > > > > -- 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] Fast template
Hi, I am working on a Fasttemplate dbase project,so i downloaded the Fasttemplate and untarred(unzipped) in the /usr/local/lib/php directory but gives me the following error :- Warning: Failed opening 'class.FastTemplate.php3' for inclusion (include_path='.:/usr/local/lib/php') in /var/www/html/htdocs/templates/demo.php on line 3 Fatal error: Cannot instantiate non-existent class: fasttemplate in /var/www/html/htdocs/templates/demo.php on line 5 pls help me TIA SHARMAD --- Feel free to contact me (flames about my english and the useless of this driver will be redirected to /dev/null, oh no, it's full...). (Michael Beck, describing the PC-speaker sound device) -- 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] no Oracle functions
Hi, I have just downloaded and installed PHP4.0.6. I have configured it --with-mysql and --with-oracle. I am able to easily use Mysql but NOT Oracle. When I try an ora_logon or ora_login I get 'Fatal error: Call to undefined function: ora_log?n' Moreover, I AM able to use Oracle w/ DBI functions, whereas our web server easily makes call to and from Oracle dbs w/ no problems. Is my problem an installation problem, or is there something else I am not aware of? Please advise. Thanks. -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com [EMAIL PROTECTED] 1.610.296.4485 -- 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] no Oracle functions
On Mon, Dec 03, 2001 at 06:58:00AM -0800, John Kolvereid wrote: > Hi, > I have just downloaded and installed PHP4.0.6. I have configured it > --with-mysql and --with-oracle. I am able to easily use Mysql but NOT > Oracle. When I try an ora_logon or ora_login I get 'Fatal error: Call > to undefined function: ora_log?n' Moreover, I AM able to use Oracle w/ > DBI functions, whereas our web server easily makes call to and from > Oracle dbs w/ no problems. Is my problem an installation problem, or is > there something else I am not aware of? Please advise. Thanks. plz configure using --with-oracle=/path/of/ORACLE_HOME also you should be using the oci*() functions - enable them using: --with-oci8=/path/of/ORACLE_HOME tc -- 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] Fast template
On Monday 03 December 2001 18:42, [EMAIL PROTECTED] wrote: > Hi, >I am working on a Fasttemplate dbase project,so i downloaded the > Fasttemplate and untarred(unzipped) in the /usr/local/lib/php directory > but gives me the following error :- > > Warning: Failed opening 'class.FastTemplate.php3' for inclusion > (include_path='.:/usr/local/lib/php') in > /var/www/html/htdocs/templates/demo.php on line 3 > Fatal error: Cannot instantiate non-existent class: fasttemplate in > /var/www/html/htdocs/templates/demo.php on line 5 Have you checked that the file 'class.FastTemplate.php3' is actually in the directory '/usr/local/lib/php' (and not in a sub-directory of '/usr/local/lib/php')? -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* If Love Were Oil, I'd Be About A Quart Low -- Book title by Lewis Grizzard */ -- 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] no Oracle functions
Hi Thies, Thanks for the info. I tried re-configuring w/ --with-oracle=$ORACLE_HOME and --with-oci8=$ORACLE_HOME. After configuration I got the msg that --with-odi8 there was no such file or directory as /u01/app/oracle/product/8.1.7 (which is $ORACLE_HOME). However, now I am able to open Oracle thanks to you and your advise. Thank you VERY much. Incidentally, what would OCI buy me? "Thies C. Arntzen" wrote: > On Mon, Dec 03, 2001 at 06:58:00AM -0800, John Kolvereid wrote: > > Hi, > > I have just downloaded and installed PHP4.0.6. I have configured it > > --with-mysql and --with-oracle. I am able to easily use Mysql but NOT > > Oracle. When I try an ora_logon or ora_login I get 'Fatal error: Call > > to undefined function: ora_log?n' Moreover, I AM able to use Oracle w/ > > DBI functions, whereas our web server easily makes call to and from > > Oracle dbs w/ no problems. Is my problem an installation problem, or is > > there something else I am not aware of? Please advise. Thanks. > > plz configure using > > --with-oracle=/path/of/ORACLE_HOME > > also you should be using the oci*() functions - enable them > using: > > --with-oci8=/path/of/ORACLE_HOME > > tc -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com [EMAIL PROTECTED] 1.610.296.4485 -- 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] Can't unserialize array from mysql
Hi, I'm trying to loop thru an unserialized array pulled from mysql. First I serialized the array before storing it: $sql ="UPDATE $table_name set performer_id='" . addslashes(serialize($perfor mer_id)) . "' WHERE lineup_id=$lineup_id"; This seems to work. mysql stores $performer_id as: a:3:{i:0;s:2:"12";i:1;s:1:"1";i:2;s:1:"3";} The next time I grab $performer_id from mysql I want to unserialize it and loop thru it with foreach(): $sql ="SELECT performer_id FROM lineup WHERE lineup_id=$lineup_id"; $result_pid = @mysql_query($sql, $connection) or die("Couldn't execute query perfomer ID."); while ($row = mysql_fetch_row($result_pid)) { $result_pid = unserialize($result_pid); foreach ($result_pid as $performer_id) { (some more code here) } But this gives me an error "Warning: Invalid argument supplied for foreach()". I used var_dump before and after I unserialized just to check that the result set actually contained data. The first var_dump produced "array(1) { [0]=> string(44) "a:3:{i:0;s:2:"10";i:1;s:1:"6";i:2;s:2:"17";}" }". Looks good, but var_dump after unserializing gives "bool(false)". I also tried using reset() after the first var_dump, and stripslashes(), but got the same error. Can anyone see what I'm doing wrong? Thanks! Jim -- 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] Use php to plot graph.
Hi, Jus wanna to ask if it is possible to use php to plot graph using data retrieve from mysql. If yes, how should i go about? Thanks, Denny -- 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] Use php to plot graph.
yes, it is possible - read up on the .PNG image format, as it is possible to create graphs ind images dynamically to suit the data and figures youve extracted from the database -Original Message- From: Denny Ow [mailto:[EMAIL PROTECTED]] Sent: 03 December 2001 16:14 To: [EMAIL PROTECTED] Subject: [PHP-DB] Use php to plot graph. Hi, Jus wanna to ask if it is possible to use php to plot graph using data retrieve from mysql. If yes, how should i go about? Thanks, Denny -- 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.303 / Virus Database: 164 - Release Date: 24/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.303 / Virus Database: 164 - Release Date: 24/11/01 -- 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] Use php to plot graph.
I'm working on a project right now where we call PHP from within an HTML page, send it vars using a POST method, and then use that to draw a graph. We're drawing bar graphs now but one of my coworkers did a line graph. You call the PHP as an tag and have PHP return a .png. We used the SAMS Teach Yourself PHP4 in 24 Hours book - it's Hour 14 where you do all sorts of stuff with images. It's not easy - you draw each line based on the endpoints and you can fill rectangles and stuff, but the end result can be pretty impressive. I'd send you my graph but it's on a development website that's password protected. If you're really interested I could save the image and download it to you. -Natalie > -Original Message- > From: Denny Ow [SMTP:[EMAIL PROTECTED]] > Sent: Monday, December 03, 2001 11:14 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Use php to plot graph. > > Hi, > > Jus wanna to ask if it is possible to use php to plot graph using data > retrieve from mysql. If yes, how should i go about? > > Thanks, > Denny > > > -- > 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] Use php to plot graph.
There are a few ways to go about this: You could: 1) Use little image blocks to dynamically build bar graphs. It's not too hard with PHP. Make some little square (or round or whatever) gifs (with transparent edges), and then position them on a background JPEG or gif using DIV tags. Make an object in PHP and feed your query results into it? 2) Use the gd library and graphics commands added in PHP 4 (you're gonna want to read up on this one...) to create images dynamically. This is much more server-intensive than option #1. and takes more programming, but can be really slick. Then you can draw all sorts of graphs - not just bar graphs or scatterplots. Wheee. 3) Combining Java and PHP and MySQL to draw images is also totally possible. I avoided this approach because it's all client-side. There is also an example of this in the JDK from Sun, and it works pretty well, but is a little buggy. Maybe it was my code, maybe it's Java, but it seemed incomplatible across platforms. Make an object in PHP that creates the necessary JavaScript, and feed your query results into it. 4) Program some really slick ascii graphs. No joke, I did this a while ago. Nice output. Really fast. You can do line graphs, too. Cheers, db Denny Ow wrote: > Hi, > > Jus wanna to ask if it is possible to use php to plot graph using data > retrieve from mysql. If yes, how should i go about? > > Thanks, > Denny > > -- > 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] -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [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 functions
Hi, I am relatively new to Oracle PHP and trying to figure out the Oracle functions. I am able to connect and open a db. But that's the extent of what I can do w/o further explanation. Within the PHP docs I can view all the Oracle functions, but their explanations are sparse to say the least. I tried the following: $i = ora_do($conn, "Select count(*) from patients"); echo "returned $i\n"; The statement is valid, I use it all the time in SQL+ and DBI. However in PHP it returns 'Resource ID #6' I am not sure that is a result of the echo statement or the ora_do function. Please advise, and let me know where a better Oracle/PHP document resides. Thanks. -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com [EMAIL PROTECTED] 1.610.296.4485 -- 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] Can't unserialize array from mysql
Either 1. Don't addslashes before you serialize it 2. use stripslashes before you unserialize it > -Original Message- > From: Jim Doolittle [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 03, 2001 9:07 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Can't unserialize array from mysql > > > Hi, > > I'm trying to loop thru an unserialized array pulled from > mysql. First I > serialized the array before storing it: > > -- > -- > > $sql ="UPDATE $table_name set performer_id='" . > addslashes(serialize($perfor > mer_id)) . "' WHERE lineup_id=$lineup_id"; > > -- > -- > > This seems to work. mysql stores $performer_id as: > > a:3:{i:0;s:2:"12";i:1;s:1:"1";i:2;s:1:"3";} > > The next time I grab $performer_id from mysql I want to > unserialize it and > loop thru it with foreach(): > > -- > -- > > $sql ="SELECT performer_id FROM lineup WHERE lineup_id=$lineup_id"; > > $result_pid = @mysql_query($sql, $connection) or > die("Couldn't execute query > perfomer ID."); > while ($row = mysql_fetch_row($result_pid)) { > $result_pid = unserialize($result_pid); > > foreach ($result_pid as $performer_id) { > (some more code here) > } > -- > -- > > But this gives me an error "Warning: Invalid argument supplied for > foreach()". I used var_dump before and after I unserialized > just to check > that the result set actually contained data. > > The first var_dump produced "array(1) { [0]=> string(44) > "a:3:{i:0;s:2:"10";i:1;s:1:"6";i:2;s:2:"17";}" }". Looks > good, but var_dump > after unserializing gives "bool(false)". > > I also tried using reset() after the first var_dump, and > stripslashes(), but > got the same error. Can anyone see what I'm doing wrong? Thanks! > > Jim > > > -- > 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]
[Fwd: [PHP-DB] Oracle functions]
ooops, forgot to reply to list too. -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [EMAIL PROTECTED] --- Begin Message --- Hola, Check out the php manual for an explanation of resources and arrays etc. "Resource ID #6" IS the result of your query - PHP stores it as a "Resource." I've only used PostgreSQL and MySQL with PHP, and what you need to do with a query result "resource" using these two databases is "fetch" the data from it using a command such as mysql_fetch_array or mysql _fetch_assoc. From http://www.php.net/manual/en/ref.oracle.php it looks like you would need to use ora_fetch to convert the "resource" into a PHP array. On this page, there's a code example of how to use PHP's Oracle functions to extract data from a database and output HTML. Cheers, db John Kolvereid wrote: > Hi, > I am relatively new to Oracle PHP and trying to figure out the > Oracle functions. I am able to connect and open a db. But that's the > extent of what I can do w/o further explanation. Within the PHP docs I > can view all the Oracle functions, but their explanations are sparse to > say the least. I tried the following: > $i = ora_do($conn, "Select count(*) from patients"); > echo "returned $i\n"; > The statement is valid, I use it all the time in SQL+ and DBI. However > in PHP it returns 'Resource ID #6' I am not sure that is a result of > the echo statement or the ora_do function. Please advise, and let me > know where a better Oracle/PHP document resides. Thanks. > > -- > John Kolvereid > http://www.odinfo.com > http://www.kolvereid.com > [EMAIL PROTECTED] > 1.610.296.4485 > > -- > 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] -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [EMAIL PROTECTED] --- End Message --- -- 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] WAS: Use php to plot graph. NOW: ASCII GRAPH CONTEST
The method I used for ascii graphs was based on some C program I wrote that created an array, which was, in essence, the graph. Each array element was two characters wide (we''l see why..) The first column of the array is all |, to make a Y axis, and the last row if the array is all _, to make an X axis. Then there were two other arrays, for labels, that were stuck along side or below the axes (dynamic). The first array is modified based on the data, using O, -, |, \ and / in goofy combinations to draw lines. Then I characterized characters (heehee) as either wide, or narrow, to avoid width problems, and when it's a "narrow" character you insert a space to avoid problems with lines not lining up. Then, spit the array out to the display. Whhe fun. We should have an "ASCII/PHP/Database Graphing Contest." I'll host it if there are interested contestants. Suggested design: HTML form for data input, passes to PHP script for immediate (and STYLIN') ascii output. Any takers? Will post the code/output example when I have a free moment... Bas Jobsen wrote: > Hi, > > > 4) Program some really slick ascii graphs. No joke, I did this a while ago. > > Nice output. Really fast. You can do line graphs, too. > > Intressting. Do you have an example? > > Tnx, > > Bas > > -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [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: [Fwd: [PHP-DB] Oracle functions]
Hi Dan, I tried "$n = ora_numcols($odb); echo "number = $n\n"; This resulted in '0' which I know is incorrect. It should be '1' = the number in the table. Any other ideas. Please advise. Thanks. Daniel Barton wrote: > ooops, forgot to reply to list too. > > -- > -- > Dan Barton > Terrestrial Program Biologist > Asst. Data Manager > Point Reyes Bird Observatory > http://www.prbo.org > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > > Subject: Re: [PHP-DB] Oracle functions > Date: Mon, 03 Dec 2001 08:46:23 -0800 > From: Daniel Barton <[EMAIL PROTECTED]> > To: John Kolvereid <[EMAIL PROTECTED]> > References: <[EMAIL PROTECTED]> > > Hola, > Check out the php manual for an explanation of resources and arrays etc. > > "Resource ID #6" IS the result of your query - PHP stores it as a > "Resource." I've only used PostgreSQL and MySQL with PHP, and what you need > to do with a query result "resource" using these two databases is "fetch" > the data from it using a command such as mysql_fetch_array or mysql > _fetch_assoc. > From http://www.php.net/manual/en/ref.oracle.php it looks like you would > need to use ora_fetch to convert the "resource" into a PHP array. On this > page, there's a code example of how to use PHP's Oracle functions to extract > data from a database and output HTML. > > Cheers, > db > > John Kolvereid wrote: > > > Hi, > > I am relatively new to Oracle PHP and trying to figure out the > > Oracle functions. I am able to connect and open a db. But that's the > > extent of what I can do w/o further explanation. Within the PHP docs I > > can view all the Oracle functions, but their explanations are sparse to > > say the least. I tried the following: > > $i = ora_do($conn, "Select count(*) from patients"); > > echo "returned $i\n"; > > The statement is valid, I use it all the time in SQL+ and DBI. However > > in PHP it returns 'Resource ID #6' I am not sure that is a result of > > the echo statement or the ora_do function. Please advise, and let me > > know where a better Oracle/PHP document resides. Thanks. > > > > -- > > John Kolvereid > > http://www.odinfo.com > > http://www.kolvereid.com > > [EMAIL PROTECTED] > > 1.610.296.4485 > > > > -- > > 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] > > -- > -- > Dan Barton > Terrestrial Program Biologist > Asst. Data Manager > Point Reyes Bird Observatory > http://www.prbo.org > [EMAIL PROTECTED] > [EMAIL PROTECTED] -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com [EMAIL PROTECTED] 1.610.296.4485 -- 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] Use php to plot graph.
On Tuesday 04 December 2001 00:14, Denny Ow wrote: > Hi, > > Jus wanna to ask if it is possible to use php to plot graph using data > retrieve from mysql. If yes, how should i go about? Check out the graphics section of http://www.phpclasses.upperdesign.com/. It's got some neat classes for creating graphs. regards -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* Under deadline pressure for the next week. If you want something, it can wait. Unless it's blind screaming paroxysmally hedonistic... */ -- 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: 4800 Would you like to lose weight while you sleep? 5060017
What exactly does this have to do w/ PHP??? Please do not ruin a good thing w/ trash. Unless, of course, your ad was generate via PHP - which I doubt - Frankly, I doubt if you have the brains to do that. [EMAIL PROTECTED] wrote: > As seen on NBC, CBS, CNN, and even Oprah! The health > discovery that actually reverses aging while burning fat, > without dieting or exercise! This proven discovery has even > been reported on by the New England Journal of Medicine. > Forget aging and dieting forever! And it's Guaranteed! > > Click here: > http://ultimatehgh1000.81832.com > > Would you like to lose weight while you sleep! > No dieting! > No hunger pains! > No Cravings! > No strenuous exercise! > Change your life forever! > > 100% GUARANTEED! > > 1.Body Fat Loss82% improvement. > 2.Wrinkle Reduction 61% improvement. > 3.Energy Level 84% improvement. > 4.Muscle Strength 88% improvement. > 5.Sexual Potency 75% improvement. > 6.Emotional Stability 67% improvement. > 7.Memory62% improvement. > > You are receiving this email as a subscriber > to the Opt-In America Mailing List. > To remove yourself from all related maillists, > just click here: > mailto:[EMAIL PROTECTED]?Subject=REMOVE -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com [EMAIL PROTECTED] 1.610.296.4485 -- 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] no Oracle functions
On Mon, Dec 03, 2001 at 10:59:45AM -0800, John Kolvereid wrote: > Hi Thies, > Thanks for the info. I tried re-configuring w/ --with-oracle=$ORACLE_HOME > and --with-oci8=$ORACLE_HOME. After configuration I got the msg that > --with-odi8 there was no such file or directory as > /u01/app/oracle/product/8.1.7 (which is $ORACLE_HOME). However, > now I am able to open Oracle thanks to you and your advise. Thank you VERY > much. Incidentally, what would OCI buy me? it's the "new" oracle api (Oracle Call Interface) it has more features than the "old" ora*() interface. tc -- 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: Trapping and masking errors
Yeah, I did look at the manual page, that was how I got the error_log() function working. What I couldn't work out though was how to get the php errors into the log. At the moment I use the error_log() to log some of my scripts variables to an error.txt file. I also couldn't see a way of preventing the php errors from appearing in the broswer window. I'll take a look at the ob_start and ob_end_clean though,thanks. -torrent "Yasuo Ohgaki" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Torrentuk wrote: > > > Hi, > > I have written a simple form emailer for my site. In it I check to see if > > the mail was sent successfully and if not I write some variables to an error > > log. My question is, I would also like to write any php errors to the log > > file, e.g. > > > > Warning: Failed to Connect in d:\WWW\htdocs/RND_ski-info-online/contact.php > > on line 152 > > > > how would I specify them in error_log()? Also how can I mask them from > > appearing in the visitor's browser window so that I can just write my > > "friendlier" error message there. > > > > Anyone hints, tips or just downright solutions would be greatly appreciated > > :) > > -torrent > > How about take a look at the manual page? > http://www.php.net/manual/en/ref.errorfunc.php > > You may also be interested in output buffering. > Look for ob_start(), ob_end_clean(), etc. > > -- > Yasuo Ohgaki > -- 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]
[Fwd: [Fwd: [PHP-DB] Oracle functions]]
oops, forgot again... -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [EMAIL PROTECTED] --- Begin Message --- Hi again, Check out the documentation on resources ("cursors"), fetch commands, etc. for Oracle. I know basically squat about Oracle except that a) I can't afford it, b) The non-profit I work for can't afford it (the world's #1 oxymoron is "IT at a non-profit organization"), c) I've never been unable to do anything I wanted to do with MySQL or PostgreSQL, so I've never needed it and d) their ad campaigns stink (although they've lessened their push recently... is open-source cutting into their profit margin$?). I'd suggest checking out the documentation on resources ("cursors"), fetch commands, etc. for Oracle on the php site? from http://www.php.net/manual/en/function.ora-numrows.php [EMAIL PROTECTED] 27-Dec-2000 09:37 It is important to note that this function acts more as a counter of the number of rows fetched from the cursor. If you execute this prior to processing the cursor you will always get a 0 for an answer. The online manual and one of my PHP reference books does not make that distinction. Some may expect this to count the number of rows in the cursor prior to processing. This function does not do that. Cheers, db John Kolvereid wrote: > Hi Dan, > I tried "$n = ora_numcols($odb); > echo "number = $n\n"; > This resulted in '0' which I know is incorrect. It should be '1' = the number > in the table. Any other ideas. Please advise. Thanks. > > Daniel Barton wrote: > > > ooops, forgot to reply to list too. > > > > -- > > -- > > Dan Barton > > Terrestrial Program Biologist > > Asst. Data Manager > > Point Reyes Bird Observatory > > http://www.prbo.org > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > > > > > > > Subject: Re: [PHP-DB] Oracle functions > > Date: Mon, 03 Dec 2001 08:46:23 -0800 > > From: Daniel Barton <[EMAIL PROTECTED]> > > To: John Kolvereid <[EMAIL PROTECTED]> > > References: <[EMAIL PROTECTED]> > > > > Hola, > > Check out the php manual for an explanation of resources and arrays etc. > > > > "Resource ID #6" IS the result of your query - PHP stores it as a > > "Resource." I've only used PostgreSQL and MySQL with PHP, and what you need > > to do with a query result "resource" using these two databases is "fetch" > > the data from it using a command such as mysql_fetch_array or mysql > > _fetch_assoc. > > From http://www.php.net/manual/en/ref.oracle.php it looks like you would > > need to use ora_fetch to convert the "resource" into a PHP array. On this > > page, there's a code example of how to use PHP's Oracle functions to extract > > data from a database and output HTML. > > > > Cheers, > > db > > > > John Kolvereid wrote: > > > > > Hi, > > > I am relatively new to Oracle PHP and trying to figure out the > > > Oracle functions. I am able to connect and open a db. But that's the > > > extent of what I can do w/o further explanation. Within the PHP docs I > > > can view all the Oracle functions, but their explanations are sparse to > > > say the least. I tried the following: > > > $i = ora_do($conn, "Select count(*) from patients"); > > > echo "returned $i\n"; > > > The statement is valid, I use it all the time in SQL+ and DBI. However > > > in PHP it returns 'Resource ID #6' I am not sure that is a result of > > > the echo statement or the ora_do function. Please advise, and let me > > > know where a better Oracle/PHP document resides. Thanks. > > > > > > -- > > > John Kolvereid > > > http://www.odinfo.com > > > http://www.kolvereid.com > > > [EMAIL PROTECTED] > > > 1.610.296.4485 > > > > > > -- > > > 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] > > > > -- > > -- > > Dan Barton > > Terrestrial Program Biologist > > Asst. Data Manager > > Point Reyes Bird Observatory > > http://www.prbo.org > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > -- > John Kolvereid > http://www.odinfo.com > http://www.kolvereid.com > [EMAIL PROTECTED] > 1.610.296.4485 -- -- Dan Barton Terrestrial Program Biologist Asst. Data Manager Point Reyes Bird Observatory http://www.prbo.org [EMAIL PROTECTED] [EMAIL PROTECTED] --- End Message --- -- 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,
[PHP-DB] onClick
Is it possible to call a PHP function using the "onclick" parameter? -- 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] finding a link in large text blob
Is there an easy way (say using eregi_replace) to find a link reference in a blob of text and add the anchor around it? Something like: "text has a link to a website at http://www.whatever.com/mydirectory/mypage.html ..." and converts it to "text has a link to a website at website ..." My thoughts are that I should be able to do something like a eregi_replace, finding any occurances of http:// and trapping all non-space characters following it to convert to the anchor. But what about multiples? How do I rebuild the text with the substitute strings? Thanks in advance Terry -- 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] onClick
Not directly, no. You can call a JavaScript function with the onClick command, but not a PHP function. But here's what I've done when I needed to do something like that. Create a separate page for the function, like function.php. Then in the anchor tag in your main page (call it index.php), call that page... e.g., < a href="function.php >click me for a function< /a >, passing parameters either in the URL or by cookies. Your function page might look something like this: In other words, in function.php, the code does the function and then immediately issues a redirect command to send the user back to the page where they started. You could also include the function in the code for index.php, and simply have the anchor tag link back to index.php, passing parameters via your favorite parameter passing technique. Jonathan Duncan wrote: > Is it possible to call a PHP function using the "onclick" parameter? -- 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] EZ Question...I think
I have looked into some source code that I found, but I'm a newbie at this, and don't understand.. if ( 0 == $this->link_id) { In this statment, what does the '->' repersent? this statment (operator?) occurs alot in this code that I have, but I can't find the definition on any site...can anyone help? Please reply to group. Thanks. Thomas -- 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] pg_fetch_object() not returning values from multi-table query
Hello all, I have the following code: /* construct the query */ $the_sql = "SELECT inv.at_id FROM invoice_items inv, customer cus WHERE inv.client_id = cus.client_id AND inv.inv_id = '2001-12-03-4'"; /* send the statement to query() for processing */ $qid = query($the_sql); $rows = pg_numrows($qid); //echo "Number of rows: $rows"; /* each row in the result will be packaged as an object and put in an array */ $out_string = ""; /* start building the string */ $out_string .= ""; for($i = 0; $i < $rows; $i++) { //echo "I: $i\n"; $dbvalue = pg_fetch_object($qid, $i); /*** Problem is on the next line **/ $id = $dbvalue->at_id; } $out_string .= ""; Problem is $id is never set to anything. I have 3 tables linked together and to find the value of inv.at_id and I can't get the pg_fetch_object to return my value. This query works via the command line, so it's not the query. I've tried doing $dbvalue->inv.at_id as well and can't get it to return my value. Any ideas? Thanks, Kevin [EMAIL PROTECTED] _ 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]
Re: [PHP-DB] onClick
Richard That is good information. Thank you very much for your help. Jonathan "Richard Crawford" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Not directly, no. You can call a JavaScript function with the onClick > command, but not a PHP function. > > But here's what I've done when I needed to do something like that. > > Create a separate page for the function, like function.php. Then in the > anchor tag in your main page (call it index.php), call that page... > e.g., < a href="function.php >click me for a function< /a >, passing > parameters either in the URL or by cookies. > > Your function page might look something like this: > > {insert data into db here} > header("Location: index.php"); > ?> > > In other words, in function.php, the code does the function and then > immediately issues a redirect command to send the user back to the page > where they started. > > You could also include the function in the code for index.php, and > simply have the anchor tag link back to index.php, passing parameters > via your favorite parameter passing technique. > > Jonathan Duncan wrote: > > > Is it possible to call a PHP function using the "onclick" parameter? > -- 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] EZ Question...I think
Thomas, It a used to referance a class method or proporty Example: debug == True) { Print($msg); } } } //To call the class you would do something like this $simple = new simple(); $simple->debug("This is a test message"); ?> That should be enough to get you started Thank You Brian Paulson Sr. Web Developer [EMAIL PROTECTED] http://www.chieftain.com -Original Message- From: Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 2:32 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] EZ Question...I think I have looked into some source code that I found, but I'm a newbie at this, and don't understand.. if ( 0 == $this->link_id) { In this statment, what does the '->' repersent? this statment (operator?) occurs alot in this code that I have, but I can't find the definition on any site...can anyone help? Please reply to group. Thanks. Thomas -- 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: EZ Question...I think
Thanks everyone. Appreciate it. "Thomas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have looked into some source code that I found, but I'm a newbie at this, > and don't understand.. > > if ( 0 == $this->link_id) { > > In this statment, what does the '->' repersent? this statment (operator?) > occurs alot in this code that I have, but I can't find the definition on any > site...can anyone help? > > Please reply to group. > > Thanks. > > Thomas > > -- 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] Unable to Open ORACLE
Hi, I tried the following snippet from http://www.php.net/manual/en/ref.oracle.php $query = "Select * from patients where clientid = 'DEMO'"; ora_parse($curs, $query); ora_exec($curs); ora_fetch($curs); The parse executed successfully, but the exec complained that Ora_Exec failed (ORA-00932: inconsistent datatypes -- while processing OCI function OEXEC/OEXN) Earlier I had taken an example from Thies Arntzen's conf notes and successfully opened, parsed and fetehed, using the same query and the same db, only w/ OCI commands. Is there a problem w/ the ordinary Oracle functions, possibly w/ a mismatch between them and the undelying OCI codes? Please advise. Thank you. -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com [EMAIL PROTECTED] 1.610.296.4485 -- 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] adding an auto-incrementing id field to an existing database
I have an existing database, created a while back, which I need to add a id field to, there isn't one currently. Will simply adding a new auto-increment field be okay? Will the existing rows receive id numbers and will they be numbered properly? Or will it start with the new data and continue from there? I hope you know what I mean. -- Chip -- 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: Unable to Open ORACLE
Hi, Me again, My table has a CLOB in it. Could that be a problem. When I tried the same querry on another table w/o a CLOB it succeeded. Please advise. Thanks. John Kolvereid wrote: > Hi, > I tried the following snippet from > http://www.php.net/manual/en/ref.oracle.php > $query = "Select * from patients where clientid = 'DEMO'"; > ora_parse($curs, $query); > ora_exec($curs); > ora_fetch($curs); > The parse executed successfully, but the exec complained that > Ora_Exec failed (ORA-00932: inconsistent datatypes -- while > processing OCI function > OEXEC/OEXN) > Earlier I had taken an example from Thies Arntzen's conf notes and > successfully opened, parsed and fetehed, using the same query and the > same db, only w/ OCI commands. > > Is there a problem w/ the ordinary Oracle functions, possibly w/ a > mismatch between them and the undelying OCI codes? > Please advise. Thank you. > > -- > John Kolvereid > http://www.odinfo.com > http://www.kolvereid.com > [EMAIL PROTECTED] > 1.610.296.4485 -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com [EMAIL PROTECTED] 1.610.296.4485 -- 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: Unable to Open ORACLE
Hi, Me again, My table has a CLOB in it. When I tried the same querry w/ another table w/o a CLOB it succeeded. Are CLOBs an issue? Please advise. Thanks. John Kolvereid wrote: > Hi, > I tried the following snippet from > http://www.php.net/manual/en/ref.oracle.php > $query = "Select * from patients where clientid = 'DEMO'"; > ora_parse($curs, $query); > ora_exec($curs); > ora_fetch($curs); > The parse executed successfully, but the exec complained that > Ora_Exec failed (ORA-00932: inconsistent datatypes -- while > processing OCI function > OEXEC/OEXN) > Earlier I had taken an example from Thies Arntzen's conf notes and > successfully opened, parsed and fetehed, using the same query and the > same db, only w/ OCI commands. > > Is there a problem w/ the ordinary Oracle functions, possibly w/ a > mismatch between them and the undelying OCI codes? > Please advise. Thank you. > > -- > John Kolvereid > http://www.odinfo.com > http://www.kolvereid.com > [EMAIL PROTECTED] > 1.610.296.4485 -- John Kolvereid http://www.odinfo.com http://www.kolvereid.com [EMAIL PROTECTED] 1.610.296.4485 -- 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: Unable to Open ORACLE
John: Yes, CLOBs are a little more difficult to access. The best way I've used them is to use the DBMS_LOB package in Oracle. Here's a link on technet.oracle.com to some documentation. http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev. 817/a76940/adl03pr4.htm#146661 I suggest using this with stored procedures and bind variables. php.net has more info on using stored procedures bind variables. Good luck, Anthony Carlos > From: John Kolvereid <[EMAIL PROTECTED]> > Date: Mon, 03 Dec 2001 22:17:44 -0800 > To: [EMAIL PROTECTED], John Kolvereid <[EMAIL PROTECTED]> > Subject: [PHP-DB] Re: Unable to Open ORACLE > > Hi, > Me again, My table has a CLOB in it. When I tried the same querry w/ > another table w/o a CLOB it succeeded. Are CLOBs an issue? Please > advise. Thanks. > > John Kolvereid wrote: > >> Hi, >> I tried the following snippet from >> http://www.php.net/manual/en/ref.oracle.php >> $query = "Select * from patients where clientid = 'DEMO'"; >> ora_parse($curs, $query); >> ora_exec($curs); >> ora_fetch($curs); >> The parse executed successfully, but the exec complained that >> Ora_Exec failed (ORA-00932: inconsistent datatypes -- while >> processing OCI function >> OEXEC/OEXN) >> Earlier I had taken an example from Thies Arntzen's conf notes and >> successfully opened, parsed and fetehed, using the same query and the >> same db, only w/ OCI commands. >> >> Is there a problem w/ the ordinary Oracle functions, possibly w/ a >> mismatch between them and the undelying OCI codes? >> Please advise. Thank you. >> >> -- >> John Kolvereid >> http://www.odinfo.com >> http://www.kolvereid.com >> [EMAIL PROTECTED] >> 1.610.296.4485 > > -- > John Kolvereid > http://www.odinfo.com > http://www.kolvereid.com > [EMAIL PROTECTED] > 1.610.296.4485 > > > > -- > 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: Unable to Open ORACLE
Hello, John Kolvereid wrote: > > Hi, > Me again, My table has a CLOB in it. When I tried the same querry w/ > another table w/o a CLOB it succeeded. Are CLOBs an issue? Please > advise. Thanks. I have no idea what is the problem here, but you may want to try Metabase which is a PHP database abstraction that handles CLOB/BLOBs very well with any supported database including Oracle. Take a look at the example described in Metabase tutorial document. http://phpclasses.UpperDesign.com/browse.html/20 Regards, Manuel Lemos > > John Kolvereid wrote: > > > Hi, > > I tried the following snippet from > > http://www.php.net/manual/en/ref.oracle.php > > $query = "Select * from patients where clientid = 'DEMO'"; > > ora_parse($curs, $query); > > ora_exec($curs); > > ora_fetch($curs); > > The parse executed successfully, but the exec complained that > > Ora_Exec failed (ORA-00932: inconsistent datatypes -- while > > processing OCI function > > OEXEC/OEXN) > > Earlier I had taken an example from Thies Arntzen's conf notes and > > successfully opened, parsed and fetehed, using the same query and the > > same db, only w/ OCI commands. > > > > Is there a problem w/ the ordinary Oracle functions, possibly w/ a > > mismatch between them and the undelying OCI codes? > > Please advise. Thank you. > > > > -- > > John Kolvereid > > http://www.odinfo.com > > http://www.kolvereid.com > > [EMAIL PROTECTED] > > 1.610.296.4485 > > -- > John Kolvereid > http://www.odinfo.com > http://www.kolvereid.com > [EMAIL PROTECTED] > 1.610.296.4485 -- 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] Failed to query correctly.
Hi, I got this problem when i tried to do a sql query and print the ouput. But the script below always failed to return the first row of the records. But i do a manual query, i got the results i wanted. Thanks, Denny $query="SELECT * from $tbl "; $result=mysql_query($query); while ($line = mysql_fetch_row($result)) { while(list($col_name, $col_value) = each($line)) { print "\t\t$col_value\n"; } }
Re: [PHP-DB] EZ Question...I think
On Mon, 3 Dec 2001 17:31:30 -0500 Thomas "Thomas" <[EMAIL PROTECTED]> wrote: > I have looked into some source code that I found, but I'm a newbie > at this, > and don't understand.. > > if ( 0 == $this->link_id) { > > In this statment, what does the '->' repersent? this statment > (operator?) > occurs alot in this code that I have, but I can't find the > definition on any > site...can anyone help? > > Please reply to group. > > Thanks. > > Thomas Thomas, "$this->" is used in a class definition when the class references itself. -- Raquel I am glad I made the late race. It gave me a hearing on the great and durable question of the age, which I could have had in no other way; and though I now sink out of view, and shall be forgotten, I believe I have made some marks which will tell for the cause of civil liberty long after I am gone. --Abraham Lincoln -- 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 Truth Told!
EDWARD LAWRENCE STRONG PRESENTS THE INSIDE EDITION Author: Edward L. Strong Order your copy Now! Amazon .com The Truth Told! This book tells the secrets of Millionaires. Real Estate Finance, Credit Repair, Real Estate Investments and the list goes on. " For additional information call 708-257-3258. With the purchase you receive a guaranteed line of credit for $5,000 to help reestablish or establish your credit. -- 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] 3000 Would you like to lose weight while you sleep? 4537552
As seen on NBC, CBS, CNN, and even Oprah! The health discovery that actually reverses aging while burning fat, without dieting or exercise! This proven discovery has even been reported on by the New England Journal of Medicine. Forget aging and dieting forever! And it's Guaranteed! Click here: http://ultimatehgh.81832.com Would you like to lose weight while you sleep! No dieting! No hunger pains! No Cravings! No strenuous exercise! Change your life forever! 100% GUARANTEED! 1.Body Fat Loss82% improvement. 2.Wrinkle Reduction 61% improvement. 3.Energy Level 84% improvement. 4.Muscle Strength 88% improvement. 5.Sexual Potency 75% improvement. 6.Emotional Stability 67% improvement. 7.Memory 62% improvement. *** Click here to see another weight loss product: http://ultimatehgh.81832.com You are receiving this email as a subscriber to the Opt-In America Mailing List. To remove yourself from all related maillists, just click here: mailto:[EMAIL PROTECTED]?Subject=REMOVE -- 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: The Truth Told!
> THE INSIDE EDITION I thought it was out there? -- Julio Nobrega Don't eat the yellow snow. <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > EDWARD LAWRENCE STRONG PRESENTS > > THE INSIDE EDITION > > Author: Edward L. Strong > > > Order your copy Now! > > Amazon .com > > The Truth Told! > > > > This book tells the secrets of Millionaires. Real Estate Finance, Credit > Repair, Real Estate Investments and the list goes on. " For additional > information call 708-257-3258. With the purchase you receive a guaranteed > line of credit for $5,000 to help reestablish or establish your credit. > > > > > > > > > -- 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] Mass Mailing
I started writing a set of scripts that would send out mutiple emails to a list of customers. I then realized that most likely this program, and/or snipits had most likely already been written. If so, can some one point me in the right direction and save me 3 or 4 days? Thanks Nathan Webmaster M-Y Communications -- 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: Mass Mailing
Hello, Nathan Cavicchi wrote: > > I started writing a set of scripts that would send out mutiple emails to a > list of customers. I then realized that most likely this program, and/or > snipits had most likely already been written. If so, can some one point me > in the right direction and save me 3 or 4 days? Forget PHP. Use a dedicated mailing list or e-mail server. If you are using Unix, I recommend strongly qmail/ezmlm. It is very good for handling bounces. I use it to distribute PHP Classes site notification messages. It is very fast and pratical. You may want to try this PHP Web interface for managing ezmlm mailing lists. It even comes with a SOAP interface for managing subscriptions programmatically eventually from a remote machine. http://phpclasses.UpperDesign.com/browse.html/package/177 Regards, Manuel Lemos -- 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]