Snipplr

(JavaScript) Sort Columns from Tables - jlustre

Thu, 05 Mar 2020 18:38:51 UTC

Use to sort table columns by clicking on the table headings

(SQL) mysql clone table with structure and indexes - ktrout

Sun, 03 Jan 2016 13:52:46 UTC

clone table with structure and indexes

(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) HTML Table to plain text - nigelnquande

Tue, 16 Dec 2014 01:11:27 UTC

Use PHP's DOM parser to convert a table into plain text (including links with images)

(SQL) Table creating sql for a typical shopping cart - jacktan

Thu, 30 Oct 2014 02:11:57 UTC

Confirm the sql script file is encoded with `UTF-8`

(jQuery) Check if one checkbox is checked (from a list, a table...) - Igeco

Fri, 17 Oct 2014 19:35:24 UTC

VÃ©rifie si une checkbox a Ã©tÃ© cochÃ©e

(JavaScript) simple table filter with jquery - bboydflo

Fri, 03 Oct 2014 16:57:08 UTC

have to change this snippet in order to hide filtered rows. Not tried out yet, but works fine in the jsfiddle

(JavaScript) Japanese Adjective Study Table - hamittou

Mon, 11 Aug 2014 03:36:57 UTC

I was studying Japanese adjectives and ye olde paper and pen wasn't enough so I made this. Basic as the basic can be

(C) sqlite create new table - ktrout

Sun, 03 Nov 2013 15:25:34 UTC

Source creating a new database (and inserting some records)

(jQuery) Cloning table header to the bottom of table with reverse - NeXTs

Sat, 15 Jun 2013 21:39:27 UTC

Snippet may be usefull for cloning table header to the bottom of table. Snippet will clone all children elements from thead, reverse and insert to tfoot. Example at jsFiddle: jsFiddle

(CSS) CSS - Spacing between thead and tbody - satie83

Thu, 11 Apr 2013 23:09:00 UTC

Spacing between thead and tbody

(CSS) Alternating Table Color Rows in CSS - apphp-snippets

Sun, 10 Mar 2013 19:31:20 UTC

These 2 techniques can be used for alternating row-colors in a table.

(CSS) Alternating Table Color Rows in CSS - apphp-snippets

Sun, 17 Feb 2013 20:24:40 UTC

These 2 techniques can be used for alternating row-colors in a table.

(CSS) Fixed Heading Scrollable Table Simulation - COBOLdinosaur

Sun, 06 Jan 2013 05:33:14 UTC

Uses the table display properties in div tags to merge the attributes of multiple tags.

(HTML) Mid America Parts Description Table - dcoxdesigns

Wed, 19 Sep 2012 00:21:30 UTC

table with image on one side, products info on the other. includes some CSS from Tablizer that has been modified.

(PHP) Quirolrichimaro Adding Headers Technique - mrtonix

Sun, 05 Aug 2012 03:14:33 UTC

Created by Quirol to avoid TOTAL errors

(MySQL) Pivot table Schedule - cahyadsn

Wed, 25 Jul 2012 13:43:46 UTC

You have a schedule table (period, day, subject, room) with a primary key period,day to avoid duplicate bookings. You wish to display the schedule as periods, subjects and rooms in rows, and days of the week in columns.

(SQL) SQL - SQL Server - Add Column with Default Value and Check Constraint - denakitan

Fri, 20 Apr 2012 01:45:29 UTC

Example of SQL syntax to add a new column to an existing table, define a default value to the columns for the existing rows and also add a check constraint to limit the values that the column can hold.

(PHP) Create table rows automatically based on number of columns - andreaskian

Thu, 19 Apr 2012 23:59:12 UTC

Let's say you want to show a list of employees, and you want to show 3 on each row, use the script below to accomplish that.

(Bash) Empty a database table - ModServ

Mon, 23 Jan 2012 12:16:05 UTC

A bash command to empty a database table.

(PHP) PHP Create pitchfx Table Structure - wa-rufio

Mon, 19 Dec 2011 07:34:34 UTC

Creates table structure for pitchfx data that is provided by mlb.com. Open PHP file and enter username and password for localhost. Feel free to customize to suit your preference.

(MySQL) Languages table - Synnoid

Thu, 08 Dec 2011 20:38:40 UTC

Most popular languages on the web table (in order of popularity). Handy for auto complete fields and such.

(SQL) Update table with values selected in a subquery - preasha

Mon, 29 Aug 2011 22:34:04 UTC

The inner join could be nested too

(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.

(PHP) Make your table color different by Mysql Select tag - Darksider3

Tue, 26 Jul 2011 02:21:32 UTC

Here you see a example to make your table background color fdifferent at last

(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

(jQuery) jQuery implementation of align=char - MikeAcreman

Fri, 17 Jun 2011 04:14:47 UTC

This is probably buggy and certainly not the most efficient way to do it.

(PHP) Build a Calendar Table - dubogii

Tue, 17 May 2011 19:52:43 UTC

(jQuery) jQuery Zebra Stripe a Table - dubogii

Tue, 17 May 2011 19:33:27 UTC

(Other) SQL - Find Table by Name - silentpro

Thu, 12 May 2011 13:34:04 UTC

(Other) SQL - Find Duplicate Rows - silentpro

Thu, 12 May 2011 13:33:26 UTC

(PHP) HTML table with PHP - LemonPro

Tue, 26 Apr 2011 22:10:16 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.

(HTML) HTML Table Template - mecha

Fri, 15 Apr 2011 05:03:41 UTC

Valid HTML table template with example data.

(CSS) HTML Table overlapping DIV - peetj

Fri, 08 Apr 2011 16:16:59 UTC

Stop your html tables overlapping other elements to the right. Fix the table with a fixed layout. You may also have to set overflow:hidden and word-wrap:break-word

(HTML) Buggy CSS for an HTML table (example) - sahwar

Wed, 16 Mar 2011 16:19:17 UTC

A code snippet for review by StackOverflow.com members. I would appreciate any help that'll aid me in fixing the bugs in the table (they are described in the StackOverflow question at http://stackoverflow.com/questions/5321646/buggy-css-for-an-html-table).

(SQL) SQL Template - Drop Column - edwinet

Wed, 02 Feb 2011 09:56:53 UTC

My Drop Column.sql This template drops a columns of the table.

(SQL) SQL Template - Add Column - edwinet

Wed, 02 Feb 2011 09:43:13 UTC

My Add Column Varchar.sql This template adds a new varchar column to the table.

(CSS) IE7 table border spacing fix - kanampo

Wed, 26 Jan 2011 07:40:54 UTC

(MySQL) Add Column Table if not exists - jatubio

Wed, 19 Jan 2011 22:13:07 UTC

Can add columns to a table checking before if there

(JavaScript) Simple Javascript to handle table sorting. - racl101

Wed, 19 Jan 2011 05:44:17 UTC

This script handles table sorting, is easy to implement and to alter and has decent documentation. I did not write this JavaScript, rather, I found it here: http://www.kryogenix.org/code/browser/sorttable/ I used this script on the ACEE WordPress Plugin I built around Jan 2011.

(MySQL) Create a table with a dynamic name - gtaking

Sat, 01 Jan 2011 01:07:27 UTC

the following code can be used to create a table with a dynamic name

(Objective C) Set a UITableView's footer text - joshparnham

Wed, 29 Dec 2010 20:27:39 UTC

Place this method in a UITableViewController Subclass' .m file

(SQL) Postgres get table schema with columns - djmornyc

Thu, 09 Dec 2010 06:08:50 UTC

Get table schema with columns via sql.

(JavaScript) jQuery Alternating Table Row Formatting - SteveRB511

Tue, 23 Nov 2010 06:12:55 UTC

(SQL) mysql dump single table - tribal

Tue, 09 Nov 2010 04:04:18 UTC

Backup a single table from a database

(jQuery) alternate table row - beso

Fri, 05 Nov 2010 21:40:32 UTC

(PHP) PHP script to make a backup copy of a MySQL table - fackz

Tue, 26 Oct 2010 04:07:52 UTC

The script below connects to a MySQL database server on "localhost" using the login name "test" and password "123456" and then connects to the database "test". It then copies the table structure and data from the table "products" to a new table "products_bak". If the target table already exists the function returns false.

(C#) create html table dynamically - hairajeshk

Sat, 09 Oct 2010 03:30:26 UTC

create html table dynamically

(jQuery) Making a table row clickable while preserving the function of additional links - theOtherOne

Sat, 09 Oct 2010 03:00:03 UTC

First: clicking on a table row forwards you to the URL given in the first As href attribute. ------ Second: clicking on a link inside the row triggers the default action **AND** a click event on the table row. This needs to be stopped, so the default action is replaced by our own and propagation to higher elements is stopped. ----- Nice to have: Hand cursor when hovering over a table row. CSS!