php - Why is My Code not showing results -

-

can code. code asks 1 of 2 things. if postcode entered code radius search , searches database rows containing postcodes in array. if city / street entered want code bypass , search rows containing them details. code below. 

    $postcode = str_replace( '+', '%20', $postcode );  $conn = mysql_connect('127.0.0.1','user','pass') or die('db connect error:'.mysql_error()); mysql_select_db('database', $conn) or die('could not select database');  $sqlstring = "select * postcodelatlng postcode ='".$postcode."'"; $result = mysql_query($sqlstring);     $row = mysql_fetch_assoc($result);  $lng = $row["longitude"] / 180 * m_pi; $lat = $row["latitude"] / 180 * m_pi;  mysql_free_result($result);      $sqlstring2 = "select distinct    postcodelatlng.postcode,   (     6367.41 * sqrt(       2 * (         1- cos(radians(postcodelatlng.latitude)) * cos(".$lat.") * (           sin(radians(postcodelatlng.longitude)) * sin(".$lng.") + cos(radians(postcodelatlng.longitude)) * cos(".$lng.")         ) - sin(radians(postcodelatlng.latitude)) * sin(".$lat.")       )     )   ) distance    postcodelatlng postcodelatlng  having distance <= '".$radius."' order distance ";  $result1 = mysql_query($sqlstring2) or die('query failed: ' . mysql_error());     while($row = mysql_fetch_array($result1)){         if ($row['postcode'] == 0){              $sqlstring3="select * property_details  street = '".$postcode."' or address3 = '".$postcode."' or county = '".$postcode."' ";     $result2 = mysql_query($sqlstring3) or die('query failed: ' . mysql_error());         while($row2 = mysql_fetch_array($result2)) {             echo '      <div class="container">         <div class="row">             <a href="viewprop.php?id='.$row2[0].'">                 <div class="col-md-12">                      <div class="col-md-12 col-md-offset-0 inner col-xs-12" align="justify">                         <div class="col-md-2 col-xs-12">                             <img src="images/rentals/1.jpg" width="80%" height="80%" />                         </div>                         <div class="col-md-8 col-xs-12">                             <h2>'. $row2[13]. '</h2>                         </div>                         <div class="col-md-2 col-xs-12">                             <h4 class="rbgclr2">£'. $row2[2]. ' per month</h3>                             <h5 class="rbgclr1">£'. $row2[3]. ' deposit</h4>                             <br />                             <p>bedrooms = '. $row2[4]. '</p>                         </div>                     </div>                 </div>             </a>         </div>     </div>             <br />';         }         }         else {             $sqlstring4="select * property_details postcode = '".$row['postcode']."' ";     $result3 = mysql_query($sqlstring4) or die('query failed: ' . mysql_error());         while($row2 = mysql_fetch_array($result3)) {             echo '      <div class="container">         <div class="row">             <a href="viewprop.php?id='.$row2[0].'">                 <div class="col-md-12">                      <div class="col-md-12 col-md-offset-0 inner col-xs-12" align="justify">                         <div class="col-md-2 col-xs-12">                             <img src="images/rentals/1.jpg" width="80%" height="80%" />                         </div>                         <div class="col-md-8 col-xs-12">                             <h2>'. $row2[13]. '</h2>                         </div>                         <div class="col-md-2 col-xs-12">                             <h4 class="rbgclr2">£'. $row2[2]. ' per month</h3>                             <h5 class="rbgclr1">£'. $row2[3]. ' deposit</h4>                             <br />                             <p>bedrooms = '. $row2[4]. '</p>                         </div>                     </div>                 </div>             </a>         </div>     </div>             <br />';         }     }     }     mysqli_close($con);   ?>


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more