1 and coalesce(telehealth_link,'') ilike $2 and coalesce(second_opinion_price::varchar,'') ilike $3 order by td_score desc", array($_GET['zip'], $condition_telehealth_link, $condition_second_opinion)); if (!$stmt2) { echo "An query error occurred.\n"; echo pg_last_error($conn); exit; } } if ($meth == "n") { $name = "%" . $_GET['name'] . "%"; $search_name = $name; $zip = "%" . $_GET['zip'] . "%"; //get total rows $total = 0; $stmt2 = pg_query_params($conn, "select count(*) from health.td where name ilike $1 ", array($name)); if (!$stmt2) { echo "An query error occurred.\n"; echo pg_last_error($conn); exit; } if ($row2 = pg_fetch_row($stmt2)) { $total = $row2[0]; $total = ($total / 2) + 1; } pg_free_result($stmt2); //end get total rows if (isset($_GET['speciality']) && $_GET['speciality'] != '') $stmt2 = pg_query_params($conn, "SELECT sno, zip, user_email, name, accepting_new_patients, lang, add1, add2, specialities, comemail, facebook, google, twitter, linkedin, highly_rated_rank, company_name as company, phone, photo, licence_document, licence_validated, licence_validate_till, td_score, website, public_id, message_to_be_posted, second_opinion_price, telehealth_price_consult, (SELECT count(*) from health.td as i1 where i1.sno<=i2.sno and name ilike $1 ) as rownum from health.td as i2 ,health.company WHERE health.company.company_id=i2.company_id and (SELECT count(*) from health.td as i1 where i1.sno<=i2.sno and name ilike $2 )%2=1 and name ilike $3 and specialities ilike $4 and ( zip ilike $5 or zip is null ) and highly_rated_rank>1 and coalesce(telehealth_link,'') ilike $6 and coalesce(second_opinion_price::varchar,'') ilike $7 order by name limit 2 offset 0", array($name, $name, $name, '%' . $_GET['speciality'] . '%', $zip, $condition_telehealth_link, $condition_second_opinion)); else $stmt2 = pg_query_params($conn, "SELECT sno, zip, user_email, name, accepting_new_patients, lang, add1, add2, specialities, comemail, facebook, google, twitter, linkedin, highly_rated_rank, company_name as company, phone, photo, licence_document, licence_validated, licence_validate_till, td_score, website, public_id, message_to_be_posted, second_opinion_price, telehealth_price_consult, (SELECT count(*) from health.td as i1 where i1.sno<=i2.sno and name ilike $1 ) as rownum from health.td as i2 ,health.company WHERE health.company.company_id=i2.company_id and (SELECT count(*) from health.td as i1 where i1.sno<=i2.sno and name ilike $2 )%2=1 and name ilike $3 and ( zip ilike $4 or zip is null ) and highly_rated_rank>1 and coalesce(telehealth_link,'') ilike $5 and coalesce(second_opinion_price::varchar,'') ilike $6 order by name limit 2 offset 0", array($name, $name, $name, $zip, $condition_telehealth_link, $condition_second_opinion)); if (!$stmt2) { echo "An query error occurred.\n"; echo pg_last_error($conn); exit; } } if ($meth == "lang") { $lang = "%" . $_GET['lang'] . "%"; $search_lang = $lang; $zip = "%" . $_GET['zip'] . "%"; //get total rows $total = 0; $stmt2 = pg_query_params($conn, "select count(*) from health.td where lang ilike $1 ", array($lang)); if (!$stmt2) { echo "An query error occurred.\n"; echo pg_last_error($conn); exit; } if ($row2 = pg_fetch_row($stmt2)) { $total = $row2[0]; $total = ($total / 2) + 1; } pg_free_result($stmt2); //end get total rows if (isset($_GET['speciality']) && $_GET['speciality'] != '') $stmt2 = pg_query_params($conn, "SELECT sno, zip, user_email, name, accepting_new_patients, lang, add1, add2, specialities, comemail, facebook, google, twitter, linkedin, highly_rated_rank, company_name as company, phone, photo, licence_document, licence_validated, licence_validate_till, td_score, website, public_id, message_to_be_posted, second_opinion_price, telehealth_price_consult from health.td ,health.company WHERE health.company.company_id=health.td.company_id and lang ilike $1 and specialities ilike $2 and ( zip ilike $3 or zip is null ) and coalesce(telehealth_link,'') ilike $4 and coalesce(second_opinion_price::varchar,'') ilike $5 order by td_score desc", array($lang, '%' . $_GET['speciality'] . '%', $zip, $condition_telehealth_link, $condition_second_opinion)); else $stmt2 = pg_query_params($conn, "SELECT sno, zip, user_email, name, accepting_new_patients, lang, add1, add2, specialities, comemail, facebook, google, twitter, linkedin, highly_rated_rank, company_name as company, phone, photo, licence_document, licence_validated, licence_validate_till, td_score, website, public_id, message_to_be_posted, second_opinion_price, telehealth_price_consult from health.td ,health.company WHERE health.company.company_id=health.td.company_id and lang ilike $1 and ( zip ilike $2 or zip is null ) and highly_rated_rank>1 and coalesce(telehealth_link,'') ilike $3 and coalesce(second_opinion_price::varchar,'') ilike $4 order by td_score desc", array($lang, $zip, $condition_telehealth_link, $condition_second_opinion)); if (!$stmt2) { echo "An query error occurred.\n"; echo pg_last_error($conn); exit; } } } $count = 0; ?> 0) : ?>