Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $server = "localhost"; // Serveur MySQL
- $db_user = "root"; // Utilisateur MySQL
- $db_pass = "ue23hasok6se"; // Pass de la base
- $base = "hakaekold"; // nome de la base MySQL
- mysql_pconnect("$server","$db_user","$db_pass");
- mysql_select_db("$base");
- $req = mysql_query("select * from db_articles") or die ('ERREUR :'.$req.' '.mysql_error());
- ?>
- removing the ../up_new/ from fichier
- <?php
- $num_rows = mysql_num_rows($req);
- $queries = array();
- echo "$num_rows Rows\n";
- while($r=mysql_fetch_array($req))
- {
- $id = $r["id"];
- $orig = $r["photo_big"];
- $str2 = substr($orig, 21);
- echo"<pre>";
- print $str2;
- echo"</pre>";
- $queries[] = "UPDATE db_articles SET photo_big='$str2' WHERE id='$id'";
- //$req2 = mysql_query("UPDATE db_articles SET photo_big='$str2' WHERE id='$id' ") or die ('ERREUR :'.$req2.' '.mysql_error());
- }
- echo"<div style='color:#FFF; position:absolute; top:0; right:0; background:green; width:50px; padding:1em;'>fini</div>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement