[PHP-WIN] Random "CGI Error" ???
I have a php page that is invoked as method in a form. It happens that (it seems randomly) I obtain a : --- CGI Error The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: --- If I try to post it again, then the page probably is displayed ok (...probably) I use some session function at the start of this page, but I can't understand why this page works good in a "ghost"-ed but slower server. The session parameters seems to be ok, since they work fine on the other server. Anyone have some idea? Thanx, Fabio -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] update?'
[Sandeep Murphy] Hi, I need to update an entire table in one database with the values from another database... My query reads like this: update palmeira.t_colaboradores t, hr.member_status s, hr.member_data d set t.structure=s.structure, t.depart_area=s.area where t.cs_id=d.cs_id and d.cs_id=125 [Sandeep Murphy] in the query, plameira and hr are the 2 diff databases any suggestions as to how to make this work??? tia, sands -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
php-windows Digest 4 Apr 2002 11:35:45 -0000 Issue 1077
php-windows Digest 4 Apr 2002 11:35:45 - Issue 1077 Topics (messages 12923 through 12927): Re: Any credability lost... 12923 by: Brad Thomas Re: testing for value in $HTTP_COOKIE_VARS 12924 by: Steve Yates Re: Configuring securely in IIS5 12925 by: olinux Random "CGI Error" ??? 12926 by: Fabio update?' 12927 by: Sandeep Murphy Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- --- Begin Message --- "Ross Fleming" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > It is after 6am, I am just going to bed after several friends have left my > flat after copious amounts of vodka consumed. Just thought people might be > interested to hear and share any similar stories! :) OK, bed now, up-time > and hang-over in 4½ hours now. Yha > > R > Right :) Vodka + PHP = Brainhurt --- End Message --- --- Begin Message --- To follow up with the group, I received an answer via e-mail within a few minutes with two methods (thanks AB). (1) $foo = @$HTTP_COOKIE_VARS["foo"]; # Where the @ suppresses the warnings on the call. if ($foo) { } (2) The one I ended up using (modified a bit): if ((isset($HTTP_COOKIE_VARS["foo"]) and ($HTTP_COOKIE_VARS["foo"] == 'value')) { } PHP short circuits the logic so method 2 doesn't throw the error on the value test. Or of course you can put the test for the value inside the if {}. Also for environment variables you can use getenv() rather than the array. - Steve Yates - * <- Tribble.! <- Tribble With A Mohawk. / Taglines by Taglinator 2.5 - www.srtware.com / --- End Message --- --- Begin Message --- Eric, I am in the beginning of the same process. I do php, unfortunately our company has just made a large investment in an ASP/MSSQL based directory. I will be building a content management system and moving site from static to database driven (www.insurancejournal.com). I'd love to share tips on how to do this most effectively. I have heard that the most recent build is much more stable as ISAPI module so that's what I'll be trying - another issue I need to sort out is how to keep url's search engine friendly - ie. website.com/news/article_id/123 I will be using the latest php build from this site. I think that this will probablybe much better configured than whatever I would come up with. http://www.php4win.com Later, Josh --- Eric Gentry <[EMAIL PROTECTED]> wrote: > I have looked at the tool already, and it doesn't > reference security for > any issues with php. > > I know what to do to the IIS server to secure it, my > concern is over the > addition of the php module and how it effects the > security of the > system. > > -Original Message- > From: Robin Bolton [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 01, 2002 10:52 AM > To: Eric Gentry; [EMAIL PROTECTED] > Subject: RE: [PHP-WIN] Configuring securely in IIS5 > > > A good place to start may be the IIS Lockdown Tool: > > http://www.microsoft.com/WINDOWS2000/downloads/recommended/iislockdown/d > efau > lt.asp > > > -Original Message- > From: Eric Gentry > [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 01, 2002 8:15 AM > To: [EMAIL PROTECTED] > Subject: [PHP-WIN] Configuring securely in IIS5 > > > I have been able to install php and get it running > on our test server > running IIS5. Everything is going fine, but now I am > beginning to ponder > the question, how do I secure this when it goes > live? > > I have read through the installation documentation, > and read the > security chapter of the php manual that I downloaded > from the php.net > website. > > Various queries to Google have been unproductive, so > I thought I may > check here. > > Now, I am not talking about script internals > security (that will be > handled more by our development team), just mainly > how to configure php > on the server so that I don't have people tearing > the darn thing down > when this site goes live. We are using the ISAPI > module. > > I have seen numerous tidbits on Apache, but we are > going to be using > IIS. > > Can anyone point me to a book, FAQ, examples, > anything to set me on the > way? > > Thanks a ton > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ --- End Message --- --- Begin Message --- I have a php page that is invoked as method in a form. It happens that (it seems randomly) I obtain a : --- CGI Error The spec
[PHP-WIN] Bounces
I can't figure out how to get email bounces to come back so that I can remove them from my lists. Is there some way to do this? I am using the mail function. Troy - Protect yourself from spam, use http://sneakemail.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] Bounces
At 09:19 AM 4/4/2002 +, you wrote: >I can't figure out how to get email bounces to come back so that I can >remove them from my lists. Is there some way to do this? I am using the >mail function. > >Troy If you mean remove them automatically, then I don't think there would be any way to do this other than setting the From: and Reply-To: headers to the address you want outgoing messages bounced to, then having PHP check that e-mail account's e-mail and detect bounced ones by parsing the messages. That, or running your own mail server software. If you mean manually, then you could just set the From: and Reply-To: headers to your e-mail address and all bounces would come back to that. -Mike -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] Using ODBC
Does anyone have any experience using ODBC to connect to an Access database, I'm runing php and Apache in Windows 2000. Any help will be apreciated. Thanks Someone -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] PHP crash www service NT + IIS4
Hi, I have a problem with some php pages when I submit via post a form, www service crash! on the event log I have this message: The Open Procedure for service "ContentFilter" in DLL "QPerf.dll" Any ideas? Thanks in advance Bye, Dave -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] R: [PHP-WIN] Using ODBC
I've used several times an ODBC Connection with Access db. I used the COM object. I found a simply example: $dbname="prova.mdb"; $query="SELECT * FROM users"; $connessione=new COM("ADODB.Connection"); $connessione->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\inetpub\\wwwroot\\$dbname"); $rs=$connessione->execute($query); if (!$rs->EOF) { while (!$rs->EOF) { $campo1=$rs->fields("name"); $campo2=$rs->fields("surname"); $campo3=$rs->fields("email"); echo $campo1->value.""; echo $campo2->value.""; echo $campo3->value.""; $rs->movenext(); } } $rs->close; ?> -Messaggio originale- Da: Someone Somewhere [mailto:[EMAIL PROTECTED]] Inviato: giovedì 4 aprile 2002 17.45 A: [EMAIL PROTECTED] Oggetto: [PHP-WIN] Using ODBC Does anyone have any experience using ODBC to connect to an Access database, I'm runing php and Apache in Windows 2000. Any help will be apreciated. Thanks Someone -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] New to PHP Need Help
mysql_fetch_row() returns an associative array containing all columns retrieved from the database. You can't echo an array directly. In the associative array, the keys are the column names from the table, the values are the values you retrieved in that row. So you could do this to see what you have: ...all the same code... $Location_Info = mysql_fetch_row($result); foreach($Location_Info as $key => $value) { echo "$key: $value\n"; } That would display the row. There's tons of tutorials on basic PHP<->MySQL stuff like this out on the web. I recommend checking webmonkey.com, zend.com, phpbuilder.com, devshed.com. Also, it's not great etiquette to send your message to multiple listservs at once. -Mike At 09:29 AM 4/4/2002 -0600, Jason Tobias wrote: >I am trying to define variables through an anchor tag to retrive data from >MySQL, When the script runs it displays Array. I am running WIN2K and IIS >5 > >echo "Camp Street Cafe"; > >Here is the script that is called. > > >$db = mysql_connect("localhost", "", "") > or die ("Could not connect to Localhost"); >mysql_select_db ("ETM", $db) > or die ("Could not connect to the Database"); > >$table = "locations"; >$location = ($_REQUEST["location"]); >$query = "Select * from $table where Location_ID = $location"; >$result= mysql_query($query); >$Location_Info = mysql_fetch_row($result); > >echo "$Location_Info"; > >?> > > > > > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php Mike Flynn - Burlington, VT http://www.mikeflynn.net/ - [EMAIL PROTECTED] home=>work=>home=>store=>home [repeat daily] -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] For John w/ Q about $_SESSION
Sorry to use public forum I totally lost your email address, but anyways, I finally managed to make this $_SESSION work although it's still weird to me (newbie) because the manual still said session_register() is not needed, but I couldn't find any other way to do it. Enough said, here's my test file (as is), just take a look at it and see if you can run it on your machine: File 1 Reg Ses "; echo session_id() . ""; echo $groo . ""; echo ""; ?> reg_2.php File 2 Sess "; print $_SESSION["groo"] ." \$_SESSION"; print "foo: $foo "; print "groo: $groo "; if (!isset($_SESSION["foo"])) { print "foo is registered!"; } else { print "foo is not registered!"; } echo ""; if (session_is_registered("groo")) { print "groo is registered!"; } else { print "groo is not registered!"; } ?>
[PHP-WIN] New to PHP Need Help
I am trying to define variables through an anchor tag to retrive data from MySQL, When the script runs it displays Array. I am running WIN2K and IIS 5 echo "Camp Street Cafe"; Here is the script that is called. $Location_Info"; ?> -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] session variables
I seem to have configuration problemsi just can't seem to get session variables written to in files under win2000, NTFS w/ Apache 1.3.23 and PHP 4.1.2 ..i've already done everything from session_start() on every page to making var globalanybody can help?? thanksbtw, i got the same system on a Linux box running apache and php and it works fine Apparently under the bug report database for bug number 16043, my exactly problem was described. According to the PHP team, this windows/apache1.3.23/php4.1.2 session not writing to file bug has been fixed in the 4.2.0RC1 binaries. I've patched my php4apache.dll with the ones from 4.2.0RC1 AND it still doesn't work!!! Anyone who used 4.2.0RC1 came across this problem and made it work? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] For John w/ Q about $_SESSION
I guess you're not the person who emailed me a couple of days ago. But if you know the answer some time in the future, I still would like to know why I still need to use session_register() although the manual specified I don't need it if I use $_session["var"]. - Original Message - From: "Asendorf, John" <[EMAIL PROTECTED]> To: "B.T." <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 11:37 AM Subject: RE: [PHP-WIN] For John w/ Q about $_SESSION > I haven't had any trouble with it, but I was interested and gave it a try... > > The line: > > if (!isset($_SESSION["foo"])) { > > should hit if the session variable IS NOT set, but it echoes "foo is > registered..." > > I don't quite get why that is true... > > - > John Asendorf - [EMAIL PROTECTED] > Web Applications Developer > http://www.lcounty.com - NEW FEATURES ADDED DAILY! > Licking County, Ohio, USA > 740-349-3631 > Nullum magnum ingenium sine mixtura dementiae fuit > > > > -Original Message- > > From: B.T. [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, April 04, 2002 2:34 PM > > To: Asendorf, John > > Subject: Re: [PHP-WIN] For John w/ Q about $_SESSION > > > > > > Sorry didn't pay attention on the last name but was it you > > that had the same > > problem with me as to maintain session variables across pages? > > > > - Original Message - > > From: "Asendorf, John" <[EMAIL PROTECTED]> > > To: "B.T." <[EMAIL PROTECTED]> > > Sent: Thursday, April 04, 2002 10:52 AM > > Subject: RE: [PHP-WIN] For John w/ Q about $_SESSION > > > > > > > Me John? Or some other John? > > > > > > - > > > John Asendorf - [EMAIL PROTECTED] > > > Web Applications Developer > > > http://www.lcounty.com - NEW FEATURES ADDED DAILY! > > > Licking County, Ohio, USA > > > 740-349-3631 > > > Nullum magnum ingenium sine mixtura dementiae fuit > > > > > > > > > > -Original Message- > > > > From: B.T. [mailto:[EMAIL PROTECTED]] > > > > Sent: Thursday, April 04, 2002 1:28 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: [PHP-WIN] For John w/ Q about $_SESSION > > > > > > > > > > > > Sorry to use public forum I totally lost your email address, > > > > but anyways, I finally managed to make this $_SESSION work > > > > although it's still weird to me (newbie) because the manual > > > > still said session_register() is not needed, but I couldn't > > > > find any other way to do it. Enough said, here's my test file > > > > (as is), just take a look at it and see if you can run it on > > > > your machine: > > > > > > > > > > > > File 1 > > > > > > > session_start(); > > > > //if (!isset($_SESSION['foo'])) { > > > > //$_SESSION['foo'] = "test foo"; > > > > session_register("foo"); > > > > $foo = "Another test"; > > > > //} > > > > > > > > session_register("groo"); > > > > $groo = "Test 2"; > > > > > > > > ?>Reg Ses > > > > > > > > "; > > > > echo session_id() . ""; > > > > echo $groo . ""; > > > > > > > > echo ""; > > > > ?> > > > > reg_2.php > > > > > > > > > > > > > > > > File 2 > > > > > > > session_start(); > > > > ?>Sess > > > > > > > > > > > > "; > > > >print $_SESSION["groo"] ." \$_SESSION"; > > > > > > > >print "foo: $foo "; > > > >print "groo: $groo "; > > > > > > > >if (!isset($_SESSION["foo"])) { > > > > print "foo is registered!"; > > > >} else { > > > > print "foo is not registered!"; > > > >} > > > > > > > >echo ""; > > > > > > > >if (session_is_registered("groo")) { > > > > print "groo is registered!"; > > > >} else { > > > > print "groo is not registered!"; > > > >} > > > > > > > > ?> > > > > > > > > > > > > > > > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] Failed opening for inclusion
I didnt think you can do that. It might work if you left out the http:// and domain.com was the domain of your server. You usually have to do the local path e.g. /usr/include/file.txt or c:/usr/include/file.txt. "Sonia" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > If your server run at Linux : yes. > But about windows it seems not. > > I would like to know if there is a solution. > > > "Alberto. Sartori" <[EMAIL PROTECTED]> a écrit dans le message news: [EMAIL PROTECTED] > You can do this? use an URL as an argument for include? > > -Messaggio originale- > Da: Sonia [mailto:[EMAIL PROTECTED]] > Inviato: mercoledì 27 marzo 2002 13.39 > A: [EMAIL PROTECTED] > Oggetto: [PHP-WIN] Failed opening for inclusion > > > Hie all, > > Do someone knows why i've got an error when my script is: > > include ("http://domain.com/test.php";) > ?> > > > Error : Failed opening 'http://domain.com/test.php' for inclusion > (include_path='') > > Other include on my localhost (server : IIS5) are ok > > > Thanks all > > French kiss > Sonia > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] New to PHP Need Help
Hi, mysql_fetch_row($result) function output is an array - so it's not strange that your script produces such output. Read the manual for detailed explanation of this function and how to handle the result set. You should also know name of the field you want to retrieve from db - in SQL query you're selecting all record fields - maybe it's not necessary... You can also try (I prefer :-)) this way: $result= mysql_query($query); $answer = mysql_fetch_array($result); $Location_Info = $answer['required field name']; echo $Location_Info; HTH Piotr Jason Tobias wrote: > I am trying to define variables through an anchor tag to retrive data from > MySQL, When the script runs it displays Array. I am running WIN2K and IIS > 5 > > echo "Camp Street Cafe"; > > Here is the script that is called. > > > $db = mysql_connect("localhost", "", "") > or die ("Could not connect to Localhost"); > mysql_select_db ("ETM", $db) > or die ("Could not connect to the Database"); > > $table = "locations"; > $location = ($_REQUEST["location"]); > $query = "Select * from $table where Location_ID = $location"; > $result= mysql_query($query); > $Location_Info = mysql_fetch_row($result); > > echo "$Location_Info"; > > ?> > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-WIN] Failed opening for inclusion
Should do, make sure that u have allow_url_fopen=On in your php.ini however, I don't know if it does server redirects. Oh also make sure you're using v4.0.5 (i think) or later? Throwing myself wide open to shouts of "you're wrong!!" people firebombing my house and laughing at me in the street and sigh yes I'm drunk again Ross -Original Message- From: LaserJetter [mailto:[EMAIL PROTECTED]] Sent: 04 April 2002 21:01 To: [EMAIL PROTECTED] Subject: Re: [PHP-WIN] Failed opening for inclusion I didnt think you can do that. It might work if you left out the http:// and domain.com was the domain of your server. You usually have to do the local path e.g. /usr/include/file.txt or c:/usr/include/file.txt. "Sonia" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > If your server run at Linux : yes. > But about windows it seems not. > > I would like to know if there is a solution. > > > "Alberto. Sartori" <[EMAIL PROTECTED]> a écrit dans le message news: [EMAIL PROTECTED] > You can do this? use an URL as an argument for include? > > -Messaggio originale- > Da: Sonia [mailto:[EMAIL PROTECTED]] > Inviato: mercoledì 27 marzo 2002 13.39 > A: [EMAIL PROTECTED] > Oggetto: [PHP-WIN] Failed opening for inclusion > > > Hie all, > > Do someone knows why i've got an error when my script is: > > include ("http://domain.com/test.php";) > ?> > > > Error : Failed opening 'http://domain.com/test.php' for inclusion > (include_path='') > > Other include on my localhost (server : IIS5) are ok > > > Thanks all > > French kiss > Sonia > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] PHP and mySQL...
Using MS Windows 98, Apache, PHP and mySQL. I've installed Apache on my hard drive to test a database driven website using PHP and mySQL. Could somebody lead me through the steps if I want to continue using the mySQL database and PHP when the site goes live and the files are uploaded and published to my ISP's server? Is this possible? Thanking all in advance. Tony Ritter -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-WIN] Login problem not in FAQ
I have the following error when login Squirrel Mail. You must be logged in to access this page. I've checked that the system was not generating any cookie when I try to login. I expect this is the cause of problem as squirrelmail need cookie. However, I've verified cookie was enabled by running a .PHP test with the following code and checked that the cookie file was actually created. I am using w2k server, IIS5, php 4.1.2 exe version, squirrel mail 1.2.5, and IE5.5 browser. Thank you very much. Barry -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
php-windows Digest 4 Apr 2002 23:55:27 -0000 Issue 1078
php-windows Digest 4 Apr 2002 23:55:27 - Issue 1078 Topics (messages 12928 through 12942): Bounces 12928 by: jmt2que001.sneakemail.com 12929 by: Mike Flynn Using ODBC 12930 by: Someone Somewhere PHP crash www service NT + IIS4 12931 by: Dave R: [PHP-WIN] Using ODBC 12932 by: Alberto. Sartori New to PHP Need Help 12933 by: Jason Tobias 12934 by: Mike Flynn 12939 by: Piotr Pluciennik For John w/ Q about $_SESSION 12935 by: B.T. 12937 by: B.T. session variables 12936 by: Lee, Ford Re: Failed opening for inclusion 12938 by: LaserJetter 12940 by: Ross Fleming PHP and mySQL... 12941 by: Anthony Ritter Login problem not in FAQ 12942 by: barry Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- --- Begin Message --- I can't figure out how to get email bounces to come back so that I can remove them from my lists. Is there some way to do this? I am using the mail function. Troy - Protect yourself from spam, use http://sneakemail.com --- End Message --- --- Begin Message --- At 09:19 AM 4/4/2002 +, you wrote: >I can't figure out how to get email bounces to come back so that I can >remove them from my lists. Is there some way to do this? I am using the >mail function. > >Troy If you mean remove them automatically, then I don't think there would be any way to do this other than setting the From: and Reply-To: headers to the address you want outgoing messages bounced to, then having PHP check that e-mail account's e-mail and detect bounced ones by parsing the messages. That, or running your own mail server software. If you mean manually, then you could just set the From: and Reply-To: headers to your e-mail address and all bounces would come back to that. -Mike --- End Message --- --- Begin Message --- Does anyone have any experience using ODBC to connect to an Access database, I'm runing php and Apache in Windows 2000. Any help will be apreciated. Thanks Someone --- End Message --- --- Begin Message --- Hi, I have a problem with some php pages when I submit via post a form, www service crash! on the event log I have this message: The Open Procedure for service "ContentFilter" in DLL "QPerf.dll" Any ideas? Thanks in advance Bye, Dave --- End Message --- --- Begin Message --- I've used several times an ODBC Connection with Access db. I used the COM object. I found a simply example: $dbname="prova.mdb"; $query="SELECT * FROM users"; $connessione=new COM("ADODB.Connection"); $connessione->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\inetpub\\wwwroot\\$dbname"); $rs=$connessione->execute($query); if (!$rs->EOF) { while (!$rs->EOF) { $campo1=$rs->fields("name"); $campo2=$rs->fields("surname"); $campo3=$rs->fields("email"); echo $campo1->value.""; echo $campo2->value.""; echo $campo3->value.""; $rs->movenext(); } } $rs->close; ?> -Messaggio originale- Da: Someone Somewhere [mailto:[EMAIL PROTECTED]] Inviato: giovedì 4 aprile 2002 17.45 A: [EMAIL PROTECTED] Oggetto: [PHP-WIN] Using ODBC Does anyone have any experience using ODBC to connect to an Access database, I'm runing php and Apache in Windows 2000. Any help will be apreciated. Thanks Someone -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- End Message --- --- Begin Message --- I am trying to define variables through an anchor tag to retrive data from MySQL, When the script runs it displays Array. I am running WIN2K and IIS 5 echo "Camp Street Cafe"; Here is the script that is called. $Location_Info"; ?> --- End Message --- --- Begin Message --- mysql_fetch_row() returns an associative array containing all columns retrieved from the database. You can't echo an array directly. In the associative array, the keys are the column names from the table, the values are the values you retrieved in that row. So you could do this to see what you have: ...all the same code... $Location_Info = mysql_fetch_row($result); foreach($Location_Info as $key => $value) { echo "$key: $value\n"; } That would display the row. There's tons of tutorials on basic PHP<->MySQL stuff like this out on the web. I recommend checking webmonkey.com, zend.com, phpbuilder.com, devshed.com. Also, it's not great etiquette to send your message to multiple listservs at once. -Mike At 09:29 AM 4/4/2002 -0600, Jason Tobias wrote: >I am trying to define variables through an anchor tag to retrive data from >MySQL, When the script runs it displays Array. I am running WIN2K and IIS >5 > >echo "Camp Street Cafe"; > >H
Re: [PHP-WIN] PHP and mySQL...
I've experience developing website using IIS, MySQL and PHP on Windows 2K machine and upload it to a server that is running Apache, MySQL and PHP on RedHat Linux 7.1 without a single code modification. To upload files to your server, you need a FTP client, to create a database that your local mahcine is running, most server has some version of PHPMyAdmin. Thanks ST Ooi Malaysia http://www.shop-streets.com - Original Message - From: "Anthony Ritter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 8:15 AM Subject: [PHP-WIN] PHP and mySQL... > Using MS Windows 98, Apache, PHP and mySQL. > > I've installed Apache on my hard drive to test a database driven website > using PHP and mySQL. > > Could somebody lead me through the steps if I want to continue using the > mySQL database and PHP when the site goes live and the files are uploaded > and published to my ISP's server? > > Is this possible? > > Thanking all in advance. > Tony Ritter > > > > > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] PHP and mySQL...
Sorry if my original question was confusing. This is what I would like to accomplish: I am currently developing a database on my website using mysql which is on my harddrive. I have installed Apache as well and I am using PHP. My database is functioning fine on localhost. I would like to find out the steps one takes in going from the process of having this reside on my harddrive - localhost - in development - to my ISP's server when it goes live. Thanking all in advance. Tony Ritter -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php