Importing CSV data using PHP/MySQL -


I am having some problem trying to import data from CSV and there are some questions about it that I have yet to You have not succeeded in solving.

To help keep things in perspective, first here is my code (to delete it a little, count cd and db connection): 

  & lt; Body & gt; & Lt; Div id = "container" & gt; & Lt; Div id = "form" & gt; & Lt ;? Php $ deleterecords = "Trunket Table Tabelmem"; // Your current record mysql_query ($ deleterecords) table blank; // upload file if (isset ($ _ POST ['submit']) {if_uploaded_file ($ _ files ['filename'] ['tmp_name'])) {echo "& lt; h1 & gt;" . "File" $ _FILES ['filename'] ['name']. "Successfully uploaded." . "& Lt; / h1>"; Echo "& lt; h2 & gt; Content displayed: "; Readfile ($ _ files ['file name'] ['tmp_name']); } // database to upload import file $ handle = fopen ($ _ FILES ['filename'] ['tmp_name'], "r"); ($ $ Data = fgetcsv ($ handle, 1000, ","))! == FALSE {$ import = "INSERT to import (text, number) value ('$ data [0]', '$ data [1]')"; Mysql_query ($ import) or die (mysql_error ()); } Fclose ($ handle); Print "imported"; // View upload form} and {print "browse to file and upload  & gt; \ n"; Upload new CSV by clicking on; Print "& lt; form enctype = 'multipart / form-data' action = 'upload.php' method = 'post' & gt;"; Print "file name to import: 
" \ n "; Print "& lt; input size = '50' type = 'file' name = 'filename' & gt; & lt; br / & gt; \ n"; Print "& lt; input type = 'submit' name = 'submit' value = 'upload'> gt; & lt; / form & gt;"; }? & Gt; & Lt; / Div & gt; & Lt; / Div & gt; & Lt; / Body & gt;   
 This is basically an example optimization that I have found in many different ways after many efforts.  
 There are two column data of my CSV, the first text and the second integer are two columns in the table in the database, the first "text" and the second "number"  
 then my The questions are:  
     
  1.  The uploaded text is being displayed as 0 in each field and I'm not sure why  
  2.  I ended up in "" I read about reading the data that happens, if this happens, then how can I What do i do  
  3.  How can I ignore CSV's first x lines for headers etc?  
  4.  Is the data format changed in this process or is it ready for me to use in a graph? As decimal in decimal would be placed in database once?   
     I think everything is included, thanks in advance for any help!  
     Edit:  
     Just tested 10,000 errors and got an error:  
     "Fatal error: Maximum execution time of 30 seconds" / P> 
     Have any thoughts over?  
     
     I asked the same question on the second day Answer:  
     MySQL has a feature  LOAD DATA INFILE , which allows it to import a CSV file directly into a single SQL query, without it We need to be processed in the loop.  
     Simple example:  
        
     It's as simple.  
     There is no end, no fuss and much more   faster than parsing it in PHP.  
     MySQL manual page here:  
     Hopes

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more