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

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

Create an abstract class “order” having members id,description.Create two subclasses “Purchase Order” and “Sales Order” having members customer name and Vendor name respectively.Define methods accept and display in all cases. Create 3 objects each of Purchase Order and Sales Order and accept and display details.

  import java . io .*; abstract class Order {       String description ;       int id ; } class PurchaseOrder extends Order {       String customername , vendorname ;             public void accept () throws IOException      {             System . out . println ( "Enter description, customername and vendorname,id :" );             BufferedReader br = new BufferedReader ( new InputStreamReader ( System . in ));                         description = br . readLine ();             customername = br . readLine ();             vendorname = br . readLine ();             id = br . read ();      }             public void display () ...
Post a Comment
Read more