Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
mysql

Featured

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 ...
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: