Welcome To Snipplr


Everyone's Recent Snippets Tagged database



This is a skeleton mock up for showing a database table in a basic datagrid with sorting and pagination.
0 1330 posted 13 years ago by brownrl
run these in the SQL tab
0 968 posted 13 years ago by xcsteve99
Refer to the following: http://codex.wordpress.org/Class_Reference/wpdb
0 1728 posted 13 years ago by redconservatory
A simple utility class that uses the H2 SQL Db to maintain a database connection. It also gives a convenience method to run SQL scripts. _Note:_The init.sql value is hardcoded, and should be replaced by a static variable if needed
0 1200 posted 13 years ago by studioevoque
Get the value of the autonumber field for the last record inserted into an Access database via the current connection.
0 1124 posted 14 years ago by wizard04
0 961 posted 14 years ago by kendsnyder
0 1003 posted 14 years ago by saibal
Create custom database tables within wordpress. Just replace 'stats' with the name of your table, and then the $sql variable with your create table sql.
0 1336 posted 14 years ago by prwhitehead
Just a simple php insert script.
0 940 posted 14 years ago by JonnySnip3r
Just a simple database script.
0 1014 posted 14 years ago by JonnySnip3r
Snip it if you keep forgetting how its done.
1 1077 posted 14 years ago by fengelz
In a recent iphone webapp I developed, I needed to use safari's Local Database feature. The webapp needed to make a few SQL Queries while performing other actions. The local database data transaction process makes it difficult to make queries and...
0 1136 posted 14 years ago by cmndo
This was a school project, so it is not well commented but feel free to ask details.
0 1185 posted 14 years ago by sp4ke
0 900 posted 14 years ago by tonatiuh
Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber
1 893 posted 14 years ago by ezerick
The uploaded file is attached to the "pid" of the recently inserted project. the "pid" variable is retrieved from the database after the project has been entered
2 1195 posted 14 years ago by danhanly
Specifications of the TOPIC database format, a standardized structure for plain text databases that's easy to read and edit in most text editors, and easy to programmatically parse as well.
0 1081 posted 14 years ago by TopcatSoftware
0 892 posted 14 years ago by delineo
0 904 posted 14 years ago by hamsterbacke82
This is my fairly easy to use MySQL database class, I use this on my Experiment framework BlahFramework, anyways I thought someone else may find this useful or just study the code to get an awesome idea of there own. Enjoy.
3 1250 posted 14 years ago by Cory
By using this snippet we can recover fields from a database by filtering these ones per a specific field.
1 1057 posted 14 years ago by juanchifc
By using this php snippnet we can store different fields (got by array post) into a sql database
1 976 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 950 posted 14 years ago by juanchifc
Database connection class to be easily incorporated into any db based softwares, using SQLite 3
2 1809 posted 14 years ago by amitkenny
Solucion a error cuando mudamos una bd de una pc a otra y luego no podemos crear un diagrama de la BD
2 1225 posted 14 years ago by derebus