INSERT into table_name (column1, column2) values (value1, value2)
Tag Archive for query
mysql insert query
mysql select query
SELECT column_names FROM table_name WHERE conditions
mysql update query
UPDATE table_name SET column_name1 = value1, column_name2 = value2 WHERE conditions
Execute MySQL query from command line
mysql.exe -udb_user -pdb_password db_name < source.sql > output.tab
Inserting from a form into a database
<cfquery datasource="turpinsshoutbox" username="root">
INSERT INTO comment(poster, email, msg)
VALUES ('#Form.poster#', '#Form.email#', '#Form.msg#')
</cfquery>
<cflocation url="shoutbox.cfm" addToken="No">
Javascript – Get Part Url
function getPartUrl(part) {
var query = self.location.href;
if( query.indexOf(part) == -1 ){
return false;
}else{
return true;
}
}
//Example
<script>document.write getPartUrl('news.php') ? 1 : 0</script>
Javascript – Get QS
<script>
function getQueryVariable(variable) {
var query = self.location.search.substring(1);
var vars = query.split("&");
for (var i=0;i<vars.length;i++) {
var pair = vars[i].split("=");
if (pair[0] == variable) {
if( variable == 'swf'){
salida = new String(pair[1]);
salida2 = salida.substr(0,salida.length-4);
}else{
salida2 = pair[1];
}
return salida2;
}
}
}
document.write(getQueryVariable('variableGET').toString())
</script>
Query Variable Function
variable = getQueryVariable("what you want to extract");//e.g "source"
function getQueryVariable(variable) {
var query = window.location.search.substring(1);
var vars = query.split("&");
for (var i=0;i<vars.length;i++) {
var pair = vars[i].split("=");
if (pair[0] == variable) {
return pair[1];
}
}
}
query to json oblect – that can be referenced by a unique id
<cfscript>
function nowhitespace(queryname,uniqueIdColumnName,columnlist,recordcount) {
var p="";
var currentrow = 1;
p = p & '"RECORDCOUNT":' & recordcount & ',' & '"UNIQUEIDS":[';
for (ids = 1; ids lte recordcount; ids = ids+1){
p = p & '"js' & evaluate("queryname." & uniqueIdColumnName & '[' & ids & ']') & '"';
if (ids lt recordcount) {p = p & ',';}
else {p = p & '],';}
}
p = p & '"COLUMNNAMES":[' & listQualify(columnlist,'"') & '],';
for (idx = 1; idx lte recordcount; idx = idx+1)
{
p = p & '"js' & evaluate("queryname." & uniqueIdColumnName & '[' & idx & ']') & '"' & ':{';
p = p & '"CURRENTROW":' & currentrow & ',';
for (idx1 = 1; idx1 lte listlen(columnlist); idx1 = idx1+1){
clmnname = listgetat(columnlist,idx1);
p = p & '"' & clmnname & '":';
evalp = evaluate("queryname." & clmnname & '[' & idx & ']');
if (NOT isNumeric(evalp)) {evalp = '"' & JSStringFormat(evalp) & '"';}
if (idx1 IS listlen(columnlist)){p = p & evalp;}
else {p = p & evalp & ',';}
}
if (idx NEQ recordcount) {
p = p & '},';
currentrow = currentrow + 1;
}
} idx1 = 1;
p = p & '}';
return '{' & p & '}';
}
</cfscript>
php mysql/mysqli query
function sqlQuery( $sql )
{
if( in_array( 'mysql', $GLOBALS[ 'loaded_extensions' ] ) )
{
$query = mysql_query( $sql ) or die(
"<pre><font color="red"><b>Invalid SQL:</b>
("
. mysql_errno()
. ' ) '
. mysql_error()
. "
"
. "<b>Query:</b>
"
. eregi_replace( " ", ' ', $sql )
. '</font></pre>' );
}
elseif( in_array( 'mysqli', $GLOBALS[ 'loaded_extensions' ] ) )
{
$query = mysqli_query( $GLOBALS[ 'dbHandle' ], $sql ) or die(
"<pre><font color="red"><b>Invalid SQL:</b>
("
. mysqli_errno( $GLOBALS[ 'dbHandle' ] )
. ' ) '
. mysqli_error( $GLOBALS[ 'dbHandle' ] )
. "
"
. "<b>Query:</b>
"
. eregi_replace( " ", ' ', $sql )
. '</font></pre>' );
}
return $query
}