Repair php script for Find and Replace text inside tabe of MySQL database

I have four years experience as a web developer will fix your issue inbox me we can discuss more over chat.

Dear Sir, am expert in php and mysql ican correct it perfectly please reply wish to do this task please come in chat

I am expert in web development using PHP / MySQL. I can work on Find and Replace text inside tabe of MySQL database on your project.

Hi, I am a magento certified developer with more than 5 years of experience in php development. I can help on this. PM me if you are interested. Thanks

Hi! try this code: You HAVE TO USE STR_REPLACE <?php //set up variables and enter your credentials here $dbname = "name"; $dbhost = "localhost"; $dbpass = "pass"; $dbuser = "name"; $tbl_name = "oc_attribute_description"; //set up your master array! Array goes in this or $mstr_array = array( "Packs", "Packets", "Manual", "Manual Book"); //connect to database $con = mysql_connect($dbhost, $dbuser, $dbpass) or die('no connection:' . mysql_error()); $db = mysql_select_db($dbname) or die ('cant select db: ' . mysql_error()); // reteive each column $sql = "SHOW COLUMNS FROM '".$tbl_name."'"; $res = mysql_query($sql) or die ('could not get columns: ' . mysql_error()); $find = 0; $replace = 1; while ($col = mysql_fetch_array($res)) { $sql = "UPDATE '".$tbl_name."' SET '".$col[0]."' = STR_REPLACE(".$mstr_array[$find].", '".$mstr_array[$replace]."' , '".$col[0]."')"; $find = $find + 2; $replace = $replace + 2; } ?>

Hello, I am a php developer and can help you with correcting your script. If you are interested in my offer, don't hesitate contacting me. Thanks

hello sir/madam your project can be done. kind regards, Niraj Lathiya. Thank you.

HI, I AM A PHP PROGRAMMER AND WEB DEVELOPER. I HAVE A LOT OF EXPERIENCE IN PHP CODING AND DIFFERENT KINDS OF SCRIPTING LANGUAGES. I HAVE DEVELOPED MANY DYNAMIC WEBSITES USING PHP. I CAN DEBUG AND FIX THE SCRIPT. YOU MAY CONTACT ME NOW TO GET UPDATED SCRIPT. THANKS

Hi there: I have expertise in php. I can get the job done for you in no time. Can provide you with 100% working code. looking forward to work with you. we can discuss details over chat. regards

I have got your job posting and I am very much interested to work in your project. About Me : I am a software developer more than 9 years working experiences of Cakephp, codeigniter, Laravel, CorePhp, AngularJs, Ionic Hybrid Mobile Application development. I am worked in leading software companies which i mentioned in my resume. and worked 40+ successful projects in various technologies. Also made many web services APIs for mobile Apps. specialization in your requirements: I worked in many php frameworks including Cakephp and 25+ projects in Cakephp. also worked in AngularJs and IONIC framework in many websites and hybrid mobile applications. and usually using MySql as a backend. Current Working Position: Right now i am working as a freelancer and not fully bounded with any organisation. So i can dedicate work with you on your assignment. And let me know next availability time so we can move forward for achieve your project requirement. Also let me know if you have any doubts or queries about me. Regards, Krishan k. Sharma