Welcome To Snipplr
Everyone's Recent Snippets Tagged sql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
Existen varias formas para hacerlo, pero lo que dejo aquà es a lo que tenemos que acostumbrarnos a hacer cada vez que programemos para prevenir que se pueda inyectar HTML o modificar las consultas SQL.\r\n\r\nThere are several ways to do it, but wha...
0
435
posted 13 years ago by arucordoba
By using this php snippnet we can store different fields (got by array post) into a sql database
1
638
posted 13 years ago by juanchifc
By using this snippnet we can recover and show on a table the items stored into a sql database managed with mysql.
1
604
posted 13 years ago by juanchifc
SQL query to update *wp_options* records that are specific to the host of a WordPress site. Run this query after copying the DB to another server (if this URL is different). Useful for deploying WordPress from a dev server to a live environment.
1
614
posted 13 years ago by errkk
To sort varchar fields which contain numeric data & returning XML
0
463
posted 13 years ago by aunlead
First you have to add a custom value with a correct date format.
The lines:
`AND CAST(wpostmeta.meta_value AS DATE) > '".date("Y-m-d H:i:s")."'
AND CAST(wpostmeta.meta_value AS DATE) < '".date("Y-m-d H:i:s", $date2)."' `
are only used to select d...
0
1188
posted 13 years ago by Mat_
Here is the SQL code to print a row of from any table. All you have to do is modify the @tableName and @whereClause variables. Works only in MS SQL 2005+
1
4806
posted 13 years ago by niaher
You can get the last query by using the following code.
Insert the first line before the query and TYPO3 will store each query.
You can get the last query with the second line.
3
741
posted 13 years ago by pogosheep