php - calculate average rating from mysql and show it as a graph -

-

please me solve this. in learning phase of php/mysql.

i have php feedback form rating system 1-5. can find form here http://innovatrix.co.in/feedback_priyajit/feedback%20form1.html

every time user provide feedback saves form values mysql database. below database structure.

enter image description here

now want calculate average data of every row (like waiting) , show on php file graph , separate graph every option on same page.

i know can use query select avg(waiting) feedback average of "waiting"

but how can every options same file , show graph. database updated frequently, should reflect graph also.

please me concept achieving this.

below php file using store form values database.

<title>process</title> <?php $host="localhost"; $user_name="pramir_feedback"; $pwd="feedback"; $database_name="pramir_feedback"; $db=mysql_connect($host, $user_name, $pwd); if (mysql_error() > "") print mysql_error() . "<br>"; mysql_select_db($database_name, $db); if (mysql_error() > "") print mysql_error() . "<br>"; $waiting = $_post['radio1']; $consultation = $_post['radio2']; $preoperative = $_post['radio3']; $specialists = $_post['radio4']; $assistants = $_post['radio5']; $painful = $_post['radio6']; $operatingroom = $_post['radio7']; $thought = $_post['radio8']; $recommend = $_post['radio9']; $suggestions = $_post['suggestions']; $query = "insert feedback (waiting, consultation, preoperative, specialists, assistants, painful, operatingroom, thought, recommend, suggestions) values ('" . $waiting . "', '" . $consultation . "', '" . $preoperative . "', '" . $specialists . "', '" . $assistants . "', '" . $painful . "', '" . $operatingroom . "', '" . $thought . "', '" . $recommend . "', '" . $suggestions . "')"; if (mysql_error() > "") print mysql_error() . "<br>"; $qresult = mysql_query($query); echo "<h1>thank submitting details!</h1>"; ?>

if want averages in 1 query, can delimit them commas.

select avg(waiting), avg(consultation), avg(preoperative), avg(specialists), ...... feedback

if want know how put them in graph, take @ 1 of many jquery graph or plot makers, like: http://www.jqplot.com/tests/bar-charts.php


Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more