Search the Community
Showing results for tags 'code'.
-
Hello I am new to this forum, so I am not sure if I have done this write by starting a new topic, if I was not supposed to start a new topic apologies in advance. Basically I want to get a price from a website and update my database with that value in the correct field. So far I have managed to get the price and update the database. However the price is stored as boolean format so when I output the variable it says "0" or "1" and when the database is updated it says "0" or "1". Here is my working code so far. I have tried using intval, doubleval and data type castings but obviously they equal the boolean value. $url = 'a website goes here'; $html = file_get_contents($url); $search = '/<span class="price">(.*?)<\/span>/'; preg_match_all($search, $html, $matches); $price = array_shift($matches[0]); $price1 = str_replace("£","",$price); $price2 = str_replace(',','', $price1); $price3 = str_replace(".","",$price2); print_r($price3); MySQL query is okay as it is. It would be great if you could help me with this code, thanks in advance.