Re: [PHP-DB] Input ++90 causing problems
Hi, I was able to trick IE but not Firefox to display some of the characters you had displayed. 212- By selecting the encoding Arabic ASMO 708 and then selecting auto select in the encoding. On IE with right to left it appears -212 followed by the two characters that look like a sleepy 9 with a u on top. I suspect that it is an issue with the encoding. Have you tried to state the encoding to use in your HTML? graeme ioannes wrote: When I copy the php page and paste in a new page, upload that, and view with the same ? variables, it works (the css works and no js errors), however when I use the original php page, and then change the URL manually in the IE address line, it again does not work (css screwed up etc)! - Original Message - From: graeme [EMAIL PROTECTED] To: ioannes [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Friday, January 14, 2005 8:17 AM Subject: Re: [PHP-DB] Input ++90 causing problems It appears as plus sign and numbers on my computer. graeme. ioannes wrote: It appears that the code below in short has the following problematic strings: ++90 ++90-212- gives 212- on my test page below: error2.htm. A clue might be that a search on google turns up Arabic unicode, and the input here was done in Turkey. check the link: http://www.londonriverside.co.uk/error2.htm and let me know if it appears the same to you or is a function of my computer, which includes Japanese libraries. (In order to send this message I need to choose unicode formatting.) ++90 ++90 gives ++90 ++90 on error3.htm - and is correct The string ++90 came from a web input form, where someone was putting in their phone number. It was stored in a database and retrieved onto a web page, all using php, on which page it screwed up the css and caused unusual javascript errors. Although when the same person input the same phone number on the same form again, the same problem did not occur all the time but did re-occur at least twice. I cut down the HTML and finally found these few figures seemed to be the cause, though if I used my HTML editor to applyt auto-formatting to the page the error did not occur. Also if I simply deleted the ++90 characters and typed them in again and uploaded that, there were no errors. Confusingly, href links to other pages requiring a query to be run on the same record in the database - although it does not require to retrieve and show the phone number on the htm page but does use the index reference of the record - fails to retrieve any information for the record, eg my dates just default to 01/01/1970 erroneously and other info is retrieved on the record, in this case there is no css problem or javascript error in the static HTML, just no data to show within the page. Also note that when I get into the table and cut and paste all the info to a new record, the new record works - ie I can retrieve it with same tel numbers and everything works. Is there something about this string ++90 that is problematic, possibly in relation to being sent from an internet form initially? If it's simply a familiar error from Arabic unicode perhaps I should be filtering this out on all input pages? are there other such problematic strings? what am I searching for if I search for good input filtering for web input forms? John I did the following test pages: error2.htm: html head titletest/title LINK href=styles/test.css type=text/css rel=stylesheet /head body text=#00 leftmargin=0 topmargin=0 marginwidth=0 marginheight=0 bgcolor=#ff table width=1000 border=1 cellspacing=0 cellpadding=0 trtd class=textset3 colspan=12 ++90 ++90-212- /td/tr/table /body /html error3.htm: html head titletest/title LINK href=styles/enquiries_css.css type=text/css rel=stylesheet /head body text=#00 leftmargin=0 topmargin=0 marginwidth=0 marginheight=0 bgcolor=#ff table width=1000 border=1 cellspacing=0 cellpadding=0 trtd class=textset3 colspan=12 ++90 ++90 /td/tr/table /body /html -- Experience is a good teacher, but she sends in terrific bills. Minna Antrim
Re: [PHP-DB] Require VB Usergroup
Thanks for your co-operation !!! But I need user group for VB 6.0 for client based programme and not for VB.NET. Regards, Rinku Joseph Crawford [EMAIL PROTECTED] wrote: you could try the Vermont .NET user group, there are several VB guru's there i think it's http://www.vtdotnet.org -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] - Do you Yahoo!? The all-new My Yahoo! What will yours do?
RE: [PHP-DB] Require VB Usergroup
definitely off topic...but www.tek-tips.com is my place for that sort of info...forums more than mail group.. bastien From: Rinku [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Require VB Usergroup Date: Fri, 14 Jan 2005 09:04:15 -0800 (PST) Dear all, Can any of you suggest me any usergroup For VB just same as this usergroup ? I know this is very different question from this group, but I had tried a lot to search for that. So all of your's comments and views will be highly apreciated ... Regards, Rinku - Do you Yahoo!? The all-new My Yahoo! Get yours free! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Integrating Firebird into PHP
I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP. Has anyone had success doing this? Todd -- inline: NewLogo.gif
[PHP-DB] Integrating Interbase.so and PHP
I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP. Has anyone had success doing this? Todd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Integrating Interbase.so and PHP
Todd Cary wrote: I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP. Has anyone had success doing this? Try asking on the firebird-php list http://groups.yahoo.com/group/firebird-php There are various notes on different distributions in the archive, a starting point would be which distribution, and PHP4 or 5 -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] values getting blown away
I have a page set up with a sql query that receives
$_POST values (from pervious page) to perpare records
for update.
Two of the values are via $HTTP_POST_VARS, 1 is via
$_SESSION.
Goes something like this:
// begin Recordset
$colname__rsLPINDS = '-1';
if (isset($HTTP_POST_VARS['PN'])) {
$colname__rsLPINDS = $HTTP_POST_VARS['PN'];
}
$colname2__rsLPINDS = '-1';
if (isset($HTTP_SESSION_VARS['KT_id'])) {
$colname2__rsLPINDS = $HTTP_SESSION_VARS['KT_id'];
}
$colname3__rsLPINDS = '-1';
if (isset($HTTP_POST_VARS['code'])) {
$colname3__rsLPINDS = $HTTP_POST_VARS['code'];
}
$query_rsLPINDS = ...[SNIP]
WHERE LurkerProfiles.ProfileID = %s and LID = %s
and hash = '%s ',
$colname__rsLPINDS,$colname2__rsLPINDS,$colname3__rsLPINDS);
...[SNIP].
$totalRows_rsLPINDS = $rsLPINDS-RecordCount();
// end Recordset
WHen the page loads, I'm printing out all the values
to make sure they exit-
PN, KT_id and code all are correct. Also I print out
$totalRows_rsLPINDS , which in this case gives me a
value of 3 (total number of records meeting criteria)
Now I've taken the same recordset and parameters and
put them on another page , using a form with post
/hidden values to pass the same values over. I've also
tried posting to the same page. The weird thing is
code and $totalRows_rsLPINDS come back empty. PN
remains intact. Totally mind boggling.
Stuart
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL db sync
Hi, I need some help. Does anyone know a good tool to synchronize MySQL databases? Thanks in advance for your help Regards, Kris
Re: [PHP-DB] Integrating Interbase.so and PHP
Todd Cary wrote: I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP. Has anyone had success doing this? Todd A quick peek at the list archives (search term=interbase.so) revealed this: http://marc.theaimsgroup.com/?l=php-dbm=107118069802473w=4 Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL db sync
sqlyog is a great tool bastien From: Kris Geens [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] MySQL db sync Date: Sat, 15 Jan 2005 14:06:50 +0100 Hi, I need some help. Does anyone know a good tool to synchronize MySQL databases? Thanks in advance for your help Regards, Kris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Adding Up MySQL Results
I hope someone can help with this frustratingly simple (I assume!) question I have. I run this mysql query: select sum(quantity)*price,price from sale where dvd_id=1 group by price; I get this result: sum(quantity)*price price 450.00 15.00 29.99 29.99 I want to display the sum of the values in the first column (450.00+29.99), but I cannot figure out how to do this! Can someone clue me in? Thanks a million, Nathan -- Nathan Mealey Website Manager Administrative Director Cycle-Smart, Inc. P.O. Box 1482 Northampton, MA 01061-1482 [EMAIL PROTECTED] (413) 210-7984 (512) 681-7043 Fax -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
