date comparison in php

Question

priyadharsinism 0 Newbie Poster

12 Years Ago

Im doing a project based on students information. Im looking for the code to add the student details to alumini form when their period of course is completed(based on their date of completion). The below code is registeration of student information.

<?php
	
	$link = mysql_connect('localhost','root','');
	if(!$link) {
		die('Failed to connect to server: ' . mysql_error());
	}
	
	$db = mysql_select_db(priya);
	if(!$db) {
		die("Unable to select database");
	}
	
	

	$sql = "INSERT INTO trade(id,name,tokenno,trade,dateofjoin,dateofcompletion,duration)VALUES('$_POST[id]','$_POST[name]','$_POST[token]','$_POST[trade]','$_POST[doj]','$_POST[doc]','$_POST[duration]')";
	
	
	if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($link)
?>

php

3 Contributors
3 Replies
180 Views
1 Week Discussion Span
Latest Post 12 Years Ago Latest Post by priyadharsinism

gopi17 8 Junior Poster in Training

12 Years Ago

i don't quite get what you want....could please be more specific...thanks..

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.

shaiang 0 Newbie Poster · Answer 1 · 2012-03-08T14:20:29+00:00

Im doing a project based on students information. Im looking for the code to add the student details to alumini form when their period of course is completed(based on their date of completion). The below code is registeration of student information.

<?php
	
	$link = mysql_connect('localhost','root','');
	if(!$link) {
		die('Failed to connect to server: ' . mysql_error());
	}
	
        // You missing qoutes around the db name.
        // Should be: $db = mysql_select_db("priya");
	$db = mysql_select_db(priya);
	if(!$db) {
		die("Unable to select database");
	}
	
	

	$sql = "INSERT INTO trade(id,name,tokenno,trade,dateofjoin,dateofcompletion,duration)VALUES('$_POST[id]','$_POST[name]','$_POST[token]','$_POST[trade]','$_POST[doj]','$_POST[doc]','$_POST[duration]')";
	
	
	if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($link)
?>

Notice, you missing qoutes around your db name.
$db = mysql_select_db(priya);
Should be: $db = mysql_select_db("priya");

priyadharsinism 0 Newbie Poster · Answer 2 · 2012-03-19T22:47:23+00:00

// Registerationform.php

<?php

    $link = mysql_connect('localhost','root','');
    if(!$link) {
        die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(priya);
    if(!$db) {
        die("Unable to select database");
    }

    $sql = "INSERT INTO trade(tokenno,contractno,name,trade,doj,doc,batch)VALUES('$_POST[tokenno]','$_POST[contractno]','$_POST[name]','$_POST[trade]','$_POST[doj]','$_POST[doc]','$_POST[batch]')"; // doj refers to date of join and doc to date of completion


    if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($link)
?>

//Aluminiform.html(This form should retrive the details automatically from the above form when the date of completion equals to the current date)

<html></head><body bgcolor="skyblue">
<br><center><font face="Times New Roman" size="4" color="">ALUMINI DETAILS</font></center><br><form id="aluminiform" name="alumini" method="post" action="alumini.php"> <table width="539" border="0" align="center" cellpadding="2" cellspacing="5">
<tr>      <th>&nbsp;</th>      <td>&nbsp;</td>      <td>&nbsp;</td>    </tr><tr>      <td>Id </td>      <td><input name="id" type="text" class="textfield" id="id" maxlength="30" /></td>      <td rowspan="6"></td>    </tr> <tr>      <td>Name </td>      <td><input name="name" type="text" class="textfield" id="name" maxlength="30" /></td>      <td rowspan="6"></td>    </tr>    <tr>      <td>Token_no </td>      <td><input name="token" type="text" class="textfield" id="token" maxlength="30" /></td>      <td rowspan="6"></td>    </tr>
 <tr>
      <td>Trade </td><br>
<td><select name="trade">
  <option value="fitter">fitter</option>
  <option value="carpenter">carpenter</option>
  <option value="painter">painter</option>
  <option value="machinist">machinist</option>
</select></td>

<br>
    </tr>
<tr>      <td>Batch </td>      <td><input name="batch" type="text" class="textfield" id="batch" maxlength="30" /></td>      <td rowspan="6"></td>    </tr>
    <tr>      <th>&nbsp;</th>      <td>&nbsp;</td>      <td>&nbsp;</td>    </tr>    <tr>      <th height="24">        <div align="right">          <input type="submit" name="Submit" value="Register" id="but"/>        </div></th>      <td><div align="center">        <input type="reset" name="Submit2" value="Reset" id="but"/>      </div></td>
<td><div align="center">
        <p><a href="regform1.html">Home</a></p>
         </div></td>
<td><div align="center">
        <p><a href="hostelform6.html">Back</a></p>
         </div></td><td><div align="center">
        <p><a href="aluminisearchform.html">search</a></p>
         </div></td>    </tr>  </table></form>  </body></html>