[PHP-DB] An Error on Interbase Database
We are writing a program with php that use interbase database. we have a problem. The error message is follow: ISC ERROR CODE:335544333 ISC ERROR MESSAGE: internal gds software consistency check(wrong record length(183)) ATATEMENT: TIBOInternalDatabase: "ibqsingle.IBOqribqSingle" this message is from Interbase Workbench. Please He. ;)
[PHP-DB] Changed database context
Hi, Has anyone else seen 'Changed database context' error message from mssql when upgrading to php 4.04pl1. Thanks Nick -- 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] [Oracle] magic_quotes_gpc magic_quotes_sybase ?
I'm using php/oracle for a short time now. I'm forced to work on server where the following configuration is used: php.ini: magic_quotes_gpc= on magic_quotes_runtime= off magic_quotes_sybase = off After my first INSERT into oracle with arbitrary returned from a post form I got bitten by special characters like ', " and \. They were all escaped with \, too. But this broke my INSERTS because ' needs to be escapde with ' so it looks like '' when the acutal insert happens. As far as my testing goes, no other character needs escaping, no '\' needs; just the '. Retrieving data withing SELECT results in getting back the data WITH backslashes in them. After settigns magic_quotes_sybase = on, I couldn't believe it. Everything worked; from now one only ' was escaped to '', no other character. With the first configuration, every data coming from post forms needed to be processed with the following sequence: $input = stripslashes( $input); $input = str_replace( "'", "''", $input); After activating magic_quotes_sybase, the above is not needs anymore as the are allready escaped the right way. Has someone had such troubles too, or are there better ways of doing that ? Does someone know if the following configuration magic_quotes_gpc= on magic_quotes_runtime= off magic_quotes_sybase = on has some known issues about php stability or other problems arising with it ? (I was told so without getting more in depth information why or what) thanks for sharing ideas, Markus -- Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/ EMail: [EMAIL PROTECTED] PGP Public Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0 -- 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] insert into mysql
On Thu, 25 Jan 2001, Darryl Friesen wrote: It still didn't work. just says unable to add part $sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')"; Another thought: Are ID and part character data of some sort? If not (i.e. if ID is an int) then remove the single quotes. A trivial point this, but if you insert values in ' into a mysql int column then MySQl still treats it as intended. THey aren' necessary for int columns, but it is acceptable to have them there -Tom - Darryl -- Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED] Education Research Technology Services, http://gollum.usask.ca/ Department of Computing Services, University of Saskatchewan -- "Go not to the Elves for counsel, for they will say both no and yes" -- 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] write in a database MS SQL
Hi there, How I make to write in a database MS SQL? That is possible? Tks Santhyago -- 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] i need help with odbc!
Emanuel.exe
[PHP-DB] Heads Up! Virus on the list?
Hello all, I don't run the firewall or the virus protect at corporate, but the firewall just sent me this mail. Not being the mail admin, I'm not sure exactly what it means, but take it for what it's worth, I guess. (I removed our corp domain from the text below) - Virus protection has detected a virus TROJ_NAVIDAD.E in your mail traffic from [EMAIL PROTECTED] on 01/29/2001 17:02:37 and has been deleted. Please inform the sender of this message of the fact that they are not able to send you your email due to the virus contained. Please make sure that any other versions of this file you might have stored locally are cleaned. Contact your local support representative for assistance. -- 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] VIRUS IN i need help with odbc!
Virus in this mail? Angel2 Gabriel Lena Valega wrote: -- Virus Warning Message (on the network) Found virus TROJ_NAVIDAD.E in file Emanuel.exe The file is deleted. - -- Virus Warning Message (on the network) Emanuel.exe is removed from here because it contains a virus. - -- 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] Getting a date out of oracle
On Tue, Jan 23, 2001 at 04:30:21PM +0100, Kallin Per wrote : I'm pretty new to PHP and now I got a problem with Date datatype and oracle. I can recive the date as a string with osiresult($stmt, "COLUMN_NAME") in the oracle date format (eg. '23-JAN-01') but I wold like to recive the whole date (eg. '2001-01-23 15:21:13'), that's the first problem. The second problem is to convert this string into datatype date in php so I can use the setlocale() function on it. Here are some examples [1] for working with Oracle dates. m. [1] http://www.camden.rutgers.edu/HELP/Documentation/Oracle-class/dates.html -- Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/ EMail: [EMAIL PROTECTED] PGP Public Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0 -- 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] moving
On Tue, Jan 23, 2001 at 05:13:24PM -0800, bryan wrote : I have a site where people have to pay for the pictures. He is a professional photographer and does not want people stealing his work. When they download and image, they pay for it. The problem with that is, if I have images named 001.jpg, 002.jpg, people can type that into the URL and get the other image without paying for it. Is there a way to rename a file once clicked on to download to eliminate this from happening? So, the user clicks on the image, called from the database, have it renamed, and then delete it from the database, so they never see the real filename... Store your images _outside_ you document root folder of your webspace and you a php-script to pass it to the client. This script checks for cookies, session or whatever and only outputs the right image when a valid user. m. -- Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/ EMail: [EMAIL PROTECTED] PGP Public Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0 -- 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] PHP and PROGRESS
Hector, OpenLink has broad support for Progress in our Multi-Tier ODBC drivers. There is a HOWTO available at http://www.iodbc.org/odbc-phpHOWTO.html and the drivers are available at http://www.openlinksw.com Best regards, Andrew -- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML E-Business Infrastructure Technology On 1/29/01 7:16 PM, "Mark Newnham" [EMAIL PROTECTED] wrote: suggest you subscribe to the webspeed/servers/sql92 (depending on your progress version) list at www.peg.com, which is where the progress/php discussions/arguments are voiced... -Original Message- From: Hector Banda [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 4:55 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and PROGRESS Hi all, Any information about how to make PHP to work with PROGRESS databases? Thanks, == Hector M BandaVoice: (949) 784-3143 Progress Programmer/Analyst Fax:(949) 784-3443 Draper's Damon's -- 9 Pasteur -- Irvine Ca, 92618 == -- 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] how to connect mysql from local to remote server?
Dear Sir / Madam, I am trying to connect our US mysql database server from Malaysia server, but it isn't work. Below is my example coding:- mysql_pconnect("202.42.236.105","tester","tester"); mysql_select_db("tester"); $sql = "select * from tester"; etc. What else should I know or I miss, to make it function? Any good idea to do that? Thanks in advance, Ian. -- 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 to db php - help
I have just started using PHP and MYSQL and am having a problem placing data into my db via a PHP generated web page. To test my connectivity to the db and that I could insert data I created a php page that as soon as I loaded it on a browser connected to mysql open the particulat database placed data into the db (the info required for the db was already in the php file) the above was successful and the new data placed in the database. My next php page connected to mysql open the particular database created a form in which to place the information then allows the user to submit the form and should place the info within the db This is where I run into problems and receive the message "Method Not Allowed The requested method POST is not allowed for the URL /index.shtml." Within my apache config I have included AddType text/html .shtml AddHandler server-parsed .shtml Can anyone help? What am I missing? Also I am running Mandrake Linux 7.2 Thanx Andrew D -- 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] Target window.
using javascript, you need to specify something like this; a href="javascript:opener.location.href='destination_url.html';"Banner Here/a At 03:42 AM 1/30/01 -0200, JJeffman wrote: Is there any way of load a php page into the opener window ? Here the situation : I have a page in a normal window that pops up a small window with a banner. I'd like to have the page linked by the banner loaded on the window which pop up the small window. Is it possible with PHP or even JavaScript ? Jayme. http://www.conex.com.br/jjeffman -- 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] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- 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] insert into mysql
$sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')"; Another thought: Are ID and part character data of some sort? If not (i.e. if ID is an int) then remove the single quotes. A trivial point this, but if you insert values in ' into a mysql int column then MySQl still treats it as intended. THey aren' necessary for int columns, but it is acceptable to have them there Thanks for pointing that out Tom. That's a good bit of info to tuck away for later. We've been using MSSQL Server 7 here quite a bit lately, and it isn't nearly as forgiving. :( - Darryl -- Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED] Education Research Technology Services, http://gollum.usask.ca/ Department of Computing Services, University of Saskatchewan -- "Go not to the Elves for counsel, for they will say both no and yes" -- 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]