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
639
posted 14 years ago by arucordoba
By using this php snippnet we can store different fields (got by array post) into a sql database
1
832
posted 14 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
806
posted 14 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
803
posted 14 years ago by errkk
To sort varchar fields which contain numeric data & returning XML
0
661
posted 14 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
1429
posted 14 years ago by Mat_
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
973
posted 14 years ago by pogosheep