alaa/snippets/imbaba2005_voters_database.php

<img alt="ÕæÊß ááãÚÇÑÖÉ" src="http://www.manalaa.net:8888/nondp4fk.gif" />

<div class="right2left">
<h3>Ýí ÍÇáÉ ÇáÃáÝ (Â Ã Å) ÇÓÊÎÏã( Ç ) ÈÏæä åãÒÉ</h3>
<h3>æÇáíÇÁ ÂÎÑ ÇáßáÇã (í) ÇÓÊÎÏã (ì)</h3>
<h3>áæ áã ÊÕá áäÊÇÆÌ ÌÑÈ ÇÓÊÎÏÇã ÚÏÏ ÃÞá ãä ÇáÃÓãÇÁ (ËäÇÆí Ãæ ËáÇËí)</h3>
<h3>ÈÑÌÇÁ ÚÏã ÇÏÎÇá ÇáÇÓã ÇáÃæá ÝÞØ ÝÇáäÊÇÆÌ ÓÊßæä ÞÇÆãÉ ßÈíÑÉ ááÛÇíÉ æáä íÙåÑ Óæì  100 ÇÓã (áíÓ ÈÇáÖÑæÑÉ Ãæá 100 ÇÓã)</h3>

<?php /*
$search=$_GET['edit']['search'];
$autoreg= $_GET['edit']['autoreg'] ? "and v.address like '%ãæÇáíÏ%'" : "";

$output=form_textfield("ÇáÇÓã", "search", "$search", 50, 255);
$output.=form_checkbox("ÇÈÍË ÝÞØ Ýí ÇáãÓÌáíä ÊáÞÇÆíÇ", "autoreg",1,$autoreg);
$output.=form_button("ÇÈÍË");
print form($output, $method = 'get');

if ($search) {

$search = str_replace(" ", " *", $search);

$result=db_query("select v.name,v.address,v.num1,v.num2,s.name as station_name, s.address as station_address, s.from from voters as v ,station as s where v.circuit=2 and s.circuit=2 and 
v.name rlike '^$search'  $autoreg and v.station=s.station order by v.name limit 100");

$header = array (
'ÇáÇÓã',
'ÇáÚäæÇä',
'ãÓáÓá',
'ÑÞã ÞíÏ',
'ÇááÌäÉ',
'ÚäæÇä ÇááÌäÉ',
'ãä ÌÏÇæá'
);
$rows=array();

while ($row=db_fetch_array($result)) {
$rows[]=$row;
}

setlocale(LC_ALL,"ar_EG.UTF-8");
function my_cmp($a,$b) {
   return ($a['name'] < $b['name']) ? -1 : 1;
}
usort($rows,"my_cmp");

print theme_table($header,$rows,array('cellspacing'=>'5','cellpading'=>'5','border'=>'1px'));
} */ 
?>
</div>

<img alt="ÕæÊß ááãÚÇÑÖÉ" src="http://www.manalaa.net:8888/nondp4fk.gif" />
1	<img alt="ÕæÊß ááãÚÇÑÖÉ" src="http://www.manalaa.net:8888/nondp4fk.gif" />
2
3	<div class="right2left">
4	<h3>Ýí ÍÇáÉ ÇáÃáÝ (Â Ã Å) ÇÓÊÎÏã( Ç ) ÈÏæä åãÒÉ</h3>
5	<h3>æÇáíÇÁ ÂÎÑ ÇáßáÇã (í) ÇÓÊÎÏã (ì)</h3>
6	<h3>áæ áã ÊÕá áäÊÇÆÌ ÌÑÈ ÇÓÊÎÏÇã ÚÏÏ ÃÞá ãä ÇáÃÓãÇÁ (ËäÇÆí Ãæ ËáÇËí)</h3>
7	<h3>ÈÑÌÇÁ ÚÏã ÇÏÎÇá ÇáÇÓã ÇáÃæá ÝÞØ ÝÇáäÊÇÆÌ ÓÊßæä ÞÇÆãÉ ßÈíÑÉ ááÛÇíÉ æáä íÙåÑ Óæì 100 ÇÓã (áíÓ ÈÇáÖÑæÑÉ Ãæá 100 ÇÓã)</h3>
8
9	<?php /*
10	$search=$_GET['edit']['search'];
11	$autoreg= $_GET['edit']['autoreg'] ? "and v.address like '%ãæÇáíÏ%'" : "";
12
13	$output=form_textfield("ÇáÇÓã", "search", "$search", 50, 255);
14	$output.=form_checkbox("ÇÈÍË ÝÞØ Ýí ÇáãÓÌáíä ÊáÞÇÆíÇ", "autoreg",1,$autoreg);
15	$output.=form_button("ÇÈÍË");
16	print form($output, $method = 'get');
17
18	if ($search) {
19
20	$search = str_replace(" ", " *", $search);
21
22	$result=db_query("select v.name,v.address,v.num1,v.num2,s.name as station_name, s.address as station_address, s.from from voters as v ,station as s where v.circuit=2 and s.circuit=2 and
23	v.name rlike '^$search' $autoreg and v.station=s.station order by v.name limit 100");
24
25	$header = array (
26	'ÇáÇÓã',
27	'ÇáÚäæÇä',
28	'ãÓáÓá',
29	'ÑÞã ÞíÏ',
30	'ÇááÌäÉ',
31	'ÚäæÇä ÇááÌäÉ',
32	'ãä ÌÏÇæá'
33	);
34	$rows=array();
35
36	while ($row=db_fetch_array($result)) {
37	$rows[]=$row;
38	}
39
40	setlocale(LC_ALL,"ar_EG.UTF-8");
41	function my_cmp($a,$b) {
42	return ($a['name'] < $b['name']) ? -1 : 1;
43	}
44	usort($rows,"my_cmp");
45
46	print theme_table($header,$rows,array('cellspacing'=>'5','cellpading'=>'5','border'=>'1px'));
47	} */
48	?>
49	</div>
50
51	<img alt="ÕæÊß ááãÚÇÑÖÉ" src="http://www.manalaa.net:8888/nondp4fk.gif" />