<code
class
=
"php"
style=
"margin: 0px; padding: 0px; "
>
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>mname</span> =
explode
(<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
','
</span>,<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>moodname</span>);<span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>num</span> =
count
(<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>mname</span>);
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>mpic</span> =
explode
(<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
','
</span>,<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>moodpic</span>);<span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>id</span> = (int)<span
class
=
"php__global"
style=
"margin: 0px; padding: 0px; color: red; "
>
$_GET
</span>[<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'id'
</span>]; <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>query</span> = mysql_query(<span
class
=
"php__string2"
style=
"margin: 0px; padding: 0px; color: fuchsia; "
>
"select * from mood where id=$id"
</span>); <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span> = mysql_fetch_array(<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>query</span>);
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>
if
</span>(<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>){
<span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>total</span> = <span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>[<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood0'
</span>]+<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>[<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood1'
</span>]+<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>[<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood2'
</span>]+<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>[<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood3'
</span>]+<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>[<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood4'
</span>]+
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>[<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood5'
</span>]+<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>[<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood6'
</span>]+<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>[<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood7'
</span>];
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>
for
</span>(<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>i</span>=<span
class
=
"php__number"
style=
"margin: 0px; padding: 0px; color: red; "
>0</span>;<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>i</span>$<span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>num</span>;<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>i</span>++){
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>field</span> = <span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood'
</span>.<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>i</span>; <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>m_val</span> =
intval
(<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>rs</span>[<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>field</span>]); <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>height</span> = <span
class
=
"php__number"
style=
"margin: 0px; padding: 0px; color: red; "
>0</span>; <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>
if
</span>(<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>total</span> && <span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>m_val</span>){
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>height</span>=
round
((<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>m_val</span>/<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>total</span>)*<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>moodpicheight</span>); <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
}
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>arr</span>[] = <span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>
array
</span>(
<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mid'
</span> => <span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>i</span>, <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood_name'
</span> => <span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>mname</span>[<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>i</span>], <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood_pic'
</span> => <span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>mpic</span>[<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>i</span>], <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'mood_val'
</span> => <span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>m_val</span>, <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
<span
class
=
"php__string1"
style=
"margin: 0px; padding: 0px; color: purple; "
>
'height'
</span> => <span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>height</span> <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
);
}
<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>
echo
</span> json_encode(<span
class
=
"php__keyword"
style=
"margin: 0px; padding: 0px; color: navy; font-weight: bold; "
>$</span><span
class
=
"php__variable"
style=
"margin: 0px; padding: 0px; color: rgb(64, 64, 194); "
>arr</span>); <span
class
=
"php__com"
style=
"margin: 0px; padding: 0px; color: green; "
>
}
</code>