Lukeidiot Posted October 7, 2013 Share Posted October 7, 2013 I am drawing a blank or either thinking too hard here. I am trying to replace each item. I have the pastebin_id that matches in mysql database. (Mysql part is all correct, is the replace script that doesnt completely work.) It seems to be only showing one item replaced. pages/1.txt: <ul id="filters"> <li><a href="/tumblr-themes">Themes</a> /</li> <li><a href="/one-column-tumblr-themes">One Column</a> /</li> <li><a href="/two-columns-tumblr-themes">Two Columns</a> /</li> <li><a href="/three-columns-tumblr-themes">Three Columns</a> /</li> <li><a href="/four-columns-tumblr-themes">Four Columns</a> /</li> <li class="last"><a href="/theme-help">Theme Help</a></li> </ul> <ul class="clearfix isotope" id="portfolio-items"> <li class="one isotope-item"><a href="http://tit-133.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/uiqhh9x/EyWm90u45/tit-133.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/HCaMRShp" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-132.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/uiqhh9x/oUcm90u1t/tit-132.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/Y8cDqc5h" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-114.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/uiqhh9x/0PMm8s6th/tit-114.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/yTYYHLkJ" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-105.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/Tv4m8767q/tit-105.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/ZY9hzx34" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-101.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/gqym87667/tit-101.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/YdrPvDdF" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-91.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/DvQm6m4uk/tit-91.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/b9MJpiUa" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-90.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/Re5m6m4ud/tit-90.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/a9QC9aJ5" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-83.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/94gm6m4u6/tit-83.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/kjeFYMrq" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-80.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/QSsm6m4u2/tit-80.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/CmKgnenP" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-79.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/cvQm6m4tx/tit-79.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/Nv2g2L51" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-72.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/5JFm6m4sx/tit-72.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/xKCyPBwt" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-67.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/G1cm6m4sr/tit-67.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/DafcTRFD" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-61.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/DS1m6m4sm/tit-61.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/YMBjUFBM" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-58.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/z3rm6m4sf/tit-58.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/KwA482F5" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-57.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/yZ3m6m4sc/tit-57.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/STNvtktU" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-56.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/9Ckm6m4s6/tit-56.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/WKuG3Rr5" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-54.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/4pgm6m4s0/tit-54.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/w5tFXywz" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-53.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/qp1m6m4qp/tit-53.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/DjJ59aUr" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-47.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/FmUm6m4qk/tit-47.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/Fk81rqge" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-46.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/xN1m6m4qg/tit-46.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/2J0Gwuv8" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-37.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/4p4m6m4qd/tit-37.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/n8MqTnci" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-36.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/jF1m6m4qa/tit-36.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/EhhLbEUk" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-34.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/Vn8m6m4q6/tit-34.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/Y4LnHEZH" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-31.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/MbBm6m4q3/tit-31.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/KbUrYjz8" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-30.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/r6Lm6m4oo/tit-30.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/j4jvCeAe" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-28.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/hC6m6m4ok/tit-28.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/drXrpCV2" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-27.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/epOm6m4oe/tit-27.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/J4LfrRra" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-26.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/wOum6m4ob/tit-26.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/KEprw3WX" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-22.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/0ezm6m4o6/tit-22.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/eF3zGm6E" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-21.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/tQDm6m4o1/tit-21.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/PquYJLkq" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-20.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/VBPm6m4nw/tit-20.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/mGfpanes" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-15.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/uTYm6m4lm/tit-15.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/rHMrgKK8" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-13.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/pCYm6m4lh/tit-13.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/2vNJic53" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-9.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/X0rm6m4lf/tit-9.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/26r4gUST" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-7.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/dSzm6m4l9/tit-7.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/ULwYt9ZT" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-5.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/fGxm6m4l6/tit-5.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/yWzxth4W" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-4.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/0yom6m4l2/tit-4.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/agU7Vqca" target="_blank">click here for theme code</a> </span></li> <li class="one isotope-item"><a href="http://tit-1.tumblr.com" target="_blank"> <img alt="" height="187" src="http://static.tumblr.com/tpqedpr/0cxm6m4kl/tit-1.png" width="280" /></a> <span class="title"> <a href="http://pastebin.com/gjd9QQHx" target="_blank">click here for theme code</a> </span></li> </ul> <div class="pagination"><span>1 page of 1</span> <div class="numbers"><a href="#">1</a></div> </div> Replace Script: <?php $columns = 'pages/1.txt'; mysql_connect('localhost', 'root', ''); mysql_select_db('themes'); $html = file_get_contents("$columns"); $sql = mysql_query("SELECT * FROM themes WHERE columns = 'one-column-tumblr-themes'"); while($row = mysql_fetch_assoc($sql)){ $new = str_replace("http://pastebin.com/$row[pastebin_id]", "http://tsil.co/theme?id=$row[name]", $html); } echo $new; ?> Link to comment https://forums.phpfreaks.com/topic/282773-str_replace-in-file_get_contents-for-multiple-items/ Share on other sites More sharing options...
Lukeidiot Posted October 7, 2013 Author Share Posted October 7, 2013 Yep. It's official. I'm an idiot. replace $new with $html, and boom it works. Link to comment https://forums.phpfreaks.com/topic/282773-str_replace-in-file_get_contents-for-multiple-items/#findComment-1452895 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.