[PHP-DB] Re: Newbie help
configuring PHP with apache is not that difficult, here's how you should do it: You should get 2 files: php4apache.dll and php4ts.dll , normally you only get these files when you compile PHP manually but conecting to PHP is much safer when you use these files, so if you need to download both versions to use these 2 dll's in your automatic install I assume you have installed both apache and PHP and that Apache works fine. You should try to get Apache 1.3 and not Apache 2 just because Apache 2 support in PHP is still experimental and it is not (yet) recommended to use PHP with apache 2. you must copy the 2 files to the directory php/sapi it is possible that you will have to create the sapi directory. When you have done that open the httpd.conf file, you can find this file in your apache/conf directory and add these lines to the file LoadModule php4_module d:/php/sapi/php4apache.dll AddModule mod_php4.c AddType application/x-httpd-php .php in the first line you should change the path to the path on your pc. now restart your pc and start apache You should see the message Apache 1.3.xx running / PHP 4.x.x. your php scripts will work fine now Greetz DragonEye Nicola Hartland [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I need some help to install and configure php I have tried downloading it a dozen times to configure it on Apache on xp but I cannot seem to get it to talk to my sql could someone provide me with an idiots guide to installing it please? Thanks in advance Nicci -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Newbie help
No such thing.but I will help. I didn't use the windows installer version.I couldn't get it to work (strange) but did get the zipped version to work. Make sure that you don't have IIS installed and running.could cause conflicts. PHP.ini should go into the \windows directory.. php4apache.dll should be in the \windows\system32 directory. Don't forget to edit the php.ini with the relevant info I found this link to be especially helpful http://www.php.net/manual/en/install.windows.php Shadow -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Newbie? - help inserting into firebird1.0
Hi Jon-David, not sure that this is the only problem, but rewrite your query like this (single quotes araound the values): $query=insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ('$txtApp','$numVersion','$txtBuild','$txtOs', '$frmSeverity', '$numPriority', '$txtState', '$txtUser', '$txtSteps', '$txtExpected', '$txtObserved', '$frmStatus', 'NOW');; Lutz [EMAIL PROTECTED] (Jon-David Schlough) writes: $query=insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE,SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ($txtApp,$numVersion,$txtBuild,$txtOs, $frmSeverity, $numPriority, $txtState, $txtUser, $txtSteps, $txtExpected, $txtObserved, $frmStatus, NOW);; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Newbie? - help inserting into firebird1.0
you're right Lutz, that is not my only problem- turns out this statement is wrought with errors :| i should not have been referring to those values as variables...stupid lamer mistake, just the name works...also, changed the double quotes to single quotes, per Lutz's suggestion, and that worked as well...so i'm getting closer. now it tosses: Warning: InterBase: conversion error from string numVersion in C:\Inetpub\dev_root\slugbug\issue_send4.php on line 19 Error. Can't insert the record with the query: insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ( 'txtApp','numVersion','txtBuild','txtOs', 'frmSeverity', 'numPriority', 'txtState', 'txtUser', 'txtSteps', 'txtExpected', 'txtObserved', 'frmStatus', 'NOW')! so this is the string conversion problem i knew was there, but hadn't gotten far enough to discover. currently RingTFM... as per usual, all help is greatly appreciated. cheers, jon-david -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lutz Bruckner Sent: Tuesday, March 26, 2002 1:34 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Newbie? - help inserting into firebird1.0 Hi Jon-David, not sure that this is the only problem, but rewrite your query like this (single quotes araound the values): $query=insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ('$txtApp','$numVersion','$txtBuild','$txtOs', '$frmSeverity', '$numPriority', '$txtState', '$txtUser', '$txtSteps', '$txtExpected', '$txtObserved', '$frmStatus', 'NOW');; Lutz [EMAIL PROTECTED] (Jon-David Schlough) writes: $query=insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE,SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ($txtApp,$numVersion,$txtBuild,$txtOs, $frmSeverity, $numPriority, $txtState, $txtUser, $txtSteps, $txtExpected, $txtObserved, $frmStatus, NOW);; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Newbie? - help inserting into firebird1.0
if APP_VERSION is defined as decimal you can not insert a string. So leaving away the quotes around $numVersion should bring you closer. Lutz [EMAIL PROTECTED] (Jon-David Schlough) writes: you're right Lutz, that is not my only problem- turns out this statement is wrought with errors :| i should not have been referring to those values as variables...stupid lamer mistake, just the name works...also, changed the double quotes to single quotes, per Lutz's suggestion, and that worked as well...so i'm getting closer. now it tosses: Warning: InterBase: conversion error from string numVersion in C:\Inetpub\dev_root\slugbug\issue_send4.php on line 19 Error. Can't insert the record with the query: insert into BUGS (APP, APP_VERSION, BUILD, OS, SEVERITY, BUG_PRIORITY, BUG_STATE, SB_USER, STEPS, EXPECTED, OBSERVED, STATUS, OPENED) values ( 'txtApp','numVersion','txtBuild','txtOs', 'frmSeverity', 'numPriority', 'txtState', 'txtUser', 'txtSteps', 'txtExpected', 'txtObserved', 'frmStatus', 'NOW')! so this is the string conversion problem i knew was there, but hadn't gotten far enough to discover. currently RingTFM... as per usual, all help is greatly appreciated. cheers, jon-david -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Newbie Help: Searching
have 2 vars $Tech and $Admin and then chnage you SQL so it says: $Query = SELECT * FROM enet WHERE TechContact LIKE '%$Tech%' AND AdminContact LIKE '%$Admin%'; Steve Devon [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... $Query = SELECT * FROM enet WHERE TechContact LIKE '%' AND AdminContact LIKE '%'; This query simply prints out my entire tables, is there a way using PHP so I can make the '%' a user input so they can search the table under those fields. Cheers -- 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]