dbPHP - Object Relational Mapping for PHP

• dbPHP is a lightweight framework allowing object relational mapping between (at present) mySQL and PHP.  
• dbphp project home
• dbphp twitter
• Google Code Home
• SourceForge Code Home
• dbphp manual
•  

• Object relational mapping is the process of creating a structural relationship between the classes/data objects used in the logic layer and the database itself.   
•  
• One of the most successfully implemented exampled of an object relational/persistence frame work in the world of open source software is Seam with Hibernate. Seam is a framework for Java that allows one to run a generation script against a database and return an entire class frame work mirroring the structure of the database.  
•  
• It allows for information to be directly loaded from the database into memory, view/altered/removed, and these changes saved without the user ever having to interact directly with the database through structured query language.  
•  
• dbPHP is not designed to be commercial - if you want a hardcore resilient server with tons of functionality then you would never even consider PHP. what dbPHP aims to do is speed up the development times of quick and dirty PHP.  
•  
• PHP allows users to develop code in incredibly shoddy ways with no regard for performance or re-usability and dbPHP tries to steer the developer towards a more structured object-oriented style of development. 
•  
•  
• Existing Frameworks 
•  
• Zend Framework 
• WACT 
• Prado 
• ZooP Framework 
• eZ Components 
• CodeIgniter 
•  
• CakePHP* 
• Symfony Project* 
• Seagull Framework* 
• PHP on TRAX* 
•  
• My research has lead me to believe that only 4 of the existing main frameworks have object relational mapping capability *. 
•  
• Object Relational Mapping 
• The importance of object relational mapping in scalable designs is clear. Maintaining a cross-platform relationship between data structures underpins many concepts which form the future of the internet - using an ORM Java example, a table can be taken from a database, loaded into memory and then directly output in XML - allowing for easy transfer of information retaining all of the semantic meaning using an open and widely available transport standard. 
•  
• Lightweight. 
• The lightweight element of dbPHP is the key to its strength. PHP is free, it runs on cheap nasty hosting and it can provide a reasonable degree of functionality in relation the the manipulation and display of data for the web. dbPHP requires no installation other than being present in a directory. It is a series of classes that can be extended allowing child classes to map their internal structure to database objects and inheriting a number of useful SQL commands such as update, delete, findAll. 
•  
• PHP Limitations
• PHP has severe memory and performance limitations when it comes to handling large amounts of data or highly recursive tasks (default time out is set to 30 secs). It also has no ability to run threads and the only time it ever bothers to execute anything is if someone or something requests a page be served up. Global variables are seriously dodgy as you never really know what has access to them meaning that whenever you are requesting something from memory you have no way of knowing who set it, what's in it or if it will change.
• PHP will quite happily work in a similar way to a well laid out java class model with private variables and get/set functions if one spends the time to do this.
•  
• Creative context.
• When you want to make a project on the web, unless you love code, you don't really want to be spending half your time reinventing the wheel and rewriting code for boring banal stuff like update databases or other such stuff. Taking this to the extreme you can make all your projects in word press and totally abstract yourself from the process - if however your project involves some low-level elements, you're doing something clever with data, you want to incorporate a piece of flash that requires the storage of persisted data or you want to create a custom photo gallery of your own design - you probably want to focus on your own project and program logic. What dbphp does is allow you to treat your database and table as another area of memory and store and retrieve without extra hassle.
•  
• framework comparison chart 
• http://www.phpit.net/demo/framework%20comparison/chart.php 

MySQL full indexed text search - just like a real database!!

• As of My Sql 3.something you can now add text indexes to your columns and do full text searches with relevance ranking! text indexes are fantastic and allow more efficient searching and categorisation of text. The relevance ranking feature is rather good too and gives you a much better idea of how your search performed. 
•  
• Issues to note are, this example uses relevance ranking as the criteria for returning results, if you take that condition out you will return every result in the database with a relevance score of 0. 
•  
• The default MySQL settings do not bother to index search terms of less than 4 characters therefore searching for anything less will bring back no results. This can be altered by setting "set ft_min_word_len =1" in your mysql config. This will result in a performance hit.  
•  
• Text indexes in large data sets can be quite processor intensive so you might also consider limiting your result set. 
•  
• ALTER TABLE `database`.`table_name` 
• ENGINE = MyISAM; 
•  
• ALTER TABLE table_name 
• MODIFY column_name TEXT; 
•  
• ALTER TABLE table_name 
• ADD FULLTEXT(column_name); 
•  
• SELECT *, 
• MATCH(column_name) 
• AGAINST ('search term') 
• AS score 
• FROM table_name 
• HAVING score > 0 
• ORDER BY score DESC;

sql

1. sql 
2.  
3. SERVEROUTPUT ON 
4.  
5. declare 
6.    result_limit number := 10; 
7.    current_query_no number := 1; 
8.    --table_n varchar2(30) := 'brian.cran1400_der_results'; 
9.    --cursor all_results is select * from brian.cran1400_der_results; 
10.    cursor result_list(counter number) is select * from brian.cran1400_der_results where queryno = counter order by score DESC, docno ASC; 
11.    --cursor sub_list is select * from brian.cran1400_der_results where  
12.    --select all results from table where query number is less than 10 
13.    inner_min number := 1; 
14.    inner_max number := 10; 
15.    total_precision number := 0; 
16.  
17.  
18. begin 
19.  
20. for result_record IN result_list(current_query_no) loop 
21. --loops through the result list in the cursor (all records 1 - 10) 
22.  
23.    for counter_one in inner_min..inner_max loop 
24.          -- do stuff here 
25.          current_query_no := counter_one; 
26.           
27.          if result_record.rn = 'R' then total_precision := total_precision + 1; 
28.          dbms_output.put_line (total_precision); 
29.          end if; 
30.  
31.  
32.  
33.    end loop; 
34. end loop; 
35. end; 
36.  
37.  
38.  

Command Line Web Browser

If need to browse the world wide web and you are either running in an ssh window or you really hate the whole web 2 thing.. help is at hand

Centos
yum install lynx

Debian
apt-get intall lynx

run lynx then you can view this page like this...

icurtain - lights on the roundabout
[H] Blog IDAT205 IDAT204 IDAT203 IDAT201 AINT204 SOFT221 ISAD223 SOFT218 Linux JSF PHP Java[EE] Java[J2ME] SQL submit search for..________
Centos NFS Install

2008-06-04 11:41:15 digg this!

Download the Centos Boot image
Download the Centos DVD image and save it on an NFS enabled share on your lan

Install with Network boot CD

choose to boot: linux text

Choose Manual IPv4
192.168.1.* / 255.255.255.0
192.168.1.*
192.168.1.*

(NORMAL LINK) Use right-arrow or to activate.
Arrow keys: Up and Down to move. Right to follow a link; Left to go back.
H)elp O)ptions P)rint G)o M)ain screen Q)uit /=search [delete]=history list

sql server - set db offline

if you can't track down all the life connections and you need to force changes:

use master
alter database db_name set offline with rollback immediate