ianhaney 0 Posted October 25, 2016 Hello I am struggling with some coding, I need a script to check if a url stored in my database is indexed in Google and if it is to display a green check image and if it is not then to display a red cross image, below is the code I have that I found by doing some searching function indexed($url) { $url = 'http://webcache.googleusercontent.com/search?q=cache:' . urlencode($url); $ch = curl_init($url); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, false); curl_setopt($ch, CURLOPT_NOBODY, true); curl_setopt($ch, CURLOPT_USERAGENT, 'Chrome 10'); if (!curl_exec($ch)) { // var_dump('failed'); return false; } $code = curl_getinfo($ch, CURLINFO_HTTP_CODE); // var_dump($code); return $code == '200'; } below is the whole code I have but is displaying an error and all the urls pulled from the database have a red cross but am sure they are indexed in Google ini_set('display_startup_errors', 1); ini_set('display_errors', 1); error_reporting(-1); // connect to the database include('connect-db.php'); function indexed($url) { $url = 'http://webcache.googleusercontent.com/search?q=cache:' . urlencode($url); $ch = curl_init($url); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, false); curl_setopt($ch, CURLOPT_NOBODY, true); curl_setopt($ch, CURLOPT_USERAGENT, 'Chrome 10'); if (!curl_exec($ch)) { // var_dump('failed'); return false; } $code = curl_getinfo($ch, CURLINFO_HTTP_CODE); // var_dump($code); return $code == '200'; } // get the records from the database if ($result = $mysqli->query("SELECT id, category, url, DATE_FORMAT(domain_expiry_date, '%d/%m/%Y') AS domain_expiry_date, site_login_url, site_username_login, site_password_login, no_of_posts, tf, cf, domain_name_owner, DATE_FORMAT(domain_owner_dob, '%d/%m/%Y') AS domain_owner_dob, domain_owner_address, domain_owner_email, domain_owner_phone, email_account, email_account_address, email_username, email_password, registrar, registrar_username, registrar_password, hosting_company, hosting_username, hosting_password, DATE_FORMAT(hosting_expiry_date, '%d/%m/%Y') AS hosting_expiry_date, hosting_cpanel_url, hosting_cpanel_username, hosting_cpanel_password, sites_linked_out_to, DATE_FORMAT(last_post_date, '%d/%m/%Y') AS last_post_date FROM websites")) { // display records if there are records to display if ($result->num_rows > 0) { // display records in a table echo "<table class='records'>"; // set table headers echo '<tr> <th>URL</th> <th>Indexed</th> </tr>'; while ($row = $result->fetch_object()) { $index = indexed($row->url); // set up a row for each record echo "<tr>"; echo "<td class='expand'><a href='http://" . $row->url . "' target='_blank'>" . $row->url . "</a></td>"; echo "<td class='shrink'><img src='images/" . (($index->indexed) ? 'green-check.png' : 'red-cross.png') . "' style='width: 30px; height: 30px;'></td>"; echo "</tr>"; } echo "</table>"; // retrieve and show the data } // if there are no records in the database, display an alert message else { echo "No results to display!"; } } // show an error if there is an issue with the database query else { echo "Error: " . $mysqli->error; } // close database connection $mysqli->close(); Notice: Trying to get property of non-object in /home/cloudnetworkhero/public_html/network/websites-info/indexed.php on line 54 Quote Share this post Link to post Share on other sites