Check in phpMyAdmin for a query box see image at: .

In your case a query is not pulling data out of the database but could be running any number of insert or update statements as generated by your other system.

let us know if this doesn't quite answer your questions

    Hi Sarahk, I have that yes. But I dont' know how to call in the database I have in txt. I was informed from my host that I cannot use microsoft access with this.

      nope, cant you msacces, gotta use MySQL :p i know nothing at all of databases or phpmyadmin, and even I knew that ,sheesh, j/k
      😉

        I just loaded a 1.5 M txt file into my database. There are a few ways you can do it. I haven't tried PhpMyAdmin, but you can probably do it from there. I did it from a little database administration tool I made myself.

        You also need to give your textfile the same name as your table

        If you have file permission, this command is supposed to work referencing your virtual path:
        load data infile '/directory/filename.txt' into table filename;

        If you don't have file permission, you need the local path to the server. You might be able to get it through PhpMyAdmin. I got my local path using phpinfo()
        This is the syntax that worked for me:

        load data local infile '/home/sites/siteno/users/me/web/directory/files.txt' into table files;

        Editing now: I just read your question again, but I guess I don't undersant it. When you said 'text form' I thought you said 'text file', which means this information I gave you is worthless, but I'll leave it here just in case I am misunderstanding what I was misunderstanding 🙂

          Hi.

          You CAN get Access and MySQL to talk to each other, with the MyODBC ODBC driver. Using this you can write a Visual basic program with ADO, specifying the DSN as a MyODBC driver (which can be on a remote server). You can then read and write to your remote database, and genreally do whatever you want to it!"

          For the MyODBC driver, go to the mysql website, http://www.mysql.com

          Hope that helps!

          Robin

            Mark, yes I can and do have MySql with the phpmyadmin.

            MrAlaska, I believe I worded wrong. I have a datafeed and its in an excel spreadsheet. I need to get that info into the table in the phpmyadmin. I think I have it down now how to make the table in phpmyadmin. I have to print out a glossary of what null, and those words mean.

            Now once I can get the info on how to call in that spreadsheet, then how to get that sheet/table called into my webpage.

            Also want to beable to target a link with a number, for easier removal of anything that expires.

            rcbasie, I was told by the host that is not the way I can go.

            But your info has all been helpful, I am almost over the hump.

              So where is your datafeed coming from? Is this a constantly updated feed or is it a one shot deal? I guess I don't have a clear picture of exactly what you are trying to do. If it was a one shot deal it would be a simple matter save it as a text file and do what I mentioned. I don't know if MySql can read directly from an Excel file or not, it might be able to, or PHP might be able to manipulate the files for you. I got it to do what I wanted, then quit researching the subject.

              BTW, what Rcbasie told you is true. You can set up an Access DB on your personal computer to communicate with MySQL on your online server. What your host told you only referred to having an Access DB in your online account.

                Robin, I have access, and a table made up. I have downloaded the odbc, and am trying to understand this part.

                Do I use php for a script to call this? Then being newbie, where can I find some free already made scripts? I am still trying to understand the terms of mysql too.

                MrAlaska, the datafeed is from a merchant. Theyupdate them monthy and I get emails. Most of the time it stays the same. This datafeed is in a txt file -delimiter is (,), I export that into access and need to get this to the webpage. Phpmyadmin is what my host provides. It has mysql.
                The big problem is this, I am new to all of this, and have no one here in physical form to talk this over with. Im doing it straight from thought or thinking, reading and so on.

                  The syntax I gave you assumes the file is tab delimited and fields are terminated by a new line. I don't have time to look it up right now, but you can add an option to the command to tell it to look for comma delimited files.

                  My text file came from a local access database, too. I cleaned it up then exported to an excell file, then I saved the Excel file as a tab delimited text file and uploaded it into my directory. Then it was just a matter of transferring the data to my MySQL database.

                  PHPMyAdmin is only an administration tool, I have never used it but I am sure you can run queries from it or build tables. Make sure you have the tables set up with similar types of fields as your Access DB. The PHP manual has some good articles, too, on moving data between files and databases.

                    Ok this is where I am stuck. I can make the tables in the phpmyadmin. But I cannot get the data in the tables.

                    questions:
                    1. if you have a txt. file delimited by comma, do you upload it to your server then try to get the info in the table? or not.

                    1. the tags you use to call the table, syntax, is that to go into your webpage? or just the php part?

                    2. the php part calls the snytax in the mysql (phpmyadmin) and back thru the php it presents itself on the web?

                    All day I have been at this read and try, read and try, Im done for the night! LOL

                      Ok, one step at a time, if something goes wrong it might because my memery cells are fried:

                      Name your text file the same name as the table you are loading it into

                      Upload the text file to your server (comma delimited is ok)

                      Make a page called phpinfo.php, with only this code on it;

                      <?php phpinfo() ?>

                      Upload phpinfo.php to the same directory as your text file

                      Send your browser to phpinfo.php, it will reveal all your server variables

                      Do a control 'f' and search for phpinfo.php on the page, you should be able to find the local path.

                      Now send your browser to PhpMyAdmin

                      In PhpMyAdmin, you will need to do a query (Somewhere there should be a place to enter queries and a button to 'run query' or something, I have never used PhpMyAdmin)

                      The query you need to run include your local path and will look something like this:
                      (Of course, use your table name for tablename and your local path)

                      load data local 
infile '/home/sites/siteno/users/your/local/directory/tablename.txt'
into table tablename fields terminated by ',';

                      The query will run very fast, probably will not take more than a couple seconds

                      Then you need to make sure the data loaded properly. By now you are an old hand at running queries, so run this query and see if all looks ok:

                      select * from tablename limit 10;

                      I have not tested the syntax of telling MySql to delimit on commas, I got it from this page:
                      http://www.mysql.com/doc/en/LOAD_DATA.html
                      If the data got loaded but in the wrong fields or something, dump the data with this command and start over again (it gets easier every time):

                      delete from tablename;

                      There is one 'gotcha' that might get you. Windows system apps will often terminate a line with '\r\n' but MySql is looking for an '\n' only. If the data looks good, check the LAST field carefully to make sure it loaded properly. You can run this query using the name of your last field and your table.

                      select lastfieldname, length(lastfieldname) from tablename limit 10

                      Count the characters by hand and see if length() is reporting an extra 'invisible' one. If so, it means an '\r' slipped in there and you may need to run the load data query again, only specifying that lines are to be terminated by '\r\n' (unless I have it backwards, my brain herts)

                      '\n' and '\r' stand for 'newline' and 'return'. In some cases it will not hurt to have an extra one in your table but it does take up extra space and it is not 'clean'.

                      These directions are also for using the local path to your text file in case you do not have proper permissions to do it using the virtual path. There is a chance you might not be able to use the local path too, but might be able to use the virtual path. If neither works, then there are other options.

                      Good luck, see ya tomorrow, when we can discuss getting your info back out of the table :o (that form you found does look like a handy tool for learning how to make a self posting form to enter single lines of data into your database, although on general principlels I would put in a bogus password and edit it after)

                        thanks mralaska, this is what I am looking for. Everything so far has helped greatly frome everyone.

                        Something came up and haven't had a chance to work with this. But as soon as I do, I will post.
                        One question you said :

                        My text file came from a local access database, too. I cleaned it up then exported to an excell file, then I saved the Excel file as a tab delimited text file and uploaded it into my directory. Then it was just a matter of transferring the data to my MySQL database.

                        When I clean the txt file I just get rid of items I won't use. Is there more to it then that? Am I suppose to word wrap it and such? The excell export area is ok for me, and the transferring to data to mysql. Yeah thats the part I am new at.

                        Yes phpmyadmin has a query box, more like an interface tool, I am sure it will be a breeze once I get going.

                        The other part when this is all completed, is how to get it to the webpage. LOL! Boy I better stock up on coffee and smokes! LOL

                          By cleaning it up, I meant to be sure to have each row contain the proper number of fields and stuff like that. If you have a row that does not have an entry for a particular column, you need to be sure it still has a delimiter so MySql will know to put the next item in the proper field. In my case I was saving zip codes and using the actual zip code as the unique identifier, so cleaning it up also meant getting rid of redundant zip code numbers. Basically, get everything as neat and tidy as you can.

                          Turning word wrap on might not hurt anything, but there is no way it can help. I turn it off on general priniples.

                          Take it one step at a time. Don't worry about getting it to the web page. After you get the database loaded the way you want it, that part will be a breeze. (But a plentiful supply of smokes and caffeine is still recommended)

                            9 days later

                            MrAlaska, you have been a godsend! I finally had the chance to work with this over the past two days. I have made the table, and made the query to upload the data. Wallah! Easy as pie, do this a few more times, I'll have it down.

                            Now I did the select to see what it would look like with 10 rows of data, yuck, all the data was gibberish. Unreadible. Althought the data txt file I used was english. What happened. Before I can move on now I have to figure this one out.

                            charles

                              That is an odd one on me. I assume you have the text file still on the server. Download it from there and open it with a plain text editor (such as notepad) and make sure it didn't get corrupted in the upload. That is where I would start.

                                It was corrupt, I must have used binary when I uploaded it instead of ascii. Alright, onto the next.....I am still futsing with the extracting of data. How to set it up. Would I make a html page first and then insert? or....well I will be here waiting.....LOL

                                  Yikes It sounds like you need to familiarize yourself with the basics.

                                  Basically speaking, to insert data your PHP page accepts variables from the HTML form, then builds the appropriate SQL statement an does the insert.

                                  To display information contained in the database, a PHP page will query the database for the information then insert them into an HTML page to your specifications.

                                  There are posts all over this site addressing the individual issues and confusions you may run into. There is also a wealth of information on the net. A google search with keywords like; PHP MYSQL BEGINNER TUTORIAL; will return thousands of pages. Then there are is the basic arsenal:

                                  There is the php manual, which contains within its pages all the facts and functions at your disposal, which is also available for download:
                                  http://www.php.net/manual/en/

                                  If you don't know SQL you should really search out some SQL tutorials. Even if you DO know SQL you need to familiarize yourself with MySql. Their documentation also has a basic tutorial but it is based on working from the shell which might seem confusing if you are in PHP mode. Actually, if you are new to SQL; installing it locally and working from the shell could turn out to be an invaluable way to gain a level of understanding that will pay for itself many times over:
                                  http://www.mysql.com/doc/en/index.html

                                  For what is is worth, I found my introduction to PHP/MySql at Webmonkey:
                                  http://hotwired.lycos.com/webmonkey/99/21/index2a.html

                                    I have read so much material, printed out alot of pages, for my makeshift binder/reference.
                                    Ya know, being so new, no one ever told me, nor did it plainly say anywhere I have found on the net yet.... that you have to make a txt file with php or perl script to show that new language in print ( $ ()_) and so on. Then make a html, htm, shtml etc. page, upload that info into the txt php file. This will sit in the cgi bin area or similar. Then upload the html files too.

                                    Then it will work.

                                    As long as you have the code written correctly.

                                    right????

                                      When writing thephp for calling out the data content in my mysql,
                                      what do I call?
                                      Say for instance I have a table, with 50 names, I would have the choice of calling in the entire table, I believe thats normal, then would I have the ability to call in only a few things from that table? Incase I wanted to add to that items from another table? make sense?

                                      Now if I want to call in the table of names, entirely,
                                      would my php look like this:

                                      <BR><TABLE Cellpadding="5">
                                      <TR>
                                      <TD Valign="top"><"%%name%%"><IMG Border="0" Src"><"%%namel%%"></A></TD>
                                      <TD Valign="top"><A Href"><"%%namel%%"><"%%name%%</A><BR>%%name%%<BR>%%name%%</TD>
                                      </TR>
                                      <TR>
                                      <TD Colspan="2">%%name%%</TD>
                                      </TR>
                                      </TABLE><BR>

                                      What I will do is make a few html files, throw them up in the cgi bin, then plut this up there with some other files, and bingo right?