Mysql update from text file

To see that a BLOB object actually contains an image and text, you need to do the following. The images above show that we really created BLOB objects that contain an image and text. Row 3 had the data 'Test Test Test.

Use BlazeMeter if you want to scale your test, collaborate on the test and results, share reports with managers and improve agility.

See the original article here. How do I import this text file I created so I dont have to change each row at a time? Imagine this could take me a month or so Hello, in what form do you need to enter them? I really don't understand It seems like you need a different table for the pkgoptions, I really don't know how you want the different packages to be entered Hello, thanks, I think I have a better understanding now of what you want.

Do you want to replace a Pkg Also, there is no way to use phpmyadmin for it. I can update each item at a time but as you have known, there are about items. The text file is written down as I had shown earlier Hello Shaffer, Thanks again!

I appreciate your time Im a new to php as well and can only write basic basic php. A complete script and a instruction would be nice. I was hoping to get this done in phpmyadmin but I guess a PHP script would do this job easily as you suggested here. Great stuff Shaffer, Thank you very much again.

Now, I am looping through the file "pkgoptions. In-order to loop through an array, I used the foreach loop, eventhough the for loop can do it as well, just messier and with less options. The following line uses the function explode to split a string into an array, every time it finds a certain character.

This time it was a comma. The function literally explodes the string. Finally, the mysql query! The sign before it, is used to have the function either return true on success or false on failure, rather an error, which the user can see no good if it's public. The query updates your table, and replaces each pkgoption with it's code. Because this is a loop, each pkgoption will get it's turn. Now, you can have as many pkgoptions as youd like. Explanation will come in a bit..

Thanks very much for your explaination here. Great tutorial, I deffinitely learn something about your code. However, Im still missing something, how exactly I would run this script? Im sorry Shaff but Im kind of lost and I dont know where to start.

A sample implementation can be found here. How can I get the data values from a read line? You can use string. Split to split on the pipe.

Because you have two of them to split values, you can use StringSplitOptions. How can I determine to Add or Update? Query the database with the ID from the line. If there's no result it's a new record, otherwise it's an existing record. Examples of database usage can be found all over the place , here for example.

Hint: check if the list contains the value. The same could have been a lot easier if you could have manged to get CSV file. I've attached the text file that I used for this project click to view. I hope following helps you, if it does, mark it as an answer. You can also download the project by : clicking here.

Each line if I call DB it will be very slow. If I am correct can you please send alternative. If you get your question answered, please come back and Mark As Answer.