How to write data to MySQL table field(column) in PHP -
itemprop = "text">
I have mysql table as websites with three columns, one serial number, the other is a website and the third is content . With the script below, I am able to loop through the website column and am manipulating some. Now there is output for each of my manipulation and as soon as I manipulate, I want to write it in the content column.
& lt ;? Php $ mysqli = new mysqli ("localhost", "root", "", "whit"); / * Check connection * / if (mysqli_connect_errno ()) {printf ("Connect failed:% s \ n", mysqli_connect_error ()); Go out(); } $ Query = "Select Website From Websites"; If ($ result = $ mysqli- & gt; query ($ query)) {while ($ line = $ result-> fetch_assoc ()) {$ website = $ row ["website"]; $ F = file_get_contents ($ website); // How to write the contents of the content in the website line in the $ MySQL table I} / * Set the Free Result * / $ Result-> Close (); } / * Close connections * / $ mysqli- & gt; Close (); ? & Gt;
Comments
Post a Comment