Snippets
sql

How-to articles, tricks, and solutions about SQL

Codeigniter $this->db->get(), how do I return values for a specific row?

The $this->db->get() function in CodeIgniter is used to retrieve data from a database table.

php sql codeigniter

Commands out of sync; you can't run this command now

The "Commands out of sync; you can't run this command now" error in PHP usually occurs when you have called a MySQL function in an incorrect order.

php sql MySQL mysqli

Converting Varchar Value to Integer/Decimal Value in SQL Server

In SQL Server, you can convert a varchar value to an integer or decimal value using the CAST or CONVERT function.

php sql sql-server

could not extract ResultSet in hibernate

If you are trying to execute a query using Hibernate and are getting an error saying "could not extract ResultSet," it could be due to a few different issues:

java sql hibernate spring-mvc

Display an array in a readable/hierarchical format

Here is an example of how you could display an array in a readable/hierarchical format in PHP:

php sql

Doctrine 2: Update query with query builder

To update an entry in a database using Doctrine's query builder, you can use the update method of the QueryBuilder class.

php sql database doctrine

Getting data posted in between two dates

To get data posted between two dates in PHP, you can use a SQL query with a WHERE clause and the BETWEEN operator.

php sql codeigniter activerecord

Hibernate show real SQL

To show the real SQL generated by Hibernate, you can enable the show_sql property in the Hibernate configuration file (hibernate.cfg.xml).

java sql hibernate orm

How can I prevent SQL injection in PHP?

There are several ways to prevent SQL injection attacks in PHP.

php sql MySQL security sql-injection

How to convert java.util.Date to java.sql.Date?

To convert a java.util.Date object to a java.sql.Date object in Java, you can use the java.sql.Date constructor that takes a long value as an argument.

java date sql datetime

1 2 3 > >>