hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : MYSQL ROW CHANGE
Reply

Forum Jump

MYSQL ROW CHANGE

Reply Post New Thread In Programming Discussion Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 04-22-2008, 05:37 PM
healthy healthy is offline
WHT Addict
 
Join Date: Jul 2006
Posts: 145

MYSQL ROW CHANGE


a customer sent me this :
in the notepad it appears as just a long row evry row change is a small square I imagine the note pad can not understand it is a row change, whoch is aa new record
but amazingly, hwen I just post that here it actually recognized it as a row change!!!

see it ist below here:

20080226,TT,398.3,,,398.3
20080229,TT,66.7,54.54,,121.24
20080301,TT,1528.28,95.45,,1623.73
20080302,TT,399.96,,,399.96
20080303,TT,259.09,45.45,,304.54
20080407,TT,318.18,118.18,,436.36
20080408,TT,528.45,180.01,,708.46




how can I make php and my sql ti understand that it is a change in the row, a new record if note pad doesnt reckognize it?

althoug this board did recognized it!!!



Sponsored Links
  #2  
Old 04-22-2008, 05:49 PM
Codebird Codebird is offline
Aspiring Evangelist
 
Join Date: Dec 2007
Location: Lebanon
Posts: 413
php doesn't depend on notepad!! it will recognize every new line

try it

PHP Code:
 $lines=file("somefile where these lines are");
 foreach(
$lines as $line){
      echo 
$line."<br />";
 } 

__________________
Hicham

  #3  
Old 04-22-2008, 06:02 PM
larwilliams larwilliams is offline
Web Hosting Master
 
Join Date: Jan 2008
Location: St. John's, NL
Posts: 2,052
Quote:
Originally Posted by Codebird View Post
php doesn't depend on notepad!! it will recognize every new line

try it

PHP Code:
 $lines=file("somefile where these lines are");
 foreach(
$lines as $line){
      echo 
$line."<br />";
 } 
The small square the OP is referring to, is likely an artifact of a text file downloaded in binary format (FTP i mean). The example appears to be a CSV. I would assume MySQL simple handles this and does the inserts.

__________________
Cpanel/WHM PHP Perl Ruby Full Time Support
LCWSoft - Canada web hosting (based in Newfoundland) since 2007
Servers based in the US and Canada (Uptime Report)

Sponsored Links
Reply

Related posts from TheWhir.com
Title Type Date Posted
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2013-08-19 12:25:00
Disruption and Opportunities in this New Era, with Tod Nielsen Web Hosting News 2013-02-05 15:43:57
Navigating Your Business Through Change with Elliot Noss - HostingCon 2012 Web Hosting News 2012-07-17 09:51:18


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?