May 13, 2008 - update: i added a fully functional example. in that way you can use the example files instead of copying text from the previous links (like peter briers said in a comment, copy and paste results in not readable scripts). i hope it could be useful. when i started this blog i said that i wasn't sure about what i'm going to write, and o

Well maybe you like me, were trying to store images or raw data like files directly in the database but that is not a good idea because store raw data or binary data inside a database is really expensive in terms of performance and could make the queries to the database's tables really slow. so you decided like me, just to store a reference to the

It's a natural and popular way to search for information and it's easy to use: enter keywords and get what you need. let's see some features: available only for myisam tables. natural language search and boolean search. creating a full text index create table articles ( articleid int unsigned not null auto_increment primary key, title varchar(200),

We were just trying to add search capabilities so the people could search through the list of courses already in the lms. first in mysql the tables in which the full text search had to be done, needs to be of a specific engine called myisam, myisam is the default engine when you don't specify any in the creation of the table, but is that true... we

I post this a little time ago in another web page, but just to have everything in one place. i think that maybe some people out there are thinking in develop the next web 2.0 application but they just don't know what software to use or to learn, well maybe this could be a list of some of the nicest programs out there that if you master those progra

We were working for a few days in the mudjungle course organization. we've taken ideas from juliux courses and adapted some for our own needs. we think the following organization fulfill the project needs ( figure 1 ). figure 1 mudjungle project organization. feel free to comment on this, because we are not sure at all.

Ok, let's see how we are organizing the project based in a previous post article: ( figure 1 ) figure 1 the mudjungle project organization (directory structure).

After spending some time trying to figure it out the right xhtml structure for the project we came with the following (figure 1). figure 1 xhtml skeleton. we think that this skeleton solves our needs and offers enough semantic meaning in the id's of the div containers. it was achieved using the yahoo user interface (yui) css library (so you know no

Db schema (updated: june 15, 2008) here it's the mudjungle database schema: ( figure 1 ) figure 1 the mudjungle db schema. there is some thoughts about this design, let me explain a few ones: after try and use some excellent php projects like gallery and wordpress, i noticed that their name convention for the tables is adding a prefix like g2_ for

Let's see a basic pagination in php: download source code: pagination adapted from the book: mysql cookbook, second edition by paul dubois