|
PCCS MySQLDatabase Admin Tool version 1.3.4
|
/ -> mysqldb_user.php
1 <?php
2 // Used PHPGen to generate most of this code
3 // Filename: mysqldb_user.php
4 // Function: provide a simple interface to the mysql user table
5 // updated 10-23-2000
6 // -- moving to a single file for global include files
7
8 require('mysqldb_app_includes.php');
9
10 common_header($str_mainTitle);
11
12 pageTop("PCCS MySQLAdmin Tool version ". $appversion,"600");
13
14
15 $link_array = array(
16 "$str_mainMenu" => "./",
17 "$str_createwebacct" => "mysqldb_create_webuser.php",
18 "LOGOUT" => "logout.php"
19 );
20
21 print "<BR>";
22 print "<CENTER>";
23 navBar($link_array);
24 print "</CENTER>";
25 print "<BR>";
26
27 if (empty($action)) $action="browselist";
28
29
30 $Select_priv_arr = array(
31 "N" => "N",
32 "Y" => "Y"
33 );
34
35 $Insert_priv_arr = array(
36 "N" => "N",
37 "Y" => "Y"
38 );
39
40 $Update_priv_arr = array(
41 "N" => "N",
42 "Y" => "Y"
43 );
44
45 $Delete_priv_arr = array(
46 "N" => "N",
47 "Y" => "Y"
48 );
49
50 $Create_priv_arr = array(
51 "N" => "N",
52 "Y" => "Y"
53 );
54
55 $Drop_priv_arr = array(
56 "N" => "N",
57 "Y" => "Y"
58 );
59
60 $Reload_priv_arr = array(
61 "N" => "N",
62 "Y" => "Y"
63 );
64
65 $Shutdown_priv_arr = array(
66 "N" => "N",
67 "Y" => "Y"
68 );
69
70 $Process_priv_arr = array(
71 "N" => "N",
72 "Y" => "Y"
73 );
74
75 $File_priv_arr = array(
76 "N" => "N",
77 "Y" => "Y"
78 );
79
80 $Grant_priv_arr = array(
81 "N" => "N",
82 "Y" => "Y"
83 );
84
85 $References_priv_arr = array(
86 "N" => "N",
87 "Y" => "Y"
88 );
89
90 $months["01"] = "January";
91 $months["02"] = "February";
92 $months["03"] = "March";
93 $months["04"] = "April";
94 $months["05"] = "May";
95 $months["06"] = "Juny";
96 $months["07"] = "July";
97 $months["08"] = "August";
98 $months["09"] = "September";
99 $months["10"] = "October";
100 $months["11"] = "November";
101 $months["12"] = "December";
102 ?>
103
104 <? /********** Save edited ************************************************/ ?>
105 <?php if (isset($action) && $action == "save"): ?>
106 <? //*** Check data
107 $ok = 1;
108 echo "<TABLE BORDER=0>";
109
110 $fields = "";
111 $Host=chop($Host);
112 if ($Host == "") {
113 $ok = 0;
114 echo "Host - must be specified !<BR>";
115 }
116
117 $fields.=',';
118 $fields.="Host=";
119 $fields.="'$Host'";
120
121 $User=chop($User);
122 if ($User == "") {
123 $ok = 0;
124 echo "User - must be specified !<BR>";
125 }
126
127 $fields.=',';
128 $fields.="User=";
129 $fields.="'$User'";
130
131 $Password=chop($Password);
132 if ($Password == "") {
133 $ok = 0;
134 echo "Password - must be specified !<BR>";
135 }
136
137 $fields.=',';
138 $fields.="Password=";
139 $fields.="'$Password'";
140
141
142 $Select_priv=chop($Select_priv);
143 if ($Select_priv == "") {
144 $ok = 0;
145 echo "Select - must be specified !<BR>";
146 }
147
148 $fields.=',';
149 $fields.="Select_priv=";
150 $fields.="'$Select_priv'";
151
152 $Insert_priv=chop($Insert_priv);
153 if ($Insert_priv == "") {
154 $ok = 0;
155 echo "Insert - must be specified !<BR>";
156 }
157
158 $fields.=',';
159 $fields.="Insert_priv=";
160 $fields.="'$Insert_priv'";
161
162 $Update_priv=chop($Update_priv);
163 if ($Update_priv == "") {
164 $ok = 0;
165 echo "Update - must be specified !<BR>";
166 }
167
168 $fields.=',';
169 $fields.="Update_priv=";
170 $fields.="'$Update_priv'";
171
172 $Delete_priv=chop($Delete_priv);
173 if ($Delete_priv == "") {
174 $ok = 0;
175 echo "Delete - must be specified !<BR>";
176 }
177
178 $fields.=',';
179 $fields.="Delete_priv=";
180 $fields.="'$Delete_priv'";
181
182 $Create_priv=chop($Create_priv);
183 if ($Create_priv == "") {
184 $ok = 0;
185 echo "Create - must be specified !<BR>";
186 }
187
188 $fields.=',';
189 $fields.="Create_priv=";
190 $fields.="'$Create_priv'";
191
192 $Drop_priv=chop($Drop_priv);
193 if ($Drop_priv == "") {
194 $ok = 0;
195 echo "Drop - must be specified !<BR>";
196 }
197
198 $fields.=',';
199 $fields.="Drop_priv=";
200 $fields.="'$Drop_priv'";
201
202 $Reload_priv=chop($Reload_priv);
203 if ($Reload_priv == "") {
204 $ok = 0;
205 echo "Reload - must be specified !<BR>";
206 }
207
208 $fields.=',';
209 $fields.="Reload_priv=";
210 $fields.="'$Reload_priv'";
211
212 $Shutdown_priv=chop($Shutdown_priv);
213 if ($Shutdown_priv == "") {
214 $ok = 0;
215 echo "Shutdown - must be specified !<BR>";
216 }
217
218 $fields.=',';
219 $fields.="Shutdown_priv=";
220 $fields.="'$Shutdown_priv'";
221
222 $Process_priv=chop($Process_priv);
223 if ($Process_priv == "") {
224 $ok = 0;
225 echo "Process - must be specified !<BR>";
226 }
227
228 $fields.=',';
229 $fields.="Process_priv=";
230 $fields.="'$Process_priv'";
231
232 $File_priv=chop($File_priv);
233 if ($File_priv == "") {
234 $ok = 0;
235 echo "File - must be specified !<BR>";
236 }
237
238 $fields.=',';
239 $fields.="File_priv=";
240 $fields.="'$File_priv'";
241
242 $Grant_priv=chop($Grant_priv);
243 if ($Grant_priv == "") {
244 $ok = 0;
245 echo "Grant - must be specified !<BR>";
246 }
247
248 $fields.=',';
249 $fields.="Grant_priv=";
250 $fields.="'$Grant_priv'";
251
252 $References_priv=chop($References_priv);
253 if ($References_priv == "") {
254 $ok = 0;
255 echo "References - must be specified !<BR>";
256 }
257
258 $fields.=',';
259 $fields.="References_priv=";
260 $fields.="'$References_priv'";
261 if (!$ok):
262 echo "Error!";
263 echo "<BR><A HREF=javascript:history.back()>Try again</A>";
264 exit;
265 endif;
266
267 $fields = substr($fields,1,strlen($fields)-1);
268
269 $result = mysqlquery("mysql","UPDATE user
270 SET $fields
271 WHERE User='$User' AND Host='$par'");
272 if (!empty($result)) {
273 /* encrypt password */
274 $res = mysqlquery("mysql","UPDATE user
275 SET Password = password('$Password')
276 WHERE User='$User' AND Host='$par'");
277 /* refresh the privilege table */
278 $result = mysqlquery("mysql","FLUSH PRIVILEGES");
279 if (!empty($result)) {
280 } else {
281 echo mysql_error()."<BR>\n";
282 }
283
284 callback_meta("action=browselist&start=0");
285 } else {
286 echo mysql_error()."<BR>\n";
287 }
288 ?>
289 <? endif ?>
290
291 <?
292 //*** Calculate number of records
293 if (empty($found)) {
294 if (isset($action) && $action == "search") {
295 $result = mysqlquery("mysql","SELECT COUNT(*) FROM user WHERE ($whichfield LIKE '%" . $searchvalue . "%') ORDER BY $whichfield");
296 } else {
297 $result = mysqlquery("mysql","SELECT COUNT(*) FROM user");
298 }
299 $found = mysql_result($result,0,0);
300 }
301
302 if ($limit == 0) $limit = $found; ?>
303
304 <TABLE WIDTH=100% BORDER=0><TR>
305 <TD BGCOLOR="#FFFFFF">[ <A HREF="mysqldb_gr_perms.php">Grant/Revoke</A>
306 | <A HREF="<? echo $PHP_SELF ?>?action=browselist&found=<? echo $found; ?>&start=0">List all</A>
307 | <A HREF="<? echo $PHP_SELF ?>?action=searchform">Search</A> ]</TD>
308 </TR></TABLE>
309
310 <?
311 if (($action == "search") || ($action == "browselist")):
312 if (empty($start)) $start=0;
313 if (isset($start) && ($start>0)) {
314 echo "<A HREF=\"$PHP_SELF?action=$action";
315 if (isset($action) && $action == "search") echo "&whichfield=$whichfield&searchvalue=$searchvalue";
316 echo "&found=$found&start=",max($start-$limit,0),"\"><<<Previous $limit</A> ";
317 }
318
319 if (isset($start) && ((($start+$limit) < $found))) {
320 echo "<A HREF=\"$PHP_SELF?action=$action";
321 if ($action == "search") echo "&whichfield=$whichfield&searchvalue=$searchvalue";
322 echo "&found=$found&start=",$start+$limit,"\">>>>Next ",min($found-$start-$limit,$limit),"</A>";
323 }
324 endif;
325 ?>
326
327 <?/********** Search *****************************************************/
328
329 if (isset($action) && $action == "search"):
330
331 $result = mysqlquery("mysql","SELECT * FROM user WHERE ($whichfield LIKE '%" . $searchvalue . "%') ORDER BY $whichfield LIMIT $start,$limit");
332 echo "<H3 align=center>Search for '$searchvalue ' in '$whichfield ' returned $found hits</H3>";
333
334 $num = mysql_numrows($result);
335 $c1 = "#EEEEEE";
336 $c2 = "#CCCCCC";
337 ?>
338 <CENTER>
339 <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1>
340 <TR>
341 <TH>Host</TH><TH>User</TH>
342 </TR>
343 <?
344 $c = "";
345 for ($i =0 ;$i < $num; $i++):
346 $c = ($c == $c1)?$c2:$c1;
347 echo "<TR BGCOLOR=\"$c\">";
348 echo "<TD><A HREF=\"$PHP_SELF?action=detail&user=",urlencode(mysql_result($result,$i,"User")),"&par=",urlencode(mysql_result($result,$i,"Host")),"\">",mysql_result($result,$i,"Host"),"</A></TD>";
349
350 echo "<TD>";
351 $val = mysql_result($result, $i, "User");
352 print_sp($val);
353 echo "</TD>";
354
355 echo "</TR>";
356 endfor;
357 echo "</TABLE></CENTER>";
358
359 mysql_free_result($result);
360 endif /* Search */ ?>
361
362 <?/********** Show all *****************************************************/
363 if (isset($action) && ($action == "browselist")):
364 echo "<H3 ALIGN=center>Host+User that are ALLOWED to connect this
365 server</H3>";
366 $result = mysqlquery("mysql","SELECT * FROM user ORDER BY Host LIMIT $start,$limit");
367 $num = mysql_numrows($result);
368 $c1 = "#EEEEEE";
369 $c2 = "#CCCCCC";
370 ?>
371 <CENTER>
372 <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1>
373 <TR>
374 <TH>Host</TH><TH>User</TH>
375 </TR>
376 <?
377 $c = "";
378 for ($i =0 ;$i < $num; $i++):
379 $c = ($c == $c1)?$c2:$c1;
380 echo "<TR BGCOLOR=\"$c\">";
381 echo "<TD><A
382 HREF=\"$PHP_SELF?action=detail&user=",urlencode(mysql_result($result,$i,"User")),"&par=",urlencode(mysql_result($result,$i,"Host")),"\">",mysql_result($result,$i,"Host"),"</A></TD>";
383
384 echo "<TD>";
385 $val = mysql_result($result, $i, "User");
386 print_sp($val);
387 echo "</TD>";
388
389 echo "</TR>";
390 endfor;
391 echo "</TABLE>";
392
393 echo "</CENTER>";
394
395 mysql_free_result($result);
396 endif /* Show all */ ?>
397
398 <?/********** Show detail **************************************************/
399 if (isset($action) && (($action == "detail") || ($action == "warnerase"))):
400
401 $result = mysqlquery("mysql","SELECT * FROM user WHERE User='$user' AND Host='$par'");
402 echo "<H2 ALIGN=center>ID: ",mysql_result($result,0,"Host"),"</H2>";
403 ?>
404 <TABLE BORDER=0 CELLSPACING=2 CELLPADDING=2>
405 <?
406 echo "<TR><TD valign=middle><B>Host: </B></TD>";
407 echo "<TD valign=middle>";
408 print_html(mysql_result($result,0,"Host"));
409 echo "</TD></TR>";
410
411 echo "<TR><TD valign=middle><B>User: </B></TD>";
412 echo "<TD valign=middle>";
413 print_html(mysql_result($result,0,"User"));
414 echo "</TD></TR>";
415
416 echo "<TR><TD valign=middle><B>Password: </B></TD>";
417 echo "<TD valign=middle>";
418 print_html(mysql_result($result,0,"Password"));
419 echo "</TD></TR>";
420
421 echo "<TR><TD valign=middle><B>Select: </B></TD>";
422 echo "<TD valign=middle>";
423 echo $Select_priv_arr[mysql_result($result,0,"Select_priv")];
424 echo "</TD></TR>";
425
426 echo "<TR><TD valign=middle><B>Insert: </B></TD>";
427 echo "<TD valign=middle>";
428 echo $Insert_priv_arr[mysql_result($result,0,"Insert_priv")];
429 echo "</TD></TR>";
430
431 echo "<TR><TD valign=middle><B>Update: </B></TD>";
432 echo "<TD valign=middle>";
433 echo $Update_priv_arr[mysql_result($result,0,"Update_priv")];
434 echo "</TD></TR>";
435
436 echo "<TR><TD valign=middle><B>Delete: </B></TD>";
437 echo "<TD valign=middle>";
438 echo $Delete_priv_arr[mysql_result($result,0,"Delete_priv")];
439 echo "</TD></TR>";
440
441 echo "<TR><TD valign=middle><B>Create: </B></TD>";
442 echo "<TD valign=middle>";
443 echo $Create_priv_arr[mysql_result($result,0,"Create_priv")];
444 echo "</TD></TR>";
445
446 echo "<TR><TD valign=middle><B>Drop: </B></TD>";
447 echo "<TD valign=middle>";
448 echo $Drop_priv_arr[mysql_result($result,0,"Drop_priv")];
449 echo "</TD></TR>";
450
451 echo "<TR><TD valign=middle><B>Reload: </B></TD>";
452 echo "<TD valign=middle>";
453 echo $Reload_priv_arr[mysql_result($result,0,"Reload_priv")];
454 echo "</TD></TR>";
455
456 echo "<TR><TD valign=middle><B>Shutdown: </B></TD>";
457 echo "<TD valign=middle>";
458 echo $Shutdown_priv_arr[mysql_result($result,0,"Shutdown_priv")];
459 echo "</TD></TR>";
460
461 echo "<TR><TD valign=middle><B>Process: </B></TD>";
462 echo "<TD valign=middle>";
463 echo $Process_priv_arr[mysql_result($result,0,"Process_priv")];
464 echo "</TD></TR>";
465
466 echo "<TR><TD valign=middle><B>File: </B></TD>";
467 echo "<TD valign=middle>";
468 echo $File_priv_arr[mysql_result($result,0,"File_priv")];
469 echo "</TD></TR>";
470
471 echo "<TR><TD valign=middle><B>Grant: </B></TD>";
472 echo "<TD valign=middle>";
473 echo $Grant_priv_arr[mysql_result($result,0,"Grant_priv")];
474 echo "</TD></TR>";
475
476 echo "<TR><TD valign=middle><B>References: </B></TD>";
477 echo "<TD valign=middle>";
478 echo $References_priv_arr[mysql_result($result,0,"References_priv")];
479 echo "</TD></TR>";
480
481 ?>
482 </TABLE>
483
484 <?
485 if (isset($action) && $action == "detail"):
486 echo "<A HREF=\"$PHP_SELF?action=edit&user=",urlencode(mysql_result($result,$i,"User")),"&par=",urlencode($par),"\">Edit</A>";
487 endif;
488 mysql_free_result($result);
489 endif /* Show detail */
490 ?>
491
492 <?/********** New/Edit *****************************************************/?>
493 <?
494 if (isset($action) && (($action == "new") || ($action == "edit"))):
495 if ($action == "edit"):
496 $result = mysqlquery("mysql","SELECT * FROM user WHERE
497 User='$user' AND Host='$par'");
498 $Host=htmlspecialchars(mysql_result($result,0,"Host"));
499 $User=htmlspecialchars(mysql_result($result,0,"User"));
500 $Password=htmlspecialchars(mysql_result($result,0,"Password"));
501 $Select_priv=htmlspecialchars(mysql_result($result,0,"Select_priv"));
502 $Insert_priv=htmlspecialchars(mysql_result($result,0,"Insert_priv"));
503 $Update_priv=htmlspecialchars(mysql_result($result,0,"Update_priv"));
504 $Delete_priv=htmlspecialchars(mysql_result($result,0,"Delete_priv"));
505 $Create_priv=htmlspecialchars(mysql_result($result,0,"Create_priv"));
506 $Drop_priv=htmlspecialchars(mysql_result($result,0,"Drop_priv"));
507 $Reload_priv=htmlspecialchars(mysql_result($result,0,"Reload_priv"));
508 $Shutdown_priv=htmlspecialchars(mysql_result($result,0,"Shutdown_priv"));
509 $Process_priv=htmlspecialchars(mysql_result($result,0,"Process_priv"));
510 $File_priv=htmlspecialchars(mysql_result($result,0,"File_priv"));
511 $Grant_priv=htmlspecialchars(mysql_result($result,0,"Grant_priv"));
512 $References_priv=htmlspecialchars(mysql_result($result,0,"References_priv"));
513 echo "<H2 ALIGN=center>Edit User Permission</H2>";
514 else:
515 echo "<H2 ALIGN=center>Create New User</H2>";
516 $Host="";
517 $User="";
518 $Password="";
519 $Select_priv="";
520 $Insert_priv="";
521 $Update_priv="";
522 $Delete_priv="";
523 $Create_priv="";
524 $Drop_priv="";
525 $Reload_priv="";
526 $Shutdown_priv="";
527 $Process_priv="";
528 $File_priv="";
529 $Grant_priv="";
530 $References_priv="";
531 endif;
532
533 if ($action == "new"):
534 echo "<FORM ACTION=\"$PHP_SELF?action=storenew\" METHOD=POST NAME=phpgen1>";
535 else:
536 echo "<FORM ACTION=\"$PHP_SELF?action=save&par=",urlencode($par),"\" METHOD=POST NAME=phpgen1>";
537 endif;
538
539 echo "<CENTER><TABLE BORDER=0 CELLPADDING=2>";
540
541 //******************************** HOST (stand)
542 echo "<TR><TD ALIGN=RIGHT VALIGN=MIDDLE><B>Host: </TD><TD VALIGN=MIDDLE>";
543 echo "<INPUT NAME=Host SIZE=60 MAXLENGTH=60 VALUE='$Host'></TD></TR>";
544
545
546 //******************************** USER (stand)
547 echo "<TR><TD ALIGN=RIGHT VALIGN=MIDDLE><B>User: </TD><TD VALIGN=MIDDLE>";
548 echo "<INPUT NAME=User SIZE=16 MAXLENGTH=16 VALUE='$User'></TD></TR>";
549
550
551 //******************************** PASSWORD (stand)
552 echo "<TR><TD ALIGN=RIGHT VALIGN=MIDDLE><B>Password: </TD><TD VALIGN=MIDDLE>";
553 echo "<INPUT NAME=Password SIZE=16 MAXLENGTH=16
554 VALUE='$Password'></TD></TR></TABLE>";
555
556
557 //******************************** SELECT_PRIV (plist)
558 echo "<TABLE><TR><TD ALIGN=RIGHT VALIGN=TOP><B>Select: </TD><TD VALIGN=TOP>";
559 echo "<SELECT NAME=Select_priv SINGLE>";
560 array2select($Select_priv_arr,$Select_priv);
561 echo "</SELECT></TD>";
562
563 //******************************** INSERT_PRIV (plist)
564 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Insert: </TD><TD VALIGN=TOP>";
565 echo "<SELECT NAME=Insert_priv SINGLE>";
566 array2select($Insert_priv_arr,$Insert_priv);
567 echo "</SELECT></TD>";
568
569 //******************************** UPDATE_PRIV (plist)
570 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Update: </TD><TD VALIGN=TOP>";
571 echo "<SELECT NAME=Update_priv SINGLE>";
572 array2select($Update_priv_arr,$Update_priv);
573 echo "</SELECT></TD>";
574
575 //******************************** DELETE_PRIV (plist)
576 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Delete: </TD><TD VALIGN=TOP>";
577 echo "<SELECT NAME=Delete_priv SINGLE>";
578 array2select($Delete_priv_arr,$Delete_priv);
579 echo "</SELECT></TD></TR>";
580
581 //******************************** CREATE_PRIV (plist)
582 echo "<TR><TD ALIGN=RIGHT VALIGN=TOP><B>Create: </TD><TD VALIGN=TOP>";
583 echo "<SELECT NAME=Create_priv SINGLE>";
584 array2select($Create_priv_arr,$Create_priv);
585 echo "</SELECT></TD>";
586
587 //******************************** DROP_PRIV (plist)
588 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Drop: </TD><TD VALIGN=TOP>";
589 echo "<SELECT NAME=Drop_priv SINGLE>";
590 array2select($Drop_priv_arr,$Drop_priv);
591 echo "</SELECT></TD>";
592
593 //******************************** RELOAD_PRIV (plist)
594 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Reload: </TD><TD VALIGN=TOP>";
595 echo "<SELECT NAME=Reload_priv SINGLE>";
596 array2select($Reload_priv_arr,$Reload_priv);
597 echo "</SELECT></TD>";
598
599 //******************************** SHUTDOWN_PRIV (plist)
600 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Shutdown: </TD><TD VALIGN=TOP>";
601 echo "<SELECT NAME=Shutdown_priv SINGLE>";
602 array2select($Shutdown_priv_arr,$Shutdown_priv);
603 echo "</SELECT></TD></TR>";
604
605 //******************************** PROCESS_PRIV (plist)
606 echo "<TR><TD ALIGN=RIGHT VALIGN=TOP><B>Process: </TD><TD VALIGN=TOP>";
607 echo "<SELECT NAME=Process_priv SINGLE>";
608 array2select($Process_priv_arr,$Process_priv);
609 echo "</SELECT></TD>";
610
611 //******************************** FILE_PRIV (plist)
612 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>File: </TD><TD VALIGN=TOP>";
613 echo "<SELECT NAME=File_priv SINGLE>";
614 array2select($File_priv_arr,$File_priv);
615 echo "</SELECT></TD>";
616
617 //******************************** GRANT_PRIV (plist)
618 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>Grant: </TD><TD VALIGN=TOP>";
619 echo "<SELECT NAME=Grant_priv SINGLE>";
620 array2select($Grant_priv_arr,$Grant_priv);
621 echo "</SELECT></TD>";
622
623 //******************************** REFERENCES_PRIV (plist)
624 echo "<TD ALIGN=RIGHT VALIGN=TOP><B>References: </TD><TD VALIGN=TOP>";
625 echo "<SELECT NAME=References_priv SINGLE>";
626 array2select($References_priv_arr,$References_priv);
627 echo "</SELECT></TD></TR>";
628
629 echo "</TABLE>";
630 echo "<INPUT TYPE=submit NAME='Save' VALUE='Save Permissions'> ";
631
632 if ($action == "new"):
633 echo "<INPUT TYPE=reset VALUE='Clear all fields'>";
634 endif;
635
636 echo "</FORM></CENTER>";
637 print "<P>";
638 print "<A HREF=mysqldb_newuser.php>Back to User</A>";
639
640 mysql_free_result($result);
641 endif; /* New/edit */
642 ?>
643
644 <? /********** Search form ************************************************/
645 if (isset($action) && $action == "searchform"):
646
647 echo "<TABLE BORDER=0 CELLPADDING=2>";
648 echo "<TR><TD ALIGN=RIGHT><B>User:</B></TD>";
649 echo "<TD><FORM METHOD=POST ACTION='$PHP_SELF'>";
650 echo "<INPUT TYPE=HIDDEN NAME=action VALUE=search>";
651 echo "<INPUT TYPE=HIDDEN NAME=start VALUE=0>";
652 echo "<INPUT NAME=searchvalue>";
653 echo "<INPUT TYPE=HIDDEN NAME=whichfield VALUE='User'></TD>";
654 echo "<TD><INPUT TYPE=SUBMIT VALUE='SEARCH'>";
655 echo "</FORM></TD>";
656 echo "</TR>";
657
658 echo "</TABLE>";
659 endif;
660
661 pageBottom();
662 ?>
| |