what is wrong in this code the data is not iserted to table

Question

sudharshan9xweb 0 Newbie Poster

10 Years Ago

<?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 >

php

3 Contributors
4 Replies
109 Views
25 Minutes Discussion Span
Latest Post 10 Years Ago Latest Post by diafol

All 4 Replies

pritaeas 2,194 ¯\_(ツ)_/¯

10 Years Ago

Do:

mysql_query($query) or die(mysql_error());

and find out why.

Reply to this topic

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.

sudharshan9xweb 0 Newbie Poster · Answer 1 · 2014-01-22T07:59:35+00:00

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 · Answer 2 · 2014-01-22T08:04:08+00:00

sudharshan9xweb 0 Newbie Poster

10 Years Ago

ok got is thank you.

diafol · Answer 3 · 2014-01-22T08:06:58+00:00

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.

what is wrong in this code the data is not iserted to table

Recommended Answers Collapse Answers

All 4 Replies

Recommended Answers