VegasKiller Posted January 6, 2011 Share Posted January 6, 2011 Hi I have made an ad application process for my ads and when the user clicks submit, it is not updating adapps table in my database. Please help. Quote Link to comment Share on other sites More sharing options...
Blade Maker Posted January 6, 2011 Share Posted January 6, 2011 I think I found a problem there might be more but: $uu="<center>[img=/GFX/layout_images/topnav.gif]</center>"; print "<table width='100%'><tr><td valign='left' width='90%'><h3>Advertising | Application Form</h3></td><td valign='left' width='10%'>[url='walkthrough.php#advertising'][img=/GFX/layout_images/help.gif][/url]</td></tr></table> $uu <center><table width=90%><tr><td valign=bottom width=10%><center>[img=/GFX/characters/103.png] [[url='viewuser.php?u=103']<font color=blue>[b]Elsie[/b]</font>[/url]]<center></td><td valign=left>[b]<font color=blue>"; The area with the $uu variable what is the variable doing, do you want to print it? If so you would do this: $uu="<center>[img=/GFX/layout_images/topnav.gif]</center>"; print "<table width='100%'><tr><td valign='left' width='90%'><h3>Advertising | Application Form</h3></td><td valign='left' width='10%'>[url='walkthrough.php#advertising'][img=/GFX/layout_images/help.gif][/url]</td></tr></table> ".$uu." <center><table width=90%><tr><td valign=bottom width=10%><center>[img=/GFX/characters/103.png] [[url='viewuser.php?u=103']<font color=blue>[b]Elsie[/b]</font>[/url]]<center></td><td valign=left>[b]<font color=blue>"; Quote Link to comment Share on other sites More sharing options...
VegasKiller Posted January 6, 2011 Author Share Posted January 6, 2011 Ty, I updated it to your fix :) Quote Link to comment Share on other sites More sharing options...
Blade Maker Posted January 6, 2011 Share Posted January 6, 2011 Did it fix it? Quote Link to comment Share on other sites More sharing options...
VegasKiller Posted January 6, 2011 Author Share Posted January 6, 2011 No it i still not updating to the adapps table. Quote Link to comment Share on other sites More sharing options...
Blade Maker Posted January 6, 2011 Share Posted January 6, 2011 Instead of this: mysql_query("INSERT INTO adapps VALUES('',$userid,'{$_POST['pos']}','{$_POST['app']}','{$_POST['name']}','{$_POST['email']}','{$_POST['phone']}','{$_POST['login']}','{$_POST['pass']}','{$_POST['desc']}','{$_POST['banner']}','{$_POST['goto']}','{$_POST['views']}','{$_POST['clicks']}','{$_POST['mature']}','{$_POST['sexgenre']}','{$_POST['age']}','{$_POST['country']}','{$_POST['paypal']}','0')", $c) or Try this: mysql_query("INSERT INTO adapps VALUES('',$userid,'{$_POST[."pos".]}','{$_POST[."app".]}','{$_POST[."name".]}','{$_POST[."email".]}','{$_POST[."phone".]}','{$_POST[."login".]}','{$_POST[."pass".]}','{$_POST[."desc".]}','{$_POST[."banner".]}','{$_POST[."goto".]}','{$_POST[."views".]}','{$_POST[."clicks".]}','{$_POST[."mature".]}','{$_POST[."sexgenre".]}','{$_POST[."age".]}','{$_POST[."country".]}','{$_POST[."paypal".]}','0')", $c) or Quote Link to comment Share on other sites More sharing options...
Rasheed saeed Posted January 6, 2011 Share Posted January 6, 2011 if($_POST['app']) { mysql_query("INSERT INTO adapps VALUES('',$userid,'{$_POST['pos']}','{$_POST['app']}','{$_POST['name']}','{$_POST['email']}','{$_POST['phone']}','{$_POST['login']}','{$_POST['pass']}','{$_POST['desc']}','{$_POST['banner']}','{$_POST['goto']}','{$_POST['views']}','{$_POST['clicks']}','{$_POST['mature']}','{$_POST['sexgenre']}','{$_POST['age']}','{$_POST['country']}','{$_POST['paypal']}','0')", $c) or print "Your Ad application could not be sent. Make sure that you have filled in all the fields"; exit($h->endpage()); print "<center><font color=blue>[b]Ciao - Ad Application Sent, You Will Be Notified With Your Result.</font>[/b] [<a href=index.php>[b]Click Me To Go Home.[/b]</a>]</center> <center>[img=/GFX/layout_images/topnav.gif]</center> "; } else { print "<center><table width=90%><tr><td valign=left> [b]Available Advertising Spaces:[/b] <font color='blue'>[b]Top Header: 10[/b] [b]Newspaper Left Side: 10[/b] [b]Shops Top: 10[/b] [b]Specialty: 10[/b] [b]Companion Header: 10[/b] [b]Front Page: 10[/b]</font></td></tr></table></center> $uu <center><table width=90%><tr><td valign=left><form action='advertise.php' method='post'> [b]The Application Process:[/b] Your Name: <textarea rows='1' cols='30' name='name'>{$_GET['name']}</textarea> (Your First & Last Real Names) Your Email: <textarea rows='1' cols='30' name='email'>{$_GET['email']}</textarea> (Your Email Where We Can Reach You If Necessary) Your Phone Number: <textarea rows='1' cols='30' name='phone'>{$_GET['phone']}</textarea> (Beginning With Area Code) Ad Space Position: <select name='pos'><option value='topheader'>Top Header</option><option value='newspaper'>Newspaper Left Side</option><option value='shops'>Shops Top</option><option value='specialty'>Specialty</option><option value='petheader'>Pet Header</option><option value='frontpage'>Front Page</option></select> (What area of the website do you want your ad shown in?)</br> Your Ad Login: <textarea rows='1' cols='30' name='login'>{$_GET['login']}</textarea> (The Name You Want To Login To Your Ad Account With) Your Ad Password: <textarea rows='1' cols='30' name='pass'>{$_GET['pass']}</textarea> (The Password You Want For Your Ad Account) Ad Description: <textarea rows='1' cols='30' name='desc'>{$_GET['desc']}</textarea> (Up to 20 characters long, This Is What Users See With Mouse Over) Ad Banner URL: <textarea rows='1' cols='30' name='banner'>{$_GET['banner']}</textarea> (This Is The URL Where Your Ad Banner Is Currently Hosted) Ad Go To URL: <textarea rows='1' cols='30' name='goto'>{$_GET['goto']}</textarea> (This Is The URL Where Your Ad redirects the user to) Ad Views To Purchase: <textarea rows='1' cols='30' name='views'>{$_GET['views']}</textarea> (10 cents USD each, Buying Ad Views gives your ad maximum exposure) Ad Clicks To Purchase: <textarea rows='1' cols='30' name='clicks'>{$_GET['clicks']}</textarea> (50 cents USD each, For purchased clicks, The ad runs until the Ad Clicks Paid limit is met) Ad Mature: <select name='mature'><option value='yes'>Yes</option><option value='no'>No</option></select> (Is your ad not fit to be viewed by children, or does it have adult content?)</br> Ad Sex Genre: <select name='sexgenre'><option value='male'>Male</option><option value='female'>Female</option><option value='both'>Both</option></select> (Is your ad to be viewed by Males, Females, Or both?)</br> Ad Age Range: <textarea rows='1' cols='30' name='age'>{$_GET['age']}</textarea> (What age range do you wish your ad to be viewed by? ex 13-27) Ad Country Reach: <textarea rows='1' cols='30' name='country'>{$_GET['country']}</textarea> (What country do you wish your ad to be viewed in?, Or do you want it viewed worldwide?) Your Paypal Adress: <textarea rows='1' cols='30' name='paypal'>{$_GET['paypal']}</textarea> (Paypal is required to run an advertisement on this website) Other Information Or Requests: <textarea rows='1' cols='30' name='app'>{$_GET['app']}</textarea> (Any special requests or comments should go here) <input type='submit' value='Send Application' /></form></td></tr></table></center>"; Remove the $_GET's so users will be able to add in their information. And it will submit. I would look up on the $_POST/GET if I were you. Quote Link to comment Share on other sites More sharing options...
Blade Maker Posted January 6, 2011 Share Posted January 6, 2011 My bad I did not look at the whole thing, you should use the post method with forms. Quote Link to comment Share on other sites More sharing options...
VegasKiller Posted January 6, 2011 Author Share Posted January 6, 2011 Thank you, All fixed. Quote Link to comment Share on other sites More sharing options...
Blade Maker Posted January 6, 2011 Share Posted January 6, 2011 Me? Did my fix fix it or did rasheed? Quote Link to comment Share on other sites More sharing options...
VegasKiller Posted January 6, 2011 Author Share Posted January 6, 2011 Rasheeds did, Sorry Blade :). Can this thread please be deleted as the error is now fixed. Quote Link to comment Share on other sites More sharing options...
Rasheed saeed Posted January 6, 2011 Share Posted January 6, 2011 It doesn't matter who fixed it Blade. The problem is fixed so no concerns to whoever fixed it. I think this thread would most possibly be locked encase anyone has the same error. 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.