Skip to main content

Checking data base connection or updating the status

 HTML CODE:


<html>
<body>
<form method="GET" action="d2.php">
Enter Title of Event : <input type="text" name="title"> <br>
<input type="submit" value="Submit">

</form>
</body>
</html>


PHP CODE:

<?php
$cname=$_GET['title'];
$con=pg_connect("host= dbname= user= password=");
if($con)
{
    echo "Able to open database\n";
}
else
{
    echo "Unable to open database \n";
}
$sql=<<<EOF
select * from eventt,committee1;
UPDATE committee1 set status='Working' where cno=(select cno from eventt,
ec where title='$cname' and eventt.eno=ec.eno);
EOF;
$ret=pg_query($con,$sql);
if(!$ret)
{
    echo pg_last_error($con);
    exit;
}
else
{
    echo "<br>Status updated successfully \n";
}
pg_close($con);
?>

Comments

Post a Comment

Popular posts from this blog

Write a program to read book information (bookid, bookname, bookprice, bookqty) in file “book.dat”. Write a menu driven program to perform the following operations using Random access file: i. Search for a specific book by name. ii. Display all book and total cost

  import java . io .*; import java . util .*; class Book {       String name , id ;       int qty ;       double price , total ;       Book ( String i , String n , String p , String q )      {               name = n ;               id = i ;               qty = Integer . parseInt ( q );               price = Double . parseDouble ( p );               total = qty * price ;      }       public String toString ()      {               System . out . println ( "name\t id\t qty\t price\t total" );               String s = name + "\t" + id + "\t" + qty + "\t" + price + "\t" + total ;           ...
Post a Comment
Read more

Define a class MyDate (day, month, year) with methods to accept and display a MyDate object. Accept date as dd, mm, yyyy. Throw user defined exception “InvalidDateException” if the date is invalid. Examples of invalid dates : 03 15 2019, 31 6 2000, 29 2 2021

  import java . io .*; import java . util .*; class InvalidDateException extends Exception {       InvalidDateException ()       {               System . out . println ( "Invalid Date" );       } } class MyDate {       int day , mon , yr ;       void accept ( int d , int m , int y )       {             day = d ;             mon = m ;             yr = y ;       }       void display ()       {             System . out . println ( "Date is valid : " + day + "/" + mon + "/" + yr );       } } class Date {       public static void main ( String args []) throws Exception       {             Scanner sc = new Sca...
Post a Comment
Read more

Write a Java program to design a screen using Awt that will take a user name and password. If the user name and password are not same, raise an Exception with appropriate message. User can have 3 login chances only. Use clear button to clear the TextFields.

  import java . awt .*; import java . awt . event .*; import javax . swing .*; class InvalidPasswordException extends Exception {       InvalidPasswordException ()       {             System . out . println ( "Username and password is not same" );       } } public class Password extends Frame implements ActionListener {       Label uname , upass ;       TextField nametext ;       TextField passtext , msg ;       Button login , Clear ;       Panel p ;       int attempt = 0 ;       char c = '*' ;             public void login ()       {             p = new Panel ();             uname = new Label ( "Username : " , Label . CENTER );             upass = n...
Post a Comment
Read more