lorddemos90 Posted October 14, 2007 Share Posted October 14, 2007 I have a code developed in Dreamweaver 8 to insert data into a mysql database, when data is inserted, it goes to a "thankyou" page. In Firefox, there is absolutely no problem whatsoever. But if you try to enter any data in Internet Explorer you get this horrible message. Also any attempts to use the image upload part of the form won't work either? here is where the code is hosted http://national-open-house.com/registration.php Method Not Implemented sellername=werwe&association=Realtor&other=qwer&company=qwer&address=sdfg&city=sdfg&state=sdf&zip=4444&weblink=&directionslink=&photolink=&price=4444&sellerphone=4444&brokerphone=3333&brokername=3333&time=3333&description=33dsfgsdfasfasd@sdffsd.com&email=jeffrey@peninsulafirst.com&MM_insert=form1GET to /thankyou.html not supported. Invalid method in request sellername=werwe&association=Realtor&other=qwer&company=qwer&address=sdfg&city=sdfg&state=sdf&zip=4444&weblink=&directionslink=&photolink=&price=4444&sellerphone=4444&brokerphone=3333&brokername=3333&time=3333&description=33dsfgsdfasfasd@sdffsd.com&email=jeffrey@peninsulafirst.com&MM_insert=form1GET /thankyou.html? HTTP/1.1 -------------------------------------------------------------------------------- Apache/1.3.33 Server at national-open-house.com Port 80 What the hell is the deal with that??? Quote Link to comment Share on other sites More sharing options...
gazever Posted October 14, 2007 Share Posted October 14, 2007 perhaps the get is too long????? Quote Link to comment Share on other sites More sharing options...
lorddemos90 Posted October 14, 2007 Author Share Posted October 14, 2007 funny thing, I tried using the forms hosted on a different host using Internet Explorer, and they generated no errors. Perhaps it has something to do with the fact that they're hosted on a "free" godaddy account? Quote Link to comment Share on other sites More sharing options...
lorddemos90 Posted October 15, 2007 Author Share Posted October 15, 2007 anybody? this is really causing problems. Quote Link to comment Share on other sites More sharing options...
trq Posted October 15, 2007 Share Posted October 15, 2007 I think were going to need to see some code. Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted October 15, 2007 Share Posted October 15, 2007 Is the method for the form "POST"? If not, it should be. Ken Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted October 15, 2007 Share Posted October 15, 2007 your free hosting could be your problem as you said, most of the time the max send for get/post is so small that you can't do anything. Quote Link to comment Share on other sites More sharing options...
lorddemos90 Posted October 15, 2007 Author Share Posted October 15, 2007 Here's code if that helps. What's really baffling me is that the error messages will only show in in IE, but it's fine in Firefox. Also there's no problems on the "good" server. <?php require_once('Connections/searchprg.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO nationalopenhouse (sellername, association, other, company, address, city, `state`, zip, weblink, directionslink, photolink, price, sellerphone, brokerphone, brokername, `time`, `description`, email) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['sellername'], "text"), GetSQLValueString($_POST['association'], "text"), GetSQLValueString($_POST['other'], "text"), GetSQLValueString($_POST['company'], "text"), GetSQLValueString($_POST['address'], "text"), GetSQLValueString($_POST['city'], "text"), GetSQLValueString($_POST['state'], "text"), GetSQLValueString($_POST['zip'], "text"), GetSQLValueString($_POST['weblink'], "text"), GetSQLValueString($_POST['directionslink'], "text"), GetSQLValueString($_POST['photolink'], "text"), GetSQLValueString($_POST['price'], "text"), GetSQLValueString($_POST['sellerphone'], "text"), GetSQLValueString($_POST['brokerphone'], "text"), GetSQLValueString($_POST['brokername'], "text"), GetSQLValueString($_POST['time'], "text"), GetSQLValueString($_POST['description'], "text"), GetSQLValueString($_POST['email'], "text")); mysql_select_db($database_searchprg, $searchprg); $Result1 = mysql_query($insertSQL, $searchprg) or die(mysql_error()); $insertGoTo = "thankyou.html"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } ?><!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"> <!-- DW6 --> <!-- Copyright 2005 Macromedia, Inc. All rights reserved. --> <head> <meta name="Title" content="National Open House: REALTORS® and Friends"> <meta name="Keywords" content="national open house, nov 4 2007, homes for sale, home, house, Realtor, FSBO, Trulia, Time Change, Save on a house, save on time "> <meta name="Title" content="National Open House: REALTORS® and Friends"> <meta name="Description" content="With Daylight Savings time, take that extra hour that you save to attend the National Open House and save on buying your next home."> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <link rel="stylesheet" href="mm_health_nutr.css" type="text/css" /> <style type="text/css"> <!-- body { background-color: #FFFFFF; } .style10 {color: #000000; font-size: 18px; font-weight: bold; } .style41 {color: #000000} .style62 {font-family: verdana; font-weight: bold; color: #89A53E; font-size: 9pt; } .style57 {font-family: georgia; font-size: 18pt; } .style64 {font-size: 18px} a:hover { color: #006633; } .style70 {font-size: 10pt} .style71 {font-size: 9pt} .style77 {font-size: 6px} .style81 {font-size: 10px} .style82 {font-size: 10px} .style85 {font-size: 10pt; font-style: italic; } .style87 {font-size: 10pt; font-weight: bold; } .style89 {font-size: 10px; color: #999999; } .style84 { font-size: 12px; color: #990000; font-family: Georgia, "Times New Roman", Times, serif; font-weight: bold; } .style90 {font-size: 12px; color: #990000; font-family: Georgia, "Times New Roman", Times, serif; } --> </style> <script type="text/JavaScript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_validateForm() { //v4.0 var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments; for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]); if (val) { nm=val.name; if ((val=val.value)!="") { if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@'); if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n'; } else if (test!='R') { num = parseFloat(val); if (isNaN(val)) errors+='- '+nm+' must contain a number.\n'; if (test.indexOf('inRange') != -1) { p=test.indexOf(':'); min=test.substring(8,p); max=test.substring(p+1); if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n'; } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; } } if (errors) alert('The following error(s) occurred:\n'+errors); document.MM_returnValue = (errors == ''); } //--> </script> <title>National Open House: REALTORS® and a Community of Friends</title></head> <body> <script language="JavaScript1.2">mmLoadMenus();</script> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <!--DWLayoutTable--> <tr bgcolor="#D5EDB3"></tr> <tr> <td height="1894" valign="top" bgcolor="#89A53E"><table border="0" cellspacing="0" cellpadding="0" width="165" id="navigation"> <tr> <td width="165"><p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p></td> </tr> <tr> <td><a href="http://searchprg.com/nationalopenhouse/openhouselist.php" class="navText">View Open Houses </a></td> </tr> <tr> <td><a href="http://searchprg.com/nationalopenhouse/registration.php" class="navText">Register Your Open House </a></td> </tr> <tr> <td width="165"><a href="http://www.national-open-house.com/extras.html" class="navText">extras: logos </a></td> </tr> <tr></tr> <tr> <td width="165"><a href="http://www.national-open-house.com/linktous.html" class="navText">link to us </a></td> </tr> <tr> <td width="165"><a href="http://www.trulia.com/voices" target="_blank" class="navText">trulia voices</a></td> </tr> <tr> <td width="165"><a href="mailto:NationalOpenHouseDay@gmail.com" class="navText">email us</a></td> </tr> <tr> <td width="165"><a href="http://www.national-open-house.com/index.html" class="navText">home</a></td> </tr> <tr> <td width="165"><a href="http://www.realtor.com/Basics/AllAbout/Realtors/WhatIs.asp" target="_blank" class="navText"><img src="images/realtorpinimage.gif" alt="REALTOR" name="REALTOR" width="29" height="35" border="0" usemap="#REALTOR" lowsrc="images/realtorpinimage.png" id="REALTOR" longdesc="images/realtorpinimage.png" /> REALTOR® </a></td> </tr> <tr></tr> <tr></tr> <tr></tr> <tr></tr> <tr></tr> <tr> <td><p> </p></td> </tr> <tr></tr> </table> <br /> <br /> <br /> <br /> <div align="center"> <p><a href="http://www.RosevilleAndRocklin.com" target="_blank"></a></p> </div> <div align="center"></div></td><td><img src="mm_spacer.gif" alt="" width="50" height="1" border="0" /></td> <td valign="top"><table width="590" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="590" align="center" valign="middle" class="quote style10"><div align="center" class="style41"> <p class="style57"><span class="style71"><a href="mailto:NationalOpenHouseDay@gmail.com"><img src="images/nationalopenhouseAnimation.gif" alt="NOH" name="nationalopenhouse" width="374" height="231" border="0" align="absmiddle" usemap="#noh" id="nationalopenhouse" longdesc="images/NewTopFCwhite.gif" /></a></span></p> <p class="style87"><span style="font-family: times;"></span> Registration Form - Time is ticking away, <span style="color: rgb(204, 0, 0); font-weight: bold;">Join NOW!</span><br> <br> <big class="style84" style="color: rgb(0, 153, 0);"><big><big><span style="font-weight: bold;">The National Open House Nov 4, 2007</span></big></big></big> <form action="<?php echo $editFormAction; ?>" method="post" name="form1" onSubmit="MM_validateForm('sellername','','R','company','','R','address','','R','city','','R','state','','R','zip','','R','time','','R','email','','RisEmail');return document.MM_returnValue"> <table align="center"> <tr valign="baseline"> <td align="right" nowrap>* indicates required field </td> <td> </td> <td> </td> </tr> <tr valign="baseline"> <td width="153" align="right" nowrap><div align="right">* Open House Host Name:</div></td> <td width="192"><input type="text" name="sellername" value="" size="32"></td> <td width="279"><small style="font-style: italic; color: rgb(204, 0, 0);">If property not represented by agent/broker, enter "FSBO" after name. </small></td> </tr> <tr valign="baseline"> <td nowrap align="right">* Association:</td> <td><select name="association"> <option value="Realtor" <?php if (!(strcmp("realtor", ""))) {echo "SELECTED";} ?>>Realtor</option> <option value="Homeowner" <?php if (!(strcmp("homeowner", ""))) {echo "SELECTED";} ?>>Homeowner</option> <option value="RE Licencee" <?php if (!(strcmp("licencee", ""))) {echo "SELECTED";} ?>>RE Licencee</option> <option value="" <?php if (!(strcmp("", ""))) {echo "SELECTED";} ?>>Other</option> </select> </td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right">Owner Phone:</td> <td><input type="text" name="other" value="" size="32"></td> <td><small style="font-style: italic; color: rgb(204, 0, 0);">Complete only if FSBO.</small><span style="color: rgb(204, 0, 0);"></span></td> </tr> <tr valign="baseline"> <td nowrap align="right">* Company / Broker Name:</td> <td><input type="text" name="company" value="" size="32"></td> <td><small style="font-style: italic; color: rgb(204, 0, 0);">Enter "No Broker" if not represented by agent/broker . </small><span style="color: rgb(204, 0, 0);"></span></td> </tr> <tr valign="baseline"> <td nowrap align="right">* Property Address:</td> <td><input type="text" name="address" value="" size="32"></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right">* Property City:</td> <td><input type="text" name="city" value="" size="32"></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right">* Property State:</td> <td><input type="text" name="state" value="" size="32"></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right">* Property Zip:</td> <td><input type="text" name="zip" value="" size="32"></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right">Web Link:</td> <td><input type="text" name="weblink" value="" size="32"></td> <td><small style="font-style: italic; color: rgb(204, 0, 0);">start with</small><span style="color: rgb(204, 0, 0);"> http://</span></td> </tr> <tr valign="baseline"> <td nowrap align="right">Mapquest Directions Link:</td> <td><input type="text" name="directionslink" value="" size="32"></td> <td><small style="font-style: italic; color: rgb(204, 0, 0);">start with</small><span style="color: rgb(204, 0, 0);"> http://</span></td> </tr> <tr valign="baseline"> <td nowrap align="right"><a name="photoupload"></a>Photo Link:</td> <td><input type="text" name="photolink" value="" size="32"></td> <td><a href="#photoupload" onClick="MM_openBrWindow('upload.php','','width=300,height=300')">Click Here to Upload A Photo</a> </td> </tr> <tr valign="baseline"> <td nowrap align="right"> Price:</td> <td><input type="text" name="price" value="" size="32"></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right"> Agent Phone:</td> <td><input type="text" name="sellerphone" value="" size="32"></td> <td><small style="font-style: italic; color: rgb(204, 0, 0);">Leave blank if no agent. </small></td> </tr> <tr valign="baseline"> <td nowrap align="right">Company / Broker Phone:</td> <td><input type="text" name="brokerphone" value="" size="32"></td> <td><small style="font-style: italic; color: rgb(204, 0, 0);">Leave blank if none. </small></td> </tr> <tr valign="baseline"> <td nowrap align="right">Agent Name:</td> <td><input type="text" name="brokername" value="" size="32"></td> <td><small style="font-style: italic; color: rgb(204, 0, 0);">Leave blank if no agent. </small></td> </tr> <tr valign="baseline"> <td nowrap align="right">* Open House Time:</td> <td><input type="text" name="time" value="" size="32"></td> <td><small style="font-style: italic; color: rgb(204, 0, 0);">example</small><span style="color: rgb(204, 0, 0);"> 11:30am - 4:00pm</span></td> </tr> <tr valign="baseline"> <td align="right" valign="top" nowrap>Description:</td> <td><textarea name="description" cols="22" rows="5"></textarea></td> <td> </td> </tr> <tr valign="baseline"> <td nowrap align="right">* Email:</td> <td><input type="text" name="email" value="" size="32"></td> <td> </td> </tr> <tr valign="baseline"> <td colspan="3" align="right" nowrap><div align="left"><small>Data will be updated twice in early October and daily the second half of October. <br> If you need to change which house or the time, please register again.<br> </small> <span style="color: rgb(204, 0, 0);">Please enter information <span style="font-weight: bold;">NOW</span></span> <small>even if it is tentative. (We need to test the system.)</small></div></td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><label for="Submit"></label> <input type="reset" name="Reset" value="Reset" id="Submit"> <input type="submit" value="Insert record"></td> <td> </td> </tr> <tr valign="baseline"> <td colspan="3" align="right" nowrap><div align="left">Thank you,<br> The National Open House Committee<br> www.National-Open-House.com</div></td> </tr> </table> <input type="hidden" name="MM_insert" value="form1"> </form> <p><br> <a href="http://www.national-open-house.com/">Return Home</a><br> <br> <a href="http://www.national-open-house.com/"><img src="http://www.national-open-house.com/images/100noh.jpg" alt="National Open House Logo" border="0" style="border: 0px solid ; width: 100px; height: 91px;"></a><br> <br> </p><span class="style71"><br /> </span><br /> </p> </div></td> </tr> </table> </td> </tr> <tr> <td height="18" class="style81"> </td> <td class="style81"> </td> <td class="style81"> </td> <td class="style81"> </td> </tr> </table> </body> </html> Quote Link to comment Share on other sites More sharing options...
trq Posted October 15, 2007 Share Posted October 15, 2007 Seriously.. when I said we need to see some code, I meant the relevent parts. dreamweaver code is hard enough to read when there is a minimal amount of it. You going to try and narrow the problem down a little yourself. Quote Link to comment Share on other sites More sharing options...
prime Posted October 15, 2007 Share Posted October 15, 2007 Any kind of wysiwyg editor always makes a mess out of code, one reason I stopped using them entirely Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted October 15, 2007 Share Posted October 15, 2007 i agree on not using wysiwyg editors. i ran into this problem before. IE imposes a limit on the number of characters allowed in the URL. You'll need to POST, use sessions or something else to get around it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.