Blog Entries for bohemia

PHP Accessing Properties and Methods

kent@templatesjoomla.ca — Sun, 05 Feb 2012 21:47:45 +0100

With PHP OOP, you can declare properties and methods to be public, private and protected. Depending on the circumstances, you will have the option to choose the ideal method for which to control properties and functions. All methods and properties can be defined within their class.

Public

Public properties or methods can be accessed anywhere in various classes

Public variables:

public $variable;

public $variable2;

Public func [...]

Strip Tags PHP

kent@templatesjoomla.ca — Sun, 05 Feb 2012 16:13:41 +0100

Stripping HTML Tags From Database Output
When you output data from a mysql database, the text could be html code with various tags such as <p>, <div> and span. Therefore, if you just selected the text for output you could end up with undesired output.

Now, let's assume that you want to convert the html into plain text just as though it was interpreted from a browser. What you need to do is remove the whitespace and html tags and display the words you want to see. W [...]

PHP Object Oriented Programming

kent@templatesjoomla.ca — Fri, 03 Feb 2012 04:48:48 +0100

OOP Programming in PHP
Depending on one's background and learning methods, a PHP programmer is often lead to examine Procedural PHP vs OOP in PHP.

For the serious individual who want to program in PHP, learning both methods opens much more doors. Even if you never code in OOP, knowing how to read it will allow you to see what is going on in other people's code. Chances are if you use large open source OOP in PHP you will want to edit or redo blocks of code. If you don't know O [...]

PHP Built-In Functions

kent@templatesjoomla.ca — Fri, 03 Feb 2012 04:38:02 +0100

PHP Built In Functions
Here is a list of common PHP fuinctions and their usage.

Execute a mysql query

mysql_query()

Connect To MYSQL Database

mysql_connect()

Fetch arrays from Database Using a Select

mysql_fetch_assoc()

mysql_fetch_array()

Fetch Object from Database Using a Select Query

mysql_fetch_object()

Get the number of rows from a query

mysql_num_rows()

The [...]

PHP Constructs

kent@templatesjoomla.ca — Fri, 03 Feb 2012 04:35:42 +0100

PHP Language Constructs
PHP has many built-in language constructs and functions. Language constructs can be used with or without parentheses while functions always have parentheses. Here is an example using a language construct. With brackets: require_once('filename.php') Without Brackets: require_once 'filename.php'
Here is a list of several PHP constructs which will be used quite frequently in even the simplest PHP / mySQL applications.

Printing strings and variables

[...]

Remove Index With PHPMYADMIN

kent@templatesjoomla.ca — Thu, 02 Feb 2012 15:50:53 +0100

Remove Unique Index With PHPMYADMIN
To remove unique index of a column,

1) Open PHPMYADMIN

2) Select database >database table >Structure >(Select from option a or b below)

3) Look for Indexes Table which is below the main table.

4) Change or remove the unique index

Unique MYSQL Columns With PHPMYADMIN

kent@templatesjoomla.ca — Thu, 02 Feb 2012 15:43:24 +0100

Unique MYSQL Columns With PHPMYADMIN
Alter a table to create unique columns. This will ensure there is no duplicate values in a column that is unique.

1) Open PHPMYADMIN

2) Select database >database table >Structure >(Select from option a or b below)

a) Look for Arrow next to More or U icon >Add Unique Index

b) Look for index >Click Edit next to desired field >Next to index type select Unique

Unique MYSQL Table Creation

kent@templatesjoomla.ca — Thu, 02 Feb 2012 15:40:25 +0100

Unique MYSQL Table Creation
Create a Table where only there is no duplicate firstname / lastname combinations
CREATE TABLE members

(

lastname varchar(30) NOT NULL,

firstname varchar(30) NOT NULL,

UNIQUE (lastname, firstname)

);

Create a New MYSQL Table With Unique

kent@templatesjoomla.ca — Thu, 02 Feb 2012 15:38:06 +0100

MYSQL Unique Columns

kent@templatesjoomla.ca — Thu, 02 Feb 2012 15:29:49 +0100

MYSQL Add a Unique Column
The code below creates a new column called username to the table called mytable. The username must be unique. In other words, if you use an insert statement and a username already exists, the data will no be duplicated.
alter table mytable add unique (username);

ALTER TABLE `mytable` ADD UNIQUE (`username`)";

Search A Single MYSQL Database Table For a Specific String

kent@templatesjoomla.ca — Thu, 02 Feb 2012 15:19:01 +0100

Search A Single MYSQL Database Table For a Specific String
1) Open phpmyadmin

2) Select Database >Select Table

3) Select Search

4) Insert Words into Desired Text Input Field

5) Refine Search with phpmyadmin operator LIKE or %like%

6) Select Go

Search All MYSQL Database Tables For a Specific String

kent@templatesjoomla.ca — Thu, 02 Feb 2012 15:15:37 +0100

Search All MYSQL Database Tables For a Word or Specific String
1) Open phpmyadmin

2) Select Database

3) Select Search

4) Insert Words into Text Input

5) Select Go

Count Distinct Rows From MYSQL Table

kent@templatesjoomla.ca — Thu, 02 Feb 2012 15:05:30 +0100

Count Distinct Rows From MYSQL Table
Method A

$command= "SELECT count(distinct username) as allusername from tablename ";

                $result = mysql_query($command, $db);

                if ($result && mysql_num_rows($result) > 0) {

                while ($row = my [...]

MYSQL NUM ROWS To Count Rows

kent@templatesjoomla.ca — Tue, 31 Jan 2012 04:31:14 +0100

MYSQL NUM ROWS
Counting Rows with mysql_num_rows function can provide useful pieces of data. The following example demostrates how to gather gather distinct first names in a table sorted by date.

$names = "select distinct firstname from table_sort WHERE date<='2012-01-27' ";

$result= mysql_query($names, $db);

$name_count = mysql_num_rows($result);
[...]

Selecting Entries With Blank Column in MYSQL

kent@templatesjoomla.ca — Tue, 31 Jan 2012 04:08:05 +0100

Selecting Entries With Blank Columns in MYSQL
Objective: Select all rows in a table for which there are blank values. You may want to see the values before you delete all the entries with a specified blank column.
To select entries with an empty column,

1) SELECT * FROM tablename WHERE column_name='';

Update Passwords Wth MYSQL

kent@templatesjoomla.ca — Sun, 29 Jan 2012 17:38:00 +0100

Update MYSQL Passwords
UPDATE PASSWORDS WITH MYSQL

Using mysql password function

update tablename set password=password('mypass') where id=9;

Update MD5 Passwords

update tablename set password=md5('mypass') where id=9;

Update sha1 Passwords

update tablename set password=sha1('mypass') where id=9;

How To Install Bohemian CMS

kent@templatesjoomla.ca — Sun, 29 Jan 2012 16:58:23 +0100

Installing Bohemian CMS
To load Bohemian CMS into a subfolder on a website,

1)Upload folder to the desired location (i.e. example.com/test)

2) create database

3) Import data to database

4) Change database connection in the files public.php and utilities.php

5) If you use your main domain (i.e. example.com), you can login, create, edit, delete pages immediately!

Otherwise, for subfolders please follow the next set of instructions!

Using Distinct in MYSQL Query For Output

kent@templatesjoomla.ca — Sun, 29 Jan 2012 05:26:44 +0100

Using Distinct For Output
Using distince in a query will output distince values for a chosen query.

For example, look at the following query:

"SELECT DISTINCT name from tablename;"

If there are two exact names in the names column, the query will output the second name. Who cares, right? But what of the query wanted distinct name and email like the query below:

"SELECT DISTINCT name, email from tablename;"

The result will retrieve rows with di [...]

Replace String in PHP

kent@templatesjoomla.ca — Sun, 29 Jan 2012 05:22:53 +0100

Replace String in PHP With str_replace Function
Replacing Parts of String With str_replace Function

$string = "I like to eat.";

echo $string; //

Output is:

I like to eat

$string = str_replace("eat","drink juice", $string);

echo $string;

New output is:

I like to drink juice.

Delete Rows From MYSQL Table

kent@templatesjoomla.ca — Sun, 29 Jan 2012 05:03:39 +0100

Delete Rows From MYSQL Table
Using PHPMYADMIN

1) Select desired database.

2) Open SQL Tab in PHPMYADMIN

Using MYSQL Console

1) Open MYSQL Console (mysql>)

2) Type command:

delete FROM `test' where id >'0';