Re: [PHP-DB] simple issue

2006-11-22 Thread Chris Carter
Thanks Jeff, As I mentioned, this is just a sample code with username password db name all changed. Thanks for your advice coz I never knew the php db archive is searchable. Jeffrey-2 wrote: You should be aware the the PHP-DB archives are openly available on the web and searchable.

[PHP-DB] Just two PHP questions

2006-11-22 Thread Chris Carter
As mentioned before, I am new to php. Till now I was trying to execute the file online. However, I have got Apache tomcat on my system which runs JSP files perfectly, including the database interactions. I am now trying to run PHP using apache on localhost. Can you please advice: 1) What

RE: [PHP-DB] Special Character

2006-11-22 Thread David Skyers
Hi Kevin, Thanks for this, it got rid of my special characters. However I now have a problem with foreign characters. Example 'De l'Âge du fer au haut Moyen Âge.' gets inserted into oracle as De l'Acirc;ge du fer au haut Moyen Acirc;ge. I have an oracle procedure that inserts the

[PHP-DB] My first try with PHP and Oracle ..

2006-11-22 Thread Matthias Bareuther
Hello everybody, I'd like to connect to OracleDB using AdoDB. Here's my sourcecode so far : ?php error_reporting(E_ALL); include '/srv/www/htdocs/adodb/adodb.inc.php'; $conn = ADONewConnection('oracle'); $conn-debug = true; $conn-PConnect($host,$user, $pass, $dbase); ? When I load the

[PHP-DB] Direct Import Excel Data to MySQL (without CSV)

2006-11-22 Thread Adrian Schimpf
Hi together Is there a way to direct import MySQL data into an Excel Sheet, edit it and click a button to upload/sync it? I'm already using an ODBC driver to import the Data but then I'm not able to write the data back. Is someone using a reliable solution? Regards Adrian Introduction: This

[PHP-DB] search error

2006-11-22 Thread Asif Qureshi
search error and code has been posted -- Got error 28 from table handler Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/wwwabcde/public_html/multipurposechain/searchfuncs.php on line 294 Got error 28 from table

RE: [PHP-DB] Just two PHP questions

2006-11-22 Thread Miguel Guirao
1) What exactly I need to download for running PHP on Apache. PHP the latest version 2) What should be the location of the downloaded PHP folder/file/executable so that it interacts easily with Apache. Any, but if you prefer tu indicate an installation directory you may do that by specifing it

[PHP-DB] search error

2006-11-22 Thread Asif Qureshi
Got error 28 from table handler Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/wwwabcde/public_html/multipurposechain/searchfuncs.php on line 294 Got error 28 from table handlerDisplaying results 1-10 of 4541 matches (12.77 seconds) Result page:

Re: [PHP-DB] My first try with PHP and Oracle ..

2006-11-22 Thread Chris
Matthias Bareuther wrote: Hello everybody, I'd like to connect to OracleDB using AdoDB. Here's my sourcecode so far : ?php error_reporting(E_ALL); include '/srv/www/htdocs/adodb/adodb.inc.php'; $conn = ADONewConnection('oracle'); $conn-debug = true; $conn-PConnect($host,$user, $pass,

Re: [PHP-DB] Direct Import Excel Data to MySQL (without CSV)

2006-11-22 Thread Chris
Adrian Schimpf wrote: Hi together Is there a way to direct import MySQL data into an Excel Sheet, edit it and click a button to upload/sync it? I'm already using an ODBC driver to import the Data but then I'm not able to write the data back. That's probably the only way to do it. What do you

Re: [PHP-DB] search error

2006-11-22 Thread Chris
Asif Qureshi wrote: Got error 28 from table handler Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/wwwabcde/public_html/multipurposechain/searchfuncs.php on line 294 Got error 28 from table handlerDisplaying results 1-10 of 4541 matches (12.77

Re: [PHP-DB] Special Character

2006-11-22 Thread Chris
David Skyers wrote: Hi Kevin, Thanks for this, it got rid of my special characters. However I now have a problem with foreign characters. Example 'De l'Âge du fer au haut Moyen Âge.' gets inserted into oracle as De l'Acirc;ge du fer au haut Moyen Acirc;ge. I have an oracle

Re: [PHP-DB] My first try with PHP and Oracle ..

2006-11-22 Thread Christopher Jones
Matthias Bareuther wrote: Hello everybody, I'd like to connect to OracleDB using AdoDB. Here's my sourcecode so far : ?php error_reporting(E_ALL); include '/srv/www/htdocs/adodb/adodb.inc.php'; $conn = ADONewConnection('oracle'); $conn-debug = true; $conn-PConnect($host,$user, $pass,

AW: [PHP-DB] Direct Import Excel Data to MySQL (without CSV)

2006-11-22 Thread Adrian Schimpf
What do you mean you can't write the data back - do you get an error? I try to edit the data on the Excel surface and then when I made some changes I would like to safe them back in the MySQL Database. Is it possible to write the data back with the common Excel functionality (including ODBC)

Fwd: Re: [PHP-DB] search error

2006-11-22 Thread Asif Qureshi
Here I narrow down the problem. www.multipurposechain.com I enter for example search word, world, Its giving error. However previously, was giving proper output and search results from tables in database. __ Do You Yahoo!? Tired

Re: Fwd: Re: [PHP-DB] search error

2006-11-22 Thread Chris
Asif Qureshi wrote: Here I narrow down the problem. I meant narrow down the problem in your code. Add echo mysql error? . mysql_error() . br/; after your mysql_query calls for example. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List

RE: [PHP-DB] Special Character

2006-11-22 Thread Vincent DUPONT
I you use a SQL adapter, like ADO, it could do the htmlentities it self... However, if you would like to change this, note that oracle will consider some chars as 'special chars', like (if I remember well) the . To be able to insert a string with these chars, you need to search/replace them by

[PHP-DB] Moving phpNuke to phpBB

2006-11-22 Thread Niel Archer
Hi I'm helping out someone move from PHPNuke to phpBB. Only the forums and users need to be moved. Nuke's Db structure for the forums seems to mimic phpBB's closely, which is no great surprise. Any advice or information would be greatly appreciated. For example, anyone know a way to

Fwd: Re: Fwd: Re: [PHP-DB] search error

2006-11-22 Thread Asif Qureshi
Note: forwarded message attached. - Sponsored Link Mortgage rates near 39yr lows. $420,000 Mortgage for $1,399/mo - Calculate new house payment---BeginMessage--- I have this code already, have a look at this few lines of code, which is already existing.