Re: [PHP-DB] Header error
Hi, [...] Warning: Cannot add header information - headers already sent by (output started at /home/thesis/public_html/registro.php:2) in /home/thesis/public_html/registro.php on line 80 [...] you can't have any output before calling header(). Output is any HTML or even whitespaces before the opening ?php-tag. You'll have to move the header before line 2. 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] Looking for info on PHP 4 Ingres DB
Anyone have experience using Ingres with PHP Ingres. I can't find any documentation on the area. -- 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] What does this error mean?
Hi, [...] Warning: fopen(logs/993700800.log,w+) - Permission denied in /home/sites/site20/users/guide/web/counter.php on line 28 are you sure you have the rights to access the file? Warning: Supplied argument is not a valid File-Handle resource in /home/sites/site20/users/guide/web/counter.php on line 29 fopen failed and so fgets, fputs and the other f* - functions (not in terms of swearing ;-)) fail also cause $hCounter is not vaild. Warning: Supplied argument is not a valid File-Handle resource in /home/sites/site20/users/guide/web/counter.php on line 30 1 [...] I'm new to this mailing list and have never used it before so I'm not sure which one/s to join or post this specific message to. I apologize if this is the wrong forum for this type of question. Thank you for your time. [...] perhaps better in general but hey, it's PHP so it can't be really OT. 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] TO_DAYS() equivalent?
Is there some way to get the equivalent of select TO_DAYS(NOW()) out of PHP without querying MySQL (or whatever.) Some formatting character for the date() function that I'm just missing? Thanks, -Dave -- 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 Error???
I CC-ed the mailing list by accident. Below is my original reply to Brian. -Original Message- From: Jonathan Hilgeman Sent: Thursday, June 28, 2001 8:14 AM To: 'Brian Grayless' Cc: PHP-DB (E-mail) Subject: RE: [PHP-DB] MySQL Error??? Hi Brian, Sounds like you have a tinyint field. Change it to something like int(4) or bigger, like int(6) or something. TinyInt fields can only hold up to 127, so when you add another record, the auto-incrementing field you're using cannot go any higher, so it tries to assign 127, but 127 is already taken. Thats why you get that error. - Jonathan -Original Message- From: Brian Grayless [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 9:24 AM To: PHP DB list (E-mail) Subject: [PHP-DB] MySQL Error??? Is anyone familiar with this MySQL error? 1062: Duplicate entry '127' for key 1 I wrote a great bookmark management program that works fine, but everytime I insert bookmarks, I insert somewhere over 120 and I start getting this error, and it won't add them anymore. Any suggestions??? Thanks, B R I A N G R A Y L E S S Web Administrator Premier Resorts www.premier-resorts.com P: 435-655-4812 F: 413-618-1518 -- 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] mysql errors .... or php errors ????
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Steve Brett) wrote: 'invalid index test assumed 'test' in test.php at line 13' can't remember the exact syntax but that's the general idea. if i quote the var when i reference it the error goes away. like $arow['test'] as opposed to $arow[test]. so in general i quote them always BUT i tried to set up a php members board on my server yesterday using someones elses code (blazeboard) and got hundreds of these errors whihc leads me to believe it's either my php or mysql setup ... Strictly speaking, these are not supposed to be the same thing: $myarray[index] //key uses the value of a constant named index $myarray['index'] //key is the literal string index It's a PHP warning that you're getting. Because it's an informational error rather than fatal, the parser continues on as long as it can find an element with that same name (even though it's looking first for the constant). If there's any danger of there being confusion between a constant and array element with the same name, then you need to correct the quoting. If you set your error_reporting level lower (you probably have it at E_ALL now) the warning will no longer appear; but understand that it'll still be *occuring*--it's just that you just won't be reminded of that fact anymore. So you still need to watch what you name those constants and keys! (And in the future, get in the habit of quoting keys correctly so there's no room for confusion.) -- CC -- 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] delay script
Or perhaps it did. = ) Sorry - I guess CC-ing the message list doesn'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] MySQL Error???
Thanks guys. It was all very helpful and worked great! Brian -Original Message- From: Christian Sandfeld [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 3:06 AM To: 'Brian Grayless'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] MySQL Error??? Brian, Sounds to me as if the field you have as primary key is set to type 'TINYINT'. TINYINT's 'signed' range accepts values from -128 to 127, when set to 'unsigned' it accepts values from 0 to 255. In your place I would concider changing that column to a 'SMALLINT' and set it to 'unsigned'. This will allow for values from 0 to 65535 (depending ofc. on how many digits you set as the max display size). Hope I helped :) /Christian -Original Message- From: Brian Grayless [mailto:[EMAIL PROTECTED]] Sent: 27. juni 2001 18:24 To: PHP DB list (E-mail) Subject: [PHP-DB] MySQL Error??? Is anyone familiar with this MySQL error? 1062: Duplicate entry '127' for key 1 I wrote a great bookmark management program that works fine, but everytime I insert bookmarks, I insert somewhere over 120 and I start getting this error, and it won't add them anymore. Any suggestions??? Thanks, B R I A N G R A Y L E S S Web Administrator Premier Resorts www.premier-resorts.com P: 435-655-4812 F: 413-618-1518 -- 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] sybase function for MS-SQL Server
Hi, I am working on Unix(Solaris 2.8) with Apache 1.3 and php4. I need to connect MS-SQL Server without ODBC. I know there is an option that using freetds but I haven't tried it yet. Someone told me that sybase functions can work with MS-SQL Server directly. So I called sybase_xxx() instead of mssql_xxx(). I was surprised that most of them really work! But the problem is that sybase_query() seems only work for select ... statement. When I tried to pass insert...,update... or delete..., this function returned false, but the database was actually updated. And the following sybase_query() would always return false even it is for select Here is an example: $conn=mssql_connect(MS-SQL Server,login,password); //successful sybase_select_db(db,$conn); //return true $result=@sybase_query(select ...,$conn); //Great! That's what I want. sybase_free_result($result); //no problem so far $result=@sybase_query(insert ...,$conn); //return false, but I did insert a new record into SQL Server. sybase_free_result($result); //successful $result=@sybase_query(select...,$conn); //return false, can't work with select... any more. ... Anybody had same experience before? I will appriecate any information from you. Wen __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.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]
Re: [PHP-DB] Modify Query, or sift through results?
My Last post was incorrect - sorry. My correct sql statement would be rlike (^|;)Midwest(;|$). Someone mentioned using Distinct before, which wouldn't work because Distinct acts on a field, to my understanding, so Northwest;East would be different than Northwest;South so it wouldn't really give me the results I'm looking for. Someone else mentioned FIND_IN_STR, which I had previously tried. That will find 'North' in 'Northeast' because 'North' is in the string. Doing a Reg Exp allows me to find exactly what I'm looking for, but with a little flexability to account for the semicolons and what not. Hopefully someone else has learned something too :) Joe Jason Stechschulte wrote: On Wed, Jun 27, 2001 at 08:54:04AM -0500, Joseph Koenig wrote: I've got a script that searches a db every night and sends out e-mail if it finds something a person would be interested in, based on criteria they gave us. The problem is that I have one field that stores regions of the country in a very unpleasant way. It stores them as: Northeast;West;South So all of the regions for one record go into one field. The problem is that when searching that, if someone has a preference of 'North', I dont want to pull records that have 'Northeast', as would happen with the above example. Is there a way to modify the MySQL query so as to find only 'North', keeping in mind that 'North' may be the 3rd in a list of semi-colon separated regions? Or do I need to sift through the results in PHP to clean them up? Thanks, You can certainly have MySQL do the work. I can't modify your query, because you didn't give it to us, but I can give you an example. ?php $sql = select * from your_table where your_column rlike North(;|$); ? This will do a regular expression match. If either North with a semicolon directly after it or North and the end of the string is found, the row will be returned. -- Jason Stechschulte [EMAIL PROTECTED] -- If you're going to define a shortcut, then make it the base [sic] darn shortcut you can. -- Larry Wall in [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] MySQL connection: Change on syntaxis?
At 9:05 AM +0100 6/22/01, Russ Michell wrote: Is this a new use of the function mysql_num_rows? No!. It's not a change in syntax, but it is a change in PHP's behavior. In PHP 4, mysql_num_rows() and mysql_num_fields() will issue error messages if the argument is not a result set. In PHP 3 they didn't seem to do this. This may account for the new error messages after updating PHP. You can use the @ to 'suppress error messages' that may reveal delicate information to users such as paths to directories on your server. It can be preppended to almost any php function likely to result in an error, if used incorrectly. Russ On Thu, 21 Jun 2001 23:30:03 +0200 Tom=?ISO-8859-1?B?4XMgR2FyY+0=?=a Ferrari [EMAIL PROTECTED] wrote: Hello, I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on lines like this: $rows = mysql_num_rows($result); and noticed that this is a solution: $rows = @mysql_num_rows($result); Is this a new use of the function mysql_num_rows? +-- --+ Tom·s GarcÌa FerrariBigital http://bigital.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] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.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] -- Paul DuBois, [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: Storing Code in a db?
Yes! I'd be interested in this as well! It would be very convenient to be able to store PHP (or any other server side code) in a database, then retrieve and execute it. I store a lot of website content with embedded HTML commands in a database. Being able to store PHP code in the database as well would be very convenient. The only way I can think of doing it would involve a lot of very messy parsing out of the php commands. I expect that would take way to much processing time. I don't imagine that would work for entire functions either. Maybe just individual PHP commands. Any ideas Thanks! Rita -Original Message- From: Mark @ 10base-t [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 6:06 AM To: [EMAIL PROTECTED] Subject: Storing Code in a db? Hey there, Is it possible to store code like a function, for example, in a mysql database and pull it into a php dynamicallly so you can use the function if needed? Mark -- 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] Executing several PHP scripts simultaneously??
Consider using set_time_limit() before each sub-script executes; this will time out on any individual script, but let you extend the limit on the master script. Lisa Elita [EMAIL PROTECTED] wrote in message 004901c0ffd5$90c63680$a6fc2bca@telkomnetnstan">news:004901c0ffd5$90c63680$a6fc2bca@telkomnetnstan... How can we execute several PHP scripts simultaneously inside a single PHP script? For example, let's say master.php has 10 tasks in different PHP scripts: 1.php, 2.php, ..., 10.php. Each task is independent (the input of each task is not determined by other tasks) so we can do the tasks in any order. But if 2.php is initiated after 1.php is done, and 3.php is initiated after 2.php is done, and so on, the master.php can be expired, causing the remaining tasks not executed. So how can we execute these PHP scripts simultaneously? Regards, Lisa Elita -- 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] Which state and country?
Um... you could look at REMOTE_HOST to get their IP address and use that to look up the address of their server. If you assume they won't log in long-distance, that should give you their country and state, and maybe a useful approximation of their city. Lisa Elita [EMAIL PROTECTED] wrote in message 004a01c0ffd5$91a991a0$a6fc2bca@telkomnetnstan">news:004a01c0ffd5$91a991a0$a6fc2bca@telkomnetnstan... Hi all, How can we know from which state and country a hit came? Regards, Lisa Elita -- 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] What does this error mean?
I'm trying to from a file in a directory called 'logs'. I've never seen this error before. What does it mean? ERROR Warning: fopen(logs/993700800.log,w+) - Permission denied in /home/sites/site20/users/guide/web/counter.php on line 28 Warning: Supplied argument is not a valid File-Handle resource in /home/sites/site20/users/guide/web/counter.php on line 29 Warning: Supplied argument is not a valid File-Handle resource in /home/sites/site20/users/guide/web/counter.php on line 30 1 END The last two errors are becuase the first fails to return a file handle. Here's the actual offending code. It's just a simple counter. CODE ?PHP $iDate = mktime(0, 0, 0, date(m), date(d), date(Y)); $iCount = 1; $sFile = logs/.$iDate..log; if (file_exists($sFile)) { $iCount = incCount($sFile); } else { createCountLog($sFile); } echo BFONT COLOR=BLUE$iCount/FONR/B; function incCount($sFile) { // Open and read existing count $hCounter = fopen($sFile, r); $iCount = fgets($hCounter, 1024); fclose($hCounter); // Write over it with the new count $hCounter = fopen($sFile, w); fputs($hCounter, ++$iCount); fclose($hCounter); return $iCount; } function createCountLog($sFile) { $hCounter = fopen($sFile, w+); fputs($hCounter, 1); fclose($hCounter); } ? END Usually I've been able to fix every PHP error I've gotten in the past - they've been pretty straightforward - but I've been playing around with this error for a few days now to no avail. I'm new to this mailing list and have never used it before so I'm not sure which one/s to join or post this specific message to. I apologize if this is the wrong forum for this type of question. Thank you for your time. -- Jimi Malcolm Web Content Manager inburst Internet Media inburst.com jimi.malcolm@inburst -- 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] Berkeley DB support
Hello I am looking for a version of PHP_DB.DLL that includes Berkeley DB support on the Windows platform. I read the php source (php405\ext\db\db.c) and have determined that DB support is not included by default. The dblist() function returns flat file support enabled. My best guess is to enable NDBM support, include the lines marked (*) which currently apply to BSD only, and build against the DB libraries. #if NDBM !GDBM #if BSD2 #define DB_DBM_HSEARCH 1(*) #include db.h (*) #else #ifdef HAVE_DB1_NDBM_H #include db1/ndbm.h #else #include ndbm.h #endif #endif Does this make sense? I have tried to rebuild php405 on windows but have been unsuccessful so far. Has anyone else already made these changes? Regards David Robinson -- 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] Looking for info on PHP 4 Ingres DB
Patrick, http://www.php.net/manual/en/ref.ingres.php Alternatively, ODBC should work just fine. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Patrick Bui [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 1:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Looking for info on PHP 4 Ingres DB Anyone have experience using Ingres with PHP Ingres. I can't find any documentation on the area. -- 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] mssql_xxx() and characters
Hi, You will need to configure the character translation in the Client tools. Open Cleint Network Utility (on the web server running php) and select the DB Library Options tab. There you can enable and disable Automatic ANSI to OEM convertion. If you are using the ISAPI version of php you will need to restart the server for any changes to kick in. - Frank Hi! I have PHP4.05 and MSSQL7 desktop on Win2k. Problem occurs when I query results contain some extended characters, for example ä or similar. In place of these chars thaere are some non-aphanumeric ones displayed like boxes, etc.(,, instead of ä) or simply some alphabetic character. Mssql tables are fine and show these chars correcty. I tried to change the default charset of php (ISO series) but that didn't help. I use the mssql_xxx functions and not odbc. MySQL does not have such problems (I have tested it). Has anyone got a working mssql-php that does not have problems with some extended characters? Could I hope to fix it somehow, how? TIA Karl H. Peterson -- 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] Which state and country?
Turn on referrers in the Apache config file and do reverse DNS lookuips in your web analyser. -Original Message- From: Lisa Elita [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 9:21 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Which state and country? Hi all, How can we know from which state and country a hit came? Regards, Lisa Elita -- 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] ereg and first occurence
Hi all, I would like to extract a piece from an html file. But when I try the ereg function like this it ends up pulling EVERYTHING from the first occurence of FONT face=Verdana all the way to the end of the file. eregi(FONT face=Verdana(.*)/FONT, $string, $output); for example: any thoughts on how I could extract 'NAME' from the following and not CITY? FONT face=VerdanaNAME/FONT FONT face=ArialCITY/FONT TIA olinux __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.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-DB] UPLOAD
My problem is to browse a local pc (win) and upload a file in a remote database. There is a simple solution ? Thanks, Enrico
RE: [PHP-DB] error ORA-12699
Sang, Your tnsnames file appears to be misconfigured. It should look like this: ORCL = (DESCRIPTION= (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521)) (CONNECT_DATA = (SID = ORCL))) The first line, ORCL =, lets you know what to use as your connect string. In this case, you're calling your connect string ORCL. When you try to login, you should use username/password@ORCL. In PHP, you set the third argument to OCILogon to ORCL. Here's what happens. When Oracle sees a connect string during a login attempt, it checks the tnsnames.ora file to resolve it into a protocol, address, and sid. In other words, ORCL is shorthand notation for all of the TCP/IP info and then some. I hope this makes sense, Anthony -Original Message- From: sang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 9:32 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] error ORA-12699 I have read some doc. $connect_string is set to equal from tnsnames.ora. $connect_string=(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))(CONNECT_DATA = (SID = ORCL))); I can connect my local oracle server before when using OCILogon(system,manager); But now , i cannot connect local oracle server!! It is always said the ORA-12699 error! I donot know what is wrong. sang Anthony Carlos [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Sang, Since you're trying to connect from another computer to the Oracle server, you probably need to specify a connect string in the OCILogon command. OCILogon('system', 'manager', $connect_string); What's the value for $connect_string? It depends on how you've set-up your Oracle networking. If you can access your DB from that client machine with SQL*Plus, then you must be loging in via the following format: sqlplus system/manager@connect_string Use the value of connect_string for $connect_string. It should be defined in your tnsnames.ora file on your client, and have a corresponding entry in your listern.ora file on your server. I suspect that your client machine is trying to access an Oracle database on itself, because no connect string was specified. Lemme know if this helps, Anthony From: sang [EMAIL PROTECTED] Date: Wed, 27 Jun 2001 18:59:31 +0900 To: [EMAIL PROTECTED] Subject: [PHP-DB] error ORA-12699 I have installed NT4+PHP+ORACLE8.0.4+APACHE in my computer. I want to access ORACLE server to another computer from web server. It is ok to access ORACLE SERVER with PERL, but i cannot access using PHP. The first error is ora-12514 , but i change, change and change, now it is always ORA-12699 Native service internal error . ?php ocilogon(system,manager,); ? Warning: _oci_open_server: ORA-12699:Native service internal error Thanks in advance. sang -- 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 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 errors .... or php errors ????
the code wasn't mine. it was a drop in message board. Steve -Original Message- From: Jason k Larson [mailto:[EMAIL PROTECTED]] Sent: 28 June 2001 11:12 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] mysql errors or php errors Another thought came to mind. These errors could be the result of verbose error reporting by PHP. php.ini or a script could be setting error reporting high enough to display these errors, however it's extremely poor PHP coding syntax to not correctly quote everything (except constants, of course). One might decide to resolve these errors once and for all by applying single or double quotes on all named Array indexes. For the short term you may look into error_reporting() in php. Jason k Larson -- 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] preg_match
k I have no idea on this. My code: 8 $begin = Property Type; 9 $end = BR; 10 preg_match($begin . (.*) . $end, $str, $data); The error: Warning: Delimiter must not be alphanumeric or backslash in c:\apache\htdocs\index.php on line 10 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.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]
Re: [PHP-DB] FW: strange numbers in link
[EMAIL PROTECTED] wrote in message BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1">news:BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1... Our website uses mysql/php. Good! ;-) I found the link written below as a hard coded link and I can't figure out why the programmer would have used c2x5han as a keyword instead of using chan as the keyword- which is an acronym for Child Health Nutrition. A HREF=/sources/search.php3?type=electronickeywords=c2x5hanoffset=0Child Health amp; Nutrition/A I thinking about changing the link but not sure what the repercussions would be - if any? (shrug) so try it. /sources/search.php3?type=electronickeywords=chanoffset=0 /sources/search.php3?type=electronickeywords=c2x5hanoffset=0 What do you get back for each, and how do they differ? If you get back the same thing, feel free to change it. Does any one have any ideas as to the logic of using c2x5han? None whatsoever; if whoever wrote it is still around, why not ask them? Thank you, Shawna Contact Information: Shawna C. Gibbs Website Technical Assistant Global Health Council 20 Palmer Court White River Junction, VT 05001 USA tel: 802.649.1340 fax: 802.649.1396 email: [EMAIL PROTECTED] website: http://www.globalhealth.org -- 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] How do I keep the values of objects when refreshing page?
Hector M Banda [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi all, My page is getting the values and the submits itself displaying the information but the original selection is gone showing the objects with no info. ... so you have a form which submits values to a script and when you return the form fields are blank? How do you return to the form? Does the submit script forward you to it again? If so, you will have to pass the parameters back again and change the form code to fill the values in, something like === form.php === form action=submit.php method=post brName: input type=text name=name value=?= $name ? brPhone: input type=text name=phone value=?= $phone ? brinput type=submit /form === submit.php === ?php storeValues($name, $phone); header(Location: form.php?name=$namephone=$phone); ? You will also need to consider some method for preventing duplicate entries. -- 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] Header error
Hello guys Thanks very much for your help on the ADODB error, I have already fix it. Now I've got another weird message. When I send data to the DataBase from a form, it does store the data but sends me back the following response: *** Warning: Cannot add header information - headers already sent by (output started at /home/thesis/public_html/registro.php:2) in /home/thesis/public_html/registro.php on line 80 *** I checked line 80 and there is a closing parenthesis in there. Any idea? Thanks a lot for your help. --- Wilmar Pérez IT Manager - Central Library University of Antioquia Medellín - Colombia tel: ++57(4)2105145 --- -- 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]