Snipplr

(MySQL) Show the output of a query in a more readable vertical format - rm1984

Thu, 30 Jun 2016 18:33:28 UTC

Show the output of a query in a more readable vertical format

(PHP) Database Connection in PHP - smagic39

Mon, 19 Oct 2015 21:17:01 UTC

try to with mysqli_*

(PHP) Save multiple row of checkbox value into database - raymondeu

Sun, 02 Aug 2015 00:52:54 UTC

I have been trying to solve my problems on stackoverflow, but none seems to help. Hopefully someone here could help me.

(PHP) php code example - johnschneider

Sun, 12 Apr 2015 01:40:13 UTC

example of php code I worked on

(VB.NET) VB.NET SQL Example: How to send SMS in VB.NET using SQL database - LoganTurn

Mon, 16 Mar 2015 17:18:43 UTC

I thought I share this code snippet because I find this way of SMS sending an easy solution. I believe that even beginners can implement this VB.NET SQL SMS application, but I think some extent of perfection in the SMS technology is required for better understanding. Okay, letâ€™s jump right in the middle of the project that allows you to send and receive SMS through database tables by using your own VB.NET application. Project information: â€¢ Language: VB.NET â€¢ Level: Intermediate â€¢ IDE: Microsoft Visual Studio â€¢ Database server: MS SQL, MS SQL Express, MySQL, Access, Oracle, etc. I used MySQL (http://www.mysql.com/). â€¢ Special prerequisites: .NET Framework (http://www.microsoft.com/hu-hu/download/details.aspx?id=17851), SMS Gateway (in order to let your PC to send/receive SMS transmissions to/from a telecommunications network). I used Ozeki NG (www.ozekisms.com). Project description: First of all, you need to create the necessary database tables: one for the outgoing messages, and another one for the incoming messages. The snippet shows my MySQL commands, but it can be changed of course depending on the database server you use. In order to be able to use your database you need to connect it to your SMS gateway, then you can insert an SMS into the table of the outgoing messages by using an SQL INSERT command. To execute this command, you need to connect to the database by using the myConnection.Open() method. Thereafter insert the message into the database ( mySqlCommand.ExecuteNonQuery() ), then close the database connection ( myConnection.Close() ). That's all there is to it! It wasn't that black magic, was it?

(PHP) Commonly used db functions for CodeIgniter - invtr

Wed, 11 Mar 2015 15:51:55 UTC

This is a common model used to run some common functions like CRUD functions, get reference data from table, check for dependencies etc. So in other model, we don't have to add those function repeatedly

(SQL) Search column names in databasee - kat

Thu, 20 Nov 2014 08:01:44 UTC

search database for column names http://vyaskn.tripod.com/sql_server_search_and_replace.htm EXEC SearchAllTables 'Computer' GO

(SQL) Search column names in databasee - kat

Thu, 20 Nov 2014 08:01:17 UTC

search database for column names

(PHP) Admin Fix for WordPress - 108Bits

Wed, 03 Sep 2014 01:01:22 UTC

Add the code below to change the Home & Site URL that is configured in the database (wp-options table) by WordPress. Whenever you copy/move a site to a new hosting and the URL has changed you can use the code below to fix any strange redirects that might happen. - Insert code to wp-loging.php - Add your new url. - Surf to www.yoursite.com/wp-login.php (site & home url is now updated) - Remove code from wp-login.php again

(PHP) CakePHP - Acesso a Dois Bancos de Dados - temistoclesarea

Fri, 29 Aug 2014 06:21:27 UTC

CakePHP - Acesso a Dois Bancos de Dados

(MySQL) Project Management Database Setup Script - JordanRowles

Sat, 12 Apr 2014 01:57:30 UTC

Sets up the database for my project management software (in development - C#)

(MySQL) Create a Database and Assign a User - apphp-snippets

Tue, 04 Feb 2014 21:21:36 UTC

This is a very simple snippet about how to create a database 1st, a user and then assign some privileges to the user to allow him/her to perform some specific actions like insert, create, update, select etc.

(Visual Basic) Sheets_List_From_File - lolrenx

Wed, 13 Mar 2013 02:04:10 UTC

lists sheets without opening the file

(Java) Basic Database in Java. Updated Version - eiger824

Mon, 21 Jan 2013 21:23:58 UTC

A basic database made in Java. It resembles a mobile phone contacts activity in which user is prompted to introduce some data of new contacts.

(MySQL) What MySQL Table Has What Column - philsown

Fri, 16 Nov 2012 00:50:08 UTC

How to find a given column in a given database in MySQL

(C#) DataBase Coonection Class - rodrigoallves

Sun, 11 Nov 2012 08:23:52 UTC

Simple Class Connection for use in C# Code. Methods: - ReturnDataTable(string strQueryCommand) - ReturnDataSet(string strQueryCommand) - ExecuteQuery(string strQueryCommand) - ReturnDataReader(string strQueryCommand)

(MySQL) MySQL - Simulate MySQL Queries - satie83

Thu, 20 Sep 2012 20:29:21 UTC

You could start a transaction before running your queries and then rollback after running them. Note that to do this you'll require InnoDB or XtraDb tables (won't work on MyISAM).

(Python) Async Twisted Db Pipeline - scrapy

Sat, 01 Sep 2012 07:15:00 UTC

(PHP) db2 connect and query - zombree

Thu, 17 May 2012 01:52:16 UTC

Connect to and query a db2 database using php.

(PHP) Select to MySQL database - paul0078

Sun, 15 Apr 2012 20:16:34 UTC

(PHP) Connect to mySQL - paul0078

Sun, 15 Apr 2012 20:16:34 UTC

(PHP) Run MySQL query - paul0078

Sun, 15 Apr 2012 20:16:34 UTC

(PHP) UTF8 Database fix - sjasliek

Fri, 13 Apr 2012 19:47:53 UTC

Author: J. van Hemert Fixes encoding when utf-8-encoded data is stored in tables with other (e.g. latin_swedish_ci) encoding. Will convert all columns in all tables to utf8_general_ci.

(Bash) Empty a database table - ModServ

Mon, 23 Jan 2012 12:16:05 UTC

A bash command to empty a database table.

(MySQL) US & CANADA Cities Database - frederichoule

Sat, 22 Oct 2011 12:36:31 UTC

(MySQL) wordpress - MYSQL - Assign all articles from one author to another - krembo99

Wed, 19 Oct 2011 13:12:52 UTC

(PHP) Convert all HTML entities in database to actual characters - f6design

Mon, 10 Oct 2011 17:06:51 UTC

Sometimes a legacy database will have HTML entities stored in it. This function converts them. Note that this function assumes you have a database abstraction layer, and may need to be modified to connect to YOUR database.

(PHP) Database php class - claudiowebdesign

Wed, 05 Oct 2011 09:31:06 UTC

That's something quick. A basic php class to manage properly a database. Thanks to magic methods opening a database is almost automatic.

(PHP) Class database mysql - jose_506

Fri, 16 Sep 2011 00:36:29 UTC

(Java) Own sqlite database in android - jamepaul

Sat, 10 Sep 2011 17:59:47 UTC

(SQL) Schema for the database DVD - georgemathewkunnathoor

Fri, 19 Aug 2011 16:06:56 UTC

(Other) To makes Pages and Posts current - sridhar

Sun, 31 Jul 2011 04:43:28 UTC

(PHP) PHP DB Table to HTML Datagrid - brownrl

Fri, 29 Jul 2011 19:49:16 UTC

This is a skeleton mock up for showing a database table in a basic datagrid with sorting and pagination.

(SQL) Replace local db with new URL - xcsteve99

Fri, 29 Jul 2011 08:10:23 UTC

run these in the SQL tab

(PHP) Wordpress: retrieve values from a custom table in the Wordpress database - redconservatory

Thu, 21 Jul 2011 00:32:10 UTC

Refer to the following: http://codex.wordpress.org/Class_Reference/wpdb

(Java) Simple H2 Database utility class - studioevoque

Wed, 20 Jul 2011 00:21:37 UTC

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

(SQL) Get ID of last inserted record in Access - wizard04

Wed, 08 Jun 2011 06:46:45 UTC

Get the value of the autonumber field for the last record inserted into an Access database via the current connection.

(PHP) PHP Simplified DB Functions - kendsnyder

Fri, 27 May 2011 03:13:10 UTC

(Bash) Script to Backup MySQL databases - saibal

Sun, 08 May 2011 15:20:48 UTC

(MySQL) Updated mysql database from SQL dump - greeneggs614

Thu, 28 Apr 2011 06:35:03 UTC

(Other) Load Postgres database with psql dump - greeneggs614

Thu, 28 Apr 2011 03:03:19 UTC

(PHP) Wordpress: Create custom database tables - prwhitehead

Sat, 16 Apr 2011 05:41:35 UTC

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.

(PHP) Simple Database Insert - JonnySnip3r

Fri, 08 Apr 2011 21:30:24 UTC

Just a simple php insert script.

(PHP) Simple database script - JonnySnip3r

Fri, 08 Apr 2011 21:04:17 UTC

Just a simple database script.

(C#) Reading data into a dataset in C# - fengelz

Mon, 04 Apr 2011 23:25:14 UTC

Snip it if you keep forgetting how its done.

(JavaScript) Query Local Database with targeted callback and custom arguements - cmndo

Wed, 16 Mar 2011 07:43:10 UTC

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 assign the data you really want. But hey, that's asynchronous event handling for you. This function allows you to tightly couple an object with the query which will be available in the callback.

(Bash) Light sql like database written in Bash - sp4ke

Sat, 12 Mar 2011 02:32:52 UTC

This was a school project, so it is not well commented but feel free to ask details.

(SQL) Search for a text in all databases - SQLServerCentral - ezerick

Thu, 03 Mar 2011 08:07:05 UTC

(C#) Single row from database - tonatiuh

Sun, 20 Feb 2011 09:06:26 UTC

(SQL) Find Duplicate Rows in Table - ezerick

Sat, 22 Jan 2011 04:47:21 UTC

Field1 + Field2 + Field3 should create 1 entry for each unique row in the DB. In an employee table, this would be FirstName + LastName + EmployeeNumber