RE: [PHP-DB] Fatal error: undefined function mysql_connect()
Hi there, we have the same problem on our Debian. In the top of the output of phpinfo() says "-with-mysql=share", but there is no section with mysql and the settings further down. Maybe someone knows the answer! Greetings Andi |-Ursprüngliche Nachricht- |Von: winescout [mailto:[EMAIL PROTECTED]] |Gesendet: Sonntag, 29. April 2001 20:44 |An: [EMAIL PROTECTED] |Betreff: Re: [PHP-DB] Fatal error: undefined function mysql_connect() | | |I am having the same problem. I followed the advice of the |message below(), and can only find any mention of mySQL in my |Configure area. |It shows that I configured it with "-with-mysql=share". |What is the next |step to solving this? | |Here is some more information that may be usefull. |RedHat 7.0 |Apache 1.3.x |PHP 4.04 compiled with Apache, not as a dynamic module | |time and suggestions much appreciated |Matt -- 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] Intialize PHP Module on Windows98
I have a problem on intializing PHP module. I've installed PHP on my windows 98 system. I used PWS. I placed php on c:/Php. My home directory is c:/Inetpub/myfolder. This is the php.ini, Paths and Directories section : doc_root = "c:/Inetpub/myfolder" extension_dir = "c:/Php/extensions" This is the registry : [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\w3svc\parameters\Scrip t Map] ".php"="c:\\Php\\sapi\\php4isapi.dll" When I try phpinfo(), I received message like this : dbase: Unable to initialize module Module compiled with debug=0, thread-safety=1 module API=20001214 PHP compiled with debug=0, thread-safety=1, module API=2609 These options need to match That's for dbase module, and for the others module it gave the same result. Anyone could help me to solve this problem ? Regards; Benny. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] installation of ct lib from freetds
I'm trying to install CT libraries for Sybase support. Freetds instruction says I need to point my $SYBASE variable to where I have installed freetds. But the $SYBASE variabale is already pointing to the directory where I have installed Sybase. Will this affect Sybase if I change the value of $SYBASE variable? Thanks, Lester - Lester June Cabrera Chief Web Programmer I-Quest Corporation Tel: (632) 867 8150 local 301 or 302 Fax: (63 2) 867 8077 E-mail: [EMAIL PROTECTED] Visit the most comprehensive on-line business travel resource at http://www.worldroom.com Successful events start here. Visit http://www.worldroomevents.com . The one-stop online exchange for event planners and suppliers to the MICE industry. -- 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 functin newbie please help
also, on line 11 you use a variable called $localhost, i think you mean $hostname, which has the value "localhost" :) that won't help since it will pass a null value and mysql_connect will bork at having too few parameters. and you need to assign your mysql connection to a variable, so that you can use it in other functions, for example $connection = mysql_connect($db_location,$db_username,$db_password); mysql_select_db($db_name, $connection); otherwise mysql can get lost as to which database connection you are talking about (if you ever use more than one) HTH Beau // -Original Message- // From: Tyrone Mills [mailto:[EMAIL PROTECTED]] // Sent: Sunday, 29 April 2001 11:35 PM // To: Greg Kelly; [EMAIL PROTECTED] // Subject: RE: [PHP-DB] problem with functin newbie please help // // // Hi Greg, // // In config.php, line 6 needs a semi-colon on the end. Try that // and see if it // does the trick. // // Tyrone // // -Original Message- // From: Greg Kelly [mailto:[EMAIL PROTECTED]] // Sent: Sunday, April 29, 2001 11:28 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] problem with functin newbie please help // // // I have a function that I have defined in a filed called // config.php. name of // function is dbconnect() when I go to call the function I get a // Parse error: parse error in /home/test/public_html/include/config.php on // line 9 // // Fatal error: Call to undefined function: dbconnect() in // /home/test/public_html/login.php on line 5 // // Can some please tell me what i am doing wrong ? // // Thank You // // // index.php // // // config.php // // // // // -- // 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]
Re: [PHP-DB] interbase (?) field contents does not show
On Sunday 29 April 2001 19:00, GMansky wrote: > I followed the documentation on interbase. I have the following code: > > $rowcount = 0;$dbh = ibase_connect ($host, $username, $password); > $stmt = 'SELECT * FROM contact'; > $sth = ibase_query ($dbh, $stmt); > while ($row = ibase_fetch_object ($sth)) { > print $row->lastname . "\n";$rowcount = $rowcount+1; > } > echo $rowcount;ibase_close ($dbh); > ?> > $rowcount gave me the correct number of rows but referenceto any field name > does not show anything. I tried uppercaseand it still does not show > anything. Anything that I am missing? > Thanks in advance, > George Hi George Try using uppercase, ibase_fetch_object will return fields as uppercase. So: print $row->LASTNAME; You can see this info in the user contributed notes in the on line manual. goto: http://www.php.net/manual/en/function.ibase-fetch-object.php -- Meir Kriheli There's someone in my head, but it's not me - Pink Floyd -- 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] mySQL connection problem
Check to see that mySQL is running on your system. On mine, when it is not, I get an error just like that. Matt ""LENNART KARLSSON"" <[EMAIL PROTECTED]> wrote in message 9cefep$4pu$[EMAIL PROTECTED]">news:9cefep$4pu$[EMAIL PROTECTED]... > Hi! > I have a problem when I try to use a mySQL connection. > I run Win98SE, PWS 4 and php4. php is working. > > When I try to run any mySQL scripts (v this one is a forum from > planet-source-code.com) I get this error: > > Running: mysql_pconnect("localhost","root"); --> > Warning: Can't connect to MySQL server on 'localhost' (10061) in x.php > on line xx. > > What am I doing wrong? > > /Eric > > > > -- > 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] Fatal error: undefined function mysql_connect()
I am having the same problem. I followed the advice of the message below(), and can only find any mention of mySQL in my Configure area. It shows that I configured it with "-with-mysql=share". What is the next step to solving this? Here is some more information that may be usefull. RedHat 7.0 Apache 1.3.x PHP 4.04 compiled with Apache, not as a dynamic module time and suggestions much appreciated Matt "Victor Foitzik" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello franky, > on 13.04.2001 you wrote: > > > I'm trying to connect to mySQL DB by Web page > > and > > > when I use mysql_connect() > > this append: > > Fatal error: Call to unsupported or undefined function mysql_connect() > > > thanks! > > are you really sure your php has mysql support compiled in (yes, it is > possible to compile it without ;-)) ? check for mysql > info, if you don't find anything, fetch the latest version and build > a new php module with mysql support. > > HTH > Vic > > > > -- > 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] interbase (?) field contents does not show
I followed the documentation on interbase. I have the following code: lastname . "\n";$rowcount = $rowcount+1; } echo $rowcount;ibase_close ($dbh); ?> $rowcount gave me the correct number of rows but referenceto any field name does not show anything. I tried uppercaseand it still does not show anything. Anything that I am missing? Thanks in advance, George -- 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 functin newbie please help
Hi Greg, In config.php, line 6 needs a semi-colon on the end. Try that and see if it does the trick. Tyrone -Original Message- From: Greg Kelly [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 29, 2001 11:28 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] problem with functin newbie please help I have a function that I have defined in a filed called config.php. name of function is dbconnect() when I go to call the function I get a Parse error: parse error in /home/test/public_html/include/config.php on line 9 Fatal error: Call to undefined function: dbconnect() in /home/test/public_html/login.php on line 5 Can some please tell me what i am doing wrong ? Thank You index.php config.php -- 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 functin newbie please help
I have a function that I have defined in a filed called config.php. name of function is dbconnect() when I go to call the function I get a Parse error: parse error in /home/test/public_html/include/config.php on line 9 Fatal error: Call to undefined function: dbconnect() in /home/test/public_html/login.php on line 5 Can some please tell me what i am doing wrong ? Thank You index.php config.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP problem
Dear Sir/Madam, I have a mysql database available with user information. I want that visitors have the change to change their personel information. Now the form works with two different types of fields. edit-fields and selectie/option-lists. How do I get the value of a user from a selectionlists selected in the form-field. All options must be availabele, but the value of the user must be selected in the form field. If anyone can help me please mail me at [EMAIL PROTECTED] Thanks Johan. -- 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] newbie help required re oracle
Ok I have looked at the faq and cant find the answer, all I seem to find is the question, everywhere and no help for stupid people like me. I want to use my Oracle db from php and apache. I understand I have to compile php4 with oracle selected as an option. I have failed to do this, and need help. Does anyone know where to go to get a compiled version of php4 with oracle, or can anyone point me to a location where i can get simple step by step instructions of what to do? please do not assume any knowledge of UNIX or C. I am a scriptor not a programmer and I have no knowledge of either, I just want a database connection! please help. RPK -- 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] to index or not
Selvin, What database are you using? The latest version of MySQL can, I believe, index text fields, so this would suit both your keywords and description fields. If that's the database you are using I'd read the relevant portion of the docs very carefully and test to match. The index function you would want to use would be one native to your database. More commonly, indexes hold single values, like surname, product_id, birth_date, etc. Your best way may be to look at one of the Open Source search engines. ht://dig is one, and is relatively easy to install and customize. If you still want to roll your own it would be worthwhile examining the source to see how those developers have handled the problem. Cheers - Miles Thompson At 07:49 PM 4/29/01 +1000, Selvin Sakal wrote: >i'm makin a search engine the table looks like this - > >--- >| number | name | keywords | description | url | rank | >--- > >query's are made to against keywords, and description which are a blob's. >I want to index both of them but i don't know if i should use php index >function to create the index or make one myself which could look like this > >- >word | site | >- >site would contain the number's of the row which have the queryed word in >their keyword or description. > >can some tell which way is faster or is there no difference and can >someone tell me a better way if there is any and also any possible idea's >on the php script required to ran a query for words > >thanks > > > >_ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] to index or not
i'm makin a search engine the table looks like this - --- | number | name | keywords | description | url | rank | --- query's are made to against keywords, and description which are a blob's. I want to index both of them but i don't know if i should use php index function to create the index or make one myself which could look like this - word | site | - site would contain the number's of the row which have the queryed word in their keyword or description. can some tell which way is faster or is there no difference and can someone tell me a better way if there is any and also any possible idea's on the php script required to ran a query for words thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]