PHP - Division By 0 Error

I am getting Warning: Division by zero in /rate.php on line 64

<?php

function rateinstar($value)
{

preg_match_all('#([0-9]+)([0.0-9.9]+)|([0-9]+)#',$value,$tek);

if($tek[0][1] > 0)
{
$rate=$tek[0][0]/$tek[0][1];
}
else
{
   $rate=0;
}

preg_match_all('#([0-9]+).([0-9]+)#',round($rate,1),$decm);

if($decm[2][0] != "")
{
$no=($decm[1][0]*2)+1;

     for($i=1;$i<=10;$i++)
{
if($i<=$no){
if($i%2!=0)
echo '<span class="starin piece1"></span>';
else
echo '<span class="starin piece2"></span>';
 }else{ 
if($i%2!=0)
echo '<span class="starin piece3"></span>';
else
echo '<span class="starin piece4"></span>';
}
}
}else{

     for($i=1;$i<=10;$i++)
{
if($i<=$rate*2){
if($i%2!=0)
echo '<span class="starin piece1"></span>';
else
echo '<span class="starin piece2"></span>';
}else{
if($i%2!=0)
echo '<span class="starin piece3"></span>';
else
echo '<span class="starin piece4"></span>';
}

}

}
}


function rateintext($value)
{

preg_match_all('#([0-9]+)([0.0-9.9]+)|([0-9]+)#',$value,$tek);

$rate=$tek[0][0]/$tek[0][1];

preg_match_all('#([0-9]+).([0-9]+)#',round($rate,1),$decm);


return round($rate,1);
}

?>

Code: [Select]
<?php
class Point
{
  public $x;
  public $y;
 
}
// Random values 0 - 1
function random_float ($min,$max) {
   return ($min+lcg_value()*(abs($max-$min)));
}
 
 
//  Fuzzy C Means Algorithm
function distributeOverMatrixU($num_of_clusters, $arr,$m) 
{
global $MatrixCentroids;
$num_of_data = sizeof($arr);
 
 
$MatrixPointX = $arr;
 
// Fill the  $MatrixU table with random values from 0 to 1
for($j = 0; $j < $num_of_data; $j++)
{
$sum = 0;
for($i = 0; $i < $num_of_clusters; $i++)
{
$MatrixU[$j][$i] = random_float(0,1);
$sum += $MatrixU[$j][$i];
}
 
// Normalize Data 
for($i = 0; $i < $num_of_clusters; $i++)
{
 
$MatrixU[$j][$i] = $MatrixU[$j][$i]/$sum;
 
}
 
}
 
 
// repeat 200 
for($a = 0; $a<200; $a++)
{
 
 
for($i = 0; $i < $num_of_clusters; $i++)
{
$tempAx = 0;
$tempBx = 0;
$tempAy = 0;
$tempBy = 0;
 
for($j = 0 ; $j < $num_of_data; $j++)
{
 
$tempAx = $tempAx + pow($MatrixU[$j][$i],$m);
 
$tempBx += pow($MatrixU[$j][$i],$m) * $MatrixPointX[$j]->x;
 
$tempAy = $tempAy + pow($MatrixU[$j][$i],$m);
 
$tempBy += pow($MatrixU[$j][$i],$m) * $MatrixPointX[$j]->y;
 
}
 
$MatrixCentroids[$i] = new Point();
$MatrixCentroids[$i]->x = $tempBx / $tempAx;
$MatrixCentroids[$i]->y = $tempBy / $tempAy;
 
 
}
// Cluster Centers
for($j = 0 ; $j < $num_of_data; $j++)
{
$tempSum = 0;
 
for($i = 0; $i < $num_of_clusters; $i++)
{
// Distance between 2 points
$distance1 = pow(($MatrixPointX[$j]->x - $MatrixCentroids[$i]->x),2); 
$distance2 = pow(($MatrixPointX[$j]->y - $MatrixCentroids[$i]->y),2);
$distance = $distance1 + $distance2;
$distance = sqrt($distance);
 
 
$MatrixU[$j][$i] = pow(1/$distance , 2/($m-1));
$tempSum += pow(1/$distance, 2/($m-1));
 
}
 
for($i = 0; $i < $num_of_clusters; $i++)
{
 
$MatrixU[$j][$i] = ($MatrixU[$j][$i]/$tempSum);
}
 
 
$sum = 0;
for($i = 0; $i < $num_of_clusters; $i++)
{
 
$sum += $MatrixU[$j][$i];
}
 
// Norm Data
for($i = 0; $i < $num_of_clusters; $i++)
{
 
$MatrixU[$j][$i] = $MatrixU[$j][$i]/$sum;
 
}
}
}
 
//print_r($MatrixCentroids);
return $MatrixU ;
 
}
// Connect to DB
$my_num = $_GET["cluster_number"];
$fuzz = $_GET["fuzz"];
require('db_connection.php');
 
$resultx=mysql_query("SELECT * FROM xdata");
$result=mysql_query("SELECT * FROM ydata");
// &#38;#916;&#38;#953;&#38;#945;&#38;#946;&#38;#940;&#38;#950;&#38;#959;&#38;#965;&#38;#956;&#38;#949; &#38;#972;&#38;#955;&#38;#945; &#38;#964;&#38;#945; &#38;#948;&#38;#949;&#38;#948;&#38;#959;&#38;#956;&#38;#941;&#38;#957;&#38;#945;
while ($a_row = mysql_fetch_array($result))
{
for($j = 1 ; $j < 17; $j++)
{
$tmp_data[$j] = $a_row[ay.$j];
 
}
}
while ($x_row = mysql_fetch_array($resultx))
{
 
  for($j = 1; $j <17; $j++)
{
$p = new Point();
$p->x = $x_row[ax.$j];
$p->y = $tmp_data[$j];
$arr[] = $p;
 
}
 
}
 
 
// Execute algorithm
 
$data_in_clusters = distributeOverMatrixU($my_num, $arr,$fuzz);
$size = sizeof($arr);
 
 
$result=@mysql_query('select * from cluster0 limit 1', $link);
 
 
if ($result) {
 
echo "O &#38;#960;&#38;#943;&#38;#957;&#38;#945;&#38;#954;&#38;#945;&#38;#962; &#38;#965;&#38;#960;&#38;#940;&#38;#961;&#38;#967;&#38;#949;&#38;#953; &#38;#954;&#38;#945;&#38;#953; &#38;#960;&#38;#961;&#38;#941;&#38;#960;&#38;#949;&#38;#953; &#38;#957;&#38;#945; &#38;#948;&#38;#953;&#38;#945;&#38;#947;&#38;#961;&#38;#945;&#38;#966;&#38;#959;&#38;#973;&#38;#957; &#38;#959;&#38;#953; &#38;#960;&#38;#961;&#38;#959;&#38;#951;&#38;#947;&#38;#959;&#38;#973;&#38;#956;&#38;#949;&#38;#957;&#38;#949;&#38;#962; &#38;#949;&#38;#947;&#38;#947;&#38;#961;&#38;#945;&#38;#966;&#38;#941;&#38;#962;...<BR>";
echo "&#38;#916;&#38;#953;&#38;#945;&#38;#947;&#38;#961;&#38;#945;&#38;#966;&#38;#942;...<BR>";
for($i = 0; $i <100; $i++)
{
 
$query="DROP TABLE cluster$i";
mysql_query($query,$link);
}
echo "H &#38;#948;&#38;#953;&#38;#945;&#38;#947;&#38;#961;&#38;#945;&#38;#966;&#38;#942; &#38;#941;&#38;#947;&#38;#953;&#38;#957;&#38;#949; &#38;#956;&#38;#949; &#38;#949;&#38;#960;&#38;#953;&#38;#964;&#38;#965;&#38;#967;&#38;#943;&#38;#945;...";
 
} 
 
for($j = 0; $j < $my_num; $j++)
{
$query_c = "CREATE TABLE cluster$j(data_points_x FLOAT NOT NULL,data_points_y FLOAT NOT NULL)";
mysql_query($query_c,$link);
}
for($i = 0; $i < $size ; $i++)
{
$max = 0;
$pos = 0;
for($j = 0; $j < $my_num; $j++)
{
$tmp_point = $data_in_clusters[$i][$j];
 
if($tmp_point > $max)
{
$max = $tmp_point;
$pos = $j;
}
 
 
}
$xxxx = $arr[$i]->x;
$yyyy = $arr[$i]->y;
 
$query="INSERT INTO cluster$pos(data_points_x,data_points_y)
values('$xxxx','$yyyy')";;
mysql_query($query,$link);
 
}
echo "<br>";
echo "<img src='db_scatter.php'  border=0 align=center width =600 height=400>";
// &#38;#917;&#38;#956;&#38;#966;&#38;#940;&#38;#957;&#38;#953;&#38;#963;&#38;#951; &#38;#928;&#38;#943;&#38;#957;&#38;#945;&#38;#954;&#38;#945; &#38;#956;&#38;#949; &#38;#964;&#38;#945; &#38;#945;&#38;#960;&#38;#959;&#38;#964;&#38;#949;&#38;#955;&#38;#941;&#38;#963;&#38;#956;&#38;#945;&#38;#964;&#38;#945;
echo "<table width='500' border='2'>";
 
 
echo "<TR><TD><B>Points</B><BR></TD>";
for($i = 0; $i < $my_num; $i++){
$xxx = $MatrixCentroids[$i]->x;
$yyy = $MatrixCentroids[$i]->y;
echo "<TD>Cluster $i Centoid:<br><b>X:$xxx Y:$yyy</b></TD>";
}
echo "</tr>";
for($i = 0; $i < $size ; $i++)
{
$x = $arr[$i]->x;
$y = $arr[$i]->y;
echo "<TR>";
echo "<TD><b>x:$x</b><br><b>y:$y</b></TD>";
for($j = 0; $j < $my_num; $j++)
{
 
$tmp_point = $data_in_clusters[$i][$j];
echo "<TD> $tmp_point</TD>";
 
}
echo "</TR>";
}
echo "</TABLE>";
 
 
?>

I am adding line items in my invoice script, while adding i validate the data. if validation fails, it will display error message with entered data filled in the form. If it clears the validation, data gets submitted to database and displays the same . Here i can add many line items, so this process should keep repeating.

Everything is working fine. But when the form submits it should display error in one place and display the submitted data in other place.

Here is my form

 

<form action="" method="post">
                                        <div class="form-row">
                                            <div class="col-md-4 mb-30">
                                                <label for="validationDefault01">Select Customer</label>
                                            <select name="customer" class="form-control" id="validationDefault01" required>
                                            <option value=""></option>
                                            <?php $c1 = mysqli_query($con, "SELECT * FROM customers WHERE status='Active'") or die (mysqli_error($con));
                                            while($c2 = mysqli_fetch_array($c1))
                                            {
                                                ?>
                                           
                                            <option value="<?php echo $c2["cid"]; ?>" <?php if($c2["cid"] == $_POST['customer'] ) { echo "selected"; }  ?> ><?php echo $c2["name"]; ?></option>
                                            <?php } ?>
                                            </select>    
                                            </div>

 
  <div class="col-md-4 mb-30">
  <label for="validationDefault02">Date</label>
 <input type="text" class="form-control" name="edate" id="datepicker" value="<?php echo isset($_POST["edate"]) ? $_POST["edate"] : $today; ?>" required />  
  </div>
  </div>                               
<!-- line item -->                               
                               <div class="table-responsive">
                             <table class="table table-active table-bordered table-sm">
                             <thead class="thead-active">

                              <tr>
                             <th>Name</th>
                            <th>Description</th>
                            <th>UOM</th>    
                            <th>Price</th>
                            <th>Stock</th>
                            <th>Qty</th>  
                            </tr>
                           </thead> 
                            <tr> 
  <td><input type="text"  id="productname" name="productname" value="<?php echo isset($_POST["productname"]) ? $_POST["productname"] : ''; ?>" required ></td> 
                               <input type="hidden"  id="productcode" name="productcode" value="<?php echo isset($_POST["productcode"]) ? $_POST["productcode"] : ''; ?>"  />
                                <td><textarea id="description" name="description"><?php echo isset($_POST["description"]) ? $_POST["description"] : ''; ?></textarea></td>
                                
                           
                                <td><select name="uom" id="uom">
                               
                                <?php $su1 = mysqli_query($con, "select * from uom");  while($su2 = mysqli_fetch_array($su1)) { 
                   
                                ?>
                                <option value="<?php echo $su2["uom_name"]; ?>" <?php if($su2["uom_name"] == $_POST['uom'] ) { echo "selected"; }  ?> ><?php echo $su2["uom_name"]; ?></option>
                                
                                <?php
                                }  
                                ?>
                                </select>
                               
                               </td> 
                               
                             <td><input type="text" required id="price" name="price"   value="<?php echo isset($_POST["price"]) ? $_POST["price"] : ''; ?>" /></td>
                             
              <td><input type="text" readonly id="stock" name="stock" value="<?php echo isset($_POST["stock"]) ? $_POST["stock"] : ''; ?>" /></td>            
                    
                   <td><input type="text"  required id="quantity" name="quantity" value="<?php echo isset($_POST["quantity"]) ? $_POST["quantity"] : ''; ?>" /></td>  
                                                       
</tr>  </table> 

<!-- line item ends--->
 <div class="form-row">
<div class="col-md-4 mb-30">
 <input name="add" class="btn btn-success" type="submit" value="Add" />
</div>
</div>                                            
</form>

form submission

<?php
 if(isset($_POST['add']))
 {
   
   
$customer = $_POST['customer'];
$edate1 = $_POST['edate'];
$edate = date('Y-m-d', strtotime((str_replace('/','-',$edate1))));
	                                            
$pname = $_POST['productname'];
$pcode = $_POST['productcode'];
$uom = $_POST['uom'];
$price = $_POST['price'];
$quantity = $_POST['quantity'];

$pc = mysqli_query($con, "SELECT min_price FROM items WHERE item_id=".$pcode."") or die (mysqli_error($con));
$prow = mysqli_fetch_array($pc);

   // This error part should be displayed inside <div id="error"></div> which is above the form 
if($price<$prow['min_price'])
{
echo  '<div class="alert alert-inv alert-inv-danger alert-wth-icon alert-dismissible fade show" role="alert">
                                        <span class="alert-icon-wrap"><i class="zmdi zmdi-bug"></i></span> Price should not be lesser than minimum price defined.
                                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                            <span aria-hidden="true">×</span>
                                        </button>
                                    </div>';   
}
else
{
  //data gets inserted into invoice table and displays submited data in table format
  // this part should be displayed below the form inside <div id="success"></div>
  
  
}
                        }

Here i am not getting how to define that displays. 

 

 

 

Hello,

I have links at above of the page. if i click a link a new page will appear.
The menu links above are same for all pages.

Which is better reloading the whole page with all menu links or keeping the above menu link permanent/unchange reloading bottom division with ajax?

I mean only one page will contain the menu.Is it better?
Or every page will contain the menu above.Is it better then the first one?

I say many web site they have link menus above if i click a link from above it seems the whole page reloads or chages.
For example:http://www.sitepoint.com/

Thank you.

I am a new developer, trying to figure out what causing a memory error. The code goes through registered appointments and depends on the service ID, I have to free a 45 minutes for another service to be booked. Now, once I book an appointment for any of the services that can have 45 minutes free spot, the website takes forever to load the hours but doesn't show them, instead I get this error

A PHP Error was encountered Severity: Error Message: Maximum execution time of 120 seconds exceeded

 

 

foreach ($appointments as $appointment) { foreach ($periods as $index => &$period) { $appointment_start = new DateTime($appointment['start_datetime']); $appointment_end = new DateTime($appointment['end_datetime']); if ($appointment_start >= $appointment_end) { continue; } $period_start = new DateTime($date . ' ' . $period['start']); $period_end = new DateTime($date . ' ' . $period['end']); $serviceId=$appointment['id_services']; $color1=1; $color2=2; $color3=3; $color4=4; $color5=5; $color6=6; $color7=7; $color8=8; $color9=9; $color10=10; $color11=11; $color12=12; $color13=13; $color14=14; $color15=15; $color16=16; $color17=17; $color18=18; $color19=19; $period_s=''; $period_e=''; if ($appointment_start <= $period_start && $appointment_end <= $period_end && $appointment_end <= $period_start) { // The appointment does not belong in this time period, so we will not change anything. continue; } else { if ($appointment_start <= $period_start && $appointment_end <= $period_end && $appointment_end >= $period_start) { // The appointment starts before the period and finishes somewhere inside. We will need to break // this period and leave the available part. //open slot for services 45,45,45 if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // // //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['start'] = $appointment_end->format('H:i'); } // //for the rest of services else { $period['start'] = $appointment_end->format('H:i');} } else { if ($appointment_start >= $period_start && $appointment_end < $period_end) { // The appointment is inside the time period, so we will split the period into two new // others. unset($periods[$index]); if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // // //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } //for other services once The code is completely correct else{ $periods[] = [ 'start' => $period_start->format('H:i'), 'end' => $appointment_start->format('H:i') ]; $periods[] = [ 'start' => $appointment_end->format('H:i'), 'end' => $period_end->format('H:i') ]; } } else if ($appointment_start == $period_start && $appointment_end == $period_end) { if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ unset($periods[$index]); $period_s= $appointment_start; $period_s->modify('+45 minutes'); $period_e= $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} // //for the rest of services else { unset($periods[$index]);} // The whole period is blocked so remove it from the available periods array. } else { if ($appointment_start >= $period_start && $appointment_end >= $period_start && $appointment_start <= $period_end) { // The appointment starts in the period and finishes out of it. We will need to remove //the time that is taken from the appointment. if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $period['end'] = $appointment_start->format('H:i'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $period['end'] = $appointment_start->format('H:i'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['end'] = $appointment_start->format('H:i'); } // // //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['end'] = $appointment_start->format('H:i'); } // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['end'] = $appointment_start->format('H:i'); } // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; $period['end'] = $appointment_start->format('H:i'); } // for the rest of services else{ $period['end'] = $appointment_start->format('H:i'); } } else { if ($appointment_start >= $period_start && $appointment_end >= $period_end && $appointment_start >= $period_end) { // The appointment does not belong in the period so do not change anything. continue; } else { if ($appointment_start <= $period_start && $appointment_end >= $period_end && $appointment_start <= $period_end) { //Open slot for service 45,45,45 if($serviceId == $color1 || $serviceId == $color3 || $serviceId == $color7 || $serviceId == $color9|| $serviceId == $color10 || $serviceId == $color11 || $serviceId == $color12){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } //Open slot for service 45,45,60 else if($serviceId == $color2 || $serviceId == $color8){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+45 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ]; } // //Open slot for service 30,45,45 else if($serviceId == $color4 || $serviceId == $color6 ||$serviceId == $color16 || $serviceId == $color18){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} //Open slot for service 30,45,60 else if($serviceId == $color5 || $serviceId == $color17){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+30 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} // // //Open slot for service 60,45,45 else if($serviceId == $color13 || $serviceId == $color15){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-45 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} // // //Open slot for service 60,45,60 else if($serviceId == $color14 ){ unset($periods[$index]); $period_s= clone $appointment_start; $period_s->modify('+60 minutes'); $period_e= clone $appointment_end; $period_e->modify('-60 minutes'); $periods[] = [ 'start' => $period_s->format('H:i'), 'end' =>$period_e->format('H:i') ];} else{ unset($periods[$index]); } } } } } } } } } return array_values($periods); }

Hello all,   Appreciate if you folks could pls. help me understand (and more importantly resolve) this very weird error:     Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, purchase_later_flag ASC, shopper1_buy_flag AS' at line 3' in /var/www/index.php:67 Stack trace: #0 /var/www/index.php(67): PDO->query('SELECT shoplist...') #1 {main} thrown in /var/www/index.php on line 67   Everything seems to work fine when/if I use the following SQL query (which can also be seen commented out in my code towards the end of this post) :  

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
           FROM shoplist, store_master, item_master
           WHERE     shoplist.store_id = store_master.store_id
                   AND shoplist.item_id = item_master.item_id";

  However, the moment I change my query to the following, which essentially just includes/adds the ORDER BY clause, I receive the error quoted above:

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name 
		FROM shoplist, store_master, item_master 
		ORDER BY purchased_flag ASC, 
				purchase_later_flag ASC, 
				shopper1_buy_flag ASC, 
				shopper2_buy_flag ASC, 
				store_name ASC) 
		WHERE 	shoplist.store_id = store_master.store_id 
				AND shoplist.item_id = item_master.item_id";

In googling for this error I came across posts that suggested using "ORDER BY FIND_IN_SET()" and "ORDER BY FIELD()"...both of which I tried with no success.   Here's the portion of my code which seems to have a problem, and line # 67 is the 3rd from bottom (third last) statement in the code below:  

                    <?php
                        /*
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        */
                    
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                ORDER BY FIND_IN_SET(purchased_flag ASC,
                                                 purchase_later_flag ASC,
                                                 shopper1_buy_flag ASC,
                                                 shopper2_buy_flag ASC,
                                                 store_name ASC)
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        $result = $pdo->query($sql);                        
                        
                        // foreach ($pdo->query($sql) as $row) {
                        foreach ($result as $row) {
                            echo '<tr>';
                                print '<td><span class="filler-checkbox"><input type="checkbox" name="IDnumber[]" value="' . $row["idnumber"] . '" /></span></td>';

    Thanks  

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\mywork\unique.php on line 15


<html>
<head>
<title>

</title>
</head>
<body bgproperties="fixed">
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$con = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'mywork';
mysql_select_db($dbname, $con);
$sql=mysql_query(insert into users (regno,name,gender,date,month,year,emailid,cell,paddress,caddress,incometype,incomeamt,dad,fyes,dadocup,mom,myes,momocup,password) VALUES ('$_POST[regno]','$_POST[name]','$_POST[gender]','$_POST[date]','$_POST[month]','$_POST[year]','$_POST[emailid]','$_POST[cell]','$_POST[paddress]','$_POST[caddress]','$_POST[incometype]','$_POST[incomeamt]','$_POST[dad]','$_POST[fyes]','$_POST[dadocup]','$_POST[mom]','$_POST[myes]','$_POST[momocup]','$_POST[password]')");
$sql1=mysql_fetch_array($sql);
$result = @mysql_query($SQl1);
$result="SELECT * FROM users WHERE regno='$regno'";
while($row = mysql_fetch_array($result))
{
    //echo $row['regno']."regno<br>";
//echo $row['name']."name<br>";
//echo $row['gender']."gender<br>";
//echo $row['date']."date<br>";
//echo $row['month']."month<br>";
//echo $row['year']."year<br>";
//echo $row['emailid']."emailid<br>";
//echo $row['cell']."cell<br>";
//echo $row['paddress']."paddress<br>";
//echo $row['caddress']."caddress<br>";
//echo $row['incometype']."incometype<br>";
//echo $row['incomeamt']."incomeamt<br>";
//echo $row['dad']."dad<br>";
//echo $row['fyes']."fyes<br>";
//echo $row['dadocup']."dadocup<br>";
//echo $row['mom']."mom<br>";
//echo $row['myes']."myes<br>";
//echo $row['momocup']."momocup<br>";
//echo $row['password']."password<br>";

}
echo "Thanks for Register!";
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";
mysql_close($con);
?>
<form name="security" action="index.php" method="post">

<input type="submit" value="click here to login">
</form>
</body>
</html>

Code: [Select]
<?php
mysql_connect ("-","-","-") or die ('Error');
mysql_select_db ("-");

$out = mysql_query("SELECT * FROM guestbook ORDER BY id DESC");

while($row = mysql_fetch_assoc($out); --and this one if that braces is deleted
{ ----this is where im getting the error
$name = $row['name'];
$email = $row['email'];
$txt = $row['comment'];

        $msg = "Are you sure you want to delete";

/* @var $_REQUEST <type> */
if (isset($_REQUEST ["action"]) && $_REQUEST["action"] == "del") 
    {
                    $id = intval($_REQUEST['id']);
                    mysql_query("DELETE FROM guestbook WHERE id=$id;");
                   echo "<action=index.php>";
                }

echo "<font face='verdana' size='1'>";
echo "<table border='0'>
<tr><td>Name: ".$name."</td></tr>"."
<tr><td>Email: ".$email."</td></tr>
<tr><td colspan='2'>Comment:</td></tr>
<tr><td colspan='2' width='500'><b>".$txt."</b></td></tr>
                     <tr><td><a onclick=\"return confirm('.$msg.');\" href='index.php?action=del&amp;id=".$row['id']."'><span class='red'>["."Delete"."]</span></a>
                        </td></tr>
  </table><br />";


echo "<hr size='1' width='500' align='left'></font>";
}
?>

Kindly help me please. When i delete ({) the error will become the ( i dont know what to do already. Thanks.

   $BoxSize = array("smallbox" = array("length" => 12, "width" => 10, "depth" => 2.5),
      "mediumbox" = array("length" => 30, "width" => 20, "depth" => 4),
      "largebox" = array("length" => 60, "width" => 40, "depth" => 11.5));
      

Hi folks,

I am a complete n00b at php and mysql. I am teaching myself from books and the WWW, but alas I am stuck...

the error I get is:
Parse error: syntax error, unexpected T_STRING in X:\xampp\htdocs\search.php on line 7

here is the code:




<?php
  
  mysql_connect ("localhost", "user", "password") or die (mysql_error());
  mysql_select_db ("it_homehelp_test") or die (mysql_error());
  
  $term = $_POST['term'];
  $sql = $mysql_query(select * from it_homehelp_test where ClientName1 like '%term%');   <<<------this is line 7
  while ($row = mysql_fetch_array($sql)){
   echo 'Client Name:' .$row['ClientName1'];
echo 'Address:' .$row['Address1'];
echo 'Phone:' .$row['Tel1'];
}
?>



Any help you can offer would be great. I can also post the ".html" file that creates the search bar if it is needed.

Thanks

I just enabled error reporting and I am not that familiar with it.  I know I have an error some where around line 33.  I know I am missing a bracket or a comma or some other syntax error I just cannot find where the error is.  Below is my script.
Thanks for any help.

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Airline Survey</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<meta name="author" content="Revised by abc1234"/>
</head>
<body>
<?php
$WaitTime = addslashes($_POST["wait_time"]);
$Friendliness = addslashes($_POST["friendliness"]);
$Space = addslashes($_POST["space"]);
$Comfort = addslashes($_POST["comfort"]);
$Cleanliness = addslashes($_POST["cleanliness"]);
$Noise = addslashes($_POST["noise"]);
if (empty($WaitTime) ||
    empty($Friendliness) ||
    empty($Space) ||
empty($Comfort) ||
    empty($Cleanliness) ||
    empty($Noise))
    echo "<hr /><p>You must enter a value in each field. Click
     your browser's Back button to return to the form.</p><hr />";
else {
        $Entry = $WaitTime . "\n";
        $Entry .= $Friendliness . "\n";
        $Entry .= $Space . "\n";
        $Entry .= $Comfort . "\n";
        $Entry .= $Cleanliness . "\n";
        $Entry .= $Noise . "\n";
        $SurveyFile = fopen("survey.txt", "w")
}
        if (flock($SurveyFile, LOCK_EX)) {
                if (fwrite($SurveyFile, $Entry) > 0) {
                        echo "<p>The entry has been successfully added.</p>";
                        flock($SurveyFile, LOCK_UN;
                        fclose($SurveyFile);
  else
                        echo "<p>The entry could not be saved!</p>";
        }
        else
                echo "<p>The entry could not be saved!</p>";
}
?d>
<p><a href="AirlineSurvey.html">Return to Airline Survey</a></p>
</body>
</html>

I have been trying to get my files to upload onto a computer and I receive this message: Parse error: syntax error, unexpected T_STRING in /home/content/19/6550319/html/listing.php on line 27. Line 27 is how the php logs into my SQL. The problem is that I was able to log in before. I just made changes to the form by adding a dropdown menu and price and now it says it doesnt parse.

Can anyone figure this out. I will include the code without the login information because the forum is public but I did put the words left out for you to see where I took out the passcodes.

Code: [Select]
<?php




//This is the directory where images will be saved
$target = "potofiles/";
$target = $target . basename( $_FILES['photo']['name']);

//This gets all the other information from the form
$price=$_POST['price'];
$gig=$_POST['giga'];
$yesg=$_POST['yesg'];
$pic=($_FILES['photo']['name']);
$pic2=($_FILES['phototwo']['name']);
$pic3=($_FILES['photothree']['name']);
$pic4=($_FILES['photofour']['name']);
$description=$_POST['iPadDescription'];
$condition=$_POST['condition'];
$fname=$_POST['firstName'];
$lname=$_POST['lastName'];
$email=$_POST['email']



// Connects to your Database
mysql_connect ("left out", "left out", "left out") or die(mysql_error()) ;
mysql_select_db("left out") or die(mysql_error()) ;

//Writes the information to the database
mysql_query("INSERT INTO listing (price,giga,yesg,photo,phototwo,photothree,photofour,iPadDescription,condition,firstName,lastName,email)
VALUES ('$price', '$gig', '$yesg', '$pic', '$pic2', '$pic3', '$pic4', '$description', '$condition', '$fname', '$lname', '$email')") ;

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $target))
{

//Tells you if its all ok
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory";
}
else {

//Gives and error if its not
echo "Sorry, there was a problem uploading your file.";
}

echo date("m/d/y : H:i:s", time()) 


?>

Hello everyone,
I am a total newbie in PHP and so do here. I am trying to build a table consisting foreign key and primary key and it is showing error like "Parse error: syntax error, unexpected 'cities' (T_STRING) in line number 29". I have marked up my lines according to sublime text 3 editor. I am trying to create a database. 

 

1 <?php
2 $servername = "localhost";
3 $username = "username";
4 $password = "password";
5 $dbname = "newDB";

7 // Create connection
8 $conn = new mysqli($servername, $username, $password, $dbname);

10 // Check connection
11 if ($conn->connect_error) {
12   die("Connection failed: " . $conn->connect_error);}

14 $firstname = $conn->real_escape_string($_REQUEST['firstname']);
15 $lastname = $conn->real_escape_string($_REQUEST['lastname']);
16 $address = $conn->real_escape_string($_REQUEST['address']);
17 $city = $conn->real_escape_string($_REQUEST['city']);
18 $country = $conn->real_escape_string($_REQUEST['country']);
19 $phone_number = $conn->real_escape_string($_REQUEST['phone_number']);
20 $email = $conn->real_escape_string($_REQUEST['email']);
 
22 // Attempt insert query execution
23 $sql1 = "INSERT INTO cities VALUES ('$city')";

25 $sql2 = "INSERT INTO countries VALUES ('$country')";

27 $sql3 = "INSERT INTO Contacts (firstname, lastname, address, city, country, phone, email) VALUES ('$firstname', '$lastname', '$address', $city, $country, '$phone_number','$email')";

29 SELECT * FROM cities;
SELECT * FROM countries;
SELECT * FROM Contacts;

if($conn->query($sql1) === true){
    echo "City added successfully.";
} else{
    echo "ERROR: Could not able to execute " . $conn->error;
}

if($conn->query($sql2) === true){
    echo "Çountry added successfully.";
} else{
    echo "ERROR: Could not able to execute " . $conn->error;
}

if($conn->query($sql3) === true){
    echo "Çontact added successfully.";
} else{
    echo "ERROR: Could not able to execute " . $conn->error;
}
 
// Close connection
$conn->close();
?>

I don`t get it, waht is wrong?!
Code: [Select]
<?php
require_once 'auth.php';
if (!isset($_SESSION['SESS_VERIFY'])) {
header("location: access-denied.php");
exit();
}
if ($_SESSION['lang'] == 'Ro') {

// setare data romania
date_default_timezone_set('Europe/Bucharest');

$today = getdate();


$zi = $today['mday'];
$luna = $today['mon'];
$lunastring = $today['month'];
$an = $today['year'];
$data = $zi.$luna.$an;
$data = (string)$data;
$ora = date('H:i:s'); 

$msg = array();
$err = array();

$luni = array (
1=>'Ianuarie',
2=>'Februarie',
3=>'Martie',
4=>'Aprilie',
5=>'Mai',
6=>'Iunie',
7=>'Iulie',
8=>'August',
9=>'Septembrie',
10=>'Octobrie',
11=>'Noiembrie',
12=>'Decembrie');

// comun
const SQL_ERR = 'SQL statement failed with error: ';
const ADD_MODEL = 'ADAUGA UN MODEL NOU';
.
.many constants..
.
}
elseif ($_SESSION['lang'] == 'It') {...

Thank you!