How to get a value from a table using functions and return count: Write a simple query and pass the parameters: function somename($tablename, $colnam, $colvalue, $mode, $returncolnam) { Select $returncolnam from $tablenam where $colnam=$colval } Note: For $returncolnam you can also use array number starting from 0.
When we search a column in MySQL we use where condition. When we have many records separated by a ‘,’ in a column then searching it becomes bit complex. We can search using like function. It will be clear by taking an example: Let say we have a record with value – 1,2,3,4,5,6,7,8,9,10,11,12 We want … Read more
You can check domain name availability of a domain name by using following code. If you want to check multiple domains for same extension modify this code by calling function again. To check different extensions you need to specify Server Name and Matching Criteria for that extension. Pass values in $server and $nomatch [php] <?php … Read more
A tree structure means nodes within nodes. By using MySQL and PHP you can read a database then fetch records recursively. By taking an example we can understand it better. There is a table Category with records for categories and sub-categories. There are 3 columns: Id, Name, Parent Id and records are: [php] 1, A, … Read more
I am a web developer and design websites for personal use. After watching the movie Social Network (though I watched it a bit late and my friends who watched it earlier then I did, had called me up to watch this movie as soon as I can, as they thought I could relate myself to … Read more
Few days back, I was working on my blogs (they are on wordpress.com, blogger.com and some others on my hosting). I was surfing the Web (as usual) that day and was Googling something and came with WordPress Multi User as search result. This search result interested me and I got to know about WPMU. Around … Read more
Today, I am moving to a new Hosting. I found it too time taking and bit boring to copy everything. It is not just files. It includes Databases and many other settings. Though I am shifting from Cpanel hosting account to Cpanel hosting on some other server (I like Cpanel, very easy to use and … Read more
I was working in PHP and MySQL. My database interface is PHPMyAdmin. Everything was working fine and some issues came when I was trying to access my site from other computer in LAN. Later these issues were resolved, so I thought to share them. Initially, when I tried to open The Site on another local … Read more
Warzone Tower Defense is a strategy game. One gets addicted to this small, fast and easy to play game. You need to create a strategy and prevent your Tower from enemies. You have various weapons and using these weapons you can destroy enemies. Here, I will describe you how to play this game, explain various … Read more
mysql_insert_id — Get the ID generated in the last query Use mysql_insert_id(); More information can be found at: http://php.net/mysql_insert_id Get the ID generated in the last query
