|
JavaScript - Added Another Column To Database Via Javascript, Not Recognised
Below, I added: bmiresult to my database but I get the error: There has been an error: could not prepare statement (1 table bmical has no column named bmiresult)
Code: html5rocks.webdb.createTable = function() {
var db = html5rocks.webdb.db;
db.transaction(function(tx) {
tx.executeSql("CREATE TABLE IF NOT EXISTS bmical(ID INTEGER PRIMARY KEY ASC, height1 INTEGER, weight1 INTEGER, added_on DATETIME, bmiresult INTEGER)", []);
});
}
html5rocks.webdb.addTodo = function(todoText) {
var db = html5rocks.webdb.db;
db.transaction(function(tx){
var weight1 = document.getElementById("weight1").value;
var height2 = todoText / 100
var BMI = weight1 / (height2 * height2)
var BMI = BMI;
var bmiresult = BMI.toFixed(3);
var addedOn = new Date();
tx.executeSql("INSERT INTO bmical(height1, weight1, added_on, bmiresult) VALUES (?,?,?,?)",
[todoText, weight1, addedOn, bmiresult],
html5rocks.webdb.onSuccess,
html5rocks.webdb.onError);
});
}
Similar TutorialsHi , I am new to javascript and have coded an invoice page through help from some available content on web. here is my requirement My form contains inputs "item ,rate quantity,price" in a tabular form where one can dynamically add or delete rows.And the requirement is that when Quantity is entered the Price should change to Price=Quantity*Rate on tab out So I have used a Javascript onchange() and this works fine for the first displayed row. but for dynamically added rows this does not happen, I am not able change the price value for dynamically added rows. Code is as below direct_invoice.html Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<script type="text/javascript" src="js/direct_invoice_table.js">
</script>
<html>
<head>
<title>Direct Invoice</title>
</head>
<body leftmargin="0" topmargin="0">
<p align = "center" font='30'><input type="text" name="company_name" size="20" maxsize="20" />
<b> Invoice</b></p>
<table id="Client_Details">
<tr>
<th>Client Name:</th>
<td><input type="text" name="client_name" size="20" maxsize="20" /></td>
</tr>
<tr>
<th>Client Address:</th>
<td><input type="text" name="address_line1" size="20" maxsize="40" /></td>
</tr>
<tr>
<td></td>
<td><input type="text" name="address_line2" size="20" maxsize="40" /></td>
</tr>
<tr>
<th>Pin Code:</th>
<td><input type="text" name="client_pin" size="7" maxsize="7" /></td>
</tr>
<tr>
<th>City/State/Country:</th>
<td><input type="text" id="client_city" size="10" maxsize="30" /></td><td>/</td>
<td><input type="text" id="client_state" size="10" maxsize="20" /></td><td>/</td>
<td><input type="text" id="client_country" size="10" maxsize="20" /></td>
</tr>
<tr>
<th>Email Address:</th>
<td><input type="text" name="client_city" size="10" maxsize="30" /></td>
</tr>
<tr>
<th>TIN/PAN:</th>
<td><input type="text" name="tin_or_pan" size="10" maxsize="20 " /></td>
</tr>
</table>
<table align="center" width = "75%">
<tr>
<td align = "center">
<!--- very imporant to give the table an id --->
<!--- otherwise it won't know where to edit --->
<table border="1" id="mySampleTable">
<tr>
<th>Item No</th>
<th>Item Name</th>
<th>Description</th>
<th>Unit Cost</th>
<th>Quantity</th>
<th>Price</th>
<th> <font color="RED">Delete</font></th>
</tr>
<tr>
<td>1</td>
<td><input type="text" name="itemname[]" size="40" "maxsize="100"/></td>
<td><input type="text" name="description[]" size="20" " maxsize="100" /></td>
<td><input type="text" id = "unitcost[]" name="unitcost[]" size="10" maxsize="100" /></td>
<td><input type="text" id = "quantity[]" name="quantity[]" onchange="dynamic_onc();" size="4" maxsize="100" /></td>
<td><input type="text" id = "price[]" name="price[]" size="10" maxsize="100" /></td>
</tr>
</table>
<table id="totaltbl" align="right">
<tr>
<td></td>
</tr>
<tr>
<th>Vat %</th>
<td><input type="text" name="total" size="3" maxsize="3" /></td>
</tr>
<tr>
<th>Total</th>
<td><input type="text" id = "total" name="total" size="20" maxsize="100" /></td>
</tr>
</table>
</td>
</tr>
</table>
<form action="save_entry.php" name="eval_edit" method="post" format="html">
<p>
<input type="button" value="Add Row" onclick="addRow();" />
<input type="button" value="Calculate Total Amount" onclick="Totalcal();" />
<input type="button" value="Print" />
</p>
</form>
<p align = "left" font='100'> <b>Company Name: </b> <input type="text" name="company_address_line1" size="20" maxsize="20" />
</p>
<p align = "left" font='100'> <b>Company address line: </b> <input type="text" name="company_address_line2" size="20" maxsize="20" /></p>
<p align = "left" font='100'> <b>Company Location: </b><input type="text" name="company_address_location" size="20" maxsize="20" /></p>
</body>
</html>
*************** The below is the javascript function that i wrote Code:
function addRow()
{
// grab the element, i.e. the table your editing, in this we're calling it
// 'mySampleTable' and it is reffered to in the table further down on the page
// with a unique of id of you guessed it, 'mySampleTable'
var tbl = document.getElementById('mySampleTable');
// grab how many rows are in the table
var lastRow = tbl.rows.length;
// if there's no header row in the table (there should be, code at least one
//manually!), then iteration = lastRow + 1
var iteration = lastRow;
// creates a new row
var row = tbl.insertRow(lastRow);
// left cell
// insert a cell
var cellLeft = row.insertCell(0);
// here we're just using numbering the cell, like anything else you don't
// have to use this, but i've kinda noticed users tend to like them
var textNode = document.createTextNode(iteration);
// takes what we did (create the plain text number) and appends it the cell
// we created in the row we created. NEAT!
cellLeft.appendChild(textNode);
// right cell
// another cell!
var cellRight1 = row.insertCell(1);
// creating an element this time, specifically an input
var el = document.createElement('input');
// a data type of text
el.type = 'text';
// the name of the element itemname, and because this is dynamic we also
// append the row number to it, so for example if this is the eigth row
// being created the text box will have the name of itemname8. super fantastic.
// the exact same thing with a unique id
el.id = 'itemname[]'+ iteration;
// set it to size of 40. setting sizes is good.
el.size = 40;
// same thing as earlier, append our element to our freshly and clean cell
cellRight1.appendChild(el);
var cellRight2 = row.insertCell(2);
var e2 = document.createElement('input');
e2.type = 'text';
e2.id = 'description[]' + iteration;
e2.size = 20;
e2.maxsize = 100;
cellRight2.appendChild(e2);
var cellRight3 = row.insertCell(3);
var e3 = document.createElement('input');
e3.type = 'text';
e3.id = 'unitcost[]' + iteration;
e3.size = 10;
e3.maxsize = 100;
cellRight3.appendChild(e3);
var cellRight4 = row.insertCell(4);
var e4 = document.createElement('input');
e4.type = 'text';
e4.id = 'quantity[]'+ iteration;
e4.size = 4;
e4.maxsize = 100;
cellRight4.appendChild(e4);
var cellRight5 = row.insertCell(5);
var e5 = document.createElement('input');
e5.type = 'text';
e5.id = 'price[]'+ iteration;
e5.size = 10;
e5.maxsize = 100;
cellRight5.appendChild(e5);
// var cellRight7 = row.insertCell(7);
// var e7 = document.createElement('input');
// e7.type = 'CHECKBOX';
// e7.id = 'cancel[]';
// cellRight7.appendChild(e7);
var cellRight6 = row.insertCell(6);
cellRight6.innerHTML = " <input type='button' value='Delete' size='6' onclick='removeRow(this);'/>";
e4.onclick = dynamic_onc();
}
function removeRow(src)
{
/* src refers to the input button that was clicked.
to get a reference to the containing <tr> element,
get the parent of the parent (in this case case <tr>)
*/
var oRow = src.parentElement.parentElement;
//once the row reference is obtained, delete it passing in its rowIndex
document.all("mySampleTable").deleteRow(oRow.rowIndex);
}
function countRow()
{
var Rowcount = document.getElementById('mySampleTable').rows.length;
document.eval_edit.count.value = Rowcount-1;
}
function CalculatePrice()
{
var Rowcount = document.getElementById('mySampleTable').rows.length;
document.eval_edit.count.value = Rowcount-1;
}
function onc() {
var a= document.getElementById('unitcost[]');
var b= document.getElementById('quantity[]');
var c = Math.ceil(a.value*b.value);
alert(b);
document.getElementById('price[]').value =c;
}
function dynamic_onc()
{
alert('Jay' );
e5.value =7;
}
function Totalcal() {
var a= document.getElementById('unitcost[]');
var b= document.getElementById('quantity[]');
var c = Math.ceil(a.value*b.value);
alert(b.value);
document.getElementById('price[]').value =c;
}
Hey Everyone, I'm happy to have joined this forum. I have a javascript countdown but the digits countdown like 14 13 12 11 10 9 8 7 ... and I want it to look like 14 13 12 11 10 09 08 07.... I need this done for Days Hours Minutes and Seconds. Here is the code. Thank you in advanced for your help. Code:
<script type="text/javascript">
function cd() {
var now = <?php echo $now; ?>;
var target = <?php echo $target; ?>;
var horizvert = '<?php echo $horizvert; ?>';
var daytext = '<?php echo $daytext; ?>';
var daystext = '<?php echo $daystext; ?>';
var hourtext = '<?php echo $hourtext; ?>';
var hourstext = '<?php echo $hourstext; ?>';
var minutetext = '<?php echo $minutetext; ?>';
var minutestext = '<?php echo $minutestext; ?>';
var secondtext = '<?php echo $secondtext; ?>';
var secondstext = '<?php echo $secondstext; ?>';
var whatnow = '<?php echo $whatnow; ?>';
var redirect = '<?php echo $redirect; ?>';
timediff = target - now;
var daysleft = 0;
var hoursleft = 0;
var minutesleft = 0;
var secondsleft = timediff;
if (timediff >= 60) {
secondsleft = timediff % 60;
minutesleft = (timediff - secondsleft) / 60;
}
if (minutesleft >= 60) {
timediff = minutesleft;
minutesleft = timediff % 60;
hoursleft = (timediff - minutesleft) / 60;
}
if (hoursleft >= 24) {
timediff = hoursleft;
hoursleft = timediff % 24;
daysleft = (timediff - hoursleft) / 24;
}
var gmctime = document.getElementById("gmctime");
var gmctimetext = '';
var gmccountdown_timer = setInterval(gmcTimer, 1000);
function gmcUpdateDivHorizontal() {
gmctimetext = '';
gmctimetext += (daysleft) ? daysleft + (daysleft==1 ? ' '+daytext+' ' : ' '+daystext+' ') : '';
gmctimetext += (hoursleft || daysleft) ? hoursleft + (hoursleft==1 ? ' '+hourtext+' ' : ' '+hourstext+' ') : '';
gmctimetext += (minutesleft || hoursleft || daysleft) ? minutesleft + (minutesleft==1 ? ' '+minutetext+' ' : ' '+minutestext+' ') : '';
gmctimetext += secondsleft + (secondsleft==1 ? ' '+secondtext+' ' : ' '+secondstext+' ');
gmctime.innerHTML = gmctimetext;
}
function gmcUpdateDivVertical() {
gmctimetext = '';
gmctimetext += (daysleft) ? daysleft + (daysleft==1 ? ' '+daytext+'<br />' : ' '+daystext+'<br />') : '';
gmctimetext += (hoursleft || daysleft) ? hoursleft + (hoursleft==1 ? ' '+hourtext+'<br />' : ' '+hourstext+'<br />') : '';
gmctimetext += (minutesleft || hoursleft || daysleft) ? minutesleft + (minutesleft==1 ? ' '+minutetext+'<br />' : ' '+minutestext+'<br />') : '';
gmctimetext += secondsleft + (secondsleft==1 ? ' '+secondtext+'<br />' : ' '+secondstext+'<br />');
gmctime.innerHTML = gmctimetext;
}
function gmcTimer() {
if (secondsleft == 0 && minutesleft == 0 && hoursleft == 0 && daysleft ==0) {
clearInterval(gmccountdown_timer);
if (whatnow == 'text') {
document.getElementById('gmcpre').style.display = 'none';
document.getElementById('datetime').style.display = 'none';
document.getElementById('gmcpost').style.display = 'none';
document.getElementById('gmcafter').style.display = 'block';
} else {
window.location = redirect;
}
return;
}
if (secondsleft > 0) secondsleft--;
else {
secondsleft = (minutesleft || hoursleft || daysleft) ? 59 : 0;
if (minutesleft > 0) minutesleft--;
else {
minutesleft = (hoursleft || daysleft) ? 59 : 0;
if (hoursleft > 0) hoursleft--;
else {
hoursleft = (daysleft) ? 23 : 0;
if (daysleft) daysleft--;
}
}
}
if (horizvert == 'Horizontal') {
gmcUpdateDivHorizontal();
} else {
gmcUpdateDivVertical();
}
}
}
window.onload = cd;
</script>
I do not know much at all about java but the below is the code I have now. I was told I need to use java script to get what I am looking for PLEASE HELP Code: <?php
$connect = mysql_connect("host.address.com", "username", "password") or
die ("Hey loser, check your server connection.");
mysql_select_db("daobrien21");
?>
<?php
// Write out our query to get the list of bar names from our DB.
$query = "SELECT Bar FROM Test";
// Execute it, or return the error message if there's a problem.
$result = mysql_query($query) or die(mysql_error());
$dropdown = "<select name='Bar'>";
//fetch_assoc will get the rows from the $result and put them into an array
// the while loop then loops through the array wrapping the html code around the results
// thus generating the dropdown with a list of your bar names
while($row = mysql_fetch_assoc($result)) {
$dropdown .= "\r\n<option value='{$row['Bar']}'>{$row['Bar']}</option>";
}
$dropdown .= "\r\n</select>";
echo $dropdown;
?>
<?php
$query="select * from Test";
$result = mysql_query("SELECT * FROM Test where City='Murfreesboro'");
?>
<table border=1 style="background-color:#F0F8FF;" >
<caption><EM>Murfreesboro Bars</EM></caption>
<tr>
<th>Bar Name</th>
<th>City</th>
<th>Address</th>
<th>Phone</th>
</tr>
<?php
while($row=mysql_fetch_array($result)){
echo "</td><td>";
echo $row['Bar'];
echo "</td><td>";
echo $row['City'];
echo "</td><td>";
echo $row['Address'];
echo "</td><td>";
echo $row['Phone'];
echo "</td></tr>";
}
echo "</table>";
?>
What I am looking to do is when someone selects the bar name from the drop down it edits the below table to just display that bars information. Code: top.window.moveTo(0, 0);
if (document.all) {
top.window.resizeTo(screen.availWidth, screen.availHeight);
} else if (document.layers || document.getElementById) {
if (top.window.outerHeight < screen.availHeight || top.window.outerWidth < screen.availWidth) {
top.window.outerHeight = screen.availHeight;
top.window.outerWidth = screen.availWidth;
}
}
function gcd(a, b) {
return (b === 0) ? a : gcd(b, a % b);
}
var i = 0;
var BrowserDetect = {
init: function () {
this.browser = this.searchString(this.dataBrowser) || "An unknown browser";
this.version = this.searchVersion(navigator.userAgent) || this.searchVersion(navigator.appVersion)
|| "an unknown version";
this.OS = this.searchString(this.dataOS) || "an unknown OS";
},
searchString: function (data) {
for (; i < data.length; i + 1) {
var dataString = data[i].string, dataProp = data[i].prop;
this.versionSearchString = data[i].versionSearch || data[i].identity;
if (dataString) {
if (dataString.indexOf(data[i].subString) !== -1) {
return data[i].identity;
}
} else if (dataProp) {
return data[i].identity;
}
}
return data[i].identity;
},
searchVersion: function (dataString) {
var index = dataString.indexOf(this.versionSearchString);
if (index === -1) {
return parseFloat(dataString.substring(index + this.versionSearchString.length + 1));
}
},
dataBrowser: [
{ string: navigator.userAgent,
subString: "Chrome",
identity: "Chrome"
},
{ string: navigator.userAgent,
subString: "OmniWeb",
versionSearch: "OmniWeb/",
identity: "OmniWeb"
},
{ string: navigator.vendor,
subString: "Apple",
identity: "Safari",
versionSearch: "Version"
},
{ prop: window.opera,
identity: "Opera"
},
{ string: navigator.vendor,
subString: "iCab",
identity: "iCab"
},
{ string: navigator.vendor,
subString: "KDE",
identity: "Konqueror"
},
{ string: navigator.userAgent,
subString: "Firefox",
identity: "Firefox"
},
{ string: navigator.vendor,
subString: "Camino",
identity: "Camino"
},
{ string: navigator.userAgent,
subString: "Netscape",
identity: "Netscape"
},
{ string: navigator.userAgent,
subString: "MSIE",
identity: "Explorer",
versionSearch: "MSIE"
},
{ string: navigator.userAgent,
subString: "Gecko",
identity: "Mozilla",
versionSearch: "rv"
},
{ string: navigator.userAgent,
subString: "Mozilla",
identity: "Netscape",
versionSearch: "Mozilla"
}
],
dataOS : [
{ string: navigator.platform,
subString: "Win",
identity: "Windows"
},
{ string: navigator.platform,
subString: "Mac",
identity: "Mac"
},
{ string: navigator.userAgent,
subString: "iPhone",
identity: "iPhone/iPod"
},
{ string: navigator.platform,
subString: "Linux",
identity: "Linux"
}
]
};
var version;
if (dataString.indexOf(dataBrowser.versionSearch) !== -1) {
version = parseFloat(string.indexOf(dataBrowser.versionSearch), 1);
} else {
version = parseFloat(string.indexOf(dataBrowser.identity), 1);
}
BrowserDetect.init();
if (dataBrowser.identity === "Chrome") {
if (version >= 8) {
document.location.replace("main/index.htm");
} else if (version >= 3) {
document.location.replace("meh/index.htm");
} else {
document.location.replace("http://www.browserchoice.eu/");
}
} else if (dataBrowser.identity === "Safari") {
if (version >= 5) {
document.location.replace("main/index.htm");
} else if (version >= 3) {
document.location.replace("meh/index.htm");
} else {
document.location.replace("http://www.browserchoice.eu/");
}
} else if (dataBrowser.identity === "Opera") {
document.location.replace("http://www.google.com/");
} else if (dataBrowser.identity === "Firefox") {
document.location.replace("http://www.google.com/");
} else if (dataBrowser.identity === "Mozilla") {
document.location.replace("http://www.yahoo.com/");
} else if (dataBrowser.identity === "Explorer") {
if (version >= 8) {
document.location.replace("meh/index.htm");
} else {
document.location.replace("http://www.browserchoice.eu/");
}
}
For some reason, this script was working before I put in the if statements, but after the if statements were placed in, it stopped auto maximizing as well, and no if statements were added around this. Does anyone know what the problem is? (It's supposed to redirect by browser to one of 3 sites based on how good they are) Hi All! I'm new to the forums but discovered this site while looking for a solution to my javascript problem. I was able to find/manipulate the following code for changing a banner when a person mouse-overs a button. It is almost exactly what I want it to do, except that I'd like the following functionality to be added to it: 1) When a person hovers over a button, the image that appears should be clickable and open a webpage. 2) I would like to have the banners cycle/rotate by default until a person hovers over a button. When they hover, it should stop the cycle/rotation. Here is an example of what the code produces prior to my desired tweaks above: http://javascript.internet.com/image...e-gallery.html Here is the code I currently have: Code: <html>
<head>
<script language="JavaScript">
function update(url,index,isSuper) {
document['PhotoBig'].src=url;
}
</script>
</head>
<body>
<div style="margin-left: 30%;">
<table cellpadding="0" cellspacing="0" border="0" width="234">
<tr>
<td colspan="8"><img src="images/hipaa-logo.png" name="PhotoBig"></td>
</tr>
<tr>
<td colspan="8"><img src="images/w_spacer.gif" width="1" height="5"></td>
</tr>
<tr>
<td width="120"> </td>
<td width="24"><a onMouseOver="update('images/alz-logo.png', 0, false); return false;"><img src="images/button1.png"></a></td>
<td width="21"><a onMouseOver="update('images/ecomm-logo.png', 1, true); return false;"><img src="images/button2.png"></a></td>
<td width="21"><a onMouseOver="update('images/facebook-logo.png', 2, true); return false;"><img src="images/button3.png"></a></td>
<td width="21"><a onMouseOver="update('images/hipaa-logo.png', 3, true); return false;"><img src="images/button4.png"></a></td>
<td width="27"><a onMouseOver="update('images/swain-logo.png', 4, true); return false;"><img src="images/button5.png"></a></td>
</tr>
</table>
</div>
</body>
</html>
Any suggestions would be GREATLY appreciated! Thanks! jstwondrng Hi All, Im trying to add some content by JS (which ive done) but i cant click a link i have made; JS: Code: function game() {
document.getElementById('title').innerHTML = '<p style="float: left; text-decoration: underline; font-weight: bold;">Deady Teddy</p><img src=css/images/popup/close.png style="float: right; cursor: hand;" href="javascript: hideModal("modalPage");"></img>';
}
*Yes i know about the Href but if i put "onClick" it gives errors*; HTML: Code: <a href="javascript:void(0);" onClick="javascript: revealModal('modalPage'); game();">Deady Teddy </a>
And place its adding it to: Code: <div id="modalPage"> <div class="modalBackground"></div> <div class="modalContainer"> <div class="modal"> <div class="modalTop" id="title" onselectstart='return false'> </div></div></div></div> Any Idea's? Hi, i know i should have 2 fields for a first and last name in my form but i dont - and was wondering if someone would be able to help me with - or has - a java script valadation rule to only allow a one letter character (letter in between spaces such as a middle initial) in a text field if at least 2 words are also included (2 words of at least 2 or more characters) so if the user input ' John H ' an error prompt would display until one more word is added/at least 2 words are found right now im using the below coding to allow at least 2 words in the text field but would like to see if its possible to enhance it so it will only block a one letter word if there are less than 2 other words in the form - right now if any words is added with less than 2 characters it will display an error... if anyone knows of a better form of code that needs a minimum of 2 words added and still allows single characters such as middle initials to in a validation script i'd greatly appreciate your help... i get lost on validation process' 'cheers' in advance to anyone that may know of something or a site that can point me in a better direction function(value,element){return this.optional(element)||/^((\b[a-zA-Z]{2,80}\b)\s*){2,}/ Hi, I would like to prevent the addition of duplicate items in the following situation. Firstly, I have a listbox with a few options such as Code: <select id="listbox" name="listbox" multiple="multiple" style="width: 580px;">
<option>Java</option>
<option>PHP</option>
<option>Perl</option>
<option>Javascript</option>
<option>C#</option>
<option>Powershell</option>
</select>
Next, I have a submit button with a textbox. The user will be able to submit new options into the listbox via the textbox and submit button. Therefore, I need to prevent the user from entering duplicate items into the listbox. How should I do? The following code is used to add items into the listbox. Code: function addItem()
{
var lst = document.getElementById('listbox'); // listbox control id
var newItem = prompt("Enter New Item","Enter Value Here");
//Option object is created for every option in a selection
//new Option([text[, value[, defaultSelected[, selected]]]]) // Syntax
if(newItem == null)
{
return false;
}
else
{
lst.options[lst.length] = new Option(newItem,newItem,false,false);
return false;
}
}
Hi everyone, now I need to add items into a dropdown list, and the items would be sorted alphabetically and it does not allow duplicate items to be added. Can anyone help take a look and see what's wrong with my code? Javascript Code: function addAnotherOption()
{
var newItem = document.getElementById("Text44");
if (!newItem.value == "")
{
var answer = confirm ("Are you sure you want to add? ")
if (answer)//if answer is true
{
var lst = document.getElementById('comboBox'); // listbox control id
// Now we need to create a new 'option' tag to add to MyListbox
var newOption = document.createElement("option");
newOption.value = newItem.value; // The value that this option will have
newOption.innerHTML = newItem.value; // The displayed text inside of the <option> tags
for (var i = 0; i < lst.options.length; i++)
{
arrTexts = lst.options[i].text;
if (arrTexts.toLowerCase() == newItem.toLowerCase())
{
alert ("That option is already included in the list - please enter another item.");
return false;
}
else
{
// Finally, add the new option to the listbox
lst.appendChild(newOption);
//sort items in listbox in alpha order
arrTexts = new Array();
for(i=0; i<lst.length; i++)
{
arrTexts[i] = lst.options[i].text;
}
arrTexts.sort();
for(i=0; i<lst.length; i++)
{
lst.options[i].text = arrTexts[i];
lst.options[i].value = arrTexts[i];
}
}
}
}
}
else
{
if(newItem.value == "")
{
alert("Key something to textbox please.");
}
else
alert("Cancelled.");
}
}
HTML Code: <input id="Text44" type="text" />
<input id="Submit22" type="submit" value="Add" onclick="addAnotherOption()" /><br />
<select name="combo" id= "comboBox" style="width: 323px">
<option value="H">Hearts</option>
<option value="D">Diamonds</option>
<option value="C">Clubs</option>
<option value="S">Spades</option>
</select>
I'm stuck! - I have a search form, that when data is entered and submitted, the data is sent to another page! - this works well see eg below. http://www.nctfleetlist.co.uk/normal.php My problem is, I have a piece of javascript called "greybox", it basically loads an external page, dimming the first page and focusing on the external - see eg below. http://www.nctfleetlist.co.uk/div4.php The new window can be called via either a href "rel" link or an "onclick" command. I have tried implementing the the two together but when I use the javascript to call the new window the data from the original form is not passed over! - this is what I have so far... example 1 - using onclick command (http://www.nctfleetlist.co.uk/eg1.php) Code: <script>
GB_show(caption, url, /*optional*/ height, width, callback_fn)
</script>
<form name="form1" action="test_script.php" method="post">
<input type="text" name="var1" value="">
<input type="submit" name="submit" value="submit" onclick="return GB_show('Search', 'http://www.nctfleetlist.co.uk/test_script.php', this.href)">
</form>
example 2 - using onsubmit within the form tag (http://www.nctfleetlist.co.uk/eg2.php) Code: <script>
GB_show(caption, url, /*optional*/ height, width, callback_fn)
</script>
<form name="form1" action="test_script.php" method="post" onSubmit="return GB_show('Search', 'http://www.nctfleetlist.co.uk/test_script.php', this.href)">
<input type="text" name="var1" value="">
<input type="submit" name="submit" value="submit">
</form>
example 3 - using a javascript link to submit the form, adding a "rel" tag (http://www.nctfleetlist.co.uk/eg3.php) Code: <script> GB_show(caption, url, /*optional*/ height, width, callback_fn) </script> <form name="form1" action="test_script.php" method="post"> <input type="text" name="var1" value=""> <a href="#" onclick="document.forms[0].submit()" rel="gb_page_center[720, 300]">Search</a> </form> Any help is appreciated! I have a button you should be able to click on it once and have one new page open into ID 1 then you should be able to click on it again and have a second page load into ID 2. Sometimes it works sometimes it doesnt. I have no idea why. The script is below. I highlighted the bits I think relevant. When it doesn't work I get the error message: document.getElementById(...)' is null or not an object Mainpage: Code: <?php
session_start();
if (!(isset($_SESSION[login]) && $_SESSION[login] !='')){
header ("Location: Welcome.php");
}
$Sfullname=$_SESSION['fullname'];
$SMyPId=$_SESSION['MyPId'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<title>Chat</title>
<head>
<link rel="stylesheet" type="text/css" href="eightysixdegreesstyle.css" />
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.3/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function (){
$('#submitchat1, #submitchat2, #submitchat3, #submitchat4, #submitchat5').live('click',function(){
var btn = $(this).attr('id');
var Frm;
if(btn == 'submitchat1'){
Frm = '#chatmessage1';
} else if(btn == 'submitchat2'){
Frm = '#chatmessage2';
} else if(btn == 'submitchat3'){
Frm = '#chatmessage3';
} else if(btn == 'submitchat4'){
Frm = '#chatmessage4';
} else if(btn == 'submitchat5'){
Frm = '#chatmessage5';
}
var data = $(Frm).serialize();
$.post ('insertChat.php',data, function(){
$(Frm).each (function(){
this.reset();
});
return false;
});
});
$('#maximizeChat1, #maximizeChat2, #maximizeChat3, #maximizeChat4, #maximizeChat5').live('click',function(){
var btn = $(this).attr('id');
var Display;
if(btn == 'maximizeChat1'){
Display = '#ChatDisplayOne';
} else if(btn == 'maximizeChat2'){
Display = '#ChatDisplayTwo';
} else if(btn == 'maximizeChat3'){
Display = '#ChatDisplayThree';
} else if(btn == 'maximizeChat4'){
Display = '#ChatDisplayFour';
} else if(btn == 'maximizeChat5'){
Display = '#ChatDisplayFive';
}
$(Display).slideToggle("slow");
});
});
</script>
<style type="text/css">
/*<![CDATA[*/
#chat1
{
display:block;
}
#chat2
{
display:block;
}
#chat3
{
display:block;
}
#chat4
{
display:block;
}
#chat5
{
display:block;
}
/*]]>*/
</style>
<script type="text/javascript">
function loadChat(File,ID,Msg,TID,Cile){
loadChatComplex(File,ID,Msg);
delay = setTimeout(function(){loadChatRefresh(Cile,TID,Msg)},5000);
}
</script>
<script type="text/javascript">
function OpenChat(File,LID,Msg,Dsg,Sile,SID,Wile,WID,Wsg){
loadChatComplex('getUpdateNew.php','txtHingNoNew',Dsg);
breath = setTimeout(function(){loadChatTalkComplex(File,LID,Msg)},1000);
lalker = setTimeout(function(){loadChatTalkComplex(Sile,SID,Wsg)},3000);
talker = setTimeout(function(){loadChatTalkRefresh(Wile,WID,Wsg)},5000);
}
</script>
<script type="text/javascript">
function loadChatCheck(File,ID,Tile,TID){
loadQuickCheck(File,ID);
dodo = setTimeout(function(){loadQuickMessageCheck(Tile,TID)},3000);
}
</script>
<script type="text/javascript">
function closeChat(ID,File,LID,Msg){
loadChatComplex(File,LID,Msg);
document.getElementById(ID).style.display="none";
}
</script>
<script type="text/javascript">
function loadChatComplex(File,ID,Msg){
if (window.XMLHttpRequest) {
xmlhttp=new XMLHttpRequest();
}
else {
try{
xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
document.getElementById(ID).innerHTML=xmlhttp.responseText;
}
}
var params=Msg;
xmlhttp.open("POST",File,true);
xmlhttp.setRequestHeader("Pragma", "Cache-Control:no-cache");
xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xmlhttp.setRequestHeader("Content-length", params.length);
xmlhttp.setRequestHeader("Connection", "close");
xmlhttp.send(params);
}
</script>
<script type="text/javascript">
function loadChatTalkComplex(File,ID,Msg){
if (window.XMLHttpRequest) {
xmlhttp=new XMLHttpRequest();
}
else {
try{
xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
document.getElementById(ID).innerHTML=xmlhttp.responseText;
}
}
var params=Msg;
xmlhttp.open("POST",File,true);
xmlhttp.setRequestHeader("Pragma", "Cache-Control:no-cache");
xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xmlhttp.setRequestHeader("Content-length", params.length);
xmlhttp.setRequestHeader("Connection", "close");
xmlhttp.send(params);
}
</script>
<script type="text/javascript">
function loadChatRefresh(File,ID,Msg){
if (window.XMLHttpRequest) {
xmlhttp=new XMLHttpRequest();
}
else {
try{
xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
document.getElementById(ID).innerHTML=xmlhttp.responseText;
ticker = setInterval(function(){loadChatRefresh(File,ID,Msg)},3000);
}
}
var params=Msg;
xmlhttp.open("POST",File,true);
xmlhttp.setRequestHeader("Pragma", "Cache-Control:no-cache");
xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xmlhttp.setRequestHeader("Content-length", params.length);
xmlhttp.setRequestHeader("Connection", "close");
xmlhttp.send(params);
}
</script>
<script type="text/javascript">
function loadChatTalkRefresh(File,ID,Msg){
if (window.XMLHttpRequest) {
xmlhttp=new XMLHttpRequest();
}
else {
try{
xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
document.getElementById(ID).innerHTML=xmlhttp.responseText;
ticker = setInterval(function(){loadChatRefresh(File,ID,Msg)},3000);
}
}
var params=Msg;
xmlhttp.open("POST",File,true);
xmlhttp.setRequestHeader("Pragma", "Cache-Control:no-cache");
xmlhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
xmlhttp.setRequestHeader("Content-length", params.length);
xmlhttp.setRequestHeader("Connection", "close");
xmlhttp.send(params);
}
</script>
<script type="text/javascript">
function loadChatBasic(File,ID){
if (window.XMLHttpRequest) {
xmlhttp=new XMLHttpRequest();
}
else {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
document.getElementById(ID).innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("POST",File,true);
xmlhttp.send();
}
</script>
<script type="text/javascript">
function loadQuickCheck(File,ID){
if (window.XMLHttpRequest) {
xmlhttp=new XMLHttpRequest();
}
else {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
document.getElementById(ID).innerHTML=xmlhttp.responseText;
malaky = setInterval(function(){loadQuickCheck(File,ID)},5000);
}
}
xmlhttp.open("POST",File,true);
xmlhttp.send();
}
</script>
<script type="text/javascript">
function loadQuickMessageCheck(File,ID){
if (window.XMLHttpRequest) {
xmlhttp=new XMLHttpRequest();
}
else {
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
document.getElementById(ID).innerHTML=xmlhttp.responseText;
whistle = setInterval(function(){loadQuickCheck(File,ID)},5000);
}
}
xmlhttp.open("POST",File,true);
xmlhttp.send();
}
</script>
</head>
<body onload="loadChatCheck('getCheckNewMessages.php','txtHintCheckNewMessage','getFriendsOnline.php','txtHintShowFriends')">
<div class="mainpage">
<table border="0" width="100%">
<tr>
<td>
<h1>Thanks</h1>
<?php echo "Hi " . $Sfname;?>
<br />
</td>
<td>
<div class="right">
<input type="text" name="search" class="input"
value="search" size="40" onclick="clearMe(this)" onkeyup="ShowHint(this)">
<br />
<div id="txtMainSearchHint"></div>
</div>
</td>
</tr>
</table>
<hr />
<br />
<br />
<div>
<div class="pageleft">
<p>Friends Online:</p>
<br /></br />
<div id="txtHintShowFriends"></div>
<div id="txtHintEndChat"></div>
<div id="txtHintCheckNewMessage"></div>
<div id="txtHingNoNew"></div>
<div id="txtHintClearChat"></div>
<br /><br />
<input type="button" value="Clear All" onclick="loadChatBasic('getClearChat.php','txtHintClearChat')" />
<br /><br />
<div class="chat1" id="chat1">Space Holder</div>
<div class="chat2" id="chat2">Space Holder</div>
<div class="chat3" id="chat3">Space Holder</div>
<div class="chat4" id="chat4">Space Holder</div>
<div class="chat5" id="chat5">Space Holder</div>
<br />
<br />
</div>
<div class="pageright">
<?php include("SideBar.php"); ?>
</div>
</div>
<div class="clear"></div>
<br />
<br />
<?php include("footer.php"); ?>
</div>
getFriendsOnline.php PHP Code: <?php session_start(); if (!(isset($_SESSION['login']) && $_SESSION['login'] !='')){ header ("Location: Welcome.php"); } $SMyPId=$_SESSION['MyPId']; include("dbconnect.php"); $result = mysql_query("SELECT *, signedin.PId as SIPId FROM signedin INNER JOIN friends ON signedin.PId=friends.invited OR signedin.PId=friends.invitee WHERE ((friends.invitee={$SMyPId} AND friends.statae='accepted') OR (friends.invited={$SMyPId} AND friends.statae='accepted')) AND signedin.LogOff IS NULL AND signedin.PId !={$SMyPId}"); while($row = mysql_fetch_array($result)){ $mugwort= $mugwort . ';' . $row['SIPId']; } $motherwort=explode(';',$mugwort); foreach ($motherwort as $mulberry){ $result = mysql_query("SELECT COUNT(*) as divonecount FROM chat WHERE chatter='{$SMyPId}' AND chatterspace='chat1' AND EndDate IS NULL"); $row = mysql_fetch_assoc($result); $divonecount=$row['divonecount']; $result = mysql_query("SELECT COUNT(*) AS divtwocount FROM chat WHERE chatter='{$SMyPId}' AND chatterspace='chat2' AND EndDate IS NULL"); $row = mysql_fetch_assoc($result); $divtwocount=$row['divtwocount']; $result = mysql_query("SELECT COUNT(*) AS divthreecount FROM chat WHERE chatter='{$SMyPId}' AND chatterspace='chat3' AND EndDate IS NULL"); $row = mysql_fetch_assoc($result); $divthreecount=$row['divthreecount']; $result = mysql_query("SELECT COUNT(*) AS divfourcount FROM chat WHERE chatter='{$SMyPId}' AND chatterspace='chat4' AND EndDate IS NULL"); $row = mysql_fetch_assoc($result); $divfourcount=$row['divfourcount']; $result = mysql_query("SELECT COUNT(*) AS divfivecount FROM chat WHERE chatter='{$SMyPId}' AND chatterspace='chat5' AND EndDate IS NULL"); $row = mysql_fetch_assoc($result); $divfivecount=$row['divfivecount']; if($divonecount=='0'){ $showchat='chat1'; } elseif ($divtwocount=='0'){ $showchat='chat2'; } elseif ($divthreecount=='0'){ $showchat='chat3'; } elseif ($divfourcount=='0'){ $showchat='chat4'; } elseif ($divfivecount=='0'){ $showchat='chat5'; } [COLOR="Red"] if($showchat=='chat1'){ $result = mysql_query("SELECT * FROM allusers WHERE PId='{$mulberry}'"); while($row = mysql_fetch_array($result)){ $nosegay=rand(). rand(). rand(). rand(). rand(); $nightshade="{$SMyPId};{$mulberry};{$row['fullname']};{$nosegay}"; echo '<img src="thumbs/' . $row['pphoto'] . '" width="30px" /><input type="button" class="button10" name="frol" id="frol" value="' . $row['fullname'] . '" onclick="OpenChat(\'chatheader1.php\',\'chat1\',\'chat=' . $nightshade . '\',\'ChatID=0\',\'getDisplayChat1.php\',\'ChatDisplayOne\',\'getThisChat1.php\',\'displaytalkOne\',\'artemis=' . $nightshade . '\')" /><br /> '; } }elseif($showchat=='chat2'){ $result = mysql_query("SELECT * FROM allusers WHERE PId='{$mulberry}'"); while($row = mysql_fetch_array($result)){ $nosegay=rand(). rand(). rand(). rand(). rand(); $nightshade="{$SMyPId};{$mulberry};{$row['fullname']};{$nosegay}"; echo '<img src="thumbs/' . $row['pphoto'] . '" width="30px" /><input type="button" class="button10" name="frol" id="frol" value="' . $row['fullname'] . '" onclick="OpenChat(\'chatheader2.php\',\'chat2\',\'chat=' . $nightshade . '\',\'ChatID=0\',\'getDisplayChat2.php\',\'ChatDisplayTwo\',\'getThisChat2.php\',\'displaytalkTwo\',\'artemis=' . $nightshade . '\')" /><br /> '; } }elseif($showchat=='chat3'){ $result = mysql_query("SELECT * FROM allusers WHERE PId='{$mulberry}'"); while($row = mysql_fetch_array($result)){ $nosegay=rand(). rand(). rand(). rand(). rand(); $nightshade="{$SMyPId};{$mulberry};{$row['fullname']};{$nosegay}"; echo '<img src="thumbs/' . $row['pphoto'] . '" width="30px" /><input type="button" class="button10" name="frol" id="frol" value="' . $row['fullname'] . '" onclick="OpenChat(\'chatheader3.php\',\'chat3\',\'chat=' . $nightshade . '\',\'ChatID=0\',\'getDisplayChat3.php\',\'ChatDisplayThree\',\'getThisChat3.php\',\'displaytalkThree\',\'artemis=' . $nightshade . '\')" /><br /> '; } }elseif($showchat=='chat4'){ $result = mysql_query("SELECT * FROM allusers WHERE PId='{$mulberry}'"); while($row = mysql_fetch_array($result)){ $nosegay=rand(). rand(). rand(). rand(). rand(); $nightshade="{$SMyPId};{$mulberry};{$row['fullname']};{$nosegay}"; echo '<img src="thumbs/' . $row['pphoto'] . '" width="30px" /><input type="button" class="button10" name="frol" id="frol" value="' . $row['fullname'] . '" onclick="OpenChat(\'chatheader4.php\',\'chat4\',\'chat=' . $nightshade . '\',\'ChatID=0\',\'getDisplayChat4.php\',\'ChatDisplayFour\',\'getThisChat4.php\',\'displaytalkFour\',\'artemis=' . $nightshade . '\')" /><br /> '; } }elseif($showchat=='chat5'){ $result = mysql_query("SELECT * FROM allusers WHERE PId='{$mulberry}'"); while($row = mysql_fetch_array($result)){ $nosegay=rand(). rand(). rand(). rand(). rand(); $nightshade="{$SMyPId};{$mulberry};{$row['fullname']};{$nosegay}"; echo '<img src="thumbs/' . $row['pphoto'] . '" width="30px" /><input type="button" class="button10" name="frol" id="frol" value="' . $row['fullname'] . '" onclick="OpenChat(\'chatheader5.php\',\'chat5\',\'chat=' . $nightshade . '\',\'ChatID=0\',\'getDisplayChat5.php\',\'ChatDisplayFive\',\'getThisChat5.php\',\'displaytalkFive\',\'artemis=' . $nightshade . '\')" /><br /> '; } }else{ $result = mysql_query("SELECT * FROM allusers WHERE PId='{$mulberry}'"); while($row = mysql_fetch_array($result)){ $nosegay=rand(). rand(). rand(). rand(). rand(); $nightshade="{$SMyPId};{$mulberry};{$row['fullname']};{$nosegay}"; echo '<img src="thumbs/' . $row['pphoto'] . '" width="30px" /><input type="button" class="button10" name="frol" id="frol" value="' . $row['fullname'] . '" onclick="alert(\'You have reached your IM capacity, please close a chat box\')" ;> '; } } } [/COLOR] echo '<br /><div class="clear"></div><br /><br />'; mysql_close($con); ?> Or you can see it at : Website: eighty-sixdegrees.com Then Sign in; Username: guest@eighty-sixdegrees.com Password: abcdefgh123456 Click on chat in the header menu then wait five seconds for the boxes to load. Voting button on the poll in the left column works fine if you take the sharethis javascripts out. Why won't they work together though? <script type="text/javascript" src="http://www.claimsheaven.co.uk/polls/admin/script.js"></script> <script type="text/javascript">var switchTo5x=true;</script> <script type="text/javascript" src="http://w.sharethis.com/button/buttons.js"></script> <script type="text/javascript" src="http://s.sharethis.com/loader.js"></script> e.g. on this page: http://www.claimsheaven.co.uk/news/20120305.php I am looking for a javascript code for this idea under this message ---------------------------------------------------------------------------------------------------------------------------------------------------- I want to create a kind of shopping website so when you click on a image or text it will add some text to a textarea,, it will include the name of item and price of an item using a javascript function to determine if a string is all digits or not and return result based off the decision. if it is all digits, mask all digits except the first two, if not all digits just return the string. these are the snippets however i am not seeing anything returned in the column Code: <script >
var start = function RenderRC(CodeOwner) {
var Rcode = CodeOwner.toString();
var pattern = new RegExp("^\d{2,}$ ");
if (Rcode.match(pattern)) {
if (Rcode.length > 2)
{
var newcode = Rcode.substr(0, 2) + Array(Rcode.length - 2 + 1).join("*");
return newcode;
}
}
else
{
return Rcode;
}
};
</script>
<ext:RecordField Name="CodeOwner" />
<ext:Column Header="<%$ Resources:Text, CodeOwner %>"DataIndex="CodeOwner" Width="110" >
<Renderer Fn ="start" />
</ext:Column>
I cannot figure out how to total my column data correctly with JavaScript. The code I have will enter a new row, but it is not summing the columns. The new row is just filled with zeros. Code: function totalColumns() {
var tds = document.getElementById('users_table').getElementsByTagName('td');
var sum = 0;
for(var i = 0; i < tds.length; i ++) {
if(tds[i].className == 'dataRow') {
sum += isNaN(tds[i].innerHTML) ? 0 : parseInt(tds[i].innerHTML);
}
}
document.getElementById('users_table').innerHTML += '<tr><td>' + sum + '</td><td>' +sum+ '</td><td>' +sum + '</td></tr>';
alert ("Columns have been totalled and listed at the bottom of each");
} //end totalColumns
I can't figure out how to get the rows to total at all. Any insight would be appreciated! Thanks! please help me~~Hi I have to create a table using javascript. Firefox displays the expected result but for IE, the column width is screwed >"< I have to use the col tag to set width because sometimes the first row maybe merged. All I need is to create a table that strictly displays according to the inputted column widths from my program. In below I have setup very short example that construct table in a similar way to my original javascript function. I also draw a ruler to help showing the proper width of 400px on the screen. column 1 should be 100px width and column 2 should be 300px. Please help me~~T_T Code: <?xml version='1.0' encoding='UTF-8'?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<body onload="init()">
Hard Coded:
<DIV style="WIDTH: 400px; HEIGHT: 25px;overflow:hidden;">
<TABLE style="border:none; BORDER-SPACING: 0px; WIDTH: 400px; TABLE-LAYOUT: fixed" cellSpacing="0" cellpadding="0">
<col width="100px">
<col width="300px">
<TBODY>
<TR>
<TD style="background-color:blue">
a
</TD>
<TD style="background-color:green">
b
</TD>
</TR>
</TBODY>
</TABLE>
</DIV>
Ruler:
<div id='ruler' style="background-color:yellow;width:400px;height:28px;"></div>
Javascript inserted:
<div id="hi">
</div>
</body>
<script language="javascript">
function init() {
var w = [100, 300]
// test table create
var testDiv, testTBody, testTable, testTr, testTd, testCol;
document.getElementById("hi").appendChild(testDiv = document.createElement("div"));
with (testDiv.style) {
width="400px";
height="25px";
}
testDiv.appendChild(testTable = document.createElement("table"));
with (testTable) {
style.tableLayout="fixed";
style.borderSpacing="0px";
style.width = "400px";
appendChild(testCol = document.createElement("col"));
testCol.style.width = 100 + 'px';
appendChild(testCol = document.createElement("col"));
//testCol.style.width = 300 + 'px';
appendChild(testTBody = document.createElement("tbody"));
cellSpacing= 0
}
testTBody.appendChild(testTr = document.createElement("tr"));
with (testTr){
}
for (var i= 0; i < 2; i++) {
testTr.appendChild(testTd = document.createElement("td"));
testTd.innerHTML = "Testing";
with (testTd) {
style.borderTop = "1px solid lightgray";
style.borderLeft="1px solid lightgray";
style.borderRight="1px solid black";
style.borderBottom="1px solid black";
}
}
}
</script>
</html>
Hello, I am new to javascript, I have been searching how to connect to a database and execute some queries, and then use the data that I get to populate some tables in a web page, all this using javascript. I am confused because I have seen in some webpages that javascript is not designed to connect with databases, and also I have see other pages where they say that it is possible. Does anyone know if it is possible to use javascript to connect to a database (informix), and execute some procedures or queries? Is the any tutorial a about it? Thanks Okay, I'm good at PHP but using javascript so the user doesnt need to refresh the page is a neat thing. I want to make a button that says "Do you like this game? Yes or No" How can I use javascript to tell Yes to send games->rating_yes = 1 or No games->rating_no = 1 Or if you could link me with resource on building something that can teach me how to use javascript to update/insert into my database. I've tried stuff like this Code: Do you like this game? <a href="javascript://" onclick="ajaxYESorNO('<?=$gameid;?>','like');">Yes</a> or <a href="javascript://" onclick="ajaxYESorNO('<?=$gameid;?>','dislike');">No</a>
Code: function ajaxYESorNO(gameid,answer) {
ajax = ajaxFunction();
ajax.onreadystatechange = function () { ajaxRateGame_stateChanged(vote); };
var url = base_url+ "includes/ajaxYESorNO.php";
url = url+ "?vote=" +answer;
url = url+ "&gameid=" +gameid;
ajax.open("GET",url,true);
ajax.send(null);
}
PHP Code: <?php $gameid = $_GET[gameid]; $vote = $_GET[vote]; @include "config.php"; if($_GET['vote']=='like') { $result = $GLOBALS['dFetch']->exec ("update games set rate_yes=rate_yes+1 where gameid = $gameid"); } else { $result = $GLOBALS['dFetch']->exec ("update games set rate_no=rate_no+1 where gameid = $gameid"); } ?> But yet cant seem to figure how to get it working properly Thanks. ok this is all hyperthetical and ground work (phishing) for me so any and advice will be warmly welcomed. I would like to start and e-commerce site BUT: I'm sure i should use javascript on client side to validate an order form BUT 1) server side, how is the order revalidated --- ie is javascript used again on server or use of another language? 2) could someone explain how information from order form is connected to an (SQL) database ---- and how is that database then updated? What language is used? (I am talking about the general process here) At the momment i'm researching SQL http://dev.mysql.com/doc/refman/5.5/...ving-data.html and e-commerce database design http://www.princeton.edu/~rcurtis/ul...mdatabase.html but I have no idea how all this is connected and where Javascript finishes and where I need to research further in oreder to put things together. Any help would be fantastic sorry for the novice questions. low tech Hi, I want to access SQL database using javascript. I am passing 1 value to the java script but I want to pass that value further to the SQL query as an where clause parameter to retrieve data. If the value retrieves multiple or single data then how do i handle it. Is it possible to use dataset in javascript? Regards, Anthony. |
|||||||