beautypg.com

Grandstream GXV3140 GMI Guide User Manual

Page 34

background image

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

)

;

?>

$

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

')

"

))

{

print

mysql_errno

()

.

"

:

"

.

mysql_error

()

.

"


";

}

$

sumresult

=

mysql_db_query

(

$

mysqldb

,"

select votes from

$

mysqltable

"

)

;

$

sum

=

(

int

)

mysql_num_rows

(

$

sumresult

)

;

if

(

!$

getval

){

print

"

Thanks for your vote.

\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

;

print

"

The total number of votes:

$

sum

. Your vote percent:

$

percent

%

\n

";

}

}

else

{

print

"

The total number of votes:

$

sum

.

\n

";

}

print

"

style='margin-top:10px;'>

";

print

"

";

print

"

";

for

(

$

i

=

0

;

$

i

<

8

;

$

i

++

){

$

per

=

mysql_db_query

(

$

mysqldb

,"

select votes from

$

mysqltable

where votes=

$

i

"

)

;

$

tempnum

=

(

int

)

mysql_num_rows

(

$

per

)

;

See also other documents in the category Grandstream Communication: