[PHP-DB] Transfer my mySQL to another server fail
I want to tranfer my database (mySQL) from my old webhosting to another webhosting. I already tried to dump the database (Structure Data) + 'Add drop table' and I got the .sql file (4 mb) when I tried to add this file to my new webhosting, I got this message : no table found in database and my database is still empty what should I do ? thanks all _ www.kaskus.com - FREE EMAIL SERVICE -- 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] USA Attacks
now isn't the time for these kind of discussions, and nothing can excuse the death of all those innocent people. America as a nation is far from innocent however, I agree with you on that Lars. My sincerest condolances to all those involved. Let's just hope that the crazy man bush doesn't do anything stupid It is replies like this that makes me understand the terrorism in the world... No doubt, it was a horrible act by cowards, but what comes up must come down. US has been playing with fire once too often and suddenly tasted their medicine - maybe time to rethink the world police strategy again. I feel sympathy for all who died in the incident for no cause. Dont get me wrong on that point ! / LJ -Original Message- From: Bartek Pawlik [mailto:[EMAIL PROTECTED]] Sent: 12. september 2001 14:35 To: [EMAIL PROTECTED] Subject: Odp: [PHP-DB] USA Attacks My deepest sympathy to all Americans, It's horrible, I can still believe it. Kill everyone who is involved into these attacks Bartek Pawlik Poland - Original Message - From: Steve Farmer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 12, 2001 4:28 AM Subject: [PHP-DB] USA Attacks Hi, My heart goes out to all our American cousins in their time of tragedy. Steve Farmer -- --- Minds are like parachutes, they work best when open Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- 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] -- Zagraj z finalistkami Miss Polonia [ http://miss.onet.pl/start.html ] -- 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 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: getting a details-page
Hi, I have a problem: with a mysql_query I get the results of a table field into a list page. Is it possible to use this result (as link) to open a new page where the detailed results of each row are shown? So you select one field and list it with a while-loop? Assuming this you can make a link like this: while ($row = mysql_fetch_array($result)){ echo $row[field]. a href=\show_details.php?criteria=$row[field]\Details/a; } and on show_details.php something like this: $query = SELECT * FROM table WHERE criteria='$criteria'; $result = mysql_query($query); hope this is what you want cheers Johannes -- 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] PDF Support on PHP
Hi All, we install PHP4.04 with PDF Lib 3.1 on our windows 2000 machine but we try to run the below PDF file creation code code we get message that undefined function pdf_new() ?php $pdf = pdf_new(); pdf_open_file($pdf); pdf_begin_page($pdf, 595, 842); pdf_set_font($pdf, Times-Roman, 30, host); pdf_set_value($pdf, textrendering, 1); pdf_show_xy($pdf, A PDF document created in memory!, 50, 750); pdf_end_page($pdf); pdf_close($pdf); $data = pdf_get_buffer($pdf); header(Content-type: application/pdf); header(Content-disposition: inline; filename=test.pdf); header(Content-length: . strlen($data)); echo $data; ? We built a new linux machine with Redhat 7.1 and install Apache /PHP MySQL with ApacheToolBox 1.58 and enable the support of pdf but still we getting same problem On windows machine linux machine when we try to get php information with phpinf(); , we get the page which say that our php installation is supported with PHP. Can any one please figure out that where is the problem! Regards sandeep Indianic Infotech Limited 91-79-6404208/09/10 98250 - 46265 98250 - 22578 Fax : 1-413-4250238 MSN : [EMAIL PROTECTED] Yahoo : indianic_sandeep ICQ : 2575332 AOL : skmnic -- 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] log out
?php session_start(); session_destroy(); header(location:http://$HTTP_HOST/mall/menu.php;); ? i wanna make this my log out page. it works without the: header(location:http://$HTTP_HOST/mall/menu.php;); i tried to put it befor session_destroy() but still didn't work??? -- 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] sessionid
Anytime you use rand() there's a chance you'll get the same results. Question is though, why are you making your own session id and not using the one built into the PHP engine itself? Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 49512 Ph. 616.554.2700 Fx. 616.554.3331 Mo. 616.291.2612 On Tue, 11 Sep 2001, J-E-N wrote: hello! i have a script below, my question is, will there be a chance that i will get thesame $sessionid. if (!$sessionid) { $sessionid = md5(uniqid(rand())); SetCookie(sessionid,$sessionid,time()+1314000); } -- 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] ODBC connection under Win32 + Apache + SQL Server
Victor, Your DSN is not being passed correctly. Under unix this could be an envrionment variable issue, but I suspect that you just have a reference error. Try something like: $dsn=MQIS; $pwd=sa; $conn=odbc_connect($dsn,$pwd,); if that doesn't work, try $dsn=dsn=MQIS; Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Victor Espina [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 11:55 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] ODBC connection under Win32 + Apache + SQL Server Hi, i'm new using PHP i'm trying to run some basic PHP scripts to retrieve a show data coming from a SQL Server database. The problem is that when i try to run this: $conn=odbc_connect(MQIS,sa,); PHP returns the following warning: Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I test the DSN with VFP using: SQLStringConnect(dsn=MQIS;usr=sa;pwd=;) and it works pretty fine. ¿What could be the problem here? TIA Victor -- == Victor Espina Caracas, Venezuela http://mitrompo.com/vespina [EMAIL PROTECTED] (Quite el 'nospam' para responder) (Remove 'nospam' to reply) -- 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] Problem with odbc_next_result
Hi, Anyone had problems with odbc_next_result on WinNT? I can call the function, but as soon as I try to get a row from the next result set, php crashes. Any ideas? Daniel Bennett [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: Problem with odbc_next_result
Michael - could seem to reply to your email address... here's the code where $res is a valid result_id (I've tested it without the odbc_next_result): do { while ($odbc_get_into($res,$row)) { print $row[0]br; } } while ($odbc_next_result($res)); Seems to crash on the first call to odbc_get_into after odbc_next_result Daniel Bennett [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, Anyone had problems with odbc_next_result on WinNT? I can call the function, but as soon as I try to get a row from the next result set, php crashes. Any ideas? Daniel Bennett [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: Problem with odbc_next_result
PS - Ignore the $'s in front of odbc - typo! Daniel Bennett [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Michael - could seem to reply to your email address... here's the code where $res is a valid result_id (I've tested it without the odbc_next_result): do { while ($odbc_get_into($res,$row)) { print $row[0]br; } } while ($odbc_next_result($res)); Seems to crash on the first call to odbc_get_into after odbc_next_result Daniel Bennett [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, Anyone had problems with odbc_next_result on WinNT? I can call the function, but as soon as I try to get a row from the next result set, php crashes. Any ideas? Daniel Bennett [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: Problem with odbc_next_result
Daniel, What driver are you using? I'll check your code against another one for comparison's sake, and do some property queries. Actually, if you want to query the driver for it's features yourself, you can download a trial of ODBCScan from our site. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Daniel Bennett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 11:47 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Problem with odbc_next_result Michael - could seem to reply to your email address... here's the code where $res is a valid result_id (I've tested it without the odbc_next_result): do { while ($odbc_get_into($res,$row)) { print $row[0]br; } } while ($odbc_next_result($res)); Seems to crash on the first call to odbc_get_into after odbc_next_result Daniel Bennett [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, Anyone had problems with odbc_next_result on WinNT? I can call the function, but as soon as I try to get a row from the next result set, php crashes. Any ideas? Daniel Bennett [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 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] USA Attacks
I'm sure that the killer will be destroyed. America will winn. Mihai Dumitrescu Romania -- 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] USA Attacks
quite interesting from Nostradamus's passage!!! In the year of the new century and nine months,From the sky will come a great King of Terror... The sky will burn at forty-five degrees.Fire approaches the great new city... There will be a great thunder,Two brothers torn apart by Chaos, While the fortress endures,The great leader will succumb, The third big war will begin when the big city is burning --Nostradamus 1654 Mihai Marcian Dumitrescu [EMAIL PROTECTED] wrote: I'm sure that the killer will be destroyed. America will winn. Mihai Dumitrescu Romania -- 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!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger.
[PHP-DB] imap problem
Hi, The imap functions in my remote server are not enabled. Is there any way by which I can use the php_imap.dll. I do not have administrative rights of the server. So I cannot edit php.ini. I am using php4.04pl on linux. Please help. Vipin Missionecom. -- 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] USA Attacks
Nostradamus died in 1566... I wonder who wrote or re-wrote that passage for the event... / LJ -Original Message- From: Danny N. [mailto:[EMAIL PROTECTED]] Sent: 13. september 2001 01:43 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] USA Attacks quite interesting from Nostradamus's passage!!! In the year of the new century and nine months,From the sky will come a great King of Terror... The sky will burn at forty-five degrees.Fire approaches the great new city... There will be a great thunder,Two brothers torn apart by Chaos, While the fortress endures,The great leader will succumb, The third big war will begin when the big city is burning --Nostradamus 1654 Mihai Marcian Dumitrescu [EMAIL PROTECTED] wrote: I'm sure that the killer will be destroyed. America will winn. Mihai Dumitrescu Romania -- 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!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. -- 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] USA Attacks
sigh http://www.nostradamus-repository.org/cityofgod.html - Original Message - From: Lars B. Jensen [EMAIL PROTECTED] To: Danny N. [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, September 13, 2001 12:59 AM Subject: RE: [PHP-DB] USA Attacks Nostradamus died in 1566... I wonder who wrote or re-wrote that passage for the event... / LJ -Original Message- From: Danny N. [mailto:[EMAIL PROTECTED]] Sent: 13. september 2001 01:43 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] USA Attacks quite interesting from Nostradamus's passage!!! In the year of the new century and nine months,From the sky will come a great King of Terror... The sky will burn at forty-five degrees.Fire approaches the great new city... There will be a great thunder,Two brothers torn apart by Chaos, While the fortress endures,The great leader will succumb, The third big war will begin when the big city is burning --Nostradamus 1654 Mihai Marcian Dumitrescu [EMAIL PROTECTED] wrote: I'm sure that the killer will be destroyed. America will winn. Mihai Dumitrescu Romania -- 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] USA Attacks
Lars B. Jensen [EMAIL PROTECTED] wrote: Nostradamus died in 1566... I wonder who wrote or re-wrote that passage for the event... / LJ -Original Message- From: Danny N. [mailto:[EMAIL PROTECTED]] Sent: 13. september 2001 01:43 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] USA Attacks quite interesting from Nostradamus's passage!!! In the year of the new century and nine months,From the sky will come a great King of Terror... The sky will burn at forty-five degrees.Fire approaches the great new city... There will be a great thunder,Two brothers torn apart by Chaos, While the fortress endures,The great leader will succumb, The third big war will begin when the big city is burning --Nostradamus 1654 Mihai Marcian Dumitrescu wrote: I'm sure that the killer will be destroyed. America will winn. Mihai Dumitrescu Romania -- 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!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. -- 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!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger.
RE: [PHP-DB] USA Attacks
Hi, A quote from another message I got may shed some light: quote I would like to address the interesting prophecy that you have attached. It, like several other Nostradamus prophecies that have been circulating on the internet recently, is a complete fabrication. The kernel of the quote was written by a Canadian college student named Neil Brock a few years ago as part of an essay to illustrate how vague language can be interpreted to fit any number of important events (he was writing ABOUT Nostradamus). It has subsequently been added to in the last 36 hours. I use the web site www.snopes.com as a quick cross check on anything that comes through from unverified channels on the internet and it saves a little worry in the long run. /quote With clearity, Roel Mulder At 10:28 12-09-2001 -0700, you wrote: Lars B. Jensen [EMAIL PROTECTED] wrote: Nostradamus died in 1566... I wonder who wrote or re-wrote that passage for the event... / LJ -Original Message- From: Danny N. [mailto:[EMAIL PROTECTED]] Sent: 13. september 2001 01:43 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] USA Attacks quite interesting from Nostradamus's passage!!! In the year of the new century and nine months,From the sky will come a great King of Terror... The sky will burn at forty-five degrees.Fire approaches the great new city... There will be a great thunder,Two brothers torn apart by Chaos, While the fortress endures,The great leader will succumb, The third big war will begin when the big city is burning --Nostradamus 1654 Mulder Technisch Advies Postbus 69 NL-2740 AB WADDINXVEEN tel. 0182-640184 fax. 0182-640185 http://www.mta.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] USA Attacks (Nostradamus -- Further Info)
A couple of links to back that up: http://www.snopes2.com/inboxer/hoaxes/predict.htm http://fury.com/article/925.php And the original essay that contains the quote: http://www.ed.brocku.ca/~nmarshal/nostradamus.htm Later... -Ari -Original Message- From: mail MTA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 12:18 PM To: [EMAIL PROTECTED] Cc: Danny N. Subject: RE: [PHP-DB] USA Attacks Hi, A quote from another message I got may shed some light: quote I would like to address the interesting prophecy that you have attached. It, like several other Nostradamus prophecies that have been circulating on the internet recently, is a complete fabrication. The kernel of the quote was written by a Canadian college student named Neil Brock a few years ago as part of an essay to illustrate how vague language can be interpreted to fit any number of important events (he was writing ABOUT Nostradamus). It has subsequently been added to in the last 36 hours. I use the web site www.snopes.com as a quick cross check on anything that comes through from unverified channels on the internet and it saves a little worry in the long run. /quote With clearity, Roel Mulder At 10:28 12-09-2001 -0700, you wrote: Lars B. Jensen [EMAIL PROTECTED] wrote: Nostradamus died in 1566... I wonder who wrote or re-wrote that passage for the event... / LJ -Original Message- From: Danny N. [mailto:[EMAIL PROTECTED]] Sent: 13. september 2001 01:43 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] USA Attacks quite interesting from Nostradamus's passage!!! In the year of the new century and nine months,From the sky will come a great King of Terror... The sky will burn at forty-five degrees.Fire approaches the great new city... There will be a great thunder,Two brothers torn apart by Chaos, While the fortress endures,The great leader will succumb, The third big war will begin when the big city is burning --Nostradamus 1654 Mulder Technisch Advies Postbus 69 NL-2740 AB WADDINXVEEN tel. 0182-640184 fax. 0182-640185 http://www.mta.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] -- 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] imap problem
I beleive the dl() function will let you load either an .so or .dll at runtime. Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 49512 Ph. 616.554.2700 Fx. 616.554.3331 Mo. 616.291.2612 On Wed, 12 Sep 2001, Vipin wrote: Hi, The imap functions in my remote server are not enabled. Is there any way by which I can use the php_imap.dll. I do not have administrative rights of the server. So I cannot edit php.ini. I am using php4.04pl on linux. Please help. Vipin Missionecom. -- 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] USA Attacks (Nostradamus -- Further Info)
yep it is very much a HOAX...LOLinteresting of what's floating out there on the net. Ari M. Roth [EMAIL PROTECTED] wrote: A couple of links to back that up: http://www.snopes2.com/inboxer/hoaxes/predict.htm http://fury.com/article/925.php And the original essay that contains the quote: http://www.ed.brocku.ca/~nmarshal/nostradamus.htm Later... -Ari -Original Message- From: mail MTA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 12:18 PM To: [EMAIL PROTECTED] Cc: Danny N. Subject: RE: [PHP-DB] USA Attacks Hi, A quote from another message I got may shed some light: I would like to address the interesting prophecy that you have attached. It, like several other Nostradamus prophecies that have been circulating on the internet recently, is a complete fabrication. The kernel of the quote was written by a Canadian college student named Neil Brock a few years ago as part of an essay to illustrate how vague language can be interpreted to fit any number of important events (he was writing ABOUT Nostradamus). It has subsequently been added to in the last 36 hours. I use the web site www.snopes.com as a quick cross check on anything that comes through from unverified channels on the internet and it saves a little worry in the long run. With clearity, Roel Mulder At 10:28 12-09-2001 -0700, you wrote: Lars B. Jensen wrote: Nostradamus died in 1566... I wonder who wrote or re-wrote that passage for the event... / LJ -Original Message- From: Danny N. [mailto:[EMAIL PROTECTED]] Sent: 13. september 2001 01:43 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] USA Attacks quite interesting from Nostradamus's passage!!! In the year of the new century and nine months,From the sky will come a great King of Terror... The sky will burn at forty-five degrees.Fire approaches the great new city... There will be a great thunder,Two brothers torn apart by Chaos, While the fortress endures,The great leader will succumb, The third big war will begin when the big city is burning --Nostradamus 1654 Mulder Technisch Advies Postbus 69 NL-2740 AB WADDINXVEEN tel. 0182-640184 fax. 0182-640185 http://www.mta.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] -- 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!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger.
[PHP-DB] Repost: Persistent connections is not persistent
Actually I don't know if this problem is a PHP-, an Apache- or a MySQL-issue, but in this forum probably a lot is using the same combination of servers, so probably someone has an experience to share with me. I'm running a PHP-build website (using PHP 4.0.6) and an Apache-server (1.3.20) on a Windows 2000-server. PHP is running as a Apache-module. Most of pages is password-protected using .htaccess-files. The website is connecting to a MySQL-server (3.23.41) using pconnect(). The setup of the MySQL-server is the default in regard of the max_connections-variable (set to 100). As far as I understood, the mysql_pconnect-mechanism should reuse earlier connections made by the same user. However, I can see, that very often just a reload of a page is opening a new process, and suddenly the max_connections-limit is reached: The user is getting 'Too many connections'-errors. The SQL-server is restarted and soon after the user get 'MySQL Server has gone away'-error. On more reload of the page makes a new connection. Before I decide to raise the 'max-connections'-setting, I would be nice to hear from anyone with a similar experience. Is there a better solution, for instance using mysql_connect() and mysql_close() instead of mysql_pconnect. Or is this just a wellknown problem in MySQL? Anyone? -- 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] I need help Please....
Hello all, I tried to create a table which included primary key and a unique key. But I got this error. You have an error in your SQL syntax near 'UNIQUE,hpassword VARCHAR(50),head VARCHAR(50),body VARCHAR(50),ears VARCHAR(50),' at line 1 Can anyone help me please. This is my code. -- Below ? $link=mysql_pconnect(hostname,Name,Password) or die(mysql_error()); mysql_select_db(DBname) or die(mysql_error()); $query=create table Body (id int unsigned auto_increment NOT NULL PRIMARY KEY,; $query.=husername VARCHAR(50) not null UNIQUE,; $query.=hpassword VARCHAR(50),; $query.=head VARCHAR(50),; $query.=body VARCHAR(50),; $query.=ears VARCHAR(50),; $query.=eyes VARCHAR(50),; $query.=hair VARCHAR(50),; $query.=mouth VARCHAR(50),; $query.=nose VARCHAR(50),; $query.=date date not null,; $query.=time time not null); mysql_query($query) or die(mysql_error()); ? 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] Using PHP with filemaker?
At 4:14 PM +0100 9/10/01, joel wrote: I am trying to get php to write the data stored in some variables directly to a filemaker pro 5.5 database. So far I have got the PHP to write to a .txt file as tab delineated text, but I then have to manually import this data into filemaker. I have not been able to find any specific function for editing filemaker databases using PHP... But the php.net manual states: Try this php class created by Chris Hansen, it was specifically designed to allow PHP to connect with FileMaker. http://www.iviking.org/ to download, or http://www.iviking.org/FX/ to test. Alnisa -- . Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit-tech.org (url) http://www.tech-library.org . Nonprofit Tech E-Update mailto:[EMAIL PROTECTED] . applying technology to transform . -- 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] USA Attacks (Nostradamus -- Further Info)
wow... i didnt know nostradomus used PHP with a database backend? otherwise, please don't post this stuff on this list... -- Leo G. Divinagracia III [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] Repost: Persistent connections is not persistent
J.T., Apache has a number of processes that standby waiting for requests. mysql_pconnect (and pg_pconnect) opens up a connection per apache process, but once a connection has been opened for a process, it will remain for any subsequents requests handled by that one process. The MaxClients parameter in httpd.conf of the Apache configuration tell you the maximum number of processes Apache will have running at any one time, and therefore you MySQL DB should be set up to handle that many simultaneous connections (assuming you only make one mysql_connect call per page). Also, Apache kills and restarts each server processes after it has handled a certain amount of requests, also killing the persistent database connection. This is configurable in httpd.conf as the MaxRequestsPerChild parameter, which you may or may not want to play with. The requests could be html, images or whatever else, and so depending on your site, a persistent connection may only last a few page requests. Cheers, Kelly. -Original Message- From: J.T [mailto:[EMAIL PROTECTED]] Sent: Thursday, 13 September 2001 7:07 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Repost: Persistent connections is not persistent Actually I don't know if this problem is a PHP-, an Apache- or a MySQL-issue, but in this forum probably a lot is using the same combination of servers, so probably someone has an experience to share with me. I'm running a PHP-build website (using PHP 4.0.6) and an Apache-server (1.3.20) on a Windows 2000-server. PHP is running as a Apache-module. Most of pages is password-protected using .htaccess-files. The website is connecting to a MySQL-server (3.23.41) using pconnect(). The setup of the MySQL-server is the default in regard of the max_connections-variable (set to 100). As far as I understood, the mysql_pconnect-mechanism should reuse earlier connections made by the same user. However, I can see, that very often just a reload of a page is opening a new process, and suddenly the max_connections-limit is reached: The user is getting 'Too many connections'-errors. The SQL-server is restarted and soon after the user get 'MySQL Server has gone away'-error. On more reload of the page makes a new connection. Before I decide to raise the 'max-connections'-setting, I would be nice to hear from anyone with a similar experience. Is there a better solution, for instance using mysql_connect() and mysql_close() instead of mysql_pconnect. Or is this just a wellknown problem in MySQL? Anyone? -- 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] Passing parameters to a PHP file.
u quick question, does VAR1 contain a value before the call??? could be null to begin with... Victor Espina wrote: I want to call a PHP file with some parameters. I tried this sintax: HREF=MyPage.PHP?Var1=Value1 But i don't seem to be receiving any value for Var1. I tested it with: print Var1: $Var1; and the output is Var1: What i'm missing here? -- == Victor Espina Caracas, Venezuela http://mitrompo.com/vespina [EMAIL PROTECTED] (Quite el 'nospam' para responder) (Remove 'nospam' to reply) -- 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] -- Leo G. Divinagracia III [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] problem with dbase connections using ODBC
boy, if i remember my old dbase days, dbase uses a table locking scheme. and a pessimistic locking style. if you are just querying the table, how about making a copy of it when a local user opens it and again, when they close it. your remote users will then query the copy... Don Jackson wrote: Windows NT 4.0 workstation Apache PHP 4 the following code works fine and returns the correct results... ? $connect = odbc_connect(partner,,); $query = SELECT company FROM listing; $result = odbc_exec($connect, $query); while(odbc_fetch_row($result)){ print odbc_result($result, company) . br; } odbc_close($connect); ? --- but if someone else is accessing the table (not exclusively) i get the error message. -- Warning: SQL error: [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine cannot open the file 'N:\listing.DBF'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLExecDirect in c:\Program Files\Apache Group\Apache\htdocs/test.php on line 6 -- Is there a work around for this or a fix? I need to give internet access for this older internal database at the same time local users are accessing it. I've tried using ASP and PWS and it works but I really want to use PHP ; thanks in advance don -- 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] -- Leo G. Divinagracia III [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] search engine for database driven site?
1. use WYSIWYG html editor to make the initial HTM page with a search form with 2 text boxes. 2. the action for the form is the PHP page. 3. connect the two (using the variables in the sql query statement that's what i do... andrew hill wrote: Hi, Can anyone recommend either a general approach or sample scripts to create a search-box on my site? It's an existing site being dynamically generated from a database - I want to specify a couple of fields in my main page table to be searched on. cheers, duirfire _ 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] -- Leo G. Divinagracia III [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] SQL expert is needed. - MySQL database
Hi Guys, here goes.. SELECT count(page_searchwords.word_id) as score, page_data.id, filename, title FROM page_data, pagewords, page_searchwords WHERE (page_searchwords.media_type='static' AND pagewords.id = page_searchwords.word_id AND page_data.id = page_searchwords.id AND LCASE(pagewords.word) LIKE LCASE('%hit%')) OR (page_searchwords.media_type='static' AND pagewords.id = page_searchwords.word_id AND page_data.id = page_searchwords.id AND LCASE(pagewords.word) LIKE LCASE('%two%')) GROUP BY page_data.id ORDER BY score DESC; Hi Guys, above is one of the SQL queries my PHP codes makes up to search my database. That is what it looks like for a two words search, i.e. hit two. It looks like the following when it does a one word search, i.e. hit SELECT count(page_searchwords.word_id) as score, page_data.id, filename, title FROM page_data, pagewords, page_searchwords WHERE (page_searchwords.media_type='static' AND pagewords.id = page_searchwords.word_id AND page_data.id = page_searchwords.id AND LCASE(pagewords.word) LIKE LCASE('%hit%')) GROUP BY page_data.id ORDER BY score DESC; I'll now explain the tables to you. I have the follwing tables in my database. (go here if the stuff below got all muddle up http://www.ezigraphics.com/sql_explanation.txt) table: page_data table: pagewordstable: page_searchwords ++--+---+-+ ++-+ ++-++ | id | filename | title | contents | | id | word|| id | word_id | media_type | ++--+---+-+ ++-+ ++-++ | 1 | 01_title | ABC | information | | 1 | wtc || 2 | 1| static| | 2 | fileAA | foo | wtc | ++-+ ++-++ | 3 | foobar | bar | content | | 2 | information || 1 + 2| static| ++--+---+-+ ++-+ ++-++ It works like this. page_data has the webpage information in it, when the page get's update the SQL I have written get's all of the keywords from the page. It then get's the id's from the pagewords table (i.e. pagewords.id), adding the words if it is not already there. Then once it has all of the id's from pagewords (i.e. pagewords.id) it adds the information to the page_searchwords table. The page_searchwords.id column contains the equivalent of the page_data.id column. page_searchwords.word_id is the equivalent of the pagewords.id column and the media_type is any of the following three strings; static, pdf, news. The search works like this it. It sorts through the page_words table and get's the id of the words the user is searching. In the example above if the user search's for wtc and information, the id's it would retrieve are 1 and 2. Once it has these id's it then searches the page_searchwords table and retrieves any row which has a word_id value of either 1 or 2 (being wtc or information respectively). Once it has this it then write the search results out to the browser using the following columns from the page_data table; id, filename, title. I then also have another table: table: news ++--+-+--+ | id | headline | content | date | ++--+-+--+ | 1 | newHead | contentH| 11.01| ++--+-+--+ | 2 | header | bulding | 12.01| ++--+-+--+ This is much the same as the page_data title. I also have the contents of the news pages being update into the pagewords and page_searchword tables. What I need to know is how to look through these at the same time, and get the new id, headline and content out of the database. Does anybody have any idea? This does make sense doesn't it? Let me know if it doesn't thanks. Thanks in advance. Scott Mebberson. -- 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] Shoutout.....
...and Lets all hope that the USA retiliation will not bring more innocent deaths. -Original Message- From: Brunner, Daniel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 12:51 AM To: PHP List (E-mail) Subject: [PHP-DB] Shoutout. This Shoutout goes to the people who have lost their lives today. My heart will be with them forever. May a quick death come for those who are involved We will never forget... All those innocent lives..lost. Dan -- 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]