Learn VBA & Macros in 1 Week!

PHP - Classes Error

Full Excel VBA Course - Beginner to Expert

Classes Error	View Content

OK, im not too crash hot on classes, so hoping someone can help me with this error:
Quote

Fatal error: Call to a member function add_current_page() on a non-object in /path/to/includes/application_top.php on line 312

This is from an osCommerce application (I know someone will probably tell me to post in 3rd party scripts, but I am more interested in whats generally causing the error). The thing that confuses me is that application_top.php is only 236 lines long.

Full Excel VBA Course - Beginner to Expert

Parse Error: Syntax Error, Unexpected 'public' (t_public) In C:\xampp\htdocs\social\classes\post.php On Line 39

Similar Tutorials

View Content

<?php
class Post{
	private $user_obj;
	private $con;

	public function __construct($con, $user){
  	$this->con = $con; 
   	$this->user_obj =  new User($con,$user);
	}
	public function submitPost($body,$user_to){
	$body = strip_tags($body);////Removing HTML TAGS
	$body = mysqli_real_escape_string($this->con,$body);
	$check_empty = preg_replace('/\s+/', '', $body);//delte all spaces

	if($check_empty != ""){


	//Current Date and time
	$date_added = date("Y-m-d H:i:s");

	//get username
	$added_by = $this->user_obj->getUsername();

	//if user have not a profile send to the none
	if($user_to == $added_by){
	$user_to = "none";
	}
	////insert query
	$query = mysqli_query($this->con,"INSERT INTO posts VALUES('','$body','$added_by','$user_to','$date_added','no','no','0')");
	$retured_id = mysqli_insert_id($this->con);

	//insert notification

	//Update post count for user
	$num_post = $this->user_obj->getNumPosts();
	$num_post++;
	$update_query = mysqli_query($this->con,"UPDATE users SET num_post = '$num_post' WHERE username = '$added_by'" );
}
	public function loadPostsFriends(){
	$str = ""; //string to return
	$data = mysqli_query($this->con,"SELECT * FROM posts where deleted = 'no' ORDER by id DESC");
	while($row = mysqli_fetch_array($data))
	{
		$id = $row['id'];
		$body = $row['body'];
		$added_by = $row['added_by'];
		$date_time = $row['date_added'];

		/// Creating user post on other user profile
		if($row['user_to'] == "none"){
			user_to = "";
			else {
             $user_to_obj = new User($con,$row['user_to']);
             $user_to_name = $user_to_obj->getFirstandLastname();
             $user_to = "to <a href='" . $row['user_to'] . "'>" .$user_to_name . "</a>";
			}
			// check if user account was closed 
			$added_by_obj = new User($this->con,$added_by);
			if($added_by_obj ->isClosed()){
				continue;
			}
			$user_details_query = mysqli_query($this->con,"SELECT first_name,last_name,profile_pic FROM users where username = '$added_by'");
			$user_row = mysqli_fetch_array($user_details_query);
			$first_name = $user_row['first_name'];
			$last_name = $user_row['last_name'];
			$profile_pic= $user_row['profile_pic'];

			///time stamp
			$date_time_now = date("Y-m-d H:i:s");
			$start_date = new Date_Time($date_time);////Time_of_post
			$end_date = new Date_Time($date_time_now);///Current_time
			$intervel = $start_date->diff($end_date);
			if($intervel->y >< 1 ){
            if($intervel ==1 )
            	$time_message = $intervel->y . " year ago";/// 1 Year Ago
            else
            	$time_message = $intervel->y . " years ago"; //1+ year ago
			}
			else if($intervel-> m >= 1 ){
				if($intervel->d == 0){
					$days = " ago";
				}
				else if($intervel->d == 1){
					$days = $intervel->d."day ago";
				}
				else
				{
					$days = $intervel->d."day ago";
				}
				if($intervel->m == 1){
					$time_message = $intervel->m." month".$days;
				}
				else 
					$time_message = $intervel->m." months".$days;
			}
		}
		else if($intervel->d >= 1){
				if($intervel->d == 1){
					$days = "Yesterday";
				}
				else
				{
					$days = $intervel->d."days ago";

				}
		
			}
			else if($intervel->h >= 1){
				if($intervel->h == 1){
					$time_message = $intervel->h." hour ago";
				}
				else
				{
					$time_message = $intervel->h." hours ago";

				}

		}
		else if($intervel->i >= 1){
				if($intervel->i == 1){
					$time_message = $intervel->i." minute ago";
				}
				else
				{
					$time_message = $intervel->i." minutes ago";

				}
	}
			else{
				if($intervel->s < 30){
					$time_message = "Just Now";
				}
				else
				{
					$time_message = $intervel->s." seconds ago";

				}
				
			}
			$str .= "<div class='status_post'>
				         <div calss='post_profile_pic'>
				         <img src='$profile_pic' width='50'> 	
				        </div>
				        <div calss='posted_by' style='color#ACACAC;'>
				        <a href = '$added_by'> $first_name $last_name </a> $user_to &nbsp;&nbsp;;&nbsp;;&nbsp;$time_message
				        </div>
				        <div id = 'post_body'$body<br></div>
				         </div>
				"
			
		}
		echo $str;
	}
}
?>

When i run this code this show me the error Parse error: syntax error, unexpected 'public' (T_PUBLIC) in C:\xampp\htdocs\social\Classes\Post.php on line 39

the line 39 is public function loadPostsFriends()

I check the code again and again but i cant find the error please help in this error

Classes Related Error

Similar Tutorials

View Content

Hello again!

I've been trying out new things (well, new for me) in php again. This time I decided to try a real challenge and make a forum system. A friend suggested I use a class for all database functionalities. i was reluctant at first, but decided if I was going to try using classes for the first time, it might as well be with this. With some guiding help, I set up the files and gave it a visual once over to check for errors. Nothing seemed out of place, but when I loaded the page to try it out, I got this error:

Quote

Fatal error: Call to a member function query() on a non-object in /home/ck9/public_html/planning/forumbuild/list.php on line 20

I didn't see anything out of line, so I consulted my friend about it. He made a few small adjustment suggestions, but nothing fixed the issue. I then bugged my host about it, and he couldn't find anything wrong either. Both people are highly experienced in php, so when they say it SHOULD be working I am left rather confused.

Here is list.php:
Code: [Select]
<?php
include("db.class.php");
include("db.config.php");

$db = new databaseConnection($config['user'],$config['pass'],$config['database']);
$g = $_GET['g'];
$s = $_GET['s'];
$t = $_GET['t'];

function tablestart($a = '1')
  {
   global $db;

   echo "<table border='" . $a . "' cellpadding='10' cellspacing='0' align='center' width='80%' style='color: #C0C0C0'>\n";
  }
function contents($table, $a, $b = '1', $c = '1')
  {
   global $db;

   $db->query("SELECT * FROM $table");

   while($row = $db->fetch_array())
    {
     if($row['level'] <= $_SESSION['ulevel'])
      {
       echo "<tr><td width='5%'></td><td width='80%'><a href='index.php?pg=h&g='" . $row['g'];
       if(($a > '1') && ($row['g'] == $b))
        {
         echo "&s=" . $row['s'];
         if(($a > '2') && ($row['s'] == $c))
          {
           echo "&t=" . $row['t'];
          }
        }
      }
     echo "' style='color: #C0C0C0 ; text-decoration: none'><font size='4'>" . $row['name'] . "</font><br /><fpnt size='3'>" . $row['desc'] . "</td><td width='15%'></td></tr>\n";
    }
  }

if(empty($_SESSION['ulevel']))
  {
   $_SESSION['ulevel'] = '0';
   echo "<font color='#CC0000'><center>You need to register to post in these forums.</center></font><br />\n";
  }

if(empty($g))
  {
   tablestart();
   contents('group', '1');
   echo "</table>\n";
  }
elseif(empty($s))
  {
   tablestart();
   contents('section', '2', $g);
   echo "</table>\n";
  }
elseif(empty($t))
  {
   tablestart('0');
   echo "<tr><td width='80%'></td><td></td></tr>\n</table>\n";
   tablestart();
   contents('topic', '3', $g, $s);
   echo "</table>\n";
  }
elseif(!empty($t))
  {
   tablestart('0');
   echo "<tr><td width='80%'></td><td></td></tr>\n</table>\n";
   $data = file_get_contents('topics/g' . $g . 's' . $s . 't' . $t . '.txt');
   $post = explode("", $data);
   $length = count($post);
   tablestart('1');
   for($z = '0'; $z < $length; $z ++)
    {
     $i = '0';
     $cont = explode("", $post[$pos]);
     echo "<tr><td><b>" . $cont[$i] . "</b><br /></td><td>\n<table width='100%' style='font-size: xx-small'>\n<tr><td height='3' width='75%'>";
     $i ++;
     echo "Posted on" . $cont[$i] . "</td><td height='3' width='25%'></td></tr><tr><td width='100%'>";
     $i ++;
     echo $cont[$i] . "</td></tr></table></td></tr>\n";
    }
   echo "</table>\n";
  }
?>
My aim here was to have a single page to display the groups, sections, topics, and posts in order to keep database calls where I could find them easily.

and here is the class file:

Code: [Select]
<?php
class databaseConnection
{
  protected $link;
  protected $lastResult;
  function databaseConnection($user,$pass,$database)
   {
    $this->link = mysql_connect("localhost",$user,$pass);
    if( !$this->link )
     {
      die('Vital information missing.');
     }
    else
     {
      mysql_select_db($database,$this->link) or die('could not find database: ' . mysql_error());
     }
   }
  function query($query)
   {
    $this->lastresult = mysql_query($query) or die('MySQL error: ' . mysql_error());
    return $this->lastresult;
   }
  function fetch_array($result = false)
   {
    if(!$result)
     {
      return mysql_fetch_array($this->lastresult);
     }
    else
     {
      return mysql_fetch_array($result);
     }
   }
}
?>
I have tried everything from adjusting the php tags to putting the class directly in the page.

The config file just provides the user, pass, and which database to connect to. I've checked it's formatting a few times just in case.

Php Error I Just Can't Figure Out, Deals With Classes

Similar Tutorials

View Content

Here is the code:

Code: [Select]
<?php
if (!defined('INCLUDE_GUARD'))
{
header("Location: /errors/forbidden");
return;
}

include_once("incs/cls/DatabaseManager.class.php");
include_once("incs/cls/VariantTemplate.class.php");

class Core
{
private $_logger;
private $_self_test_results;
private $_config;
private $_dbmgr;
private $_vtemp;

public __construct() // this is line 19
{
$this->setupLogger();
$this->_self_test_results = array();
$this->_self_test_results['missing'] = array();
$this->_self_test_results['failed'] = array();
$this->_config = array();
$this->_dbmgr = null;
$this->_vtemp = null;
$this->selfTest();
}

Here is the error I've been receiving.

Parse error: syntax error, unexpected T_STRING, expecting T_VARIABLE in /home/ditecha1/public_html/slick/incs/cls/SlickCMSCore.class.php on line 19

I am finding this error extremely weird, my host uses PHP 5.2.14. I was setting the private variables directly (without the assistance of the constructor), but I removed this and had the constructor set basic values to start with to see if this was the issue, but it wasn't. I've tried commenting out the include_once lines, since they are also in development I thought maybe an error was being carried over in to this file as the includes were happening, but still no change in the error message at all.

Any help would be greatly appreciated!

Php Classes - Tricks For Loading Classes Within Classes

Similar Tutorials

View Content

I've been spending long hours learning about classes and their magic methods. I just came across a tutorial which showed a constructor like this:

class Device {
    //...
    public function  __construct(Battery $battery, $name) {
        // $battery can only be a valid Battery object
        $this->battery = $battery;
        $this->name = $name;
        // connect to the network
        $this->connect();
    }
    //...
}

the Battery part instantly caught my attention. Here had previously made a Battery class (and a more complete Device class) but the next thing he did really caught my interest:

$device = new Device(new Battery(), 'iMagic');
// iMagic connected
echo $device->name;
// iMagic

what the hell is going on here? Is this another way to include the methods and properties of one class into another class, in order words is this the same thing as:

class Device extends Battery

I don't think so because this new Battery() thing looks more like its creating an object inside the Device object. Previously the only way I could to that was to type $battery = new Battery() inside one of my methods. But this looks like hes doing something different. Can anyone explain whats going on here? The whole tutorial is he http://code.tutsplus...-php--net-13085 in the main Device method he has a premade $battery variable to hold the Battery object. Sometimes I have multiple classes containing functions which I'd like to include in my main class. I can only extend one class, so I usually extent a class containing only properties, no methods. I still don't know what difference making that info class abstract is, I'd appreciate if anyone could tell me. Also I'd love to know what the point in static methods is. I've never used them because I've never seen the point. Is it just to make it easier to call the methods because you don't need to create an object instance to call them? Sorry for the extra questions, the first one is what I'm really wondering about.

Unrelated Classes Within Classes(?)

Similar Tutorials

View Content

Not sure how to describe what I'm trying to do here in the title, but here goes with what I am trying to accomplish.

I've got a few hundred lines of code in total so far, so I'll try to keep it as short as I can. I've got an application that I am programming using classes for each module and right now I am coding the base classes that I need in order for it to run (database, errors, logging, etc). What I'm doing for my database class is I have a query factory and it extends the MySQLi class so I can process, clean and code the rest of my app faster. I also have another, unrelated class "Error", which will be used for processing errors I might come across.

I'd rather do it this way instead of having to call trigger_error and error_log every time there is an error. I'd also not like to have to call a new instance of an object every time I need to use something from that class. Is there any way I can call a class within a class and return it as an object for all the methods within the class?

I've tried the methods below, but no luck I've tried others, but I'm trying to keep it brief and get what I'm trying to do across.

<?php

class QueryFactory extends MySQLi {

public  $err = new error(); //Doesn't work.
public  $err = error(); //Nope.

#This is the function that I need the $err object for.
function set($fields, $newvals) {

if ( is_array($fields) && is_array($newvals) ) {

if ( count($fields) != count($newvals) ) {
//Instead of below, I want to do something like $err->('Array lengths must match for method', 256, $islogged = 1);
                              trigger_error('Array lengths must match for method', 256);
}

}
}

}

The thing is, I have a "run.inc.php" which does include and create new objects for running just the basic app and if I try to redeclare the error class in query.class.php, it gives me an error saying I can't do that, but if i try to call $err from the page that has all the classes defined it throws an error saying that my method is undeclared. I'd like my error class be available to every other class I create so I can display and log errors as needed. Any suggestions or links to point me where I'd like to go?

Classes Help

Similar Tutorials

View Content

Take the following example:

<?php
class a {
var $things;
public function __construct($stuff) {
$this->things = $stuff;
}
}
class b {
var $morethings;
$this->morethings = "something";
}

$c = new a(new b);

echo $c->things->__PARENT__;
?>

The line "echo $c->things->__PARENT__;" (as you can probably imagine) does not work. How would I output what the 'b' object is stored in ('a')?

Classes Help

Similar Tutorials

View Content

ini_set('display_errors', 1);
error_reporting(E_ALL);

class A
{
    private function operation1() //only be used inside this class
    {
        echo 'operation1 called';
    }
    protected function operation2() //only inside this class
    {
        echo 'operation2 called';
    }
    public function operation3() //public can be used in any class
    {
        echo 'operation3 called';
    }
}
class B extends A
{
    function _construct()
    {
        //$this->operation1();
        //$this ->operation2();
        $this->operation3();

    }
}

$b = new B;

can someone please tell me why this code doesn't work ?

Classes

Similar Tutorials

View Content

How can i get my class to be showed on the front page
here is the front page
<?php
require('ex2.php');
$start = new A();
$tart->Display();
?>
now here is ex2.php
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);

class A
{
public $title = "test1";
public $end = "test2";
}
function __set($name, $value)
{
$this->$name = $value;
}
function Display()
{
echo $title;
echo $end;
}

?>
shoudn't this print test1 and test2 ?

Php Classes

Similar Tutorials

View Content

If I have defined an instance of a class in one script how do I then use this same instance and the same variable in other scripts? For example say I have this code in a file called "index.php"

include("myclass.class.php");

$myclass = new myClass;

$myclass->$variable = "hello world";

However if I then have this code in a file called "page1.php" when I try to access the same variable it is empty.

include("myclass.class.php");

echo($myclass->$variable)

How can I use the same instance of this class across all files keep the variable values the same?

Thanks for any help.

Help With Php Classes

Similar Tutorials

View Content

Hi, I want to build a simple calculator class and one of the function is to calculate the factorial, but for some reason I cannot get this to work.

Here is class:
=========
Code: [Select]
<?php
class Calculator {

function factorial($n) {
if($n==1)
return 1;
else
return factorial($n-1)*$n;
}
}//END CLASS Calculator

$calculator=new Calculator();
print $calculator->factorial(3);
?>

But it doesn't work, I know this is simple but I am a little rusty with object oriented programming.

I'd appreciated any help!

Classes

Similar Tutorials

View Content

Hello,

maybe back to basics, but

[PHP] pobierz, plaintext

Help With Classes

Similar Tutorials

View Content

Classes

Similar Tutorials

View Content

Hi.

I want to know how I access calsses in PHP. I mean how I search for class that I want and need. do I need to search in php.net? and what editors that provide access the the whole php classes and who they keep updated?

Cheers.

Classes

Similar Tutorials

View Content

im currently doing a large php project and i am confident i can do it. Its a basic forum like phpbb or mybb where users can download the files and instal. however i have looked through their code and i see they use classes. I have never learned to do classes since i havent had to use them yet. should i be using them now for this project? do i need to? and if so then what are the benefits?

Classes

Similar Tutorials

View Content

Hello All,

I am fairly new to PHP class development, and I was wondering if it is normal behaviour to see classes not being able to access global variables related to PHP-based requests ($_GET, $_SESSION, etc.)? I seem to either have to use "global <var>" inside of the class to access the data, or I am forced to change the methods so then such required data is passed in as parameters. Perhaps I am just doing something wrong?

Here is an example of what I mean:

class Something
{
       function aFunc()
       {
               if (isset($_SESSION['somedata'])) { return false; } // this always returns false whether I had set the value or not
       }
       function bFunc()
       {
              global $_SESSION; // figured this would already be in a global accessible scope
              if (isset($_SESSION['somedata'])) { return false; } // now this will return false only when the value is set
       }
}

Now the above example is commented to demonstrate what I was meaning above, and I was wondering if this was the 'norm' when developing classes for PHP (and thus such values should be passed as parameters)?

Thanks!

Php Classes

Similar Tutorials

View Content

I have just start using PHP classes and was wondering how you continue an instance of a class in another file. For example I have a folder called "includes" where I includes files that I send data to when I perform ajax request. However how do I continue an instance of class in these files? Hope that makes sense.

Thanks for any help.

Php Classes

Similar Tutorials

View Content

Hi there, This might a newbie question but I need help understanding PHP classes which am currently learning. I have an index page. With this three included files. database.php config.php account.php on database.php, the class is declared using $connection new Database(...), on this page is also all the coding for this class. In config.php is a declared class of $account new Account($user_id); and on account.php is all the details for the account class. on the index.php is echo $account->sayHello; However, My page is throwing out an error because I'm trying to use $connection->query(..) in my account.php / Account class. I have tried to extend the Account class with Database but still have no luck. How can I make sure the I can use a class function from another page in my Account class? Thanks for reading

A Php Error Was Encountered Severity: Error Message: Maximum Execution Time Of 120 Seconds Exceeded Error

Similar Tutorials

View Content

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); }

Fatal Error: Uncaught Exception 'pdoexception' With Message 'sqlstate[42000]: Syntax Error Or Access Violation: 1064 You Have An Error In Your Sql Syn

Similar Tutorials

View Content

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

Understanding Php Classes

Similar Tutorials

View Content

Let's see....

You add values to variables but you can declare them before assigning a value...
Loops are great - they do things until a specific criteria is met....then I exit or break out of them.
Functions are code that do specific tasks (or series of tasks) & can be called upon at any given time during a script.
An array is like a....hotel with many different rooms - each room being a different value.
I get GET and POST...and know how to use them between pages.
Sessions can be used to pass data between pages - they help to keep track of things....
Cookies are like little signatures from your script that you can give to a users browser for any number of reasons.

I guess you could say I'm starting to get it. It's only been 4 months.

That being said can someone give me a brief and yet simple summary of what a PHP Class is...