Featured
-
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Best 5 Lightweight PHP Frameworks for REST APIs Development
Are you ready to develop the Rest AP
by ankur.kumar -
PHP: Full-Stack Framework vs Micro Framework
A web framework can be described as a software fra
by ankit.bhatia -
How to get facebook profile picture by Facebook App
If you would like to get your profile picture in f
by vivek.rastogi -
Creating RESTful API in cakephp
This tutorial will help you to learn how to create
by pushpendra.rawat
Tags
Full Calendar Events From Database
1- Create a mysql Database.
2- Create a Table events inside created database.
CREATE TABLE `events` (
`id` int(10) NOT NULL AUTO_INCREMENT,
...
How to get selected numbers of character from column using Codeigniter?
Hello Readers, If you are using CodeIgniter you want to fetch limited MySQL results then in this blog we will learn how to to this.
Suppose you want only first 200 chars of a field then you should only fetch limited results, this wil...
Import excel sheet into database using PHP
Hello friends, This tutorial will help you to insert excel sheet data into the MySQL database using PHP I have also included the snapshots which will help you to understand more clearly.
Import Students: You can import students by cl...
How to insert values into database in php.
Inserting data to a database would be possible by using SQL statements, specifically the INSERT command. Data can be entered into the database using insert query into the function, here is simple line of code that will create a database usi...
How can we prevent SQL-injection in PHP?
Hello Readers ,
For preventing SQL injection we can do by two ways :
1- > Escaping the special characters in your post or get variables , or
2-> By using a parameterized query.
Both would protect you from SQL injection.
Ex...
How to use Order By in Zend Framework
Hello Friends,
If you are looking to use order by clause in Zend Framework. Please use the below code for the same::
$dbObj = Zend_Db_Table::getDefaultAdapter();
$selectObj = $this->select();
$selectObj->from(array('tbl_users'),arra...
Save MySQL query results into a text or CSV file
Hello Readers!
MySQL provides an easy mechanism for writing the results of a select statement into a text file on the server.
Given a query such as
SELECT order_id,product_name,qty FROM orders
which returns three columns of data, t...
How to use GROUP_CONCAT in a CONCAT in mysql
GROUP_CONCAT will always return a string value . It can be easily explain by the example.
Example:
bookid | bookname | isbnno | cateid | autid | pubid
| BK001 | Introduction to Electrodynamics | 0000979001 |...
Laravel 5.0 Writing Static Query In Laravel
Many times we needs to write static query in Laravel. Some time due to the complexity of the query or sometime due to the MYSQL build in functions not supported in the Query Builder or in Eloquent in Laravel example LPAD. Thus at that time Larave...
Find where field is not null in cakephp
Hello Readers!
if you have a database table "users" which has a field "email". And you are looking for a query that fetch out every email field only which are not null in cakephp
Here is the following code below you can use, and its working ...
