Thank u for support. I had solved it. Thank u so much

how to insert date in table by using datepicker jquery?

my jquery code is as:

 <script language="JavaScript" type="text/javascript">
        $(function() {
            $( "#date" ).datepicker();
        });
    </script> 

in html

<tr colspan="2">
<td valign="top" align="left">
Date<font color="red">*</font></td>
<td valign="top" align="left">
<input type="text" id="date" name="date" value="" readonly="readonly" autocomplete="off" size="20">
</td></tr>

Thnaks, I also able to do this after i had post my code. and i also follow your sugessetion but still there is little bit of change. i want to show trailer in popup window as color box pop up. have u seen colorbox example? there is one link for direct link to youtube. and they will show that example in their own popup not in youtube site. likewise i also want to do like that. plz guide me

this is my template.php file and in dbconfig.php i have write database configration code.

<?php require_once 'dbconfig.php'; ?>
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html" charset="utf-8" />
        <link type="text/css" href="style.css" rel="stylesheet" />
        <link type="text/css" href="menu.css" rel="stylesheet" />
        <link type="text/css" href="menu_h.css" rel="stylesheet"/>
        <link type="text/css" href="jsCarousel-2.0.0.css" rel="stylesheet" />
        <link type="text/css" href="thumbnail_slider.css" rel="stylesheet" />
        <link rel="stylesheet" href="colorbox.css" />
        <script type="text/javascript" src="./jquery-ui/js/jquery-1.8.2.js"></script>
        <script type="text/javascript" src="menu.js"></script>
        <script type="text/javascript" src="jsCarousel-2.0.0.js"></script>
        <script type="text/javascript" src="jquery.validate.js"></script>
        <!-- menu script itself. you should not modify this file -->
        <script language="JavaScript" src="menu_h.js"></script>
        <!-- items structure. menu hierarchy and links are stored there -->
        <script language="JavaScript" src="menu_items.js"></script>
        <!-- files with geometry and styles structures -->
        <script language="JavaScript" src="menu_tpl.js"></script>
        <!--        for showing trailer-->
        <script src="colorbox/colorbox/jquery.colorbox.js"></script>
        <title>Online Cinema Ticket Booking</title>
    </head>
    <body>
        <table width="100%" cellpadding="0" cellspacing="0">
            <tr>
                <td width="10%" valign="top"></td>
                <td width="980" align="left" valign="top">
                    <table width="100%" cellpadding="0" cellspacing="0">
                        <tr><td align="left" valign="top" colspan="2"><?php require_once("header.php"); ?></td></tr>
                        <tr>
                            <?php 
                            if(stristr($_SERVER['SCRIPT_NAME'],'food.php')=="" && stristr($_SERVER['SCRIPT_NAME'],'book_ticket.php')=="" && stristr($_SERVER['SCRIPT_NAME'],'payment.php')=="" 
                                    && stristr($_SERVER['SCRIPT_NAME'],'contectus.php')=="") { ?>
                            <td align="left" valign="top" width="15%" style="padding-left: 10px;"><?php require_once("left_panel.php"); ?></td>
                            <?php } ?>
                            <td align="left" valign="top" style="height:400px;"><?php echo main(); ?></td> 
                        </tr>
                        <tr><td align="left" valign="bottom" colspan="2"><? require_once("footer.php"); ?></td></tr>
                    </table>
                </td>
                <td width="10%" valign="top"></td>
            </tr>
        </table>
    </body>
</html>

thanks. but i have store all the trailer's path in my db. movie wise i had stored trailer path in my db table. and in trailer.php page i showing movie image, casts n director name and there is one button which is redirect to trailer_redirect.php file. i think u had refer this very well. so plz guide me. how i can display popup window and how can i redirect to youtube while user click on particuler button under movie image. i have refer your demo n code. but i m not able to understand clearly that actually what should i do? guide me plz i have never done this type of work

I want to show movie trailer by click on movie button. i have done this by using colorbox. i had include .js and .css file in my template.php file. and i prepare following code for this. but i can't able to do this. plz anyone guide me. how can i show trailer in my website? i had store trailer path in my database for partcular movies.

My code is as:

trailer.php

<?
require_once("template.php");

function main() {
    ?>
    <table width="100%" cellpadding="0" cellspacing="0">
        <tr>
            <td>
                <?php
                $sql = "select * from movie";
                $result = mysql_query($sql);
                ?>
                <table>
                    <tr>
                        <?php
                        $i = 0;

                        while ($rows = mysql_fetch_array($result)) {

                            if ($i % 3 == 0) {
                                echo '</tr><tr>';
                            }
                            ?>
                            <td>
                                <table width="100%" cellpadding="0" cellspacing="0">
                                    <tr>
                                        <td valign="center">
                                            <img src="<?php echo "images/thumbnail/" . $rows['image']; ?>" height="130" width="100" border="0" /><br>
                                        </td>
                                        <td valin="" width="200" style="padding-left: 10px;">
                                            <font size="4">
                                            <?php
                                            echo "<b>Stars</b>" . '<br>' . "<font size='3'>" . $rows['actor'] . "</font>" . '<br>';
                                            echo "<font size='3'>" . $rows['actress'] . "</font>" . '<br><br>';
                                            echo "<b>Director</b>" . '<br>' . "<font size='3'>" . $rows['director'] . "</font>" . '<br>';
                                            ?>
                                            </font>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="left" valign="center">
                                            <a href="trailer_redirect.php?movie_id=<? echo $rows['movie_id']; ?> ">
        <!--                                                <img src="images/buy_tickets.jpg" width="79" height="18" alt="buy_tickets" border="0"/>-->
                                                <input type="submit" value="View Trailer" name="view_trailer" />
                                            </a>

                                        </td>
                                        <td>&nbsp;</td>
                                    </tr>
                                </table>
                            </td>
                            <?php
                            $i++;
//                            if(isset($_POST['view_trailer'])) {
//                              header("location: trailer_redirect.php");
//                                }
                        }
                        ?>
                    </tr>

                </table>
            </td>
        </tr>
    </table>
    <?
}
?>

trailer_redirect.php

<?php
require_once 'template.php';
//require_once 'dbconfig.php';
function main() {
//get value of id that sent from address bar ...

I have find this from net. this is work fine. but i want to just change this with as:
i want to give chance user to select the theatre from drop down list. then click on button and it have to show google map of that theatre. i have also write drop down box code here. plz refer this and guide me.

<?php
require_once("template.php");
function main() {
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>GSmapSearchControl Sample</title>
<!– Note:
Make sure to replace the &key=internal with &key=~the value of your key~
in both the maps API script load and in the Ajax Search API script load statements
–>
<!– maps api, ajax search api, map search control code –>
<script    src="http://maps.google.com/maps?file=api&v=2&
key=ABQIAAAAGvs30FUboNhX-BMsz1wHmhRueXhM_ZR0uaVb2boWRzq1eE2kghQvVdJiR71BuD29Jsee_kDbmydTOQ"
type="text/javascript">
</script>
<script   src="http://www.google.com/uds/api?file=uds.js&    v=1.0&key=ABQIAAAAGvs30FUboNhX-BMsz1wHmhRueXhM_ZR0uaVb2boWRzq1eE2kghQvVdJiR71BuD29Jsee_kDbmydTOQ"
type="text/javascript">
</script>
<script src="http://www.google.com/uds/solutions/mapsearch/gsmapsearch.js"
type="text/javascript">
</script>
<!– ajax search stylesheet, map search stylesheet –>
<link href="http://www.google.com/uds/css/gsearch.css" rel="stylesheet"    type="text/css"/>
<link href="http://www.google.com/uds/solutions/mapsearch/gsmapsearch.css" rel="stylesheet"/>
<style>
/*body, table, p{
background-color: white;
font-family: Arial, sans-serif;
font-size: 13px;
}*/
/*#mapsearch {
width : 400px;
margin-left: 10px;
padding: 4px;
border : 1px solid #f9f9f9;
}*/
</style>
<script>
function LoadMapSearch() {
var options = {
title : "Googleplex",
url : "http://www.google.com/corporate/index.html"
}
new GSmapSearchControl(
document.getElementById("mapsearch"),
"1600 Amphitheatre Parkway, Mountain View, CA",
options
);
}
GSearch.setOnLoadCallback(LoadMapSearch);
</script>
</head>
<body>
<div id="mapsearch">Loading…</div>
<?php $result = mysql_query("select * from theatre order by theatre_name"); ?>
<select name="mapsearch" id="mapsearch" style="width: 155px;">
    <option value="">--select--</option>
    <?php
    if (mysql_num_rows($result) > 0) {
        while ($theatre = mysql_fetch_assoc($result)) {
            echo '<option value="' . $theatre['theatre_name'] . '">' . $theatre['theatre_name'] . '</option>';
        }
    } ...

sory for late reply. and thanks for sugession. i have refer that link. i want to do something like that. but i want to disply theatre location as per user's choice.

i have save path of theatre in my database table. and like above procedure i want to show google map in new window or in popup window by clicking button

I want to show google map of selected theatre. first user have to select city then they have to choose theatre as per selected city. i have used drop down box for both. then, after selecting theatre, when he clicks on show button i want to show google map of that theatre.

plz help me i have tried my best but i cant be able to do this. so plz help me

my code of my add movie page is as:

<?php require_once '.../dbconfig.php/'; 
//require_once('calendar/calendar/classes/tc_calendar.php');
//echo hi;
if(isset($_POST['submit']))
{
$sql=mysql_query("INSERT INTO movie(`movie_name`,`movie_id`,`actor`,`actress`,`director`,`release_year`,`description`,`image`)
VALUES('$_POST[t1]','$_POST[t2]','$_POST[t3]','$_POST[t4]','$_POST[t5]','$_POST[t6]','$_POST[t7]','$_POST[t8]')");

echo $sql." Record added Successfully";
}

//for fetch date value
//$theDate = isset($_REQUEST["date1"]) ? $_REQUEST["date1"] : "";

?>
<html>

<form action="" method="post" name="admin_movie" id="movie" onSubmit="return validation();">

            <fieldset>
    <table width="100%" cellpadding="5" cellspacing="5" align="center">
        <tr>
            <th colspan="2" valign="top" align="left" style="padding-left:263px;"><span style="border-bottom:#000000 2px solid;"></span></th>
        </tr>
        <tr><td>Enter Movie Name</td><td><input type="text" name="t1" id="name" value="" size="20" /><br></td></tr>
        <tr><td>Enter Movie_Id</td><td><input type="text" name="t2" id="id" value="" size="20" /></td></tr>
        <tr><td>Enter Actor_Name</td><td><input type="text" name="t3" id="actor" value="" size="20" /></td></tr>
        <tr><td>Enter Actress_Name</td><td><input type="text" name="t4" id="actress" value="" size="20" /></td></tr>
        <tr><td>Enter Producer_Name</td><td><input type="text" name="t5" id="producer" value="" size="20" /></td></tr>
        <tr><td>Movie Releasing Date</td><td>
                <input type="text" name="t6" id="date" value="" size="20" title="Plz enter date in yyyy-mm-dd formate"/>
                </td></tr>
        <tr><td>Description About Movie</td><td><textarea name="t7" cols="20" rows="5" id="description"></textarea></td></tr>
        <tr><td>Select Movie Image</td><td><input type="file" name="t8" value="" width="100" height="500" id="image" /></td></tr>
       <!-- <tr><td>Select Movie Image</td><td><img src="" width="150" height="100"/>-->

        <tr></tr>
        <tr><td>  <center><input type="submit" value="Submit" name="submit" /></center></td></tr>
   </table>
            </fieldset>
    </form>

</html>

My code for view_details page is as: at here i want to view the images when i run this page. my code is as:

<?php
require_once '../dbconfig.php';
$sql="SELECT * FROM movie";
$result=mysql_query($sql);
?>
<?php if (mysql_num_rows($result)==0) { ?>     Database is empty <br/> <?php } else { ?> 
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td colspan="8"><strong>List data from mysql </strong> </td>
</tr>

<tr>
<td align="left"><strong><font face="Arial, Helvetica, sans-serif">Movie_Name</strong></font></td>
<td align="left"><strong><font face="Arial, Helvetica, sans-serif">Movie_Id</strong></font></td>
<td align="left"><strong><font face="Arial, Helvetica, sans-serif">Actor</strong></font></td>
<td align="left"><strong><font face="Arial, Helvetica, sans-serif">Actress</strong></font></td>
<td align="left"><strong><font face="Arial, Helvetica, sans-serif">Director</strong></font></td>
<td ...

I have one table as movie. In that i have one field as 'image' in which i want to store the images. In my mca project, I m trying to make admin panel. For this when administrater is going to add movie details, at that time i want to store the image of movies then how can i do this? and i also want to disply that images in other pages. for example: when administrator want to view data of movie table then at that time that movie image shold also be displayed.

Plz help me. as soon as possible.

Thanks in advance.. plz help me

Thank u so much. And can u plz guide me how related combo boxes can work? I want to do as:
I am going to design quick booking page in php. in that I want to do that user will select city name from my 1st combo box. city name comes from my location table then another combo box should find the theatre_name from table where city_name= selected city. and fetched data should be displayed in that combo box. Like wise same procedure should be follow for movie_name, show_time etc.

location table contains fields like theatre_id, theatre_name, owner_name,address, city, email_id etc

movie tbale contains movie_id, movie_name, release_date, actors, acress, director etc.

theatre table contains theatre_id,theatre_name, no_of_screen

So plz help me in this.
Thanks to u a lot in advance

I have one table named as movie. which contains fields like movie_id, movie_name etc.
I want that movie_id in my drop down list. so i have to retrive that data from movie table. I tried my best but i dont get success in this. plz help me to retrive data in my drop down list from movie table.

I have 2 table: 1 name is movie and another's name is screen. movie table contains fields like movie_id,movie_name etc. screen table contains fields like movie_id screen_id etc. I am going to add data in my screen table by user.

So i want that if user enter the movie_id which is not in movie table then it should prompt the user and display msg as plz enter correct movie_id. my code is as: plz verify this and answer me as soon as possible. plz

<?php require_once '.../dbconfig.php/'; 
//echo hi;
if(isset($_POST['submit']))
{
$sql=mysql_query("INSERT INTO screen(`movie_id`,`screen_id`,`theatre_id`,`capacity`)
VALUES('$_POST[t1]','$_POST[t2]','$_POST[t3]','$_POST[t4]')");

echo $sql." Record added Successfully";
}

?>
<html>
    <form action="" method="post" name="add_screen" id="movie" onSubmit="return validation();">
        <div>
            <fieldset>
    <table width="100%" cellpadding="5" cellspacing="5" align="center">
        <tr>
            <th colspan="2" valign="top" align="left" style="padding-left:263px;"><span style="border-bottom:#000000 2px solid;"></span></th>
        </tr>
        <tr><td>Enter Movie_Id</td><td><input type="text" name="t1" value="" size="20" /><br></td></tr>
        <tr><td>Enter Screen_Id</td><td><input type="text" name="t2" value="" size="20" /></td></tr>
        <tr><td>Enter Theatre_Id</td><td><input type="text" name="t3" value="" size="20" /></td></tr>
        <tr><td>Enter capacity of Theatre</td><td><input type="text" name="t4" value="" size="20" /></td></tr>
        <tr><td>  <center><input type="submit" value="Submit" name="submit" /></center></td></tr>
   </table>
            </fieldset>
    </form>
</html>

how to get the data dynamically in drop down list? I want to use the drop down list in my html form's code but i wnat to fatch the data from my table. Plz help me

Thank u so much

Plz help me. I want to insert data in table which is filled by user. But i want to keep that insert query code in same file where i have created my html form. I want not to make insert.php individually.

In this way i want to insert data in my table. so plz help me as sson as possible

I want to connect the mysql database in netbeans IDE 7.0 but I dont know how to do this. plz plz provide me any idea about this as soon as possible.