Re: [PHP] text imports
http://www.php.net/manual/en/function.chop.php Returns the argument string without trailing whitespace, including newlines Wagner Tomy Web Developer Editus S.A. - Original Message - From: Karl Phillipson [EMAIL PROTECTED] To: 'Alexander Wagner' [EMAIL PROTECTED]; MindHunter [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 12:53 PM Subject: [PHP] text imports Hi, I have been given a (notepad generated) text file which contains a list of countries in a format such as: United Kingdom, United States, Blah, Blah, Blah, I have imported the data into a countries table in a mySQL database using the excellent 'mysqlfront' prog. No probs on the import itself except for some pesky pipes that I believe to be carriage returns. Anyone know a way I can strip these out so I have nice clean data. Ta in adavance. Karl Saffron Hill Ventures 67 Clerkenwell Road London EC1R 5BL Saffron Hill: 0207 693 8300 -- PHP General 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] PHP inside code problem
try this: if (!($html_support)) { $user_message = htmlspecialchars(stripslashes($user_message)); } Wagner Tomy Web Developer Editus S.A. - Original Message - From: Nick K. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 12:11 PM Subject: [PHP] PHP inside code problem hi there - if ($act = add) //Add the message... { if (!empty($user_name) !empty($user_ip) !empty($user_message) !empty($user_sex)) { if (!($html_support)) { $user_message = htmlspecialchars($user_message); } $user_message = ereg_replace(\n,br,$user_message); $userinfo = $user_name!¡Ó!¡Ó$user_sex!¡Ó!¡Ó$user_ip!¡Ó!¡Ó$user_message!¡Ó!¡Ó$user_date.\n; $fp = fopen($filename,'a'); flock($fp,2); fwrite($fp, $userinfo); flock($fp,1); fclose($fp); header(Location: index.php); setcookie(cuser,$user_name,time()+(3600*24*365),/,$SERVER_NAME); exit; } } - The code above is what I use for processing messages Everytime when I'm trying to use the function, htmlspecialchars(), it'll replace with quot; . After that, I save the data and print out again, the result will add \ after the data... ( I don't want the extra \) There is an example. When I try to type in ^^ to be my new message, it suppose to show the same thing. However, in the saved data, it shows !¡Ó!¡Ó^^\quot; (!¡Ó!¡Ó is what I use to different from different filez) I don't want the extra \ however, I tried the way in below: I use $user_message = eregi_replace(,lt;,$user_message); $user_message = eregi_replace(,gt;,$user_message); instead of the original one which is $user_message = htmlspecialchars($user_message); however, when I check the saved file, it still have and extra \ before the characters . god damn it I run this code in windows98SR2, maybe it's micro$oft's problem, is it? plz help me.thx dudes nick -- PHP General 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] text imports
ah k, yes that's the way to do it in SQL ;p Tomy Wagner Web Developer Editus S.A. - Original Message - From: Karl Phillipson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 1:08 PM Subject: RE: [PHP] text imports Yup, thanks Wagner. I can do this within PHP itself using trim or chop, I was hoping for a snippet of SQL code that would do it from the command line. This is what have done: LOAD DATA LOCAL INFILE 'C:\MYDIR\countries.txt' INTO TABLE DBNAME.COUNTRY LINES TERMINATED BY ',' (COUNTRY_NAME) == Karl Phillipson PHP SQL Programmer Saffron Hill Ventures 67 Clerkenwell Road London EC1R 5BL Saffron Hill: 0207 693 8300 Direct Line: 0207 693 8318 -Original Message- From: Wagner Tomy [mailto:[EMAIL PROTECTED]] Sent: 07 August 2001 12:00 To: Karl Phillipson; 'Alexander Wagner'; MindHunter; [EMAIL PROTECTED] Subject: Re: [PHP] text imports http://www.php.net/manual/en/function.chop.php Returns the argument string without trailing whitespace, including newlines Wagner Tomy Web Developer Editus S.A. - Original Message - From: Karl Phillipson [EMAIL PROTECTED] To: 'Alexander Wagner' [EMAIL PROTECTED]; MindHunter [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 12:53 PM Subject: [PHP] text imports Hi, I have been given a (notepad generated) text file which contains a list of countries in a format such as: United Kingdom, United States, Blah, Blah, Blah, I have imported the data into a countries table in a mySQL database using the excellent 'mysqlfront' prog. No probs on the import itself except for some pesky pipes that I believe to be carriage returns. Anyone know a way I can strip these out so I have nice clean data. Ta in adavance. Karl Saffron Hill Ventures 67 Clerkenwell Road London EC1R 5BL Saffron Hill: 0207 693 8300 -- PHP General 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 General 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] text imports
RE: [PHP] text importstry this: LOAD DATA LOCAL INFILE 'C:\MYDIR\countries.txt' INTO TABLE DBNAME.COUNTRY LINES TERMINATED BY ',\n' (COUNTRY_NAME) or if it does not work, simply drop the commas and use the newline character as separator ? Tomy Wagner Web Developer Editus S.A. - Original Message - From: Karl Phillipson To: 'Wagner Tomy' ; [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 1:16 PM Subject: RE: [PHP] text imports So if this is the way to do it in SQL, is there a way to get rid of the pipe linefeeds using SQL too? If not I s'pose the solution is to run a php 'trim' script, grab the data, perform the modifications and then re-insert the data back into the table Bit long winded but if that's the only way? == Karl Phillipson PHP SQL Programmer Saffron Hill Ventures 67 Clerkenwell Road London EC1R 5BL Saffron Hill: 0207 693 8300 Direct Line: 0207 693 8318 -Original Message- From: Wagner Tomy [mailto:[EMAIL PROTECTED]] Sent: 07 August 2001 12:06 To: Karl Phillipson; [EMAIL PROTECTED] Subject: Re: [PHP] text imports ah k, yes that's the way to do it in SQL ;p Tomy Wagner Web Developer Editus S.A. - Original Message - From: Karl Phillipson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 1:08 PM Subject: RE: [PHP] text imports Yup, thanks Wagner. I can do this within PHP itself using trim or chop, I was hoping for a snippet of SQL code that would do it from the command line. This is what have done: LOAD DATA LOCAL INFILE 'C:\MYDIR\countries.txt' INTO TABLE DBNAME.COUNTRY LINES TERMINATED BY ',' (COUNTRY_NAME) == Karl Phillipson PHP SQL Programmer Saffron Hill Ventures 67 Clerkenwell Road London EC1R 5BL Saffron Hill: 0207 693 8300 Direct Line: 0207 693 8318 -Original Message- From: Wagner Tomy [mailto:[EMAIL PROTECTED]] Sent: 07 August 2001 12:00 To: Karl Phillipson; 'Alexander Wagner'; MindHunter; [EMAIL PROTECTED] Subject: Re: [PHP] text imports http://www.php.net/manual/en/function.chop.php Returns the argument string without trailing whitespace, including newlines Wagner Tomy Web Developer Editus S.A. - Original Message - From: Karl Phillipson [EMAIL PROTECTED] To: 'Alexander Wagner' [EMAIL PROTECTED]; MindHunter [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 12:53 PM Subject: [PHP] text imports Hi, I have been given a (notepad generated) text file which contains a list of countries in a format such as: United Kingdom, United States, Blah, Blah, Blah, I have imported the data into a countries table in a mySQL database using the excellent 'mysqlfront' prog. No probs on the import itself except for some pesky pipes that I believe to be carriage returns. Anyone know a way I can strip these out so I have nice clean data. Ta in adavance. Karl Saffron Hill Ventures 67 Clerkenwell Road London EC1R 5BL Saffron Hill: 0207 693 8300 -- PHP General 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 General 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] if(!$submit)
Fair enough, so then I add if (isset(!$submit)) and I then get an error; try if(!isset($submit)) instead Tomy Wagner Web Developer Editus S.A. - Original Message - From: Tarrant Costelloe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 4:47 PM Subject: [PHP] if(!$submit) When using if (!$submit) I get an error saying: Warning: Undefined variable: submit in C:\Inetpub\webpub\default.php on line 1 Fair enough, so then I add if (isset(!$submit)) and I then get an error; Parse error: parse error, expecting `T_VARIABLE' or `'$'' Could someone please tell me the more than likely simple sollution. Thanks Taz -- PHP General 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 General 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] execution time
http://www.php.net/manual/en/function.set-time-limit.php the set_time_limit allows you to reset the max execution time.. the manual says: When called, set_time_limit() restarts the timeout counter from zero. In other words, if the timeout is the default 30 seconds, and 25 seconds into script execution a call such as set_time_limit(20) is made, the script will run for a total of 45 seconds before timing out. Wagner Tomy Editus S.A. - Original Message - From: Pétur Björn Thorsteinsson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 2:03 PM Subject: [PHP] execution time I have a slight problem and was wondering if anyone could help. I have a php script that runs every 30 minutes. It takes the contents of a directory (which is constantly being updated) and dumps them into a mysql database. Recently this directory has become increasingly large and the php script only updates a portion of it before it stops execution. To run the php script I use a lynx command in a crontab. I'm running suse linux and apache on both machines (the machine containting the directory and the other machine containing the database). I've tried changing the max execution time in php.ini file but it appears to have no affect. When I took the php script and divided it into portions and ran them one at a time it worked (except for one portion of the script). the execution time of the script doesn't matter to me, I just need it to run. When I run the php script through a browser, and the script doesn't complete, I get a 'page cannot be displayed' message (while I am expecting a 'fatal error, exceeded max execution time' error message). Maybe it could be fixed by using something other than lynx to run the php script internally, but I don't know of any alternatives. hope someone can help.. -petur -- PHP General 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 General 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] 2D array
$my2darray = Array(); while(list($myname, $myphone, $myemail) = mysql_fetch_row($result)) { $my2darray[$myname] = array($myphone, $myemail); } Wagner Tomy Editus S.A. - Original Message - From: AJDIN BRANDIC [EMAIL PROTECTED] To: Wagner Tomy [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 2:34 PM Subject: Re: [PHP] 2D array Wag, I do not wish to push whole of the row into an array. Also I need the id of the parent array to be $myname; Ajdin On Fri, 27 Jul 2001, Wagner Tomy wrote: $my2darray = Array(); while($row = mysql_fetch_row($result)) { array_push($my2darray, $row); } OR: for($i = 0; $i mysql_num_rows($result); $i++) { $row = mysql_fetch_row($result); $my2darray[$i] = $row; } Wagner Tomy Editus S.A. - Original Message - From: AJDIN BRANDIC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 2:18 PM Subject: [PHP] 2D array Hi I have been trying to do this for hours now. I have a while loop (rows from mysql db) and on each pass I want to pussh a new element into a 2D array, bot always end up with the last element of the while loop. So: table mytable myname myphone myemail john 254688 [EMAIL PROTECTED] tom789787 [EMAIL PROTECTED] $myquery=select * from mytable; while ($myrow = mysql_fetch_array($myrows)) { .. .. . . . $my2darray = array ($myname = array ($myphone,$myemail)); } $mycount=count(my2darray); // returns 1 while (list($key,$value) = each ($my2darray)) { echo$key,; echo$value[0]; echo$value[1]br; // retuns only one row with tom,798779,[EMAIL PROTECTED] } How do I push multiple entries into a 2d array? I tried $my2darray[]=array(... Regards Ajdin -- PHP General 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 General 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 General 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 General 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] Grabbing data up to \n
$data = file(myfile); $data = array of the lines from myfile ( they still contain the newline character ) Wagner Tomy Editus Luxembourg S.A. - Original Message - From: Jeff Lewis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 5:14 PM Subject: [PHP] Grabbing data up to \n I am grabbing lines of a file using: $buffer = fgets($fd, 4096); How can I grab the line up to \n or does this do it? Like if the line is only a few characters, it will only grab up to \n? And if the line up to the \n is a huge message will I still be able to grab all of it with the 4096? Jeff -- PHP General 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]MySQL error, what's wrong here..
try this: $query = SELECT songname FROM mp3 WHERE sgid = \$id\; (or a little cleaner: $query = sprintf(SELECT songname FROM mp3 WHERE sgid = \%d\, $id); ) instead of: $query = SELECT songname FROM mp3 WHERE sgid = .$id; - Original Message - From: James Holloway [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 11:05 AM Subject: Re: [PHP]MySQL error, what's wrong here.. Hi Chris, If you're using MySQL 3.23+, you might want to consider using something like: SELECT songname FROM mp3 ORDER BY RAND() LIMIT 1 Not that this answers your original problem, but it seems to make more sense than manually coding a random number (which is, perhaps, impractical especiallyif you plan to add / take away entries to your table on a regular basis). James Chris Cocuzzo [EMAIL PROTECTED] wrote in message 014d01c113ca$dd3bf460$[EMAIL PROTECTED]">news:014d01c113ca$dd3bf460$[EMAIL PROTECTED]... ?php $id = rand(1,2); $query = SELECT songname FROM mp3 WHERE sgid = .$id; $result = mysql_query($query,$connection); $mp3d = mysql_fetch_array($result); ? the server is telling me line 43(which starts with $mp3d) is not a valid mysql result resource. what am i doing wrong?? chris -- PHP General 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 General 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]