Pure-Essence.Net

Archive for the ‘php code’ Category

write better search engine in php

Posted by: pureessence on: April 14, 2005

my limited mysql knowledge always produced inaccurate search results when i write the board search engine. i want to do better this time for the new board so i’m reading this and trying out mysql regular expression and full text search. i’m pretty excited. oh also, leslie reminded me. this perl style coding will save [...]

mysql date column type

Posted by: pureessence on: April 11, 2005

i have to say that the decision to make the birthday column for members on the new board type DATE is a very good one. i never knew about all the magic mysql DATE type can do but i still love the simplicity of time arithmetic unix timestamp provides.

javascript unescape like php function

Posted by: pureessence on: March 29, 2005

when you start dealing with languages (i.e. chinese) that require 8 bit encoding or more, you will learn about all the wonderful jazz of utf8, unicode, ISO etc. i was looking all over for a php function that does what javascript unescape does. normally rawurldecode would work, but…

the mystery of querying

Posted by: pureessence on: March 24, 2005

if i know (or remember) more from my database class, i may have an answer for this. i was just coding my new board and was curious about which of the following query is faster: or m.uid is a primary index while m2.uid is an index. what would be your guess?

save arrays into database

Posted by: pureessence on: February 28, 2005

i’ve known this for a while but forgot to share it. there is a very easy way you can store array into database as a string. then you can grab the string from the database and convert it back into an array. code example: you should get

separate template from code

Posted by: pureessence on: February 23, 2005

when you do serious coding, it’s always a good idea to separate your layout design (template) from your logic code. i’m at the beginning stage rebuilding dmb. one thing i want to do very badly is to get rid of all templates in the database. every time i load a template right now it causes [...]


My most adorable Pomeranians

Categories

Archives

SocialVibe


Follow

Get every new post delivered to your Inbox.