free code snippets - All - spyka Webmaster

« Prev 123 4 5 Next »

Selecting the minimum value

in mysql

SELECT MIN(`downloads`) as `downloads` FROM `scripts`

Selecting the minimum value of the field in the brackets.

Select code

Selecting the maximum value

in mysql

SELECT MAX(`downloads`) as `downloads` FROM `scripts`

Selecting the maxmimum value of the column in the brackets.

Select code

Check array is associative

in php

function is_assoc_array($array) { if(is_array($array) && !is_numeric(array_shift(array_keys($array)))) { return true; } return false; }

PHP is_assoc_array function to check if given array is associative or not

Select code

Convert a string to upper/lower case

in vb6

Dim simpleString As String simpleString = "tHis IS a sTriNG" MsgBox LCase$(simpleString) MsgBox UCase$(simpleString)

Convert a string to either upper or lower case with the LCase and UCase functions

Select code

Disable text box

in vb6

Private Sub Command1_Click() Form1.Text1.Enabled = False End Sub

Disable text box on commandButton click. Be sure to update the control names to make it work!

Select code

Check file exists

in vb6

Dim fileLocation As String fileLocation = "D:\folder\file.txt" If Dir$(fileLocation) = "" Then MsgBox "File does not exist" Else MsgBox "File does exist" End If

A Visual Basic 6 code snippet to check if a given file name exists

Select code

Current page URL

in javascript

var pageURL; pageURL = window.location.href;

Get the current title of the page using javascript and store it into a variable

Select code

Page title

in javascript

var pageTitle; pageTitle = window.document.title;

Get the current title of the page using javascript and store it into a variable

Select code

Close window

in javascript

<a href="#" onClick="close.window();">Close Window</a>

Attempts to close the current window. Good idea for popups

Select code

Back button

in javascript

<input type="button" name="Back" onClick="history.go(-1)" value="Go Back">

Allows you to take a user to the previous page they were on using a button

Select code

« Prev 123 4 5 Next »

Tips & advice

Need coding help? Tips, tricks or advice? Check out our webmaster forums

free css templates

PHP, Javascript, CSS & mySQL code snippets