Grandstream GXV3140 GMI Guide User Manual
Page 34
Grandstream Networks, Inc.
GMI HTML SDK and API Guide
Page 34 of 43
www.grandstream.com
Last Updated: 09/2010
`votes` INT( 4 ),
PRIMARY KEY ( `name` )
)
';
mysql_query
(
$
sql
,
$
conn
)
;
}
mysql_free_result
(
$
result
)
;
?>
<?php
$
selvalue
=
$
_POST
[
"
myvote
"
]
;
$
getval
=
$
_GET
[
"
vote
"
]
;
$
name
=
mt_rand
()
;
if
(
$
selvalue
!=
""
||
$
getval
==
1
){
mysql_pconnect
(
$
mysqlserver
,
$
mysqluser
,
$
mysqlpass
)
;
if
(
!
mysql_db_query
(
$
mysqldb
,"
insert into
$
mysqltable
values
('
$
name
','
$
selvalue
')
"
))
{
mysql_errno
()
.
"
:
"
.
mysql_error
()
.
"
<BR>
";
}
$
sumresult
=
mysql_db_query
(
$
mysqldb
,"
select votes from
$
mysqltable
"
)
;
$
sum
=
(
int
)
mysql_num_rows
(
$
sumresult
)
;
if
(
!$
getval
){
"
<p>Thanks for your vote.</p>
\n
";
$
result
=
mysql_db_query
(
$
mysqldb
,"
select votes from
$
mysqltable
where votes=
$
selvalue
"
)
;
if
(
$
result
){
$
num
=
(
int
)
mysql_num_rows
(
$
result
)
;
$
per
=
round
(
$
num
/$
sum
,
3
)
;
$
percent
=
$
per
*
100
;
"
<p>The total number of votes:
$
sum
. Your vote percent:
$
percent
%</p>
\n
";
}
}
else
{
"
<p>The total number of votes:
$
sum
.</p>
\n
";
}
"
<table width='100%' border='0' cellspacing='0' cellpadding='0'
style='margin-top:10px;'>
";
"
<tr><td width='450'>
";
"
<table width='420' border='0' cellspacing='0' cellpadding='0'>
";
for
(
$
i
=
0
;
$
i
<
8
;
$
i
++
){
$
per
=
mysql_db_query
(
$
mysqldb
,"
select votes from
$
mysqltable
where votes=
$
i
"
)
;
$
tempnum
=
(
int
)
mysql_num_rows
(
$
per
)
;