mabog

Found the problem. Data (where those 0As are) is a tab-delimited text file created by excel. That line feed is confusing file handling when trying to get data one row at a time with fgets(). It acts like 0A is a new row.. Tried to add ini_set('auto_detect_line_endings', true); before fopen(), but no change. So those characters would be needed to remove BEFORE the file is opened. And that, I think, is impossible since files might be quite big.. Going through the file one character at a time for 0A's, is slow... So it's easier to ask users to remove word warp (that, i belive, is creating 0As) from the excel file before uploading it to my page. No can do.

Hello. Trying to get rid a line feed which is coming from a excel cell which has Text and a line feed after that word. After the excel file has been saved-as tab-delimited, that text transforms to this: "Text" That line feed is between t and the last double-quote. Hex viewer shows: 22 54 65 78 74 0A 22 so it must be that 0A. I have tried with trim() and with str_replace("\x0A","",$data) but nothing (like \r or \n) works. How do I get rid of that hidden character? Is that \x0A correct?

But I don't want to assign width to the middle <td>. The first and last <td> contains always short text, but the middle one just sometimes. I want the middle one to disappear when it's empty (= looks like there's only two <td>). Has anyone created a site where browsing with explorer is totally prevented.....? I could do that. Would give more time to actually improve the site..........

I totally agree! But I can't prevent other people to browse my site with it... I like to design websites, but trying to make everything work correctly on explorer is very very frustrating Anyway, I solved the alignment problem (page's other code was affecting it) but the widths are still not correct. Here'a a sample page Which is looking like this to me: I need those smaller tables to be 30 & 50 pixels wide but the center one to be a "flexible" one. Does anyone have any clue how to fix it? Maybe it's just not possible....

Why the "R w50" text is not on the right?? How can I fix it? Also the first "w30" has not correct width.........? <table border=1 cellpadding=5 cellspacing=0> <tr> <td style=\"width:30px;\">w30</td> <td>n</td> <td style=\"text-align:right; width:50px;\">R w50</td> </tr> <tr> <td colspan=3> <table border=1 cellpadding=5 cellspacing=0 bordercolor=red width=100%> <td style=\"width:30px;\">w30</td> <td>n n n n n n n n n n n n n n n n n n n</td> <td style=\"text-align:right; width:50px;\">R w50</td> </table> </td> </tr> </table>

Problem solved. The server hosting company had implemented somekind of additional cache... Clearly wasn't working like it should so they removed it. Thanks for the help.

Ok, the problem is seen in this simple code: <? // thispage2.php echo date('d.m.Y H:m:s'); echo "<br><a href=\"thispage2.php\">Reload</a>"; ?> I think the date should be updated every time the 'Reload' link is clicked? Well, it's not.. If I keep clicking the link continuously, the date is updated in every 19 seconds sharp! This has little to do with PHP anymore, but maybe someone could have an idea what causes this glich?

Sometimes nothing happens (button stays, number is the same) and sometimes the number is increased by one. But the mysql table is updated EVERY time. If I click "refresh page" AFTER nothing was happened, the number is increased by one. I've made more investigation and: That example page is working on the Explorer! And with Chrome. But not with Firefox! (Firefox now updated to 4.01) With Explorer and Chrome the number is increasing every time I click the button. On my site, the problem is happening with every browser! Ok, that example code is not 100% equally constructed like a page on my site, but it should be close enough. BUT it is strange thing also that my site's users haven't (yet..) reported any problems about this... so could this be happening in my end only? I've tried with firefox, explorer, chorme, with three different computers (xp, vista). But the problem stays.

No errors

You're right, my explanation was a little vague, sorry. This shows my problem. It should echo $num +1 every time the button is clicked, but it's not. $num will increase ONLY when "refresh page" from the browser is clicked. <? /* CREATE TABLE `numbers` ( `num` TINYINT( 3 ) DEFAULT '0' ); INSERT INTO `numbers` ( `num` ) VALUES ( '1' ); */ $db = mysql_connect("localhost", "username", "password"]) or die(mysql_error($db)); $sql_vars["db"] = $db; mysql_select_db("dbname"], $db) or die(mysql_error($db)); switch($action) { case "increase": mysql_query("update numbers set num=".(1+$_POST["newnum"])); $url="thispage.php"; header("Location: ".$url); die(); break; } $num=mysql_result(mysql_query("select num from numbers"),0); echo $num; echo "<form action=\"thispage.php?action=increase\" method=\"POST\">"; echo "<input type=\"submit\" value=\"increase\">"; echo "<input name=\"newnum\" value=\"".$num."\" type=\"hidden\">"; echo "</form>"; ?>

Hello! My server hosting company has updated PHP from 4 to 5 version, and now the header function doesn't work very well anymore. It does load the new page everytime, like it should, but the data is not always refreshed. Not until I click "reload current page" from the browser. I'm using Firefox 3.6.3. Here's the code which worked just fine few days ago: $url="thepage.php"; header("Location: ".$url); die(); I tried something like this, but that doesn't work either: $url="thepage.php"; header("Refresh: 0; url=".$url); die(); This is really nasty problem... How can I fix it?

Thanks!

Preg matching is killing me... $string1="Here: http://www.example.com"; $string2="Here: http://www.example.com check that."; How can I match that address only in both cases? I have this: preg_match_all("/[hH][tT][tT][pP]\:\/\/.*\s/",$string,$matches); print_r($matches); Which matches only string 2 AND with a space at the end. And this: preg_match_all("/[hH][tT][tT][pP]\:\/\/.*.(\s|\b)/",$string,$matches); print_r($matches); Which matchs both BUT with "check that" text at the end! Is the trick to match that link as one word? How?

Can get this to work.. please help. $string="Click me";$splitted=preg_split("/\/",$string);print_r($splitted); preg is WITHOUT http:// forum added it just url= I need to extract this: "Click me"

I need to search short words, like "4 x 4". Actually it's should act like one word, five letters long. But cannot find the right syntax.. Is it even possible? Query is now like this: SELECT * FROM car WHERE MATCH ( car.name ) AGAINST ( "\"4 x 4\"" IN BOOLEAN MODE ) CREATE TABLE `car` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '<empty>', PRIMARY KEY (`id`), FULLTEXT KEY `name` (`name`) ) ; INSERT INTO `car` (`id`, `name`) VALUES (1, '4 x 4');

I got answered to this from elsewhere. SELECT user, color, piece, SUM(quantity) AS quantity FROM ( SELECT test1_loose.user,test1_loose.color, test1_loose.piece,test1_loose.quantity FROM test1_loose UNION SELECT test2_boxes.own_user,test3_boxinv.color, test3_boxinv.piece, (test3_boxinv.quantity * test2_boxes.own_quantity) AS quantity FROM test2_boxes,test3_boxinv WHERE test2_boxes.own_item = test3_boxinv.item ) as ss GROUP BY user, color, piece; Thanks anyway.

7.5 sec function checkRemoteFile($url) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); // don't download content curl_setopt($ch, CURLOPT_NOBODY, 1); curl_setopt($ch, CURLOPT_FAILONERROR, 1); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); if(curl_exec($ch)!==FALSE) { return true; } else { return false; } } http://hungred.com/how-to/php-check-remote-email-url-image-link-exist/

What is the fastest way to check if external file (image) exists? I have tried these, but both are quite slow. if (@fclose(@fopen("http://www.example.com/image.jpg", "r"))) { if (@GetImageSize("http://www.example.com/image.jpg")) { In my page, there is 10 small external images. fopen took 15 sec to check and getimagesize 16.5 sec.

OK, I read the quidelines now.. MySQL Server version: 4.1.25 Create tables & inserts: CREATE TABLE `test1_loose` ( `id` int(11) NOT NULL auto_increment, `piece` varchar(255) default NULL, `user` int(11) default NULL, `quantity` int(11) default NULL, `color` int(11) default NULL, `log` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; # # Dumping data for table `test1_loose` # INSERT INTO `test1_loose` VALUES (1, 'piece13', 9, 9100, 99, NULL); INSERT INTO `test1_loose` VALUES (2, 'piece19', 9, 9200, 66, NULL); # -------------------------------------------------------- # # Table structure for table `test2_boxes` # CREATE TABLE `test2_boxes` ( `id` int(11) NOT NULL auto_increment, `own_user` int(11) default NULL, `own_item` varchar(255) default NULL, `own_quantity` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; # # Dumping data for table `test2_boxes` # INSERT INTO `test2_boxes` VALUES (1, 9, 'box1', 1); INSERT INTO `test2_boxes` VALUES (2, 9, 'box2', 1); INSERT INTO `test2_boxes` VALUES (3, 4, 'box4', 3); # -------------------------------------------------------- # # Table structure for table `test3_boxinv` # CREATE TABLE `test3_boxinv` ( `id` int(11) NOT NULL auto_increment, `item` varchar(255) default NULL, `piece` varchar(255) default NULL, `color` int(11) default NULL, `quantity` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; # # Dumping data for table `test3_boxinv` # INSERT INTO `test3_boxinv` VALUES (1, 'box1', 'piece13', 99, 100); INSERT INTO `test3_boxinv` VALUES (2, 'box1', 'piece14', 99, 200); INSERT INTO `test3_boxinv` VALUES (3, 'box1', 'piece15', 22, 300); INSERT INTO `test3_boxinv` VALUES (4, 'box2', 'piece13', 99, 2100); INSERT INTO `test3_boxinv` VALUES (5, 'box2', 'piece16', 44, 2200); INSERT INTO `test3_boxinv` VALUES (6, 'box3', 'piece14', 88, 3100); INSERT INTO `test3_boxinv` VALUES (7, 'box4', 'piece33', 99, 4100); INSERT INTO `test3_boxinv` VALUES (8, 'box4', 'piece13', 77, 4200);

Please help me with this joining, I don't get it. I have tried something like this: SELECT * FROM (SELECT test1_loose.user,test1_loose.color,test1_loose.piece,test1_loose.quantity FROM test1_loose UNION SELECT test2_boxes.own_user,test3_boxinv.color,test3_boxinv.piece,(test3_boxinv.quantity * test2_boxes.own_quantity) AS quantity FROM test2_boxes LEFT JOIN test3_boxinv ON test2_boxes.own_item = test3_boxinv.item WHERE test2_boxes.own_item = test3_boxinv.item ) as ss But nothing happens. It's very important that query joins all items which have same user, color and item in second select.

I'm getting there: SELECT * FROM ( SELECT test1_loose.user,test1_loose.color,test1_loose.piece,test1_loose.quantity FROM test1_loose UNION SELECT test2_boxes.own_user,test3_boxinv.color,test3_boxinv.piece,(test3_boxinv.quantity * test2_boxes.own_quantity) AS quantity FROM test2_boxes,test3_boxinv WHERE test2_boxes.own_item = test3_boxinv.item ) as ss +------+-------+---------+----------+ | user | color | piece | quantity | +------+-------+---------+----------+ | 9 | 99 | piece13 | 9100 | | 9 | 66 | piece19 | 9200 | | 9 | 99 | piece13 | 100 | | 9 | 99 | piece14 | 200 | | 9 | 22 | piece15 | 300 | | 9 | 99 | piece13 | 2100 | | 9 | 44 | piece16 | 2200 | | 4 | 99 | piece33 | 12300 | | 4 | 77 | piece13 | 12600 | +------+-------+---------+----------+ But still needs some joining?

OK, first example is not possible - one total quantity is enough. user piece color total_quantity 9 piece13 99 11300 (9100 loose + 100 from box1 + 2100 from box2) 9 piece19 66 9200 9 piece14 99 200 9 piece15 22 300 9 piece16 44 2200 4 piece33 99 12300 (user 4 has three box4, so it's 3x 4100) 4 piece13 77 12600 (user 4 has three box4, so it's 3x 4200)

Need help with my query. I think the answer is union and/or join but how? Example tables: mysql> select * from test1_loose; +----+---------+------+----------+-------+ | id | piece | user | quantity | color | +----+---------+------+----------+-------+ | 1 | piece13 | 9 | 9100 | 99 | | 2 | piece19 | 9 | 9200 | 66 | +----+---------+------+----------+-------+ mysql> select * from test2_boxes; +----+----------+----------+--------------+ | id | own_user | own_item | own_quantity | +----+----------+----------+--------------+ | 1 | 9 | box1 | 1 | | 2 | 9 | box2 | 1 | | 3 | 4 | box4 | 3 | +----+----------+----------+--------------+ mysql> select * from test3_boxinv; +----+------+---------+-------+----------+ | id | item | piece | color | quantity | +----+------+---------+-------+----------+ | 1 | box1 | piece13 | 99 | 100 | | 2 | box1 | piece14 | 99 | 200 | | 3 | box1 | piece15 | 22 | 300 | | 4 | box2 | piece13 | 99 | 2100 | | 5 | box2 | piece16 | 44 | 2200 | | 6 | box3 | piece14 | 88 | 3100 | | 7 | box4 | piece33 | 99 | 4100 | | 8 | box4 | piece13 | 77 | 4200 | +----+------+---------+-------+----------+ Result should look like this: user piece color loose_quantity box_quantity 9 piece13 99 9100 2200 (100 from box1) + (2100 from box2) 9 piece19 66 9200 9 piece14 99 200 9 piece15 22 300 9 piece16 44 2200 4 piece33 99 12300 (user 4 has three box4, so it's 3x 4100) 4 piece13 77 12600 (user 4 has three box4, so it's 3x 4200) Explanation: Users can have loose pieces or pieces in boxes. If piece, color and user is equal (loose or boxed), data should be combined. test1_loose table is for loose pieces, test2_boxes table defines what boxes users have (and quantity of boxes) and test3_boxinv is the table for pieces in boxes. This query is what I have now, but it doesn't show user 4's data and user 9's data is doubled. SELECT test1_loose.user, test1_loose.piece, test1_loose.color, test3_boxinv.piece, test3_boxinv.color, test1_loose.quantity AS loose_quantity, test3_boxinv.quantity AS box_quantity FROM test1_loose,test3_boxinv,test2_boxes LEFT JOIN (test3_boxinv t3) ON (t3.piece = test1_loose.piece AND test1_loose.color = t3.color) WHERE test2_boxes.own_user = test1_loose.user AND test2_boxes.own_item = test3_boxinv.item

Which is incorrect because there was more than 1 row. But I tested that query again, with / without group_concat: Without: Showing rows 0 - 7 (8 total, Query took 0.0218 sec), 8 rows visible With: Showing rows 0 - 0 (1 total, Query took 0.0220 sec), 8 rows visible ??

OK. Can't remember anymore was there 3 or 4 or 5 rows but at least there was few. But still 'showing rows 0-0' ...