php page take time to load!!!

Question

WaleedaaN 0 Newbie Poster

14 Years Ago

hi ,,,

i have create php page code for show booking online

and for free seat is come green color if paid red color and... blah blah

is working fine but can you fix it to be better and fast browseing page

this PHP file and MySql

ticket.php

tickets.txt

waiting Answer thanks

php

ticket.php (562.93 KB)

The attachment preview is chopped off after the first 10 KB. Please download the entire file.

<?php
include("mysql.php");
if (!$do) {
///echo "<meta http-equiv=\"refresh\" content=\"10;URL=ticket.php\">";

echo "<center>

<table border='0' width='500' dir='rtl' cellpadding='0' style='border-collapse: collapse' height='29'>
	<tr>
		<td align='center' width='139' bgcolor='#00FF00'><b>
		<font face='Tahoma' size='2'>
		 </font></b></td>
		<td align='center' width='141' bgcolor='#FF0000'><b>
		<font face='Tahoma' size='2'>
		</font></b></td>
		<td align='center' bgcolor='#990000' width='115'><b>
		<font face='Tahoma' color='#FFFFFF' size='2'> </font></b></td>
		<td align='center' bgcolor='#0000FF'><b><font face='Tahoma' size='2'>
		<font color='#FFFFFF'><span lang='en-us'> </span></font> </font>
		</b></td>
	</tr>
</table><hr size='2'><img border='0' src='images/show.png' width='712' height='171'>";
echo "
<form name='form' method='POST' action='' >";
$result = mysql_query("SELECT * FROM tickets");
$count=mysql_num_rows($result);

while($row = mysql_fetch_array($result))
  {
  
  $id[] = $row['id']; /// this id for multi update or delete
  $seat_number = $row['seat_number'];
  $status = $row['status'];
  $checkid = $row['id']; 
/////// line a free ////////
if ($seat_number == "A-1" && $status == "free")  {  $seatnumbera1 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-2" && $status == "free")  {  $seatnumbera2 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-3" && $status == "free")  {  $seatnumbera3 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-4" && $status == "free")  {  $seatnumbera4 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-5" && $status == "free")  {  $seatnumbera5 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-6" && $status == "free")  {  $seatnumbera6 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-7" && $status == "free")  {  $seatnumbera7 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-8" && $status == "free")  {  $seatnumbera8 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-9" && $status == "free")  {  $seatnumbera9 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-10" && $status == "free")  {  $seatnumbera10 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-11" && $status == "free")  {  $seatnumbera11 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-12" && $status == "free")  {  $seatnumbera12 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-13" && $status == "free")  {  $seatnumbera13 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-14" && $status == "free")  {  $seatnumbera14 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-15" && $status == "free")  {  $seatnumbera15 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-16" && $status == "free")  {  $seatnumbera16 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-17" && $status == "free")  {  $seatnumbera17 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-18" && $status == "free")  {  $seatnumbera18 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-19" && $status == "free")  {  $seatnumbera19 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-20" && $status == "free")  {  $seatnumbera20 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-21" && $status == "free")  {  $seatnumbera21 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-22" && $status == "free")  {  $seatnumbera22 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-23" && $status == "free")  {  $seatnumbera23 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-24" && $status == "free")  {  $seatnumbera24 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-25" && $status == "free")  {  $seatnumbera25 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-26" && $status == "free")  {  $seatnumbera26 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-27" && $status == "free")  {  $seatnumbera27 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-28" && $status == "free")  {  $seatnumbera28 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-29" && $status == "free")  {  $seatnumbera29 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-30" && $status == "free")  {  $seatnumbera30 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-31" && $status == "free")  {  $seatnumbera31 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-32" && $status == "free")  {  $seatnumbera32 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-33" && $status == "free")  {  $seatnumbera33 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-34" && $status == "free")  {  $seatnumbera34 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-35" && $status == "free")  {  $seatnumbera35 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-36" && $status == "free")  {  $seatnumbera36 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-37" && $status == "free")  {  $seatnumbera37 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-38" && $status == "free")  {  $seatnumbera38 = "bgcolor='#00FF00'";  }  
if ($seat_number == "A-39" && $status == "free")  {  $seatnumbera39 = "bgcolor='#00FF00'"; }  
if ($seat_number == "A-40" && $status == "free")  {  $seatnumbera40 = "bgcolor='#00FF00'";  }  
/////// line a paid ////////
if ($seat_number == "A-1" && $status == "paid")  {  $seatnumbera1 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-2" && $status == "paid")  {  $seatnumbera2 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-3" && $status == "paid")  {  $seatnumbera3 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-4" && $status == "paid")  {  $seatnumbera4 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-5" && $status == "paid")  {  $seatnumbera5 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-6" && $status == "paid")  {  $seatnumbera6 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-7" && $status == "paid")  {  $seatnumbera7 = "bgcolor='#ff0000'"; }  
if ($seat_number == "A-8" && $status == "paid")  {  $seatnumbera8 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-9" && $status == "paid")  {  $seatnumbera9 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-10" && $status == "paid")  {  $seatnumbera10 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-11" && $status == "paid")  {  $seatnumbera11 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-12" && $status == "paid")  {  $seatnumbera12 = "bgcolor='#ff0000'"; }  
if ($seat_number == "A-13" && $status == "paid")  {  $seatnumbera13 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-14" && $status == "paid")  {  $seatnumbera14 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-15" && $status == "paid")  {  $seatnumbera15 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-16" && $status == "paid")  {  $seatnumbera16 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-17" && $status == "paid")  {  $seatnumbera17 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-18" && $status == "paid")  {  $seatnumbera18 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-19" && $status == "paid")  {  $seatnumbera19 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-20" && $status == "paid")  {  $seatnumbera20 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-21" && $status == "paid")  {  $seatnumbera21 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-22" && $status == "paid")  {  $seatnumbera22 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-23" && $status == "paid")  {  $seatnumbera23 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-24" && $status == "paid")  {  $seatnumbera24 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-25" && $status == "paid")  {  $seatnumbera25 = "bgcolor='#ff0000'"; }  
if ($seat_number == "A-26" && $status == "paid")  {  $seatnumbera26 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-27" && $status == "paid")  {  $seatnumbera27 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-28" && $status == "paid")  {  $seatnumbera28 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-29" && $status == "paid")  {  $seatnumbera29 = "bgcolor='#ff0000'"; }  
if ($seat_number == "A-30" && $status == "paid")  {  $seatnumbera30 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-31" && $status == "paid")  {  $seatnumbera31 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-32" && $status == "paid")  {  $seatnumbera32 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-33" && $status == "paid")  {  $seatnumbera33 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-34" && $status == "paid")  {  $seatnumbera34 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-35" && $status == "paid")  {  $seatnumbera35 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-36" && $status == "paid")  {  $seatnumbera36 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-37" && $status == "paid")  {  $seatnumbera37 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-38" && $status == "paid")  {  $seatnumbera38 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-39" && $status == "paid")  {  $seatnumbera39 = "bgcolor='#ff0000'";  }  
if ($seat_number == "A-40" && $status == "paid")  {  $seatnumbera40 = "bgcolor='#ff0000'";  }  
/////// line a block ////////
if ($seat_number == "A-1" && $status == "block")  {  $seatnumbera1 = "bgcolor='#990000'";  }  
if ($seat_number == "A-2" && $status == "block")  {  $seatnumbera2 = "bgcolor='#990000'";  }  
if ($seat_number == "A-3" && $status == "block")  {  $seatnumbera3 = "bgcolor='#990000'"; }
if ($seat_number == "A-4" && $status == "block")  {  $seatnumbera4 = "bgcolor='#990000'"; }
if ($seat_number == "A-5" && $status == "block")  {  $seatnumbera5 = "bgcolor='#990000'";  }
if ($seat_number == "A-6" && $status == "block")  {  $seatnumbera6 = "bgcolor='#990000'";  }
if ($seat_number == "A-7" && $status == "block")  {  $seatnumbera7 = "bgcolor='#990000'"; }
if ($seat_number == "A-8" && $status == "block")  {  $seatnumbera8 = "bgcolor='#990000'";  }
if ($seat_number == "A-9" && $status == "block")  {  $seatnumbera9 = "bgcolor='#990000'"; }
if ($seat_number == "A-10" && $status == "block")  {  $seatnumbera10 = "bgcolor='#990000'";  }
if ($seat_number == "A-11" && $status == "block")  {  $seatnumbera11 = "bgcolor='#990000'"; }
if ($seat_number == "A-12" && $status == "block")  {  $seatnumbera12 = "bgcolor='#990000'"; }
if ($seat_number == "A-13" && $status == "block")  {  $seatnumbera13 = "bgcolor='#990000'"

tickets.txt (66.14 KB)

The attachment preview is chopped off after the first 10 KB. Please download the entire file.

-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 05, 2010 at 03:24 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `ticket`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `tickets`
-- 

CREATE TABLE `tickets` (
  `id` int(255) NOT NULL auto_increment,
  `seat_number` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29585 ;

-- 
-- Dumping data for table `tickets`
-- 

INSERT INTO `tickets` VALUES (1, 'A-1', 'free');
INSERT INTO `tickets` VALUES (2, 'A-2', 'free');
INSERT INTO `tickets` VALUES (3, 'A-3', 'free');
INSERT INTO `tickets` VALUES (4, 'A-4', 'free');
INSERT INTO `tickets` VALUES (5, 'A-5', 'free');
INSERT INTO `tickets` VALUES (6, 'A-6', 'free');
INSERT INTO `tickets` VALUES (7, 'A-7', 'free');
INSERT INTO `tickets` VALUES (8, 'A-8', 'free');
INSERT INTO `tickets` VALUES (9, 'A-9', 'free');
INSERT INTO `tickets` VALUES (10, 'A-10', 'free');
INSERT INTO `tickets` VALUES (17, 'A-11', 'free');
INSERT INTO `tickets` VALUES (18, 'A-12', 'free');
INSERT INTO `tickets` VALUES (19, 'A-13', 'free');
INSERT INTO `tickets` VALUES (20, 'A-14', 'free');
INSERT INTO `tickets` VALUES (21, 'A-15', 'free');
INSERT INTO `tickets` VALUES (22, 'A-16', 'free');
INSERT INTO `tickets` VALUES (23, 'A-17', 'free');
INSERT INTO `tickets` VALUES (24, 'A-18', 'free');
INSERT INTO `tickets` VALUES (25, 'A-19', 'free');
INSERT INTO `tickets` VALUES (26, 'A-20', 'free');
INSERT INTO `tickets` VALUES (27, 'A-21', 'free');
INSERT INTO `tickets` VALUES (28, 'A-22', 'free');
INSERT INTO `tickets` VALUES (29, 'A-23', 'free');
INSERT INTO `tickets` VALUES (30, 'A-24', 'free');
INSERT INTO `tickets` VALUES (31, 'A-25', 'free');
INSERT INTO `tickets` VALUES (32, 'A-26', 'free');
INSERT INTO `tickets` VALUES (33, 'A-27', 'free');
INSERT INTO `tickets` VALUES (34, 'A-28', 'free');
INSERT INTO `tickets` VALUES (35, 'A-29', 'free');
INSERT INTO `tickets` VALUES (36, 'A-30', 'free');
INSERT INTO `tickets` VALUES (65, 'A-31', 'free');
INSERT INTO `tickets` VALUES (66, 'A-32', 'free');
INSERT INTO `tickets` VALUES (67, 'A-33', 'free');
INSERT INTO `tickets` VALUES (68, 'A-34', 'free');
INSERT INTO `tickets` VALUES (69, 'A-35', 'free');
INSERT INTO `tickets` VALUES (70, 'A-36', 'free');
INSERT INTO `tickets` VALUES (71, 'A-37', 'free');
INSERT INTO `tickets` VALUES (72, 'A-38', 'free');
INSERT INTO `tickets` VALUES (73, 'A-39', 'free');
INSERT INTO `tickets` VALUES (74, 'A-40', 'free');
INSERT INTO `tickets` VALUES (75, 'B-1', 'free');
INSERT INTO `tickets` VALUES (76, 'B-2', 'free');
INSERT INTO `tickets` VALUES (77, 'B-3', 'free');
INSERT INTO `tickets` VALUES (78, 'B-4', 'free');
INSERT INTO `tickets` VALUES (79, 'B-5', 'free');
INSERT INTO `tickets` VALUES (80, 'B-6', 'free');
INSERT INTO `tickets` VALUES (81, 'B-7', 'free');
INSERT INTO `tickets` VALUES (82, 'B-8', 'free');
INSERT INTO `tickets` VALUES (83, 'B-9', 'free');
INSERT INTO `tickets` VALUES (84, 'B-10', 'free');
INSERT INTO `tickets` VALUES (129, 'B-11', 'free');
INSERT INTO `tickets` VALUES (130, 'B-12', 'free');
INSERT INTO `tickets` VALUES (131, 'B-13', 'free');
INSERT INTO `tickets` VALUES (132, 'B-14', 'free');
INSERT INTO `tickets` VALUES (133, 'B-15', 'free');
INSERT INTO `tickets` VALUES (134, 'B-16', 'free');
INSERT INTO `tickets` VALUES (135, 'B-17', 'free');
INSERT INTO `tickets` VALUES (136, 'B-18', 'free');
INSERT INTO `tickets` VALUES (137, 'B-19', 'free');
INSERT INTO `tickets` VALUES (138, 'B-20', 'free');
INSERT INTO `tickets` VALUES (139, 'B-21', 'free');
INSERT INTO `tickets` VALUES (140, 'B-22', 'free');
INSERT INTO `tickets` VALUES (141, 'B-23', 'free');
INSERT INTO `tickets` VALUES (142, 'B-24', 'free');
INSERT INTO `tickets` VALUES (143, 'B-25', 'free');
INSERT INTO `tickets` VALUES (144, 'B-26', 'free');
INSERT INTO `tickets` VALUES (145, 'B-27', 'free');
INSERT INTO `tickets` VALUES (146, 'B-28', 'free');
INSERT INTO `tickets` VALUES (147, 'B-29', 'free');
INSERT INTO `tickets` VALUES (148, 'B-30', 'free');
INSERT INTO `tickets` VALUES (149, 'B-31', 'free');
INSERT INTO `tickets` VALUES (150, 'B-32', 'free');
INSERT INTO `tickets` VALUES (151, 'B-33', 'free');
INSERT INTO `tickets` VALUES (152, 'B-34', 'free');
INSERT INTO `tickets` VALUES (153, 'B-35', 'free');
INSERT INTO `tickets` VALUES (154, 'B-36', 'free');
INSERT INTO `tickets` VALUES (155, 'B-37', 'free');
INSERT INTO `tickets` VALUES (156, 'B-38', 'free');
INSERT INTO `tickets` VALUES (157, 'B-39', 'free');
INSERT INTO `tickets` VALUES (158, 'B-40', 'free');
INSERT INTO `tickets` VALUES (257, 'C-1', 'free');
INSERT INTO `tickets` VALUES (258, 'C-2', 'free');
INSERT INTO `tickets` VALUES (259, 'C-3', 'free');
INSERT INTO `tickets` VALUES (260, 'C-4', 'free');
INSERT INTO `tickets` VALUES (261, 'C-5', 'free');
INSERT INTO `tickets` VALUES (262, 'C-6', 'free');
INSERT INTO `tickets` VALUES (263, 'C-7', 'free');
INSERT INTO `tickets` VALUES (264, 'C-8', 'free');
INSERT INTO `tickets` VALUES (265, 'C-9', 'free');
INSERT INTO `tickets` VALUES (266, 'C-10', 'free');
INSERT INTO `tickets` VALUES (267, 'C-11', 'free');
INSERT INTO `tickets` VALUES (268, 'C-12', 'free');
INSERT INTO `tickets` VALUES (269, 'C-13', 'free');
INSERT INTO `tickets` VALUES (270, 'C-14', 'free');
INSERT INTO `tickets` VALUES (271, 'C-15', 'free');
INSERT INTO `tickets` VALUES (272, 'C-16', 'free');
INSERT INTO `tickets` VALUES (273, 'C-17', 'free');
INSERT INTO `tickets` VALUES (274, 'C-18', 'free');
INSERT INTO `tickets` VALUES (275, 'C-19', 'free');
INSERT INTO `tickets` VALUES (276, 'C-20', 'free');
INSERT INTO `tickets` VALUES (277, 'C-21', 'free');
INSERT INTO `tickets` VALUES (278, 'C-22', 'free');
INSERT INTO `tickets` VALUES (279, 'C-23', 'free');
INSERT INTO `tickets` VALUES (280, 'C-24', 'free');
INSERT INTO `tickets` VALUES (281, 'C-25', 'free');
INSERT INTO `tickets` VALUES (282, 'C-26', 'free');
INSERT INTO `tickets` VALUES (283, 'C-27', 'free');
INSERT INTO `tickets` VALUES (284, 'C-28', 'free');
INSERT INTO `tickets` VALUES (285, 'C-29', 'free');
INSERT INTO `tickets` VALUES (286, 'C-30', 'free');
INSERT INTO `tickets` VALUES (287, 'C-31', 'free');
INSERT INTO `tickets` VALUES (288, 'C-32', 'free');
INSERT INTO `tickets` VALUES (289, 'C-33', 'free');
INSERT INTO `tickets` VALUES (290, 'C-34', 'free');
INSERT INTO `tickets` VALUES (291, 'C-35', 'free');
INSERT INTO `tickets` VALUES (292, 'C-36', 'free');
INSERT INTO `tickets` VALUES (293, 'C-37', 'free');
INSERT INTO `tickets` VALUES (294, 'C-38', 'free');
INSERT INTO `tickets` VALUES (295, 'C-39', 'free');
INSERT INTO `tickets` VALUES (296, 'C-40', 'free');
INSERT INTO `tickets` VALUES (297, 'D-1', 'free');
INSERT INTO `tickets` VALUES (298, 'D-2', 'free');
INSERT INTO `tickets` VALUES (299, 'D-3', 'free');
INSERT INTO `tickets` VALUES (300, 'D-4', 'free');
INSERT INTO `tickets` VALUES (301, 'D-5', 'free');
INSERT INTO `tickets` VALUES (302, 'D-6', 'free');
INSERT INTO `tickets` VALUES (303, 'D-7', 'free');
INSERT INTO `tickets` VALUES (304, 'D-8', 'free');
INSERT INTO `tickets` VALUES (305, 'D-9', 'free');
INSERT INTO `tickets` VALUES (306, 'D-10', 'free');
INSERT INTO `tickets` VALUES (307, 'D-11', 'free');
INSERT INTO `tickets` VALUES (308, 'D-12', 'free');
INSERT INTO `tickets` VALUES (309, 'D-13', 'free');
INSERT INTO `tickets` VALUES (310, 'D-14', 'free');
INSERT INTO `tickets` VALUES (311, 'D-15', 'free');
INSERT INTO `tickets` VALUES (312, 'D-16', 'free');
INSERT INTO `tickets` VALUES (313, 'D-17', 'free');
INSERT INTO `tickets` VALUES (314, 'D-18', 'free');
INSERT INTO `tickets` VALUES (315, 'D-19', 'free');
INSERT INTO `tickets` VALUES (316, 'D-20', 'free');
INSERT INTO `tickets` VALUES (317, 'D-21', 'free');
INSERT INTO `tickets` VALUES (318, 'D-22', 'free');
INSERT INTO `tickets` VALUES (319, 'D-23', 'free');
INSERT INTO `tickets` VALUES (320, 'D-24', 'free');
INSERT INTO `tickets` VALUES (321, 'D-25', 'free');
INSERT INTO `tickets` VALUES (322, 'D-26', 'free');
INSERT INTO `tickets` VALUES (323, 'D-27', 'free');
INSERT INTO `tickets` VALUES (324, 'D-28', 'free');
INSERT INTO `tickets` VALUES (325, 'D-29', 'free');
INSERT INTO `tickets` VALUES (326, 'D-30', 'free');
INSERT INTO `tickets` VALUES (327, 'D-31', 'free');
INSERT INTO `tickets` VALUES (328, 'D-32', 'free');
INSERT INTO `tickets` VALUES (329, 'D-33', 'free');
INSERT INTO `tickets` VALUES (330, 'D-34', 'free');
INSERT INTO `tickets` VALUES (331, 'D-35', 'free');
INSERT INTO `tickets` VALUES (332, 'D-36', 'free');
INSERT INTO `tickets` VALUES (333, 'D-37', 'free');
INSERT INTO `tickets` VALUES (334, 'D-38', 'free');
INSERT INTO `tickets` VALUES (335, 'D-39', 'free');
INSERT INTO `tickets` VALUES (336, 'D-40', 'free');
INSERT INTO `tickets` VALUES (337, 'E-1', 'free');
INSERT INTO `tickets` VALUES (338, 'E-2', 'free');
INSERT INTO `tickets` VALUES (339, 'E-3', 'free');
INSERT INTO `tickets` VALUES (340, 'E-4', 'free');
INSERT INTO `tickets` VALUES (341, 'E-5', 'free');
INSERT INTO `tickets` VALUES (342, 'E-6', 'free');
INSERT INTO `tickets` VALUES (343, 'E-7', 'free');
INSERT INTO `tickets` VALUES (344, 'E-8', 'free');
INSERT INTO `tickets` VALUES (345, 'E-9', 'free');
INSERT INTO `tickets` VALUES (346, 'E-10', 'free');
INSERT INTO `tickets` VALUES (347, 'E-11', 'free');
INSERT INTO `tickets` VALUES (348, 'E-12', 'free');
INSERT INTO `tickets` VALUES (349, 'E-13', 'free');
INSERT INTO `tickets` VALUES (350, 'E-14', 'free');
INSERT INTO `tickets` VALUES (351, 'E-15', 'free');
INSERT INTO `tickets` VALUES (352, 'E-16', 'free');
INSERT INTO `tickets` VALUES (353, 'E-17', 'free');
INSERT INTO `tickets` VALUES (354, 'E-18', 'free');
INSERT INTO `tickets` VALUES (355, 'E-19', 'free');
INSERT INTO `tickets` VALUES (356, 'E-20', 'free');
INSERT INTO `tickets` VALUES (357, 'E-21', 'free');
INSERT INTO `tickets` VALUES (358, 'E-22', 'free');
INSERT INTO `tickets` VALUES (35

3 Contributors
13 Replies
116 Views
17 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by WaleedaaN

mahavir123 1 Junior Poster in Training

14 Years Ago

As far as i understand, your code is slow because the php server is taking much more time to process.
So I think your color is according to the status so why you write those code for every ticket, rather then you can write only 3 if conditions for 'block,free, and paid' only once.

And try to put those ticket listing in a loop.
Hope this might work.

richieking 44 Master Poster

14 Years Ago

You are doing a lot of hand coding there. hoooop

I dont remember the last time i did this. Very time consuming and slow.

Try more iteration functions. Thats whay they were made for.
It will cut your code from 500 lines to 200 or less i think.

:) explore

Edited 14 Years Ago by richieking because: n/a

richieking 44 Master Poster

14 Years Ago

OK

1.You have 2000 seats in the hall,
2. You want block.php
3.paid.php
4.free.php

or what?????

what is block,paid,free thing????
Can you please come out with some good flow chart.
Explore :)

richieking 44 Master Poster

14 Years Ago

I will have to download your script and go through. can you reload your script again.

this time mark where you think needs attention. how much time do you have at hane before your deadline?

Explore :)

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

WaleedaaN 0 Newbie Poster · Answer 1 · 2010-10-05T19:45:49+00:00

thanks for replay,,,

did you have any idea or code to give me

thanks

WaleedaaN 0 Newbie Poster · Answer 2 · 2010-10-06T00:22:55+00:00

ok what the best why to create code php

for booking seats for show i have 2000 seat i want block,paid,free

and i have for 1 day more in 3 times show

how i can create best code of my code see ^^^ up ^^^ you will see my php file and sql

thanks

WaleedaaN 0 Newbie Poster · Answer 3 · 2010-10-06T01:30:57+00:00

when i block seat is come background color black if is free green when paid red all same file or what you what to do but i want it work :)

you can ue my files to know my idea and what i do

thanks very much

WaleedaaN 0 Newbie Poster · Answer 4 · 2010-10-06T01:39:13+00:00

my seats From A to Z and every litter like A or B have 40 seat

thanks

WaleedaaN 0 Newbie Poster · Answer 5 · 2010-10-06T01:52:40+00:00

WaleedaaN 0 Newbie Poster

14 Years Ago

i have time for 10 days :)

Edited 14 Years Ago by WaleedaaN because: n/a

richieking 44 Master Poster · Answer 6 · 2010-10-06T02:08:33+00:00

Thats a lot of time. just mark when you think gives you problems on your file and upload it to me via PM ok?

WaleedaaN 0 Newbie Poster · Answer 7 · 2010-10-06T02:14:32+00:00

WaleedaaN 0 Newbie Poster

14 Years Ago

you want me upload files and send it to you by pm ?

Edited 14 Years Ago by WaleedaaN because: n/a

richieking 44 Master Poster · Answer 8 · 2010-10-06T02:26:51+00:00

richieking 44 Master Poster

14 Years Ago

YES SIR :)

WaleedaaN 0 Newbie Poster · Answer 9 · 2010-10-06T05:18:24+00:00

i dont know how to attachment in PM

this link to download file and sql
just do sql coonect and you will see my code

if you want create idea from your mind go head

http://www.daniweb.com/forums/attachment.php?attachmentid=17504&d=1286278342
http://www.daniweb.com/forums/attachment.php?attachmentid=17505&d=1286278397

dont care for my files :)