Archive for the ‘ MySQL ’ Category

Create Table Structure for Storing Multi Level Category Data

  • July 29th, 2010
  • Posted in MySQL

TweetSomebody asking about how to create table structure to store multilevel category data. Here is the scenario. For example you will create an online article system and each article will have specified category. So how about the table structure to handle this? First you create the table for store the category, let[ READ MORE ]

Performance Tuning Best Practices for MySQL

  • December 25th, 2009
  • Posted in MySQL

Tweet MYSQL STORED PROCEDURE PROGRAMMING – GUY HARRISON (PAPE US $33.63 End Date: Thursday Dec-31-2009 17:00:26 PST Buy It Now for only: US $33.63 Buy it now | Add to watch list HIGH PERFORMANCE MYSQL – BARON SCHWARTZ (PAPERBACK) NEW US $34.92 End Date: Thursday Dec-31-2009 17:34:21 PST Buy It Now for only: US $34.92 [...][ READ MORE ]

Everything is an object

  • December 21st, 2009
  • Posted in MySQL . PHP

Tweet “We are all made of stars” sings Moby in one of his top-selling tracks, and how could I disagree with that?! If there are about 7,000,000,000,000,000,000,000,000,000 atoms in a 70kg human body, and if we would consider atoms as objects, is everything an object, even us? Trying to give an answer to this question [...][ READ MORE ]

Edit In Place with AJAX Using jQuery Javascript Library

TweetI originally saw a version of this concept on Quirksmode and then a more Web 2.0-ish version on the 24 Ways site. I[ READ MORE ]

Fancy Quotes With jQuery, AJAX & CSS

Tweet[ READ MORE ]

Ajax Forms with jQuery

TweetThere are so many different javascript frameworks out there, but I have recently started to use jQuery, and I love it. Not only is the library much smaller than others, but it is so simple to use. I wanted to show how easy it is to turn a regular form into a AJAX form. Start [...][ READ MORE ]

My-BIC = Easy Ajax – NOW WITH PHP TO

TweetFIREBUG SUPPORT! Current Features as of 1.0 – Visit the Features section for more info Easy Forms – one function call will take all your form values and create a pretty little query string for you ajaxObj.getForm(‘formid’); JSON Client Side Encoding – Now you can send and receive JSON encoded data from client or server! [...][ READ MORE ]

MySQL Numeric Types

  • October 3rd, 2009
  • Posted in MySQL

Tweet MySQL supports all of the standard SQL numeric data types. These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). The keyword INT is a synonym for INTEGER, and the keyword DEC is a synonym for DECIMAL. For [...][ READ MORE ]

MySQL question & answer

  • October 2nd, 2009
  • Posted in MySQL . PHP

Tweet Explain the difference between mysql and mysqli interfaces in PHP?[ READ MORE ]

Finding a web host

TweetIf you want to make blog and make money from it, you should get your own domain. But let me tell you, a domain is without any web hosting service. You have to use a web host to put your website on the net. And before you pick a web host, it is sensible to [...][ READ MORE ]