<?php
include_once('includes/configuration.php');
if(isset($_POST['add']))
{
if($_POST['student_id'] == "")
{
$message = 'Please Enter Srudent ID';
}
else
{
$student_id = $_REQUEST['student_id'];
$date = $_REQUEST['date'];
$free_indoor_play = $_REQUEST['free_indoor_play'];
$rhymes_session = $_REQUEST['rhymes_session'];
$language = $_REQUEST['language'];
$snaks = $_REQUEST['snaks'];
$concept_gk = $_REQUEST['concept_gk'];
$maths= $_REQUEST['maths'];
$music_movements = $_REQUEST['music_movements'];
$story_time = $_REQUEST['story_time'];
$free_outdoor_play = $_REQUEST['free_outdoor_play'];
$child_health = $_REQUEST['child_health'];
$child_food = $_REQUEST['child_food'];
$remarks = $_REQUEST['remarks'];
$query="insert into child-s-remarks (student_id , date , free_indoor_play , rhymes_session , language , snaks , concept_gk , maths , music_movements , story_time , free_outdoor_play , child_health , child_food , remarks) values ('$student_id' , '$date' , '$free_indoor_play' , '$rhymes_session' , '$language' , '$snaks' , '$concept_gk' , '$maths' , '$music_movements' , '$story_time' , '$free_outdoor_play' , '$child_health' , '$child_food' , '$remarks')";
mysql_query($query);
$message = 'student daily performence has been added Sucessfully';
}
}
?>
<form action="child-s-remarks.php" method="POST" enctype="multipart/form-data">
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"> <b>Student ID :</b></div>
<div id="registerfield">
<input name="student_id" type="text" class="field" id="textfield" required/>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Date(today) :</b></div>
<div id="registerfield">
<input type="text" id="datepicker" name="date" class="field" />
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Free Indoor Play :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="free_indoor_play" id="radio" value="Good" checked />Good
</label>
<label>
<input type="radio" name="free_indoor_play" id="radio2" value="Average" />Average
</label>
<label>
<input type="radio" name="free_indoor_play" id="radio3" value="Poor" />Poor
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Rhymes Session :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="rhymes_session" id="radio" value="Good" checked />Good
</label>
<label>
<input type="radio" name="rhymes_session" id="radio2" value="Average" />Average
</label>
<label>
<input type="radio" name="rhymes_session" id="radio3" value="Poor" />Poor
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Language (Alphabets , vocabulary) :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="language" id="radio" value="Good" checked />Good
</label>
<label>
<input type="radio" name="language" id="radio2" value="Average" />Average
</label>
<label>
<input type="radio" name="language" id="radio3" value="Poor" />Poor
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Snaks :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="snaks" id="radio" value="Taken" checked />Taken
</label>
<label>
<input type="radio" name="snaks" id="radio2" value="Not Taken" />Not Taken
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Concept General Knoweledge :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="concept_gk" id="radio" value="Good" checked/>Good
</label>
<label>
<input type="radio" name="concept_gk" id="radio2" value="Average" />Average
</label>
<label>
<input type="radio" name="concept_gk" id="radio3" value="Poor" />Poor
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Maths :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="maths" id="radio" value="Good" checked />Good
</label>
<label>
<input type="radio" name="maths" id="radio2" value="Average" /> Average
</label>
<label>
<input type="radio" name="maths" id="radio3" value="Poor" /> Poor
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Music Movements :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="music_movements" id="radio" value="Good" checked />Good
</label>
<label>
<input type="radio" name="music_movements" id="radio2" value="Average" /> Average
</label>
<label>
<input type="radio" name="music_movements" id="radio3" value="Poor" /> Poor
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Story Time :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="story_time" id="radio" value="Good" checked />Good
</label>
<label>
<input type="radio" name="story_time" id="radio2" value="Average" /> Average
</label>
<label>
<input type="radio" name="story_time" id="radio3" value="Poor" /> Poor
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Free outdoor Play :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="free_outdoor_play" id="radio" value="played" checked />Played
</label>
<label>
<input type="radio" name="free_outdoor_play" id="radio2" value="not played" /> Not Played
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Child Health :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="child_health" id="radio" value="Good" checked />Good
</label>
<label>
<input type="radio" name="child_health" id="radio2" value="Average" /> Average
</label>
<label>
<input type="radio" name="child_health" id="radio3" value="Poor" /> Poor
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Child Food :</b></div>
<div class="bodytext2" id="registerfield" style="margin-top:8px;">
<label>
<input type="radio" name="child_food" id="radio" value="Good" checked />Good
</label>
<label>
<input type="radio" name="child_food" id="radio2" value="Average" /> Average
</label>
<label>
<input type="radio" name="child_food" id="radio3" value="Poor" /> Poor
</label>
</div>
</div>
<div id="registercontainer3">
<div class="bodytext2" id="registercontent"><b>Remarks :</b></div>
<div id="registerfield">
<textarea name="remarks" cols="30" rows="5" class="textarea" id="textarea" required >
sudharshan9xweb 0 Newbie Poster
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
Do:
mysql_query($query) or die(mysql_error());
and find out why.
sudharshan9xweb 0 Newbie Poster
Could not connect: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-s-remarks(student_id , date , free_indoor_play , rhymes_session , language , sn' at line 1
i got this error..
sudharshan9xweb 0 Newbie Poster
ok got is thank you.
diafol
SO there you are. Enclose any table names with spaces or hyphens in them with `backticks`. Otherwise SQL may interpret them as 'minus' signs.
PS use $_POST instead of $_REQUEST. REQUEST can be modified by cookies and url parameters.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.