mATOK Posted August 15, 2006 Share Posted August 15, 2006 Hello out there!I have a DB that I am going to be populationg via a form that I am going to create in html/php.I have 4 fields in my DB that are of type mediumtxt. When I use MySQL consol manager i am prompted to save and name my txt files and then to apply so that the record is loaded from the file.How do I go about doing this via a form? I have a naming convention so I'm hoping that I can submit some mysql command...please help Link to comment https://forums.phpfreaks.com/topic/17620-mediumtxt/ Share on other sites More sharing options...
fenway Posted August 15, 2006 Share Posted August 15, 2006 You mean uploading files to mysql? Link to comment https://forums.phpfreaks.com/topic/17620-mediumtxt/#findComment-75106 Share on other sites More sharing options...
mATOK Posted August 15, 2006 Author Share Posted August 15, 2006 Perhaps, I don't know.I have an empty table with fields of type Medium txt. I just want to be able to populate these fields via a form.If I do it using the MySQL control center I create a txt file, name it and apply it. I'm just wondering how to do all this via a form and action script Link to comment https://forums.phpfreaks.com/topic/17620-mediumtxt/#findComment-75174 Share on other sites More sharing options...
fenway Posted August 15, 2006 Share Posted August 15, 2006 Populate these fields with the contents of the "txt file"? I don't understand. Link to comment https://forums.phpfreaks.com/topic/17620-mediumtxt/#findComment-75195 Share on other sites More sharing options...
mATOK Posted August 15, 2006 Author Share Posted August 15, 2006 can I do a straight "UPDATE table SET lotzoftxt='$data'; If lotzoftxt is of type mediumtext? Or do I need to specify anything else? Link to comment https://forums.phpfreaks.com/topic/17620-mediumtxt/#findComment-75202 Share on other sites More sharing options...
fenway Posted August 15, 2006 Share Posted August 15, 2006 Yes, you can issue the statement you described -- just beware of quoting issues. Link to comment https://forums.phpfreaks.com/topic/17620-mediumtxt/#findComment-75235 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.