- Strength to Increase Rep
- +2
- Strength to Decrease Rep
- -0
- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 2
- Posts with Downvotes
- 1
- Downvoting Members
- 2
When user clicks on the calendar image, date can be chosen. If the text field changes, the date will be compared with $today with Javascript. If the date is earlier than today, a mesage will be shown. I did these codes and the message could not be shown when I … |
|
roomID is used to list all record of some room ID, all the record is associated with roomBookingID. When a user clicked "modify", a form is supposed to show. However, a error message shown after I added the red statement. <?php require_once('../../config/conn.php'); $roomID=$_GET['roomID']; $sql="SELECT * FROM roomBooking where roomID = … |
|
It is supposed to list out all records of roomID 57, but the record is duplicate. <?php require '../../source/authentication.inc'; session_start(); sessionAuthenticate(); require_once('../../config/conn.php'); ?> <?php require_once('../../config/conn.php'); $roomID=$_GET['roomID']; $sql="SELECT * FROM roomBooking where roomID = '$roomID'"; $rs=mysql_query($sql,$conn); $row_rs = mysql_fetch_assoc($rs); $count=mysql_num_rows($rs); $roomID=$row_rs['roomID']; $bookingDate=$row_rs['bookingDate']; $startTime=$row_rs['startTime']; $endTime=$row_rs['endTime']; $numberOfPeople=$row_rs['numberOfPeople']; ?> <!DOCTYPE HTML> <html> <head> <meta … |
|
table roomBooking: roomBookingID roomID bookingDate startTime endTime glID numberOfPeople staffID table room: `roomID typeOfRoom roomState` php code: <?php require_once('../config/conn.php'); $sql="SELECT * FROM roomBooking, room WHERE roomState='empty'"; $rs=mysql_query($sql,$conn); $row_rs = mysql_fetch_assoc($rs); $count=mysql_num_rows($rs); ?> ... <table border="0"> <?php do { ?> <tr> <td> <?php echo $row_rs['roomID']; ?> </td> <td> <?php printf('<a href="action/roomDetail.php?roomID=%s">詳情</a>',$row_rs['roomID']); … |
|
What is the code for informing user that the data is updated or removed??? |
|
It is supposed to show up details of a room selected, but the first record in database is always displayed. The link is incorrect too.. http://test/action/roomDetail.php?roomID= The value is missed... ROOM: <table border="0"> <tr> <td> <p> <label for="room">選擇房間</label> <select name="roomID"> <?php do { printf('<option value="%s">%s</option>', $row_rsRoom['roomID'], $row_rsRoom['roomID']); } while ($row_rsRoom … |
|
[CODE]<? session_start(); if(!session_is_registered(myusername)){ header("location:../index.php"); } ?> <?php require_once('../config/conn.php'); $sql="SELECT * FROM roomBooking ORDER BY roomID ASC"; $rs=mysql_query($sql,$conn); $row_rs = mysql_fetch_assoc($rs); $count=mysql_num_rows($rs); ?><!DOCTYPE HTML> <html> <head> <meta charset="utf-8"> <title>組長控制中心</title> <link href="../css/master.css" rel="stylesheet" type="text/css" media="screen"> </head> <body> <header> <h1>組長控制中心</h1> </header> <nav> <ul> <li><a href="g_home.php">主頁</a></li> <li class="selected"><a href="BookingManagement.php">房間資源</a></li> </ul> </nav> <div id="content"> <div … |
|
I tried to use SQL command to rename activity to Activity, but it did not work. |
|
My codes work in localhost but this error happens when I upload to a web site. [code]<?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_conn = "mysql4.000webhost.com"; $database_conn = "a3027257_ccbc"; $username_conn = "a3027257_ccbc"; $password_conn = "a123456"; $conn = mysql_pconnect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(),E_USER_ERROR); mysql_select_db($database_conn, $conn) or die("cannot select Database"); mysql_query("SET NAMES … |