andrew_biggart

February 27, 2009

Im trying to make a form page post to it self when it is submitted, but i im having a few problems, when the page first loads it displays an error message as if the form has tried to be submitted which isnt what i want, how do i tell it not to run the php until the submit button has been pressed?

im using the following code for the form and php

	<div id="page_content_topic">
<table class="myprofile_change">
<tr><td class="myprofile_changesh">
<tr><td class="reg_status"> 
<?php

   include("config_members_temp.php");
   $recipe_username=$_GET['username'];   
   $recipe_title = ($_POST['recipe_title']);
   $recipe_ingre = ($_POST['recipe_ingre']);
   $recipe_method = ($_POST['recipe_method']);
   $recipe_cat = ($_POST['recipe_cat']);



   $sql = "INSERT INTO User_recipesT ( Recipe_username, Recipe_subject, Recipe_content, Recipe_ingre, Recipe_cat ) VALUES( '$recipe_username', '$recipe_title', '$recipe_method', '$recipe_ingre', '$recipe_cat' )";
   $result=mysql_query($sql) or die(mysql_error().": $sql");
     if($result){
echo "Your recipe has been successfully to our database";
}


// if not found
else {
echo "Ops there has been a problem please go back and try again!";
}

    ?>
    </td></tr>
    </td></tr>
</table>
<form method="post" action="upload_recipe_submit.php?username=<? echo"".$_SESSION["myusername"]."" ?>">
<table class="myprofile_change">
<tr><td class="myprofile_changesh">
<img alt="Cooking cannabis : add a recipe" src="../Header_images/addrecipe.jpg" width="156" height="46" /></td></tr>
<tr><td class="myprofile_subtext2">You are about to add a recipe to the 
	weloveweed mansions achieve. Make sure that your recipe is as sensible 
	as possible without being to dull. Even if its a recipe you have just 
	made up and think that tastes good, add it anyway because other members 
	might like it as well. Once your recipe has been submitted it may take 
	24hrs to show up as it has to be approved by one of our team.</td></tr>
<tr><td></td></tr>
</table>
<br />
<table class="myprofile_change">
<tr><td class="myprofile_subtext">Recipe Title :</td><td class="style3">
	<input name="recipe_title" type="text" /></td><td class="myprofile_max">Max 200 characters</td></tr>
<tr><td class="myprofile_subtext">Recipe cat :</td><td class="style3">
	<select name="recipe_cat" id="Fav"style="width: 126px">
	<option>Choose</option>
	<option>Snack recipes</option>
	<option>Starter recipes</option>
	<option>Main course recipes</option>
	<option>Desert recipes</option>
	<option>Miscellaneous recipes</option>
	</select></td><td class="myprofile_max">Please select one</td></tr>

<tr><td class="myprofile_subtext">Recipe ingredients :</td>
	<td class="style3">
	<textarea name="recipe_ingre" style="width: 355px; height: 76px"></textarea></td><td class="myprofile_max">Max 
	400 characters<br />
	Use <br /> to separate each ingredient.</td></tr>
<tr><td class="myprofile_subtext">Recipe method :</td><td class="style3">
	<textarea name="recipe_method" style="width: 355px; height: 190px" cols="20"></textarea></td><td class="myprofile_max">
	Max 800 characters</td></tr>
<tr><td></td></tr>
<tr><td></td><td></td><td><input name="Reset1" type="reset" value="reset" /><input name="Submit1" type="submit" value="add that shit !" /></td></tr>
<tr><td></td></tr>
</table>
<br />
</form>
</div>

Thankyou in advance

February 20, 2009

Thanks everyone <3

February 20, 2009

im confused as to what u mean mate.... I have a date and time field yea so that makes it easier but how do i actually do it? is it via php code or what?

February 20, 2009

I was just wondering is there any way of clearing entrys from your database after say a week? so that it doesnt get clogged up?

mysql counting the number of members · February 20, 2009

Thankyou

mysql counting the number of members · February 20, 2009

Is this the right code to count the number of members and display them?

	<table style="width: 100%" cellspacing="0" cellpadding="0">
<tr><td class="proinfo_h">Amount of members</td></tr>
<tr><td class="proinfo">
<?php

include("config_recipes.php");

// Retrieve data from database 
$sql="SELECT * count(User_id) as usercount FROM User_infoT";
$result=mysql_query($sql);
?>	
<? echo ['usercount']; ?>
</td></tr>
<tr><td class="proinfo_h">Amount of complaints</td></tr>
<tr><td class="proinfo">1234</td></tr>
<tr><td class="proinfo_h">Amount In my Inbox</td></tr>
<tr><td class="proinfo">1234</td></tr>
</table>
<br />

Cheers in advance

February 20, 2009

Cheers everyone thats worked

February 20, 2009

yea i have a timestamp on it hwo would i do the select statement then? cheers

February 20, 2009

is this right then?

	<br />
<img alt="Newest recipe" src="../Header_images/newestrecipe.gif" /><br />
<br />
<?php

include("config_recipes.php");

// Retrieve data from database 
$sql="SELECT * FROM User_recipesT ORDER BY Recipe_id LIMIT 1 ";
$result=mysql_query($sql);

// Start looping rows in mysql database.
while($rows=mysql_fetch_array($result)){
?>
<table>
<tr><td class="newmain">
<table>
<tr><td><h1 class="new_up">Uploaded by :</h1></td><td><h1 class="new_sub_user"><a href="profile.php?username=<? echo $rows['Recipe_username']; ?>"><? echo $rows['Recipe_username']; ?></a></h1></td></tr>
</table>
<table>
<tr><td><h1 class="new_sub"><? echo $rows['Recipe_subject']; ?></h1></td></tr>
</table>
<? echo $rows['Recipe_content']; ?>
</td></tr>
</table>
<br />
<?
// close while loop 
}

// close connection 
mysql_close();
?>

February 20, 2009

what kind of statement would i use to do the following/

i would like to select the latest say recipe added to the database so how would i tell it to select the last recipe_id ?

and also is there a way that i can count the number of users i have in my database and display it as a number?

thanks

February 20, 2009

nope i tried that and its still not getting through to hotmail grrrrrrrrrrr

cheers for ur help tho <3

February 20, 2009

Yea man fucking psammers and scammers are spoiling it for everyone grrrrrrrrrrrrrr.

I dotn really understand this header shit man, where do i put them etc ??

i tryed it with my uni email address and it send and confirmed no problem, but i need my users to be able to use any email address to register toerwise there is no point on having a registration page to be honest aghhhhhhhhhhhhhhhhh lol

February 20, 2009

il have a look at that cheers!!

its so annoying lol

February 20, 2009

Im trying to set up a verifying registration system and i know that its working properly apart from, it doesnt send the email to the user with the confirmation link so i guess it doesnt work fully lol.

registration page.htm ..

	<form method="post" action="user_register_submit.php">	
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Username :</td><td class="maxleft">

		<input name="Username" id="Username" type="text" maxlength="16 "value="Make your own up" /> 
		Max 16 characters
	</td></tr>
<tr><td class="reg_headers">Password :</td><td class="maxleft">
		<input name="Password" id="Password" type="password" maxlength="8" /> Max 8 characters</td></tr>
<tr><td class="reg_headers">Email address :</td><td>

		<input name="Email" id="Email" type="text" value="Must be valid" />
	</td></tr>	
</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Location :</td><td>
	<input name="Location" id="Location" type="text" value="Where your from" /></td></tr>
<tr><td class="reg_headers">Favourite Smoking method :</td><td>
	<select name="Fav" id="Fav"style="width: 126px">
	<option>Choose</option>
	<option>Joint</option>
	<option>Blunt</option>
	<option>Tulip</option>
	<option>Bong</option>
	<option>Lung</option>
	<option>Bucket</option>
	</select></td></tr>
<tr><td class="reg_headers">Favourite quote :</td><td class="maxleft">
	<input name="Quote" id="Quote"type="text" style="width: 246px" maxlength="50 "value="Words of wisdom" /> 
	Max 50 characters</td>

</tr>
<tr><td class="reg_headers" style="width: 200px" valign="top">About me : </td><td>
		<textarea name="Aboutme" id="Aboutme" style="width: 415px; height: 135px" >Write a little about yourself</textarea>
	</td></tr>
	<tr><td class="reg_headers" style="width: 200px" valign="top">Why do you 
		love weed? : </td><td>
		<textarea name="Whywe" id="Whywe" style="width: 415px; height: 135px" >Give a short reason why you love weed so others can read it on your profile</textarea>
	</td></tr>

</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Interests :</td><td class="maxleft">
	<input name="Interests" id="Interests" type="text" style="width: 246px" /> 
	Max 50 characters</td></tr>
<tr><td class="reg_headers">What makes you happy? :</td><td class="maxleft">
	<input name="Happy" id="Happy"type="text" style="width: 246px" /> 
	Max 70 characters</td></tr>
<tr><td class="reg_headers">What makes you sad? :</td><td class="maxleft">
	<input name="Sad" id="Sad"type="text" style="width: 246px" /> 
	Max 70 characters</td>
</tr>
<tr><td class="reg_headers" style="width: 200px" valign="top">Bad habits : </td><td class="maxleft">
	<input name="Habits" id="Habits"type="text" style="width: 246px" /> 
		Max 60 characters
	</td></tr>
</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Music :</td><td class="maxleft">
	 <select id="Music"name="Music" style="width: 126px">
	<option>Choose</option>
	<option>Dance</option>
	<option>RnB</option>
	<option>Funky House</option>
	<option>Indie</option>
	<option>Rock</option>
	<option>Electro</option>
	<option>Chillout</option>
	</select></td></tr>
<tr><td class="reg_headers">Movie :</td><td class="maxleft">
	<input name="Movie" id="Movie"type="text" style="width: 246px" /> 
	Max 100 characters</td></tr>
<tr><td class="Website">Website :</td><td class="maxleft">
	<input name="Website" id="Website"type="text" style="width: 246px" /> 
	No spamming</td>
</tr>
</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Update your status : </td><td>
		<input name="regstatus"type="text"  maxlength="50" style="width: 419px" value="What are you doing right now?" />
	</td></tr>
	<tr><td class="maxright">Max 50 characters     </td></tr>
<tr><td>


	</td><td class="style1"> </td></tr>

</table>
<table>
<tr><td class="reg_headers">Upload a profile picture : </td><td>
		<input name="File1" type="file" style="width: 248px" />
	</td></tr>
	<tr><td class="maxright">Max size 100px X 100px   </td></tr>


</table>

</td></tr>
</table>
<br />
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="terms"><h1 class="subcats">Terms & Conditions</h1>
	I hereby solemnly declare that once I have received my keys to the 
	weloveweed mansion I will not act like a demented retard, cock slurping, 
	member abusing, page spamming 
	slut. I will respect my new online home as if I was in my own home. I 
	will not post shit all over the walls, abuse or bully my family members 
	or leave 
	porn, and useless links lying around everywhere.<br />
	<br />
	I declare that I will try my best to donate new content to the site and upload as much 
	cool things as I come across while browsing the web. <br />
	<br />
	And most of all I agree to enjoy this site to its full extent, have as 
	much fun as possible and treat it like my own!<br />
	<br />
	<br />
	<h1 class="subcats">Important Information</h1>
	By Clicking the box below and submitting your details means that you 
	agree to our <a href="terms_conditions.htm">Terms & Conditions</a><h1 class="accept">
	<input type="checkbox" style="width:16px;" onclick="if(this.checked==1)document.getElementById('register').disabled='';else document.getElementById('register').disabled='disabled';" 
value="" name="accept" />Accept that shit !</h1>
</td></tr>
</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="style1"><input name="regreset" type="reset" value="D'oh" />
<input id="register" name="register" type="submit" value="Join the mansion" disabled="disabled" />
</td></tr>
</table>
</td></tr>
</table>

<br />
<br />
</form>

This all works fine.

Registration page .php

<?php

   include("config_members_temp.php");
   
   $confirm_code=md5(uniqid(rand()));
   
   $Username = ($_POST['Username']);
   $Password = ($_POST['Password']);
   $Email = ($_POST['Email']);
   $Location = ($_POST['Location']);
   $Fav = ($_POST['Fav']);
   $Quote = ($_POST['Quote']);
   $Interests = ($_POST['Interests']);
   $Happy = ($_POST['Happy']);
   $Sad = ($_POST['Sad']);
   $Habits = ($_POST['Habits']);
   $Music = ($_POST['Music']);
   $Movie = ($_POST['Movie']);
   $Website = ($_POST['Website']);
   $Aboutme = ($_POST['Aboutme']);
   $Whywe = ($_POST['Whywe']);


   $sql = "INSERT INTO Temp_Users ( Username, Password, Email, Location, Fav, Quote, Interests, Happy, Sad, Habits, Music, Movie, Website, Aboutme, Whywe, Confirm_code) VALUES( '$Username','$Password', '$Email', '$Location', '$Fav', '$Quote', '$Interests', '$Happy', '$Sad', '$Habits' , '$Music', '$Movie', '$Website', '$Aboutme', '$Whywe', '$confirm_code' )";
   $result=mysql_query($sql) or die(mysql_error().": $sql");
     if($result){
// send e-mail to ...
$to=$Email;

// Your subject
$subject="www.weloveweed.co.uk | Your confirmation link!";

// From
$header="from: AdMiN <help@weloveweed.co.uk>";

// Your message
$message="Your Comfirmation link <3 from AdMiN \r\n";
$message.="Click on this link to activate your account \r\n";
$message.="http://server.microlite20.com/andrewbiggart.co.uk/weloveweed/Webpages/confirmation.php?passkey=$confirm_code";

// send email
$sentmail = mail($to,$subject,$message,$header);

}

// if not found
else {
echo "We have not found your email in our database";
}

// if your email succesfully sent
if($sentmail){
echo "Your confirmation link has been sent to your email address, you have to activate your account before you are able to login.";
}
else {
echo "Cannot send Confirmation link to your e-mail address, please make sure you have entered a valid email address and try again.";
}

   ?>

It doesnt send the email but it adds the information to the database including the confirmation code.

confirmation.php...............

	<?
include('config_members_temp.php');

// Passkey that got from link
$passkey=$_GET['passkey'];

$tbl_name1="Temp_Users";

// Retrieve data from table where row that match this passkey
$sql1="SELECT * FROM $tbl_name1 WHERE Confirm_code ='$passkey'";
$result1=mysql_query($sql1);

// If successfully queried
if($result1){

// Count how many row has this passkey
$count=mysql_num_rows($result1);

// if found this passkey in our database, retrieve data from table "temp_members_db"
if($count==1){

$rows=mysql_fetch_array($result1);
$name=$rows['name'];
    $Username = $rows['Username'];
    $Password = $rows['Password'];
    $Email = $rows['Email'];
    $Location = $rows['Location'];
    $Fav = $rows['Fav'];
    $Quote = $rows['Quote'];
    $Interests = $rows['Interests'];
    $Happy = $rows['Happy'];
    $Sad = ($_POST['Sad']);
    $Habits = $rows['Habits'];
    $Music = $rows['Music'];
    $Movie = $rows['Movie'];
    $Website = $rows['Website'];
    $Aboutme = $rows['Aboutme'];
    $Whywe = $rows['Whywe'];

$tbl_name2="User_infoT";

// Insert data that retrieves from "temp_members_db" into table "registered_members"
$sql2="INSERT INTO $tbl_name2 ( Username, Password, Email, Location, Fav, Quote, Interests, Happy, Sad, Habits, Music, Movie, Website, Aboutme, Whywe ) VALUES( '$Username','$Password', '$Email', '$Location', '$Fav', '$Quote', '$Interests', '$Happy', '$Sad', '$Habits' , '$Music', '$Movie', '$Website', '$Aboutme', '$Whywe' )";
$result2=mysql_query($sql2);
}

// if not found passkey, display message "Wrong Confirmation code"
else {
echo "Wrong Confirmation code";
}

// if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"
if($result2){

echo "Welcome to weloveweed your account has been activated & you can log your ass in. <3 AdMiN ";

// Delete information of this user from table "temp_members_db" that has this passkey
$sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";
$result3=mysql_query($sql3);

}

}
?>

and i know this bit works as i have manually entered the confirmation code in the address bar and it changes all the information to the permanant users table and removes all the old information from the tempery tabel so i guess.

Im trying to send the email to my hotmail account but it is just never getting received and it is not appearing in the junk section either.... What am i doing wrong?

Thanks for all your help in advance and ive tried to explain the problem to the best of my knowledge lol <3

displaying profile images ??? · February 14, 2009

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office">
<head>
<title>Welcome to www.weloveweed.co.uk | All your stoner resources under one roof</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="../stylesheets/layout_profile.css" />
<link rel="stylesheet" type="text/css" href="../stylesheets/headers.css" />
<link rel="stylesheet" type="text/css" href="../stylesheets/images.css" />
<link rel="stylesheet" type="text/css" href="../stylesheets/inputs.css" />
<link rel="stylesheet" type="text/css" href="../stylesheets/links.css" />
<link rel="stylesheet" type="text/css" href="../stylesheets/styles2.css" />
<link rel="stylesheet" type="text/css" href="../stylesheets/tables.css" />
<link rel="stylesheet" type="text/css" href="../stylesheets/tds.css" />

<style type="text/css">
.style2 {
border-width: 0px;
}
</style>

<script type="text/javascript">
<!--
function FP_swapImgRestore() {//v1.0
var doc=document,i; if(doc.$imgSwaps) { for(i=0;i<doc.$imgSwaps.length;i++) {
  var elm=doc.$imgSwaps[i]; if(elm) { elm.src=elm.$src; elm.$src=null; } } 
  doc.$imgSwaps=null; }
}

function FP_swapImg() {//v1.0
var doc=document,args=arguments,elm,n; doc.$imgSwaps=new Array(); for(n=2; n<args.length;
n+=2) { elm=FP_getObjectByID(args[n]); if(elm) { doc.$imgSwaps[doc.$imgSwaps.length]=elm;
elm.$src=elm.src; elm.src=args[n+1]; } }
}

function FP_preloadImgs() {//v1.0
var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array();
for(var i=0; i<a.length; i++) { d.FP_imgs[i]=new Image; d.FP_imgs[i].src=a[i]; }
}

function FP_getObjectByID(id,o) {//v1.0
var c,el,els,f,m,n; if(!o)o=document; if(o.getElementById) el=o.getElementById(id);
else if(o.layers) c=o.layers; else if(o.all) el=o.all[id]; if(el) return el;
if(o.id==id || o.name==id) return o; if(o.childNodes) c=o.childNodes; if(c)
for(n=0; n<c.length; n++) { el=FP_getObjectByID(id,c[n]); if(el) return el; }
f=o.forms; if(f) for(n=0; n<f.length; n++) { els=f[n].elements;
for(m=0; m<els.length; m++){ el=FP_getObjectByID(id,els[n]); if(el) return el; } }
return null;
}
// -->
</script>

</head>

<body background="../Layout_images/bg.gif" onload="FP_preloadImgs(/*url*/'../Header_images/enter_forum_h.jpg')">
<div id="wrapper">
<div id="masthead">
<a href="default.php">
<img alt="Homepage" src="../Layout_images/homebutton.gif" width="355" height="65" class="style2" /></a></div>


<div id="nav">
<div id="nav_left">

<a class="button1" href="default.php">Homepage</a>
<br />
<a class="button2" href="pictures.htm">Pictures</a>
<br />
<a class="button3" href="../videos.htm">Videos</a>
<br />
<a class="button1" href="recipes.htm">Recipes</a>

<br />
<a class="button2" href="diy.htm">D.I.Y</a>
<br />
<a class="button3" href="links.htm">Links</a>
<br />
<a class="button1" href="contact_us.htm">Contact Us</a>
</div>

<div id="nav_content">
<img alt="masthead" src="../Layout_images/Banner.jpg" width="697" height="173" />
</div>
</div>

<div id="container">
<div id="left_col">

<div id="login_header">
</div>

<div id="login">

	<table>
<tr><td class="profile_spacer"></td><td class="profilepicture"><img src='Profile_pics/' style='width:100px; height:100px;' /></td></tr>
</table>
<table cellspacing="0">
	<tr><td class="profile_spacer"> </td>
	<td class="profileinfoimg">
	<img alt="" src="../Header_images/mailme.jpg" width="15" height="15" /></td>
	<td class="profileinfolinks"><a class="profile_sub" href="message_me.htm">Message 
	me</a></td>

</tr>
<tr><td class="profile_spacer"> </td>
	<td class="profileinfoimg">
	<img alt="" src="../Header_images/myrecipes.jpg" width="15" height="15" /></td>
	<td class="profileinfolinks">
	<a class="profile_sub" href="my_recipes.htm">My recipes</a></td>
</tr>
<tr><td class="profile_spacer"> </td>

	<td class="profileinfoimg">
	<img alt="" src="../Header_images/mypictures.jpg" width="15" height="15" /></td>
	<td class="profileinfolinks">
	<a class="profile_sub" href="my_pictures.htm">My pictures</a></td>
</tr>
<tr><td class="profile_spacer"> </td>
	<td class="profileinfoimg">
	<img alt="" src="../Header_images/myvids.jpg" width="15" height="15" /></td>

	<td class="profileinfolinks">
	<a class="profile_sub" href="my_videos.htm">My videos</a></td>
</tr>
</table>
</div>
<div id="new_recipes_header" style="left: 0px; top: 0px">
<h1 class="procats" style="font-weight: normal">Personal Info</h1>
</div>

<div id="new_recipes">
<table style="width: 100%" cellspacing="0" cellpadding="0">
<tr><td class="proinfo_h">Interests</td></tr>
<tr><td class="proinfo">Web designing, getting high & dressing up as a hot dog.</td></tr>
<tr><td class="proinfo_h">Makes me happy</td></tr>
<tr><td class="proinfo">Smoking bongs & generally when im high</td></tr>

<tr><td class="proinfo_h">Makes me sad</td></tr>
<tr><td class="proinfo">People being cocks on this site</td></tr>
<tr><td class="proinfo_h">Bad Habits</td></tr>
<tr><td class="proinfo">Sitting up smoking all night & sleeping all day</td></tr>
</table>
</div>

<div id="new_members">
<h1 class="procats" style="font-weight: normal">Favourite Things</h1>
<table style="width: 100%" cellspacing="0" cellpadding="0">
<tr><td class="proinfo_h">Music</td></tr>
<tr><td class="proinfo">Indie, house, electro & Chillout</td></tr>
<tr><td class="proinfo_h">Movie</td></tr>

<tr><td class="proinfo">Half Baked, pineapple express</td></tr>
<tr><td class="proinfo_h">Website</td></tr>
<tr><td class="proinfo"><a class="profile_site" href="http://www.weloveweed.co.uk">click hear to view</a></td></tr>
</table>
<br />
</div>	
<div id="forum">
Weloveweed Forum
<br />

<br />
<a href="forum.htm">
<img alt="Enter weloveweed forum" src="../Header_images/enter_forum1.jpg" width="70" height="19" id="img1" onmouseout="FP_swapImgRestore()" onmouseover="FP_swapImg(1,1,/*id*/'img1',/*url*/'../Header_images/enter_forum_h.jpg')" class="style2" /></a></div>

<div id="feedback">
<br />
	<form method="post">
		<table>
		<tr><td></td></tr>
		<tr><td class="suggest_headers">Username :</td><td>

		<input class="comments_user"name="Text1" type="text" style="width: 94px" value="Not Registered" />
		</td></tr>
		</table>

		<table>
		<tr><td  class="suggest_headers">Comment  :</td></tr>
		<tr><td><textarea class="comments" name="TextArea1" style="height: 76px; width: 171px">Hear at weloveweed mansion we appreciate your feedback, so feel free to add your comments and dont fucking abuse it <3</textarea></td></tr>
		<tr><td class="comments" style="height: 34px">

		<input name="Reset" type="reset" value="D'oh" /><input name="Submit" type="submit" value="Whooohoo" />
		</td></tr>
		</table>
	</form>
</div>

</div>

<div id="page_content">
<div id="page_content_mainheader">
<table class="status_table">

<tr><td class="status">
	<img alt="we love weed weloveweed admins profile" src="../Header_images/theonlyone.gif" /><img alt="" src="../Header_images/buttons2.jpg" width="10" height="10" /><img alt="" src="../Header_images/buttons3.jpg" width="10" height="10" /><img alt="" src="../Header_images/buttons1.jpg" width="10" height="10" /></td></tr>
</table>
</div>

<div id="page_content_spacer">
<div id="page_content_header">
</div>
<div id="page_content_content">
<table class="profiletable" style="border-width: 0">

	<tr>
		<td colspan="2" class="status"><br />
		</td>
	</tr>
	<tr>
		<td class="profileinfo">Username :</td>
		<td><a href="profile.php?username=AdMiN">AdMiN</a></td>
	</tr>

	<tr>
		<td class="profileinfo">Location :</td>
		<td class="profileinfo_h">Manchester, UK</td>
	</tr>
	<tr>
		<td class="profileinfo">Favourite smoking method :</td>
		<td class="profileinfo_h">Buckets, Lungs & Bongs</td>

	</tr>
	<tr>
		<td class="profileinfo" style="width: 200px" valign="top">Favourite Quote :</td>
		<td class="profileinfo_quote">" I like a blunt or a big fat cone, but this double barrelled bong is getting me stoned !"</td>
	</tr>
</table>
</div>


<div id="page_content_spacer">
<div id="page_content_header">
</div>
<div id="page_content_content">
<img alt="Top 5 weloveweed Pictures" src="../Header_images/top5.gif" width="200" height="40" /><br />
<br />
<table>
<tr><td class="newpics">
<img class ="thumbs" alt="" src="../Thumbnail_images/np1.jpg" width="100" height="100" />

<img class ="thumbs" alt="" src="../Thumbnail_images/np2.jpg" width="100" height="100" />
<img class ="thumbs" alt="" src="../Thumbnail_images/np3.jpg" width="100" height="100" />
<img class ="thumbs" alt="" src="../Thumbnail_images/np4.jpg" width="100" height="100" />
<img class ="thumbs" alt="" src="../Thumbnail_images/np5.jpg" width="100" height="100" /></td></tr>
</table>
<br />
</div>


<div id="page_content_spacer">

<div id="page_content_header">
</div>
<div id="page_content_content">
<img alt="About me section" src="../Header_images/aboutme.gif" width="200" height="40" /><br />
<br />
<table class="profileaboutme">
<tr><td class="about">Peace! Hope your enjoying the site as much as I have enjoyed making it for you. I have successfully built all of us stoners a giant online mansion to chill in.
<br />
<br />
"Which means that I am the only resident around here who is allowed to kick ass."

<br />
<br />
Ok a little about me. I've smoked the sweet sweet Mary Jane for about 8 years now, there's nothing better than smoking joint after joint until it is coming out of your ears. I love to smoke myself into a state of numbness, I can be a cock, sometimes I have an attitude but most of the time im a sound guy. Im originally from Northern Ireland, and I moved to Manchester 4 years ago to go to university and obviously because the weed in Manchester is a lot better and I've been numbing myself ever since.
<br />
<br />
This is when i realised that there is no cool sites online where stoners can chat shit & chill so along came the idea to build. weloveweed.</td></tr>
</table>
<br />
</div>

<div id="page_content_spacer">
<div id="page_content_header">

</div>
<div id="page_content_content">
<img alt="Why we love weed section" src="../Header_images/whywelove.gif" width="200" height="40" /><br />
<br />
<table class="profileaboutme">
<tr><td class="about">I first fell in love with Mary Jane back in the year 2000 when I was 15 & feeling rebellious against the world. To my surprise weed seemed to straighten me out, make me chill out and not have a fucking care in the world.
<br />
<br />
Now im just a part time smoker only on evenings and weekends, but back in the day I was definitely positively a full time smoker especially when I started university. The second I landed in Manchester smoking weed has been the only exercise my lungs have seen in 5 years.</td></tr>

</table>
	<br />
</div>


<div id="page_content_spacer">
<div id="page_content_header">
</div>
<div id="page_content_content">
	<img alt="My blog section" src="../Header_images/myblog.gif" width="200" height="40" /><br />
		<table class="blogborder">

		<tr>
			<td>
			<table class="profileaboutme">
				<tr>
					<td class="blogdate" style="width: 503px">Post made:</td>
					<td class="blogdate">2009-02-14</td>
				</tr>
				<tr>

					<td class="blogsubject">High timeeeeeeeeeeeeee</td>
				</tr>
				<tr>
					<td class="about" colspan="2"><br /><br />Great news, I've nearly got our new home finished, the end is in sight. I hope everyone is excited to see what i have done to the place. I know you will be as there all your suggestions put into a mansion. There are still a few kinks that i need to iron out so please bare with me and don't complain as i will be able to find all the errors myself.
<br />
<br />
Im so excited so I've made a nice big fat blunt to celebrate whop <3  Enjoy !!</td>
				</tr>
			</table>

			</td>
		</tr>
	</table>

	<br />
</div>

</div>

<br />
</div>

</div>
</div>
</div>
</div>
<div id="footer"><img alt="" src="../Layout_images/footer_final.jpg" width="881" height="58" /></div>
<div id="final_footer">
Copyright <span class="style10">©</span><a class="link" href="http://www.weloveweed.co.uk"> weloveweed.co.uk</a><span> 2009</span><br />
<a class="link" href="terms_conditions.htm">Terms & Conditions</a> |
<a class="link" href="legal_disclaimer.htm">Legal Disclaimer</a><span><br />

Web design by 
<a class="link" href="http://www.andrewbiggart.co.uk/examples.html">BIGdesigns</a> SEO by <a class="link" href="http://www.andrewbiggart.co.uk/">Andrew Biggart</a></span>

</div>
</div>
</body>
</html>

displaying profile images ??? · February 14, 2009

ok in the last site i had this sussed how ever for some reason this one is being gay....

im using the following code

	<?php

include("config_members.php");
$username=$_GET['username'];


// Retrieve data from database 
$sql="SELECT * FROM User_infoT WHERE Username='$username'";
$result=mysql_query($sql);

// Start looping rows in mysql database.
while($rows=mysql_fetch_array($result)){
?>
<table>
<tr><td class="profile_spacer"></td><td class="profilepicture"><? echo "<img src='Profile_pics/". $rows['Profile_picture'] . "' style='width:100px; height:100px;' />";?></td></tr>
</table>

obviously i have closed the loop further own but can anyone see any reason why this wouldnt work? it loads the blanc sqaure but no picture loads?

February 14, 2009

Yea it still being weird but its working without the if and else so il just leave it at that as long as the info is going into the database for now it will do cheers everyone for your help !!

February 14, 2009

ok finally some progress.....

it works without the if and else statements, can anyone see why?

   if($result){
   echo "<h1 class=contact_us2>Successful, you are now a registered member of www.weloveweed.co.uk, welcome to the family"</h1>;
   echo "<BR>";
   echo "<h1 class=contact_us2>You are now able to login, <a href="default.php">Click hear</a></h1>";

   }
   
   else {
   echo "<h1 class=contact_us>ERROR, please try again and insure you have filled in all *required fields, Thank you</h1>";
   }

February 14, 2009

I have definitly got it uploaded correctly, my login and profiles are working from the same mysql so it isnt that.

The config file is 100% the right one.

and ive tried writing it like this and it still isnt working....

	<?php

phpinfo();

include("config_members.php");

$Username = ($_POST['Username']);
$Password = ($_POST['Password']);
$Email = ($_POST['Email']);
$Location = ($_POST['Location']);
$Fav = ($_POST['Fav']);
$Quote = ($_POST['Quote']);
$Interests = ($_POST['Interests']);
$Happy = ($_POST['Happy']);
$Sad = ($_POST['Sad']);
$Habits = ($_POST['Habits']);
$Music = ($_POST['Music']);
$Movie = ($_POST['Movie']);
$Website = ($_POST['Website']);
$Aboutme = ($_POST['Aboutme']);
$Whywe = ($_POST['Whywe']);


$sql = "INSERT INTO User_infoT ( '$Username', '$Password', '$Email', '$Location', '$Fav', '$Quote', '$Interests', '$Happy', '$Sad', '$Habits', '$Music', '$Movie', '$Website', '$Aboutme', '$Whywe'))";
$result=mysql_query($sql) or die(mysql_error().": $sql");

if($result){
echo "<h1 class=contact_us2>Successful, you are now a registered member of www.weloveweed.co.uk, welcome to the family"</h1>;
echo "<BR>";
echo "<h1 class=contact_us2>You are now able to login, <a href="default.php">Click hear</a></h1>";

}

else {
echo "<h1 class=contact_us>ERROR, please try again and insure you have filled in all *required fields, Thank you</h1>";
}

// close connection
mysql_close();
?>

Is there anything left that i can try?

February 14, 2009

The first ones are the names of each bit in the table the cvalues need to go into, and then the second ones are the actual values which i have declared at the top of the code !!!

I have named the inputs, the $thingys and the table sections all the same to try and keep it simple grrrrrrrrr

February 14, 2009

Again absoultly nothing this is depressing lol

February 14, 2009

Ok it having real trouble now i actually cant fiqure this shit out.

The php code is this;

	<?php

include("config_members.php");

$Username = ($_POST['Username']);
$Password = ($_POST['Password']);
$Email = ($_POST['Email']);
$Location = ($_POST['Location']);
$Fav = ($_POST['Fav']);
$Quote = ($_POST['Quote']);
$Interests = ($_POST['Interests']);
$Happy = ($_POST['Happy']);
$Sad = ($_POST['Sad']);
$Habits = ($_POST['Habits']);
$Music = ($_POST['Music']);
$Movie = ($_POST['Movie']);
$Website = ($_POST['Website']);
$Aboutme = ($_POST['Aboutme']);
$Whywe = ($_POST['Whywe']);


$sql = "INSERT INTO User_infoT ( Username, Password, Email, Location, Fav, Quote, Interests, Happy, Sad, Habits, Music, Movie, Website, Aboutme, Whywe) VALUES( '$Username','$Password', '$Email', '$Location', '$Fav', '$Quote', '$Interests', '$Happy', '$Sad', '$Habits' , '$Music', '$Movie', '$Website', '$Aboutme', '$Whywe' )";
$result=mysql_query($sql) or die(mysql_error().": $sql");

if($result){
echo "<h1 class=contact_us2>Successful, you are now a registered member of www.weloveweed.co.uk, welcome to the family"</h1>;
echo "<BR>";
echo "<h1 class=contact_us2>You are now able to login, <a href="default.php">Click hear</a></h1>";

}

else {
echo "<h1 class=contact_us>ERROR, please try again and insure you have filled in all *required fields, Thank you</h1>";
}

// close connection
mysql_close();
?>

and the html is this !!

	<form method="post" action="user_register_submit.php">	
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Username :</td><td class="maxleft">

		<input name="Username" id="Username" type="text" maxlength="16 "value="Make your own up" /> 
		Max 16 characters
	</td></tr>
<tr><td class="reg_headers">Password :</td><td class="maxleft">
		<input name="Password" id="Password" type="password" maxlength="8" /> Max 8 characters</td></tr>
<tr><td class="reg_headers">Email address :</td><td>

		<input name="Email" id="Email" type="text" value="Must be valid" />
	</td></tr>	
</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Location :</td><td>
	<input name="Location" id="Location" type="text" value="Where your from" /></td></tr>
<tr><td class="reg_headers">Favourite Smoking method :</td><td>
	<select name="Fav" id="Fav"style="width: 126px">
	<option>Choose</option>
	<option>Joint</option>
	<option>Blunt</option>
	<option>Tulip</option>
	<option>Bong</option>
	<option>Lung</option>
	<option>Bucket</option>
	</select></td></tr>
<tr><td class="reg_headers">Favourite quote :</td><td class="maxleft">
	<input name="Quote" id="Quote"type="text" style="width: 246px" maxlength="50 "value="Words of wisdom" /> 
	Max 50 characters</td>

</tr>
<tr><td class="reg_headers" style="width: 200px" valign="top">About me : </td><td>
		<textarea name="Aboutme" id="Aboutme" style="width: 415px; height: 135px" >Write a little about yourself</textarea>
	</td></tr>
	<tr><td class="reg_headers" style="width: 200px" valign="top">Why do you 
		love weed? : </td><td>
		<textarea name="Whywe" id="Whywe" style="width: 415px; height: 135px" >Give a short reason why you love weed so others can read it on your profile</textarea>
	</td></tr>

</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Interests :</td><td class="maxleft">
	<input name="Interests" id="Interests" type="text" style="width: 246px" /> 
	Max 50 characters</td></tr>
<tr><td class="reg_headers">What makes you happy? :</td><td class="maxleft">
	<input name="Happy" id="Happy"type="text" style="width: 246px" /> 
	Max 70 characters</td></tr>
<tr><td class="reg_headers">What makes you sad? :</td><td class="maxleft">
	<input name="Sad" id="Sad"type="text" style="width: 246px" /> 
	Max 70 characters</td>
</tr>
<tr><td class="reg_headers" style="width: 200px" valign="top">Bad habits : </td><td class="maxleft">
	<input name="Habits" id="Habits"type="text" style="width: 246px" /> 
		Max 60 characters
	</td></tr>
</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Music :</td><td class="maxleft">
	 <select id="Music"name="Music" style="width: 126px">
	<option>Choose</option>
	<option>Dance</option>
	<option>RnB</option>
	<option>Funky House</option>
	<option>Indie</option>
	<option>Rock</option>
	<option>Electro</option>
	<option>Chillout</option>
	</select></td></tr>
<tr><td class="reg_headers">Movie :</td><td class="maxleft">
	<input name="Movie" id="Movie"type="text" style="width: 246px" /> 
	Max 100 characters</td></tr>
<tr><td class="Website">Website :</td><td class="maxleft">
	<input name="Quote" id="Quote"type="text" style="width: 246px" /> 
	No spamming</td>
</tr>
</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="reg_headers">Update your status : </td><td>
		<input name="regstatus"type="text"  maxlength="50" style="width: 419px" value="What are you doing right now?" />
	</td></tr>
	<tr><td class="maxright">Max 50 characters     </td></tr>
<tr><td>


	</td><td class="style1"> </td></tr>

</table>
<table>
<tr><td class="reg_headers">Upload a profile picture : </td><td>
		<input name="File1" type="file" style="width: 248px" />
	</td></tr>
	<tr><td class="maxright">Max size 100px X 100px   </td></tr>


</table>

</td></tr>
</table>
<br />
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="terms"><h1 class="subcats">Terms & Conditions</h1>
	I hereby solemnly declare that once I have received my keys to the 
	weloveweed mansion I will not act like a demented retard, cock slurping, 
	member abusing, page spamming 
	slut. I will respect my new online home as if I was in my own home. I 
	will not post shit all over the walls, abuse or bully my family members 
	or leave 
	porn, and useless links lying around everywhere.<br />
	<br />
	I declare that I will try my best to donate new content to the site and upload as much 
	cool things as I come across while browsing the web. <br />
	<br />
	And most of all I agree to enjoy this site to its full extent, have as 
	much fun as possible and treat it like my own!<br />
	<br />
	<br />
	<h1 class="subcats">Important Information</h1>
	By Clicking the box below and submitting your details means that you 
	agree to our <a href="terms_conditions.htm">Terms & Conditions</a><h1 class="accept">
	<input type="checkbox" style="width:16px;" onclick="if(this.checked==1)document.getElementById('register').disabled='';else document.getElementById('register').disabled='disabled';" 
value="" name="accept" />Accept that shit !</h1>
</td></tr>
</table>
</td></tr>
</table>
<br />
<table class="profileforum">
<tr><td class="forum1">
<table>
<tr><td class="style1"><input name="regreset" type="reset" value="D'oh" />
<input id="register" name="register" type="submit" value="Join the mansion" disabled="disabled" />
</td></tr>
</table>
</td></tr>
</table>

<br />
<br />
</form>

Please help

February 14, 2009

Tried this and its not bringing up any errors just that forking blanc screen !!!

	<?php
error_reporting(E_ALL);
ini_set("display_errors",TRUE);

include("config_members.php");

$Username = ($_POST['Username']);
$Password = ($_POST['Password']);
$Email = ($_POST['Email']);
$Location = ($_POST['Location']);
$Fav = ($_POST['Fav']);
$Quote = ($_POST['Quote']);
$Interests = ($_POST['Interests']);
$Happy = ($_POST['Happy']);
$Sad = ($_POST['Sad']);
$Habits = ($_POST['Habits']);
$Music = ($_POST['Music']);
$Movie = ($_POST['Movie']);
$Website = ($_POST['Website']);
$Aboutme = ($_POST['Aboutme']);
$Whywe = ($_POST['Whywe']);


$sql = "INSERT INTO User_infoT ( Username, Password, Email, Location, Fav, Quote, Interests, Happy, Sad, Habits, Music, Movie, Website, Aboutme, Whywe) VALUES( '$Username','$Password', '$Email', '$Location', '$Fav', '$Quote', '$Interests', '$Happy', '$Sad', '$Habits' , '$Music', '$Movie', '$Website', '$Aboutme', '$Whywe' )";
$result=mysql_query($sql);

if($result){
echo "<h1 class=contact_us2>Successful, you are now a registered member of www.weloveweed.co.uk, welcome to the family"</h1>;
echo "<BR>";
echo "<h1 class=contact_us2>You are now able to login, <a href="default.php">Click hear</a></h1>";

}

else {
echo "<h1 class=contact_us>ERROR, please try again and insure you have filled in all *required fields, Thank you</h1>";
}

// close connection
mysql_close();
?>

February 14, 2009

Yea i have uploaded it onto the web server its just being really annoying grrrrr

February 14, 2009

This is really bugging the shit out of me, its just a simple php registration process but when i submit the form im getting that dam blanc screen, i know it will be something silly but my eyes are failing to see it!! anyone notice anything purcular?

Thanks in advance

	<?

include("config_members.php");

$Username = ($_POST['Username']);
$Password = ($_POST['Password']);
$Email = ($_POST['Email']);
$Location = ($_POST['Location']);
$Fav = ($_POST['Fav']);
$Quote = ($_POST['Quote']);
$Interests = ($_POST['Interests']);
$Happy = ($_POST['Happy']);
$Sad = ($_POST['Sad']);
$Habits = ($_POST['Habits']);
$Music = ($_POST['Music']);
$Movie = ($_POST['Movie']);
$Website = ($_POST['Website']);
$Aboutme = ($_POST['Aboutme']);
$Whywe = ($_POST['Whywe']);


$sql = "INSERT INTO User_infoT ( Username, Password, Email, Location, Fav, Quote, Interests, Happy, Sad, Habits, Music, Movie, Website, Aboutme, Whywe) VALUES( '$Username','$Password', '$Email', '$Location', '$Fav', '$Quote', '$Interests', '$Happy', '$Sad', '$Habits' , '$Music', '$Movie', '$Website', '$Aboutme', '$Whywe' )";
$result=mysql_query($sql);

if($result){
echo "<h1 class=contact_us2>Successful, you are now a registered member of www.weloveweed.co.uk, welcome to the family"</h1>;
echo "<BR>";
echo "<h1 class=contact_us2>You are now able to login, <a href="default.php">Click hear</a></h1>";

}

else {
echo "<h1 class=contact_us>ERROR, please try again and insure you have filled in all *required fields, Thank you</h1>";
}

// close connection
mysql_close();
?>

Sign In

andrew_biggart

Posts

Joined

Last visited

Days Won

Content Type

Profiles

Forums

Posts posted by andrew_biggart

form help please !

[SOLVED] clearing entrys from your database ?

[SOLVED] clearing entrys from your database ?

[SOLVED] clearing entrys from your database ?

mysql counting the number of members

mysql counting the number of members

[SOLVED] mysql statements

[SOLVED] mysql statements

[SOLVED] mysql statements

[SOLVED] mysql statements

php mail function :(

php mail function :(

php mail function :(

php mail function :(

displaying profile images ???

displaying profile images ???

[SOLVED] Fresh eyes required !!!

[SOLVED] Fresh eyes required !!!

[SOLVED] Fresh eyes required !!!

[SOLVED] Fresh eyes required !!!

[SOLVED] Fresh eyes required !!!

[SOLVED] Fresh eyes required !!!

[SOLVED] Fresh eyes required !!!

[SOLVED] Fresh eyes required !!!

[SOLVED] Fresh eyes required !!!

Browse

Activity

Important Information