help with php gui

Wed, 09 Aug 2006 10:33:25 -0700

Hello all

I thing this is going to be very complex.

I have a Some PHP and HTML files I would like to put together but, there is things that need to happen. I forgot the MySQL database set up. I will first post the script and code for the PHP and HTML.

PHP Script


1 <html>
2 <head>
3 <title>Getting Data out of the Database</title>
4 </head>
5 <body bgcolor="#FFFFFF">
6 <h1>The Daily News</h1>
7 <!-- Order news by 
8 <a href="chapter7/chapter7/data_out.php3?orderby=date
">Date</a>, 
9 <a href="chapter7/chapter7/data_out.php3?orderby=head
ing">Heading</a> or by 
10 <a href="chapter7/chapter7/data_out.php3?orderby=auth
or">Author</a>. -->
11 <p>
12 <form action="list_out.php" method="POST">
13 Search:
14 <input type="text" name="Title"> 
15 <input type="submit" name="submit" value="Submit!">
16 </form>
17 <table border="1" cellpadding="3">
18 <?php
19 /* This program gets news items from the database */
20 $db = mysql_connect("localhost", "root", "c705m5p");
21 mysql_select_db("php", $db);
22 /* if ($orderby == 'date'):
23 $sql = "select * from news order by 'date'";
24 elseif ($orderby == 'author'):
25 $sql = "select * from news order by 'author_name'";
26 elseif ($orderby == 'heading'):
27 $sql = "select * from news order by 'heading'";
28 else
29 else: */
30 if (isset($submit)):
31 $sql = "select * from list where Title = '$Title'";
32 endif; 
33 $sql = "select * from list";
34 $result = mysql_query($sql);
35 while ($row = mysql_fetch_array($result)) {
36 print("<tr><td bgcolor=\"#003399\"><b>");
37 printf("<font color=\"white\">%s</font></b></td></tr>\n", 
38 $row["heading"]);
39 printf("<td>By: <a href=\"mailto:%s\">%s</a>\n", 
40 $row["author_email"], $row["author_name"]);
41 printf("<br>Posted: %s<hr>\n", 
42 $row["date"]);
43 printf("%s</td></tr>\n", 
44 $row["body"]);
45 }
46 ?>
47 </table>
48 </body>
49 </html>

HTML Code


1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2 <html xmlns="http://www.w3.org/1999/xhtml">
3 <head>
4 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
5 <title>Untitled Document</title>
6 	
7 	<style type="text/css">
8 
9 	body {
10 		behavior:url("csshover.htc");
11 	}
12	
13	* {
14		font-family:arial,tahoma,verdana,helvetica;
15		font-size:12px;
16	}
17
18	/* the menu */
19
20	ul,li,a {
21		display:block;
22		margin:0;
23		padding:0;
24		border:0;
25	}
26
27	ul {
28		width:250px;
29		border:1px solid #9d9da1;
30		background:white;
31		list-style:none;
32	}
33
34	li {
35		position:relative;
36		padding:1px;
37		z-index:9;
38	}		
39		li.folder ul {
40			position:absolute;
41			width: 160px;
42			left:250px; /* IE */
43			top:5px;
44		}
45		div#descrip
46		{
47			left:
48		}		
49			li.folder>ul { left:250px; } /* others */
50
51	a {
52		padding:2px;
53		border:1px solid white;
54		text-decoration:none;
55		color:gray;
56		font-weight:bold;
57		width:100%; /* IE */
58	}
59		li>a { width:auto; } /* others */
60
61	/* regular hovers */
62
63	a:hover {
64		border-color:gray;
65		background-color:#bbb7c7;
66		color:black;
67	}
68		li.folder a:hover {
69			background-color:#bbb7c7;
70		}
71	
72	/* hovers with specificity */
73	
74	li.folder:hover { z-index:10; }		
75		
76	ul ul, li:hover ul ul {
77		display:none;
78	}
79
80	li:hover ul, li:hover li:hover ul {
81		display:block;
82	}		
83
84	</style>
85
86 </head>
87
88 <body>
89	<ul id="menu">
90		<li class="folder">			
91		<a href="#" class="submenu"></a></li>
92	      <ul>
93	        <li class="folder">&nbsp;&nbsp;See: </li>
94		      <li class="folder">
95			      &nbsp;&nbsp;Paper:  <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;See Reference</li>
96		      <li class="folder">
97			      &nbsp;&nbsp;Paper: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;See Reference</li>
98		      <li class="folder">
99			      <a href="">Online catalogue</a></li>
100		      <li class="folder">		
101			      <a href="">Full text  Online - Infotrac</a></li>
102		      <li class="folder">		
103			      <a href="">Full text  Online - CBCA</a></li>
104		      <li class="folder">&nbsp;&nbsp;Absorbed:  <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
bsp;&nbsp;&nbsp;&nbsp;&nbsp;See Reference</li>
105		      <li class="folder">&nbsp;&nbsp;ISSN: </li>
106     </ul>
107   </li>
108	</ul>
109
110 </body>
111 </html>

The MySQL heading columns are Title, See, Page 1, Page 2, Page 3, Online Catalogue, Full Text - Online - Infotrax, Full Text - Online - CBCA, CBCA Dates, Absorbed, Microfilm, ISSN and Electronic.

What I would like to do is put the php into the html so when the search is done it will display the results like so.

http://kennyleitz.googlepages.com/iemenu.html

Re: help with php gui

Wed, 09 Aug 2006 12:00:59 -0700

: I have a Some PHP and HTML files I would like to put together but, there is things that need to happen. I forgot the MySQL database set up. I will first post the script and code for the PHP and HTML.
:
:
: What I would like to do is put the php into the html so when the search is done it will display the results like so.
:
: http://kennyleitz.googlepages.com/iemenu.html
:
:
:

Do you want the PHP code to be in the HTML code or what?
That's impossible.

But you can try the PHP code once, and then copy the result to a HTLM, that will be almost the same, exept it isn't dynamic.
You can make it dynamic again with a script on the server.

'help with php gui' Thread RSS Feed

help with php gui

Re: help with php gui