|
JavaScript - Load Data From Database Onto A Form
how can I load data onto a form using jquery/java?
Similar TutorialsHi, I was going through this tutorial: http://www.electrictoolbox.com/json-...ery-php-mysql/ and I changed it round slightly, I would like the first select box to be Search by either Town or County - Having links would easier?! http://www.mypubspace.com/dashnew/ So, when a user selects Town, the PHP selects the Towns or if the user selects County, then show the Counties list I am currently getting the following error: $ is not defined [Break On This Error] $(document).ready(function() { here is my HTML Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
<script language="javascript" type="text/javascript">
function populateFruitVariety() {
$.getJSON('search-by.php', {fruitName:$('#fruitName').val()}, function(data) {
var select = $('#fruitVariety');
var options = select.attr('options');
$('option', select).remove();
$.each(data, function(index, array) {
options[options.length] = new Option(array['variety']);
});
});
}
$(document).ready(function() {
populateFruitVariety();
$('#fruitName').change(function() {
populateFruitVariety();
});
});
</script>
</head>
<body>
<form>
Search by:
<select name="name" id="fruitName">
<option>Please Select</option>
<option id="Town">Town</option>
<option id="County">County</option>
</select>
Variety:
<select name="variety" id="fruitVariety">
</select>
</form>
</body>
</html>
PHP Code: <?PHP
$dsn = "mysql:host=xxx;dbname=[xxx]";
$username = "[xxx]";
$password = "[xxx]";
$pdo = new PDO($dsn, $username, $password);
$rows = array();
if(isset($_GET['Town'])) {
$stmt = $pdo->prepare("SELECT rsTown FROM pubs WHERE name = ?");
$stmt->execute(array($_GET['rsTown']));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
if(isset($_GET['County'])) {
$stmt = $pdo->prepare("SELECT rsCounty FROM pubs WHERE name = ?");
$stmt->execute(array($_GET['rsCounty']));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
echo json_encode($rows);
?>
Please help Hello, I am trying to copy data from one element to another on page load. Below is the scenario: I want to copy the below data within each element <h2>Product Name</h2> <div class="price">$9.99</div> To the different parts of this URL <a href="https://myaccount.foxycart.com/cart?name=PRODUCT NAME&price=PRICE" class="foxycart">Add to Cart</a> Thank you in advance for your help. Hi, Need to put a cursor in a password form on page load here is what I got that does not work. This will be used on a touch screen Code: <script type = "text/javascript">
var count = 2;
function validate() {
var pw = document.myform.pword.value;
var valid = false;
/*Failed attempt to put cursor in myform on page Load */
function setCursor(myform){
return set;
}
var pwArray = ["1701", "Password2", "Password3", "Password4"]; // the corresponding passwords;
for (var i=0; i <pwArray.length; i++) {
if (pw == pwArray[i]) {
valid = true;
break;
}
}
if (valid) {
alert ("Login was successful");
window.location = "030.html";
return false;
}
var t = " tries";
if (count == 1) {t = " try"}
if (count >= 1) {
alert ("Invalid password. You have " + count + t + " left.");
document.myform.pword.value = "";
setTimeout("document.myform.pword.select()", 25);
count --;
}
else {
alert ("Still incorrect! You have no more tries left!");
document.myform.pword.value = "";
document.myform.pword.disabled = true;
return false;
}
}
</script>
Thank you for any help. Hello all, I am building a service that other developers will use. As part of this, they need to embed a form on their website. This form will be hosted on my server, be updated periodically, etc. We'd been trying to create a Javascript file that would use JQuery to load the form, but we're running into issues from the Same Origin Policy, where Ajax requests cannot be made across different domains. Does anyone have an idea of how to fix this? We thought about using an iframe, but that solution will not suffice. Thanks! I am creating a customized home page that can display regular links and login forms. I am adding Gmail login form into it. I can further customize it by putting multiple sign in buttons that can fill in username/password for different accounts before submitting. Here's the preview: http://imgur.com/s4Ert.jpg Now the problem is, in Gmail login form a hidden variable called "dsh" is filled with a value that is matched with server as well as a cookie, this value changes in some hours. So this means that I cannot create a complete offline form, but is it possible to load the login page hidden, and catch the value from it? I tried with an iframe with display:none and src="http://mail.google.com" but it opened in the top frame. Any other ideas? In short, what we need is, every time a page is opened from my computer, an online page should be open invisible from the user, and a hidden form value is to be fetched from it. Hi guys, Been stuck for a few days with this scenario. Any help? The alert box appears on an error. But the submitting won't stop. The details are submitted and the form is processed. Any help is greatly appreciated... Code: <html>
<head>
<script type="text/javascript" src="email_helper/jscripts/tiny_mce/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
// General options
mode : "textareas",
theme : "simple"
});
</script>
<script language="javascript">
function MM_openBrWindow(theURL,winName,features) {
window.open(theURL,winName,features);
}
function err_check(){
var email = document.getElementById('to_email').value;
if(email.length==0){
alert('Please Enter Email Address');
return false;
}
var AtPos = email.indexOf("@")
var StopPos = email.lastIndexOf(".")
if (AtPos == -1 || StopPos == -1) {
alert("Please Enter Valid Email Address");
document.getElementById('email').focus();
return false;
}
email = document.getElementById('cc_email').value;
if(email.length != 0){
var AtPos = email.indexOf("@")
var StopPos = email.lastIndexOf(".")
if (AtPos == -1 || StopPos == -1) {
alert("Please Enter Valid Email Address");
document.getElementById('email').focus();
return false;
}
}
var answer = confirm ("Send E-Mail?");
if (!answer){
return false;
}
}
</script>
<!-- /TinyMCE -->
<style type="text/css">
body, table, td, th{
background-color:#CCCCCC;
font-family: Arial;
font-size:14px;
}
.que{
font-weight:bold;
}
</style>
</head>
<body>
<form method="post" enctype="multipart/form-data">
<?php
include 'library/database.php';
include 'library/opendb.php';
$query = mysql_query("SELECT email,contact,mobile FROM users WHERE user_id='$uid'") or die(mysql_error());
$row = mysql_fetch_row($query);
$from_email = $row[0];
$from_person = $row[1];
$from_mobile = $row[2];
$query = mysql_query("SELECT customer_id FROM campaign_summary WHERE camp_id='$camp_id'") or die(mysql_error());
$row = mysql_fetch_row($query);
$cusid = $row[0];
$query = mysql_query("SELECT email FROM client_info WHERE comp_id='$cusid'") or die(mysql_error());
$row = mysql_fetch_row($query);
$toer = $row[0];
include 'library/closedb.php';
?>
<table width="100%" border="0">
<tr><td rowspan="4"><input type="submit" name="send_email" id="send_email" style="height:50px; width:100px;" value="SEND" onClick="return err_check();" /></td><td><span class="que">From : </span></td><td colspan="3"><?php echo $from_email; ?><input type="hidden" name="from_mail" id="from_mail" /><input type="hidden" name="camp_id" id="camp_id" value="<?php echo $camp_id;?>"/></td></tr>
<tr><td><span class="que">To : </span></td><td colspan="3"><input name="to_email" id="to_email" style="width:250px;" value="<?php echo $toer;?>"/></td></tr>
<tr><td><span class="que">CC : </span></td><td colspan="3"><input name="cc_email" id="cc_email" style="width:250px;"/></td></tr>
<tr><td><span class="que">Subject : </span></td><td colspan="3"><input style="width:300px;" name="subject" id="subject" /></td></tr>
<tr><td rowspan="1" colspan="2"> </td><td><input type="checkbox" name="ori_pdf" id="ori_pdf" checked /> PDF Quotation</td><td> </td><td> </td></tr><tr><td colspan="2"><span class="que">Credit Application</span></td><td><input type="checkbox" name="corporate" id="corporate"/>Corporate</td><td><input type="checkbox" name="individual" id="individual" />Individual</td><td><input type="checkbox" name="cash" id="cash" />Cash Account</td>
</tr>
<tr>
<td colspan="2" rowspan="3"></td><td><input type="checkbox" name="tabloid" id="tabloid" />Tabloid Example</td>
<td><input type="checkbox" name="broadsheet" id="broadsheet" />Broadsheet Example</td></tr>
<tr><td><input type="checkbox" name="colmt" id="colmt" />Column Sizes Tabloid</td>
<td><input type="checkbox" name="colmb" id="colmb" />Column Sizes Broadsheet</td></tr>
<tr><td><input type="checkbox" name="maps" id="maps" />Maps / Distribution</td><td colspan="2" align="right">External Attachments <input id="upload_file" name="upload_file" type="file"/> </td></tr>
<tr><td colspan="2"><span class="que">Message :</span></td><td colspan="3">
<textarea id="elm1" name="elm1" rows="15" cols="80" style="width: 100%">
<?php
echo "<br><br><br>" . $from_person . "<br>" . $from_mobile;
?>
</textarea>
</td></tr>
</table>
</form>
</body>
</html>
Hi all Is there a way to get the image(s) to load into the table after the page has loaded instead of the way I have it now? I have 4 tabs, but I would like the imgs in tabs 2,3,4 to load after page load. Example of how the tabs look. Code: <div class="tabbertab">
<h2>Australia_____</h2>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFCC">
<caption class="highlight_Red">澳洲 Australia
</caption>
<tr>
<td><a href="pages/promotion.html#aus_ACE" rel="nofollow" target="_blank"><img src="pages/images/Pics/AUS/ace.jpg" alt="ACE / ATTC" width="110" height="69" border="0" align="left" class="ozimg_L"/> ...a few more images etc
the other tabs look the same. LT This script displays a link to a registration/login form that loads in a light box for Joomla. I've been goin nuts trying to figure out how to get this to load on page load with a delay. Anyone know how to get this done? PHP Code: <?php JHTML::_('behavior.mootools'); $document = JFactory::getDocument(); $document->addStyleSheet(JURI::base() . 'media/system/css/modal.css'); $document->addScript(JURI::base() . 'media/system/js/modal.js'); $document->addScriptDeclaration("window.addEvent('domready', function() {SqueezeBox.initialize({});});"); $user = & JFactory::getUser(); $uri = JFactory::getURI(); $url = $uri->toString(); $return = base64_encode($url); ?> <div id="lbframeid" style="position:absolute;top:1px;left:1px;height:0px;width:0px;overflow:hidden"> <a href="http://www.wowjoomla.com/"><h1>Joomla Login LightBox powered by WowJoomla.com</h1> </a> </div> <?php if ($user->get('guest')) :?> <a href="<?php echo JRoute::_('index.php?option=com_loginbox')?>" onclick="SqueezeBox.fromElement(this); return false;" rel="{handler: 'iframe', size: {x: 660, y: 500}}"><?php echo JText::_('SIGNUP_LOGIN')?></a> <?php else: ?> <?php echo JText::sprintf( 'HINAME', $user->get('name') ); ?> <br> <a href="javascript:void(0);" onclick="LB_onLogout(); return false;"><?php echo JText::_('LOGOUT')?></a> <?php endif; ?> <script type="text/javascript"> function LB_onLogout() { var form = new Element('form'); form.setProperty('method', 'POST'); form.setProperty('target', '_self'); form.setProperty('action', 'index.php'); var input = new Element('input'); input.setProperty('type', 'hidden'); input.setProperty('name', 'option'); input.setProperty('value', 'com_user'); form.appendChild(input); var input = new Element('input'); input.setProperty('type', 'hidden'); input.setProperty('name', 'task'); input.setProperty('value', 'logout'); form.appendChild(input); var input = new Element('input'); input.setProperty('type', 'hidden'); input.setProperty('name', 'return'); input.setProperty('value', '<?php echo $return; ?>'); form.appendChild(input); $E('body').appendChild(form); form.submit(); } </script> I am trying to get around using server side scripting for an issue on a webpage. I have a basic html form like this: Code: <html>
<body>
<FORM NAME="myform" ACTION="" METHOD="GET">Enter something in the box: <BR>
<INPUT TYPE="text" NAME="inputbox" VALUE=""><P>
<INPUT TYPE="button" NAME="button" Value="Click" onClick="testResult (this.form)">
</body>
</html>
I know I can use JavaScript to capture the data like this: Code: function testResults (form) {
var TestVar = form.inputbox.value;
alert ("You typed: " + TestVar);
}
Instead of alerting it, can I save the data in an iframe? Will it stay there once they leave the page? I want the iframe to eventually contain info from lots of people's answers. I am wanting to simulate saving the answers to a text file on the server. hello i am trying to fire a form which after the call to retrieve the data, populate the form with the data. i can see from firebug that the json data is being captured, but cannot seem to be able to populate the form with it. i am using a jquery plugin facybox, that opens the form, but the fields are blank. i have attached my code and would be grateful if someone could tell me where i am going wrong? many thanks js code Code: <script type="text/javascript">
function edit(com, grid) {
if (com == 'Edit') {
if($('.trSelected').length>0){
if($('.trSelected').length>1){
alert('Please select just one row');
return;
}
var items = $('.trSelected');
var itemlist ='';
for(i=0;i<items.length;i++){
itemlist+= items[i].id.substr(3);
}
$.ajax({
type: "POST",
dataType: "json",
url: "tempcontact.php",
data: "items="+itemlist,
success: function(data){
document.getElementById('id').value = data.id;
document.getElementById('email').value = data.email;
$("#flex1").flexReload();
}
});
/*and so on then you can call facybox*/
jQuery.facybox({ div: "#editform"});
} else{
alert('Please select a row to edit.');
}
}
}
</script>
form Code: <div id="editform" style="display:none;"> <form action="conedit.php" method="post" class="webform"> <fieldset> <legend><span>Update Contact</span></legend> <br /> <div id="dataText">Please delete the fields if there is no data 'No data to display'.</div> <label for="id">ID:</label> <input id="id" name="id" class="text" type="text" value="" /> <label for="name">Full Name:</label> <input id="name" name="name" class="text" type="text" value="" /> <label for="email">Email address:</label> <input id="email" name="email" class="text" type="text" value="" /> <label for="phone">Telephone:</label> <input id="phone" name="phone" class="text" type="text" value="" /> <label for="mobile">Mobile:</label> <input id="mobile" name="mobile" class="text" type="text" value="" /> <label for="fax">Fax:</label> <input id="fax" name="fax" class="text" type="text" value="" /> <label for="notes">Notes:</label> <textarea name="notes" cols="25" rows="3"></textarea> </fieldset> <input class="submit" type="submit" name="submit" value="Update" /> </form> </div> I am working on my form. Once user put data in the form, I want to save it as cookie and display it in another page as form processor. In my html file therefore, I have Code: <form id="frmBuyer" method="get" action="FormProcessor_Cookies.html"
enctype="application/x-www-form-urlencoded"
onsubmit="return validate();" onreset="location.reload();">
which is basically validate all the data and once it meets the requirement, it goes to FormProcessor_Cookies.html. So, i put a function in my js file to get all the data as cookie as following. Code:
function createCookie(){
document.cookie = first + "=" + encodeURIComponent(document.forms[0].FirstName.value);
document.cookie = last + "=" + encodeURIComponent(document.forms[0].LastName.value);
document.cookie = phone1 + "=" + encodeURIComponent(document.forms[0].PhoneA.value);
document.cookie = phone2 + "=" + encodeURIComponent(document.forms[0].PhoneB.value);
document.cookie = phone3 + "=" + encodeURIComponent(document.forms[0].PhoneC.value);
document.cookie = email + "=" + encodeURIComponent(document.forms[0].Email.value);
location.href = "cookie.html";
}
and I called this function after it validates. Code: function validate(){
var blnError = false;
var zip = document.getElementById("Zip").value;
var textBoxthree = document.getElementById("third");
var textLengththree = textBoxthree.value.length;
var textBoxtwo = document.getElementById("second");
var textLengthtwo = textBoxtwo.value.length;
var textBoxone = document.getElementById("first");
var textLengthone = textBoxone.value.length;
var patternZip = new RegExp("^([0-9]){5}(([ ]|[-])?([0-9]){4})?$");
if (document.forms[0].Zip.value == ""||!patternZip.test(document.forms[0].Zip.value)){
document.getElementById('E_Zip').style.display="inline";
document.forms[0].Zip.focus();
document.forms[0].Zip.style.backgroundColor="lemonchiffon"
blnError = true;
}
else{
document.getElementById('E_Zip').style.display="none";
document.forms[0].Zip.style.backgroundColor="white"
}
var patternCity = new RegExp("^(?:[a-zA-Z]+(?:[.'\-,])?\s?)+$");
if (document.forms[0].City.value == ""||!patternCity.test(document.forms[0].City.value)){
document.getElementById('E_City').style.display="inline";
document.forms[0].City.focus();
document.forms[0].City.style.backgroundColor="lemonchiffon"
blnError = true;
}
else{
document.getElementById('E_City').style.display="none";
document.forms[0].City.style.backgroundColor="white"
}
var patternAddress = new RegExp("^[a-zA-Z]+.*|.*[a-zA-Z]+|.*[a-zA-Z]+.*$");
if (document.forms[0].Address1.value == ""||!patternAddress.test(document.forms[0].Address1.value)){
document.getElementById('E_Address1').style.display="inline";
document.forms[0].Address1.focus();
document.forms[0].Address1.style.backgroundColor="lemonchiffon"
blnError = true;
}
else{
document.getElementById('E_Address1').style.display="none";
document.forms[0].Address1.style.backgroundColor="white"
}
var patternConfirm = new RegExp("^[_a-zA-Z0-9\\-]+(\.[_a-zA-Z0-9\\-]+)*@[a-zA-Z0-9\\-]+(\.[a-aZ-Z0-9\\-]+)*(\.[a-z]{2,3})$");
if (document.forms[0].ConfirmEmail.value == ""
||!patternConfirm.test(document.forms[0].ConfirmEmail.value)
||document.forms[0].ConfirmEmail.value != document.forms[0].Email.value){
document.getElementById('E_ConfirmEmail').style.display="inline";
document.forms[0].ConfirmEmail.focus();
document.forms[0].ConfirmEmail.style.backgroundColor="lemonchiffon"
blnError = true;
}
else{
document.getElementById('E_ConfirmEmail').style.display="none";
document.forms[0].ConfirmEmail.style.backgroundColor="white"
}
var patternEmail = new RegExp("^[_a-zA-Z0-9\\-]+(\.[_a-zA-Z0-9\\-]+)*@[a-zA-Z0-9\\-]+(\.[a-aZ-Z0-9\\-]+)*(\.[a-z]{2,3})$");
if (document.forms[0].Email.value == ""||!patternEmail.test(document.forms[0].Email.value)){
document.getElementById('E_Email').style.display="inline";
document.forms[0].Email.focus();
document.forms[0].Email.style.backgroundColor="lemonchiffon"
blnError = true;
}
else{
document.getElementById('E_Email').style.display="none";
document.forms[0].Email.style.backgroundColor="white"
}
var patternPhoneA = new RegExp("^\\d{3}$");
var patternPhoneB = new RegExp("^\\d{3}$");
var patternPhoneC = new RegExp("^\\d{4}$");
if(patternPhoneC.test(document.forms[0].PhoneC.value)
&&patternPhoneB.test(document.forms[0].PhoneB.value)
&&patternPhoneA.test(document.forms[0].PhoneA.value)){
document.getElementById('E_Phone').style.display="none";
}
if(patternPhoneC.test(document.forms[0].PhoneC.value)){
document.forms[0].PhoneC.style.backgroundColor="white"}
if(patternPhoneB.test(document.forms[0].PhoneB.value)){
document.forms[0].PhoneB.style.backgroundColor="white"}
if(patternPhoneA.test(document.forms[0].PhoneA.value)){
document.forms[0].PhoneA.style.backgroundColor="white"}
if (!patternPhoneC.test(document.forms[0].PhoneC.value)){
document.getElementById('E_Phone').style.display="inline";
document.forms[0].PhoneC.focus();
document.forms[0].PhoneC.style.backgroundColor="lemonchiffon"
}
if (!patternPhoneB.test(document.forms[0].PhoneB.value)){
document.getElementById('E_Phone').style.display="inline";
document.forms[0].PhoneB.focus();
document.forms[0].PhoneB.style.backgroundColor="lemonchiffon"
}
if (!patternPhoneA.test(document.forms[0].PhoneA.value)){
document.getElementById('E_Phone').style.display="inline";
document.forms[0].PhoneA.focus();
document.forms[0].PhoneA.style.backgroundColor="lemonchiffon"
}
var patternLast = new RegExp("^[a-zA-Z]+.*|.*[a-zA-Z]+|.*[a-zA-Z]+.*$");
if (document.forms[0].LastName.value == ""||!patternLast.test(document.forms[0].LastName.value)){
document.getElementById('E_LastName').style.display="inline";
document.forms[0].LastName.style.backgroundColor="lemonchiffon"
blnError = true;
}
else{
document.getElementById('E_LastName').style.display="none";
document.forms[0].LastName.style.backgroundColor="white"
}
var patternFirst = new RegExp("^[a-zA-Z]+.*|.*[a-zA-Z]+|.*[a-zA-Z]+.*$");
if (document.forms[0].FirstName.value == ""||!patternFirst.test(document.forms[0].FirstName.value)){
document.getElementById('E_FirstName').style.display="inline";
document.forms[0].FirstName.style.backgroundColor="lemonchiffon"
blnError = true;
}
else{
document.getElementById('E_FirstName').style.display="none";
document.forms[0].FirstName.style.backgroundColor="white"
}
if (blnError == true){
document.getElementById('E_Alert').style.display="inline";
return false;
}
else {
document.getElementById('E_Alert').style.display="none";
createCookie();
return true;
}
}
Lastly, I tried to display all the cookies in my "FormProcessor_Cookies.html" page Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="author" content="" />
<meta name="description" content="Home" />
<meta name="keywords" content="Client Side Programming, JavaScript, CSS" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Language" content="en-us" />
<link rel="stylesheet" href="javascript.css"/>
<script type="text/javascript" src="shopping.js"></script>
<title>Homepage::Seunghun Jun</title>
</head>
<body>
<div id="container">
<!-- Begin web page -->
<div id="header"><!-- Header and Navigation -->
<!-- Page Heading --><!-- Navigation -->
<script type="text/javascript">
displayHeader();
</script> <br/><br/><br/><br/>
</div>
<div id="content">
<!-- Main Content --><div id="submited">
<script type="text/javascript">
/* <![CDATA[ */
document.write(documetn.cookie;);
/* ]]> */
</script></div>
</div><br/><br/><br/><br/>
<div id="footer">
<!-- Footer -->
<!-- Begin Footer Div-->
<script type="text/javascript">displayFooter();</script>
<!-- End Footer Div -->
</div>
<!--End web page -->
</div>
</body>
</html>
And its not showing any messages...I know I am asking to much...but could any expert can help me what is wrong and how I can fix this? Hello, I used a standard orderform which I expanded. With this form people can order some products. But when I submit the form with data from a javascript the mail is empty. Can anyone help? I am just a beginner.... You can try the form here Thanks in advance! Hein. Basically I have comments posted on articles and I want to allow users to report them if they find inappropriate content. I want them to be able to click on icon on the comment which will open up a pop-up. Then in the pop-up they can type why they are reporting the comment. Code: <script type="text/javascript">
function popup() {
Report = window.open('/report.php','Report','width=350, height=400');
document.reportform.submit();
}
</script>
<form action="/report.php" name="reportform" method="post" target="Report">
<input type="hidden" name="reporter_id" value = "<?php echo $user_id; ?>" />
<input type="hidden" name="reported_id" value="<?php echo $row['uid'] ?>" />
<input type="hidden" name="comment_id" value="<?php echo $row['id'] ?>" />
<a href="#" name="reportform" class="submit" onclick="return popup();"> Report</a></form>
I've been messing with this code for a while now. This code successfully brings up the pop-up, but it doesn't transfer the form data. My main coding language is PHP, and I'm in the process of learning Javascript. Can anyone help? I have a long survey form and once its submitted it gets recorded into a database. I would love to be able to save a PDF version of the HTML form with all their radio buttons and textfields filled out at the same time its submitted. It would need a unique name that matches their record in the database (maybe it pulls the data that was entered into one of the form fields for the name). Whether it gets uploaded to an ftp or just emailed to a mailbox doesn't really matter. The purpose of this is to basically have a visual interpretation of the data by a single user. Is something like this even possible? Hi, I have a rather complicated problem for me as it involves both php and js. And I'm getting lost... Let me explain: On a page, order.html, I have a form including the following fields: - name - comment When posted, it is linked to request.php and request.validation.js, to end up on confirmation.php. On confirmation.php, I would like to reuse the information entered in the fields on order.php (name, email, comment) to display them on the page. My issue I can't find how to 'take them along' in request.php / request.validation.js to confirmation.php where I'm trying to display them with : Code: Contact: <span id="name"><?php echo($_POST['name']); ?></span> etc. For reference, here are my files request.php and request.validation.js: PHP Code: <?php // CONFIGURATION -------------------------------------------------------------- // This is the email where the contact mails will be sent to. $config['recipient'] = 'mail@mail.com'; // This is the subject line for contact emails. // The variable %name% will be replaced with the reference ordered. $config['subject'] = 'Website enquiry from %name%'; // These are the messages displayed in case of form errors. $config['errors'] = array ( 'no_name' => 'Veuillez entrer votre nom.', 'no_email' => 'Votre adresse email est requise.', 'invalid_email' => 'Votre adresse email n est pas valide.', ); // END OF CONFIGURATION ------------------------------------------------------- // Ignore non-POST requests if ( ! $_POST) exit('Nothing to see here. Please go back to the site.'); // Was this an AJAX request or not? $ajax = (isset($_SERVER['HTTP_X_REQUESTED_WITH']) AND strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest'); // Set the correct HTTP headers header('Content-Type: text/'.($ajax ? 'plain' : 'html').'; charset=utf-8'); // Extract and trim contactform values $name = isset($_POST['name']) ? trim($_POST['name']) : ''; $email = isset($_POST['email']) ? trim($_POST['email']) : ''; $comment = isset($_POST['comment']) ? trim($_POST['comment']) : ''; // Take care of magic quotes if needed (you really should have them disabled) set_magic_quotes_runtime(0); if (get_magic_quotes_gpc()) { $name = stripslashes($name); $email = stripslashes($email); $comment = stripslashes($comment); } // Initialize the errors array which will also be sent back as a JSON object $errors = NULL; // Validate name if ($name == '' || strpos($name, "\r") || strpos($name, "\n")) { $errors['name'] = $config['errors']['no_name']; } // Validate email if ($email == '') { $errors['email'] = $config['errors']['no_email']; } elseif ( ! preg_match('/^[-_a-z0-9\'+*$^&%=~!?{}]++(?:\.[-_a-z0-9\'+*$^&%=~!?{}]+)*+@(?:(?![-.])[-a-z0-9.]+(?<![-.])\.[a-z]{2,6}|\d{1,3}(?:\.\d{1,3}){3})(?::\d++)?$/iD', $email)) { $errors['email'] = $config['errors']['invalid_email']; } // Validation succeeded if (empty($errors)) { // Prepare subject line $subject = str_replace('%name%', $name, $config['subject']); // Set date $todayis = date("l, F j, Y") ; // Prepare message $message = "Date: $todayis Nom: $name email: $email Commentai $comment"; // Additional mail headers $headers = 'Content-Type: text/plain; charset=utf-8'."\r\n"; $headers .= 'From: '.$email; // Send the mail if ( ! mail($config['recipient'], $subject, $message, $headers)) { $errors['server'] = 'Server problem'; } } if ($ajax) { // Output the possible errors as a JSON object echo json_encode($errors); } else { // Show a simple HTML feedback message in case of non-javascript support if (empty($errors)) { header('Location: ../steps/confirmation.php'); } else { echo '<h2>Oups!</h2>'; echo '<ul><li>'; echo implode('</li><li>', $errors); echo '</li></ul>'; echo '<br><br><a href="javascript:history.back(-1);">Retour</a>'; } } Code: /*
* Request Form Validation v1.0
* By Simon Bouchard <www.simonbouchard.com>
* You need at least PHP v5.2.x with JSON support for the live validation to work.
*/
jQuery(document).ready(function(){
jQuery('#requestform').submit(function() {
// Disable the submit button
jQuery('#requestform input[type=submit]')
.attr('value', 'Send...')
.attr('disabled', 'disabled');
// AJAX POST request
jQuery.post(
jQuery(this).attr('action'),
{
name:jQuery('#name').val(),
email:jQuery('#email').val(),
comment:jQuery('#comment').val(),
},
function(errors) {
// No errors
if (errors == null) {
document.location.href="confirmation.php";
}
// Errors
else {
// Re-enable the submit button
jQuery('#requestform input[type=submit]')
.removeAttr('disabled')
.attr('value', 'Envoyer');
// Technical server problem, the email could not be sent
if (errors.server != null) {
alert(errors.server);
return false;
}
// Empty the errorbox and reset the error alerts
jQuery('#requestform .errorbox').html('<ul></ul>').show();
jQuery('#requestform li').removeClass('alert');
// Loop over the errors, mark the corresponding input fields,
// and add the error messages to the errorbox.
for (field in errors) {
if (errors[field] != null) {
jQuery('#' + field).parent('li').addClass('alert');
jQuery('#requestform .errorbox ul').append('<li>' + errors[field] + '</li>');
}
}
}
},
'json'
);
// Prevent non-AJAX form submission
return false;
});
});
Thanks for your help. M. Hi. I need to fo a form and the content be sent to a database but i'm stuck... I knwo hot to do forms and also how to send data to mysql using php. But now i need something a bit more complex and i'm stuck. I need to make a form lets say with "parent name, age, child name, child age" Some people has 1 child some people has 2 3 4...and i need to have it separated and not just write like "joe, bob, jack" in the same line. How can i do this? And how should the database be structured? i can't put "id, parent, age, c_name, c_age" because some ppl will need to have more than 1 child in the database. Don't know what to do Hey Guys, A litttle new to web coding so bare with me(hope this is posted in the right section). Im workin on a backend panel where i populate a simple table with a few text boxes in there so they can update some values. I also have at the end of every row in the table an Edit, Delete & Save button. When i hit the save button i would like to update that entry in the database. My Problem is that i need a value from the table before hitting a submit button, and the element names are dynamically created meaning ill likely need a variable sent from php to javascript and once i have the value in javascript ill need to send it back over to the php to manipulate and send to the server. From wat i can gather using 'document.form.element.value' is the best way to go, hence why i posted this in javascript when most of my code is php. PLEASE HELP Hello, I have a form which asks for some user data and then submits this data and inserts into a mysql database. I wanted to know the best way to validate the form before the data is submittted to the action script. For example, checking form fields to see if they are empty and also making sure no special characters are inserted by the user. The code I have tried is: Code: function checkForm() {
var theForm = document.forms.feedback;
if (theForm.fname.value == "" || theForm.loc.value="" || theForm.com.value == "") {
alert("Please complete all of the form");
}
}
Working with this form: Code: <form id="feedback" name="feedback" action="php/phpcustom.php" method="POST">
<fieldset>
<legend>Gardenable.com Feedback</legend>
<p><label for="fname">Name:</label><input type="text" size="30" maxlength="40" id="fname" name="fname" /></p>
<p><label for="loc">Location:</label><input type="text" size="30" maxlength="40" id="loc" name="loc" /></p>
<p><label for="com">Comments:</label><textarea cols="40" rows="6" maxlength="300" id="com" name="com"></textarea></p>
<p><input type="submit" name="send" id="submitbutton" value="Submit" onclick="checkForm()" /><input type="reset" name="reset" value="Reset" /></p>
</fieldset>
</form>
I've added this function to the onclick attribute of the submit input button but it is just submitting the data and not executing. Just wondering if anyone could please explain how to stop the execution of the data being submitted and check the form before doing so. If not could you possibly advise any good sites/links for me to browse to achieve this. regards, LC. I have 2 types of addresses 1. Permanent address > Postal code, Street, City, State, Country 2. Current address > Postal code, Street, City, State, Country and a check box 'Copy from Permanent address' with Current address when i checked that check box then all values from 'Permanent address' will be copy to 'Current address' Please send me the code Hi there, I'm absolute newbie in javascript, so the question may look not worth asking for you. Sorry for that. My situation is like that: I want to make a preview of form data using javascript. After the button "preview" is clicked I start showing div dialog which should contain data entered by users. The problem is that because my div dialog is coded in the same page as form I can get only default values. It means - after making some changes, they are not visible. To get and print the value of input I use this code: Code: <script type="text/javascript">
mytext = document.getElementById('name').value;
document.write(mytext);
</script>
How it would be possible to update the values on "on click" event. Thank you very much for considering this question. |
|||||||