php my sql

[theaf]

<form method="POST"action="insertdata.php">
Name:<input type="text" name="name">
age:<input type="text" name="age">
<button name="submit" type="submit">submit</button>
</form>


php page එක

<?php
if(isset($_POST['submit'])){
$name=$_POST['name'];
$age=$_POST['age'];

$con=mysql_connect("localhost","root","");
mysql_select_db("test2",$con);

mysql_query("INSERT INTO
student(name,age)
VALUES('$name','$age')") or die(mysql_error());
echo "hi";

}else{
echo "pala";
}

මචන්ලා මේකේ database එකේ blank record වදින එක නවත්තන්නේ කොහොමද

 

[theaf]

..

 

[kosandpol]

<?php
if(isset($_POST['submit'])){
$name=$_POST['name'];
$age=$_POST['age'];

if ((strlen($name) >0) && strlen($age>0))
{
$con=mysql_connect("localhost","root","");
mysql_select_db("test2",$con);

mysql_query("INSERT INTO 
student(name,age)
VALUES('$name','$age')") or die(mysql_error());
echo "hi";
}
else
{
echo "blank values";
}

}else{
echo "pala";
}

ඕක හරිද බලන්න..

 

[DjSpK]

code eke me line eke podi varaddak thiyenava

mysql_query("INSERT INTO student(name,age)VALUES('$name','$age')") or die(mysql_error());

mysql_query($con,"INSERT INTO student(name,age)VALUES('$name','$age')") or die(mysql_error());

 

[Ayeshlive]

<?php
if(isset($_POST['submit'])
  && !empty($_POST['name'])
  && !empty($_POST['age']) 
  ){
  $name =& $_POST['name'];
  $age =& $_POST['age'];

  $con =  mysql_connect("localhost","root","");
  mysql_select_db("test2",$con);

  mysql_query("INSERT INTO
    student(name,age)
    VALUES('$name','$age')") or die(mysql_error());
  echo "hi";
  } else {
    echo "pala";
  }
  ?>

BTW, your coding is horrible bro. You should use PDO or at least mysqli_* with some mysql escaping. You'll never get selected if you show this in an interview.

 

[theaf]

<?php
if(isset($_POST['submit'])){
$name=$_POST['name'];
$age=$_POST['age'];

if ((strlen($name) >0) && strlen($age>0))
{
$con=mysql_connect("localhost","root","");
mysql_select_db("test2",$con);

mysql_query("INSERT INTO 
student(name,age)
VALUES('$name','$age')") or die(mysql_error());
echo "hi";
}
else
{
echo "blank values";
}

}else{
echo "pala";
}

ඕක හරිද බලන්න..

nane ethakota dekatama enne blank value kiyalane

 

[theaf]

<?php
if(isset($_POST['submit'])
  && !empty($_POST['name'])
  && !empty($_POST['age']) 
  ){
  $name =& $_POST['name'];
  $age =& $_POST['age'];

  $con =  mysql_connect("localhost","root","");
  mysql_select_db("test2",$con);

  mysql_query("INSERT INTO
    student(name,age)
    VALUES('$name','$age')") or die(mysql_error());
  echo "hi";
  } else {
    echo "pala";
  }
  ?>

BTW, your coding is horrible bro. You should use PDO or at least mysqli_* with some mysql escaping. You'll never get selected if you show this in an interview.

ahh vade harii thankx