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