Jump to content

how to insert GET variable into mysql


annaright

Recommended Posts

hello can anyone help me how to insert GET variable into mysql   

 

 

<?php

$page_title = 'Personal Wellness';

include ('template/header.inc');

include_once('config.php');

 

$id = $_GET['id'];

 

if(isset($_POST['submit']))

//if submit was pressed

{

if(strlen($_POST['height'])<1) //if there was no height

{

print "You did not enter a height.";

}

else if(strlen($_POST['weight'])<1) //no weight

{

print "You did not enter a weight.";

}

else if(strlen($_POST['bodyfat'])<1) //no bodyfat

{

print "You did not enter a Body Fat Range";

}

else if (strlen ($_POST['bodywater'])<1) //no bodywater

{

print "You did not enter a Body Water Range";

}

else if( strlen($_POST['musclemass'])<1) //no musclemass

{

print "You did not enter a Muscle Mass";

}

else if (strlen ($_POST['physiqueratt'])<1) //no physiqueratt

{

print "You did not enter a Physique Ratings";

}

else if (strlen ($_POST['bonemass'])<1) //no bonemass

{

print "You did not enter a Bone Mass";

}

else if (strlen ($_POST['bmr'])<1) //no bmr

{

print "You did not enter a BMR";

}

else if (strlen ($_POST['basalmetabolic'])<1) //no basalmetabolic

{

print "You did not enter a Basal Metabolic Age";

}

else if (strlen ($_POST['visceralfat'])<1) //no visceralfat

{

print "You did not enter a Visceral Fat";

}

else if(strlen($_POST['registrationmonth'] && $_POST['registrationday'] && $_POST['registrationyear'])<1) // no date

{

print "You did not enter a date of birth";

}

else //all fields met

{

$id=$_GET['id'];

$height=$_POST['height'];

$weight=$_POST['weight'];

$bodyfat=$_POST['bodyfat'];

$bodywater=$_POST['bodywater'];

$musclemass=$_POST['musclemass'];

$physiqueratt=$_POST['physiqueratt'];

$bonemass=$_POST['bonemass'];

$bmr=$_POST['bmr'];

$basalmetabolic=$_POST['basalmetabolic'];

$visceralfat=$_POST['visceralfat'];

$date=$_POST['registrationyear'] . '-' . $_POST['registrationmonth'] . '-' . $_POST['registrationday'];

 

$insertadmin="INSERT into personalwelness (m_id,height,weight,body_fat,body_water,muscle_mas s,physique_ratt,bone_mass,bmr,basal_metabolic,visc eral_fat,evaluation_date) values ('$id','$height','$weight','$bodyfat','$bodywater','$mus clemass','$physiqueratt','$bonemass','$bmr','$basa lmetabolic','$visceralfat','$date')"; //registering admin in databae

echo $insertadmin;

$insertadmin2=mysql_query($insertadmin) or die("Could not insert admin");

print "Personal Wellness Successfully Submitted";

}

}

 

?>

<form method="post" class="form" action="<?php echo $_SERVER['PHP_SELF'];?>">

<fieldset><legend>Enter Personal Wellness Information in the form below:</legend>

 

<table width="80%" border="0">

<tr>

<td width="16%">Height(CM)</td>

<td width="2%">:</td>

<td width="82%"><label for="height"></label>

<input type="text" name="height" id="height" value="<?php if (isset($_POST['height']))

echo $_POST['height'];?>" /></td>

</tr>

<tr>

<td>Weight(KG)</td>

<td>:</td>

<td><label for="weight"></label>

<input type="text" name="weight" id="weight" value="<?php if (isset($_POST['weight']))

echo $_POST['weight'];?>" /></td>

</tr>

<tr>

<td >Body Fat Range</td>

<td>:</td>

<td><label for="body fat"></label>

<input type="text" name="bodyfat" id="bodyfat" value="<?php if (isset($_POST['bodyfat']))

echo $_POST['bodyfat'];?>" ></td>

</tr>

<tr>

<td>Body Water Range(%)</td>

<td>:</td>

<td><label for="bodywater"></label>

<input type="text" name="bodywater" id="bodywater" value="<?php if (isset($_POST['bodywater']))

echo $_POST['bodywater'];?>"/></td>

</tr>

<tr>

<td>Muscle Mass</td>

<td>:</td>

<td><label for="musclemass"></label>

<input type="text" name="musclemass" id="musclemass" value="<?php if (isset($_POST['musclemass']))

echo $_POST['musclemass'];?>"></td>

</tr>

<tr>

<td>Physique Ratings</td>

<td>:</td>

<td><label for="physiqueratt"></label>

<input type="text" name="physiqueratt" id="physiqueratt" value="<?php if (isset($_POST['physiqueratt']))

echo $_POST['physiqueratt'];?>"></td>

</tr>

<tr>

<td>Bone Mass</td>

<td>:</td>

<td><label for="bonemass"></label>

<input type="text" name="bonemass" id="bonemass" value="<?php if (isset($_POST['bonemass']))

echo $_POST['bonemass'];?>" /></td>

</tr>

<tr>

<td>BMR</td>

<td>:</td>

<td><label for="bmr"></label>

<input type="text" name="bmr" id="bmr" value="<?php if (isset($_POST['bmr']))

echo $_POST['bmr'];?>"/></td>

</tr>

<tr>

<td>Basal Metabolic Age</td>

<td>:</td>

<td><label for="basalmetabolic"></label>

<input type="text" name="basalmetabolic" id="basalmetabolic" value="<?php if (isset($_POST['basalmetabolic']))

echo $_POST['basalmetabolic'];?>"></td>

</tr>

<tr>

<td>Visceral Fat</td>

<td>:</td>

<td><label for="visceralfat"></label>

<input type="text" name="visceralfat" id="visceralfat" value="<?php if (isset($_POST['visceralfat']))

echo $_POST['visceralfat'];?>"></td>

</tr>

<tr>

<td>Evaluation Date</td>

<td>:</td>

<td> <?php echo date_picker("registration")?></td>

</tr>

</table>

</fieldset>

<div align="center"><input type="submit" name="submit" value="Submit" />

 

</div>

</form>

<?php

function date_picker($name, $startyear=NULL, $endyear=NULL)

{

if($startyear==NULL) $startyear = date("Y")-100;

if($endyear==NULL) $endyear=date("Y")+50;

 

$months=array('','January','February','March','Apr il','May',

'June','July','August', 'September','October','November','December');

 

// Month dropdown

$html="<select name=\"".$name."month\">";

 

for($i=1;$i<=12;$i++)

{

$html.="<option value='$i'>$months[$i]</option>";

}

$html.="</select> ";

 

// Day dropdown

$html.="<select name=\"".$name."day\">";

for($i=1;$i<=31;$i++)

{

$html.="<option $selected value='$i'>$i</option>";

}

$html.="</select> ";

 

// Year dropdown

$html.="<select name=\"".$name."year\">";

 

for($i=$startyear;$i<=$endyear;$i++)

{

$html.="<option value='$i'>$i</option>";

}

$html.="</select> ";

 

return $html;

}

?>

 

<?php

include ('template/footer.inc');

?>

Link to comment
Share on other sites

First of all, post your code in code or php tags (the # button in the post editor) Secondly, you need to be specific. Just posting code and asking how to do something won't get you help. When you run this code, what happens? What do you expect to happen (obviously this would be the get variable is inserted into the database) What have you done to debug the problem. Have you printed your $_GET variable to verify it has a value? Is there a mysql error? php error?

Link to comment
Share on other sites

First of all, post your code in code or php tags (the # button in the post editor) Secondly, you need to be specific. Just posting code and asking how to do something won't get you help. When you run this code, what happens? What do you expect to happen (obviously this would be the get variable is inserted into the database) What have you done to debug the problem. Have you printed your $_GET variable to verify it has a value? Is there a mysql error? php error?

 

sorry i'm new in php, actually i have to two table, table1 will store members info and table2 will store personal wellness info. there is a relationship between table1 and table2, so i need to store the member_id into table2.

 

<a href=\"add_wellness.php?id=$res[m_id]\">Add</a> when i click add, it will pass the member_id and i can add the personal wellness which is belong to this member_id.  what i expect to happen is i can insert this member_id into table2. there is no mysql error or php error , when i click submit only member_id still no value

 

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.