Skip to main content

Posts

Recent posts

New Object-Oriented Features

The new OO features are too numerous to give a detailed description in this section. Chapter 3, “PHP 5 OO Language,” details each feature.The following list provides the main new features:

public/private/protectedaccess modifiers for methods and properties.Allows the use of common OO access modifiers to control access tomethods and properties:




class MyClass {
private $id = 18;
public function getId() {
return $this->id;
}
}


Unified constructor name__construct().
Instead of the constructor being the name of the class, it is now declared as __construct(), which makes it easier to shift classes inside class hierarchies:


class MyClass {
function __construct() {
print "Inside constructor";
}
}

Object destructor support by defining a __destructor() method.Allows defining a destructor function that runs when an object is destroyed:




class MyClass {
function __destruct() {
print ”Destroying object”;
}

}

Interfaces.

Gives the ability for a class to fulfill more than one is-a relati…

Array Sorting Function

arsort — Sort an array in reverse order and maintain index association
asort — Sort an array and maintain index association
compact — Create array containing variables and their values
count — Count all elements in an array, or something in an object
current — Return the current element in an array
each — Return the current key and value pair from an array and advance the array cursor
end — Set the internal pointer of an array to its last element
extract — Import variables into the current symbol table from an array
in_array — Checks if a value exists in an array
key — Fetch a key from an array
krsort — Sort an array by key in reverse order
ksort — Sort an array by key
list — Assign variables as if they were an array
natcasesort — Sort an array using a case insensitive "natural order" algorithm
natsort — Sort an array using a "natural order" algorithm
next — Advance the internal array pointer of an array
pos — Alias of current
prev — Rewind the internal array poin…

PHP MySQL Function

mysql_affected_rows — Get number of affected rows in previous MySQL operation mysql_client_encoding — Returns the name of the character set mysql_close — Close MySQL connection mysql_connect — Open a connection to a MySQL Server mysql_create_db — Create a MySQL database mysql_data_seek — Move internal result pointer mysql_db_name — Retrieves database name from the call to mysql_list_dbs mysql_db_query — Selects a database and executes a query on it mysql_drop_db — Drop (delete) a MySQL database mysql_errno — Returns the numerical value of the error message from previous MySQL operation mysql_error — Returns the text of the error message from previous MySQL operation mysql_escape_string — Escapes a string for use in a mysql_query mysql_fetch_array — Fetch a result row as an associative array, a numeric array, or both mysql_fetch_assoc — Fetch a result row as an associative array mysql_fetch_field — Get column information from a result and return as an object mysql_fetch_lengths — Get the length of ea…

SQL Joins

1. Login in to the mysql client using the login name and password provided by your instructor (if
not already logged in).

2. View the existing databases that the MySQL Server is maintaining.

SHOW DATABASES;

3. Utilize the photo_album database.

USE photo_album;

---- If Need be, recreate the database and load the SQL data
in that will be used for this lab

CREATE DATABASE photo_album;
SOURCE /tmp/photo_album.sql;

4. Query the database to display the active primary customer (email, first and last name) and all
the associated active login names associated with that customer.

SELECT customers.email_customer, customers.fname,customers.lname, logins.login_name FROM customers, loginsWHERE customers.email_customer = logins.email_customer AND customers.active_customer = 'True' AND logins.active_login = 'True';

SQL DML Commands

1. Login in to the mysql client using the login name and password provided by your instructor (if
not already logged in).

2. View the existing databases that the MySQL Server is maintaining.

SHOW DATABASES;

3. Utilize the photo_album database.

USE photo_album;
---- If Need be, recreate the database and load the SQL data
in that will be used for this lab
CREATE DATABASE photo_album;
SOURCE /tmp/photo_album.sql;

4. Search the customers records for the customer with the following e-mail address:
hollywood@truedog.com

SELECT * FROM customers WHERE email_customer ='hollywood@truedog.com'\G

5. Search the logins records for logins associated with the customer identified in step 4.

SELECT * FROM logins WHERE email_customer ='hollywood@truedog.com';

6. In the customers table, update the customers e-mail address, identified in step 4, to
howleewood@truedog.com.

UPDATE customers SET email_customer = 'howleewood@truedog.com'
WHERE email_customer = 'hollywood@truedog.com';

7…

SQL Expressions

1. Login in to the mysql client using the login name and password provided by your instructor (if
not already logged in).

2. View the existing databases that the MySQL Server is maintaining.

SHOW DATABASES;

3. Utilize the photo_album database.

USE photo_album;

---- If Need be, recreate the database and load the SQL data in that will be used for this lab

CREATE DATABASE photo_album;
SOURCE /tmp/photo_album.sql;

4. Calculate how many days ago each person logged into the photo_album system. Note:
Difference in dates are returned in microseconds when directly subtracted from each other.

SELECT login_name, ROUND((NOW() - last_login)/24/60/60/60)
FROM logins;

5. List the actual day name (Monday, Tuesday, etc.) for the last logins to determine if there is a
trend in the day of the week for the last time a person logged into the photo_album system.

SELECT login_name, DAYNAME(last_login) FROM logins;

6. Modify the statement above by having the output show 'Weekend' for Saturday and Sunday, a…