2
Answers

Database is not connecting and i am getting errors

Photo of naveena pagadal

naveena pagadal
7y
809
1
studentdb.html

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style>
body{background-color:PaleGoldenRod;}
table{border-collapse: collapse; }
header, footer {
padding: 1em;
color: white;
background-color: black;
text-align: center;
}
</style>
</head>
<body>
<form action="ostudentdb.php" method="POST">
<header>
<h3 align="center">STUDENT APPLICATION FORM</h3>
</header>
<table align="center" cellpadding="10">
<tr>
<td>FIRST NAME</td>
<td><input type="text" name="FName" id="fname" required="Enter First Name" >
(max 10 characters)
</td>
</tr>
<tr>
<td>LAST NAME</td>
<td><input type="text" name="LName" id="lname" required="Enter Last Name">
(max 10 characters)
</td>
</tr>
<tr>
<td>GENDER </td>
<td><input type="radio" name="Gender" value="female" id="female" required>FEMALE
<input type="radio" name="Gender" value="male" id="male"required>MALE
</td>
</tr>
<tr>
<td>DATE OF BIRTH</td>
<td><input type="text" name="DOB" id="dob" required>
(In mm/dd/yyyy)
</td>
</tr>
<tr>
<td>EMAIL ID</td>
<td><input type="email" name="Email" required ></td>
</tr>
<tr>
<td>MOBILE NUMBER</td>
<td>
<input type="text" name="contact_no" id="contact_no" required>(10 digit number)
</td>
</tr>
<tr>
<td> SSLC PERCENTAGE</td>
<td>
<input type="text" name="SSLC" id="10th" required>(In %)
</td>
</tr>
<tr>
<td> 10th PASSED YEAR</td>
<td>
<input type="text" name="SSLCP" id="10p"required >
</td>
</tr>
<tr>
<tr>
<td>PUC II PERCENTAGE</td>
<td>
<input type="text" name="PUC" id="12th" required>(In %)
</td>
</tr>
<tr>
<td> 12th PASSED YEAR</td>
<td>
<input type="text" name="PUCP" id="12p"required >
</td>
</tr>
<tr>
<td>COURSE APPLIED FOR</td>
<td><select name="Course" value="Course" id="Course" required>
<option value="-1" selected>choose your course</option>
<option value="BCA">BCA</option>
<option value="BTECH">BTECH</option>
<option value="BSC">BSC</style>
<option value="BCOM">BCOM</option>
<option value="BBM">BBM</option>
<option value="BA">BA</option>
</td>
</tr>
<tr>
<td>APPLIED FOR SCHOLORSHIP </td>
<td><input type="radio" name="Scholorship" value="yes" id="Scholorship">YES
<input type="radio" name="Scholorship" value="no" id="Scholorship">NO
</td>
</tr>
<tr>
<td>ADDRESS <br ><br ><br ></td>
<td><textarea name="Address" rows="4" cols="30" id="address" required></textarea></td>
</tr>
<tr>
<td>CITY</td>
<td><input type="text" name="City" id="city"required>
</td>
</tr>
<tr>
<td>PIN CODE</td>
<td><input type="text" name="Code" id="pin">
</td>
</tr>
<tr>
<td>STATE</style></td>
<td><select name="State" value="State" id="state"required>
<option value="-1" selected>select state</option>
<option value="Andra Pradesh">Andra Pradesh</option>
<option value="Arunachal Pradesh">Arunachal Pradesh</style>
<option value="Assam">Assam</option>
<option value="Bihar">Bihar</option>
<option value="Chhattisgarh">Chhattisgarh</option>
<option value="Goa">Goa</option>
<option value="Gujarat">Gujarat</option>
<option value="Haryana">Haryana</option>
<option value="Himachal Pradesh">Himachal Pradesh</option>
<option value="Jammu and Kashmir">Jammu and Kashmir</option>
<option value="Jharkhand">Jharkhand</option>
<option value="Karnataka">Karnataka</option>
<option value="Kerala">Kerala</option>
<option value="Madya Pradesh">Madya Pradesh</option>
<option value="Maharashtra">Maharashtra</option>
<option value="Manipur">Manipur</option>
<option value="Meghalaya">Meghalaya</option>
<option value="Mizoram">Mizoram</option>
<option value="Nagaland">Nagaland</option>
<option value="Orissa ">Orissa</option>
<option value="Punjab">Punjab</option>
<option value="Rajasthan">Rajasthan</option>
<option value="Sikkim">Sikkim</option>
<option value="Tamil Nadu">Tamil Nadu</option>
<option value="Tripura">Tripura</option>
<option value="Uttaranchal">Uttaranchal</option>
<option value="Uttar Pradesh">Uttar Pradesh</option>
<option value="West Bengal">West Bengal</option>
</td>
</tr>
<tr>
<td>COUNTRY</td>
<td><input type="text" name="Country" id="country" required></td>
</tr>
<br><br>
<tr><td>
<input type="submit" value="Submit" >
<input type="reset" value="Reset">
</td>
</tr>
</table>
<footer>Copyright &copy; NAVEENA</footer>
</form>
</body>
</html>

studentdb.php

<?php
ini_set('display_errors',1);

$FName=$_POST['FName'];
$LName=$_POST['LName'];
$Gender=$_POST['Gender'];
$DOB=$_POST['DOB'];
$Email=$_POST['Email'];
$contact_no=$_POST['contact_no'];
$SSLC=$_POST['SSLC'];
$SSLCP=$_POST['SSLCP'];
$PUC=$_POST['PUC'];
$PUCP=$_POST['PUCP'];
$Course=$_POST['Course'];
$Scholorship=$_POST['Scholorship'];
$Address=$_POST['Address'];
$City=$_POST['City'];
$Code=$_POST['Code'];
$State=$_POST['State'];
$Country=$_POST['Country'];

echo $_POST["FName"];
echo '<br />';
echo $_POST["LName"];
echo '<br />';
echo $_POST["Gender"];
echo '<br />';
echo $_POST["DOB"];
echo '<br />';
echo $_POST["Email"];
echo '<br />';
echo $_POST["contact_no"];
echo '<br />';
echo $_POST["SSLC"];
echo '<br />';
echo $_POST["SSLCP"];
echo '<br />';
echo $_POST["PUC"];
echo '<br />';
echo $_POST["PUCP"];
echo '<br />';
echo $_POST["Course"];
echo '<br />';
echo $_POST["Scholorship"];
echo '<br />';
echo $_POST["Address"];
echo '<br />';
echo $_POST["City"];
echo '<br />';
echo $_POST["Code"];
echo '<br />';
echo $_POST["State"];
echo '<br />';
echo $_POST["Country"];
echo '<br />';?>

mainpage.html

<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style>
body{background-color:PaleGoldenRod;}
table{border-collapse: collapse; }
header, footer {
padding: 1em;
color: white;
background-color: black;
text-align: center;
}
</style></head>
<body>
To Insert New Details<a href="ostudentdb.html">INSERT</a><br>
To Display Details<a href="selection.php">DISPLAY</a><br>

</body>
</html>

connectionEx.php

<?php
$conn_string= "host=localhost port=5432 dbname=naveenadb user=naveena password=P@ssw0rd";
$dbconn = pg_connect($conn_string);

class connectionEx extends conne
{


public $FName;
public $LName;
public $Gender;
public $DOB;
public $Email;
public $contact_no;
public $SSLC;
public $SSLCP;
public $PUC;
public $PUCP;
public $Course;
public $Scholorship;
public $Address;
public $City;
public $Code;
public $State;
public $Country;

$connectionEx->creation();
$connectionEx->insertion($FName,$LName,$Gender,$DOB,$Email,$contact_no,$SSLC,$SSLCP,$PUC,$PUCP,$Course,$Scholorship,$Address,$City,$Code,$State,$Country);
$connectionEx->selection($result);

}
?>

selection.php

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Display</title>
<meta name="description" content="To select">
<head>
<style>
body{background-color:LightGray;
text-align: center;}
</style>
</head>
<body>
<?php
$conn_string= "host=localhost port=5432 dbname=naveenadb user=naveena password=P@ssw0rd";
$dbconn = pg_connect($conn_string);
include('connectionEx.php');
function selection($result)
{
return $this->$result;
}
?>
</body>
</html>

this is a small application im tryin to do.i have created a database using postgresql. the database is not connecting. and if i select on the SELECT in the mainpage.html,the selection process is not getting,im getting errors.Please resolve the problem for me.

Answers (2)