Forum SIMSON JAWA ROMET (!!) Strona Główna
->
top lista
Napisz odpowiedź
Użytkownik
Temat
Treść wiadomości
Emotikony
Więcej Ikon
Kolor:
Domyślny
Ciemnoczerwony
Czerwony
Pomarańćzowy
Brązowy
Żółty
Zielony
Oliwkowy
Błękitny
Niebieski
Ciemnoniebieski
Purpurowy
Fioletowy
Biały
Czarny
Rozmiar:
Minimalny
Mały
Normalny
Duży
Ogromny
Zamknij Tagi
Opcje
HTML:
NIE
BBCode
:
TAK
Uśmieszki:
TAK
Wyłącz BBCode w tym poście
Wyłącz Uśmieszki w tym poście
Kod potwierdzający: *
Wszystkie czasy w strefie EET (Europa)
Skocz do:
Wybierz forum
motorowery
----------------
Simson
Jawa
Romet Ogar
Romet Komar
problemy
----------------
problemy
sklepik
----------------
Kupię
sprzedam
zamienię
wasze
----------------
wasze motorowery
top lista
wasze motocykle
motocykle
----------------
motocykle
Przegląd tematu
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline"> <tr> <th class="thCornerL" width="22%" height="26">Autor</th> <th class="thCornerR">Wiadomość</th> </tr> <tr> <td width="22%" align="left" valign="top" class="row1"><span class="name"><a name=""></a><b>qingsuanhy</b></span></td> <td class="row1" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="http://picsrv.fora.pl/xeon/images/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="postdetails">Wysłany: Nie 9:02, 30 Sty 2011<span class="gen"> </span> Temat postu: spyder jacket Statistical View of Data in a Cluste</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">The inner-most loop iterates through every student��s name.? It calls the function Collect_Data(..) and stores it in five arrays:??? $student_name[], $program[], $subject[], $student_data[], and $student_dt.? It too stores their amount in variable $sum.? From dividing $student_data along $sum, we can calculate the ratio. The length of the picture is determined according to this percentile.? Also, an smart code is used to draw a new bar each period.? Then, using this file, it draws the bar chart whereupon. Display the information in tabular format at iterating and retrieving data from the on 5 arrays. Third part terminates the table. This part purges the on 5 arrays. This is important in that whether array size is smaller in the afterward iteration, the before data may be written. <br /><select name="sel_month_from"> <br /> <?php <br /> for ($i = 1; $i < 10 ; $i++) <br /> echo "<option value=0".$i.">" . $months[$i] . "</option>"; <br /> for ($i = 10; $i < 13; $i++) <br /> echo "<option value=".$i.">" . $months[$i] . "</option>"; <br /> php?> <br /> </select> <br />Processing time is calculated based on the retinue code: <br />If both dates are correct, then range of the date is stored in the $msg variable. <br />The processing code is mobilized in such a course that it needs 3 laired FOR loops.? You can mushroom alternatively dwindle them apt add/drop a new dimension. <br />for ($c=0; $c < $total_counts_program_id; $c++) <br />{ <br /> for ($b=0; $b < $total_counts_subject_id; $b++) <br /> { <br />// Collection of Data <br /> for ($a=0; $a < $total_counts_student_id; $a++) <br /> <br /> Collect_Data($sel_id[$a] , $sel_program_id[$c] , $sel_subject_id[$b]); <br /> // end of the sel_id loop <br />$total_counts_student_id = count($sel_id);?? <br />$total_counts_program_id = count($sel_program_id);?? <br />$total_counts_subject_id = count($sel_subject_id); <br />The above variables have been affirmed global so that their values can be accessed outdoor this consumer defined function; otherwise, they would convert regional variables, thus rendering them out of range. <br />if ($sum > 0)? // if data found? ... <br /> {??? <br />// Draw Graph???????????? <br /> $total_counts = count($student_data); <br /> for ($i=0; $i < $total_counts; $i++) <br /> ??? <br /> $bar_width = multi_factor * ( (100 * $student_data[$i] ) / $sum );????? <br /> $bar = ($i % bar_counter)."_bar.gif";?? <br /> echo "<tr><td><img src='images/$bar' width=$bar_width? height='10'>?? "; <br /> echo number_format($bar_width/multi_factor , 2, '.', '')."%??? (".$student_name[$i] . " , " . $program[$i] . " , " . $subject[$i] . ")</td></tr>";? ?? <br />// Display Data in Tabular Format??? <br /> echo "<tr><td><table border=1 bordercolor=blue>"; <br /> echo "<tr><th>Name</th><th>Program</th><th>Subject</th> <th>Marks</th><th>Date</th></tr>"; <br /> for ($i = 0; $i < $total_counts; $i++) <br /> { <br /> echo "<tr><td>" . $student_name[$i] . "</td><td>" . $program[$i] . "</td><td>" . $subject[$i] . "</td>"; <br /> if (isset($student_data[$i]) )? echo "<td>" . $student_data[$i] . "</td>"; <br /> another??????????????????????????? echo "<td>Not Taken</td>"; <br /> echo "<td>" . formate_date($student_dt[$i]) . "</td></tr>"; <br /> } <br /> echo "</table></td></tr>";??? $x = 0; $sum = 0;? echo "<tr><td><hr></td></tr>";? <br /> for ($i=0; $i < $total_counts; $i++)? /// purge the array ... better to purge all the arrays..... <br /> array_pop($student_data); <br /> <br /> <br /><?php <br />$months = array (1=>"January" ,<a href="http://www.spyderskiwearsale.com/" target="_blank" class="postlink">spyder jacket</a>, "February" , "March" , "April" , "May" , "June" , "July" , "August" , "September" , "October" , "November" , "December"); <br />php?> <br />$dt_from = $sel_year_from . $sel_month_from . $sel_day_from; <br />$dt_to?? = $sel_year_to . $sel_month_to . $sel_day_to; <br /> $dt_valid = "False"; <br />$back = "<a rel="nofollow" onclick="javascript:_gaq.push(['_trackPageview',<a href="http://www.allshoesstore.com/" target="_blank" class="postlink">cheap Alife shoe</a>, '/outgoing/article_exit_link']);" href="" onclick="history.back()">Back</a>"; <br /> if ( !(checkdate(intval($sel_month_from) , intval($sel_day_from) ,? <br /> $sel_year_from)) ) <br /> $msg = "<font color=red>Invalid From Date...</font>"; <br /> elseif ( !(checkdate(intval($sel_month_to) , intval($sel_day_to) , <br /> $sel_year_to)) ) <br /> $msg = "<font color=red>Invalid To Date...</font>"; <br /> else <br /> <br /> $msg = formate_date($sel_year_from."-".$sel_month_from."-".$sel_day_from) . " ---- " . <br /> formate_date($sel_year_to."-".$sel_month_to."-".$sel_day_to); <br /> $dt_valid = "True"; <br /> <br /> <br />The stop of code above stores the date (from) and date (to) in two global variables (global variables have their visibility affable inside the user defined funtion). <br /> <br /> <br /> <br /><?php <br /> $query = "select p.id ,<a href="http://www.startupbusinessblog.co.uk/forum/index.php?topic=114775.msg171431#msg171431" target="_blank" class="postlink">supra tk How apt Lose 20 Lbs in 7 Days - Ready, Set, Go!_7767</a>, p.program from programs as p order by p.program"; <br /> $result = mysql_query($query);???? <br /> php?> <br /> <select name= "sel_program_id[]" size = "5"? multiple? style = "background-color: #ffffe8;" > <br /> <?php <br /> while ($row = mysql_fetch_row($result)) <br /> echo "<option value=" . $row[0] . ">" . $row[1] . "</option>";??? <br /> php?> <br /> </select> <br /> <br /> <br /> <br /> <br />For each selected Program List from the input form, it will scan each program and subsequent student data: <br /> <br /> <br /> <br />Students Table <br />$start_time = getmicrotime(); <br />$time_diff = (float)(getmicrotime() - $start_time); <br />reverberate "<tr><td colspan=6><i>Processing Time:- " . number_format($time_diff , 3,'.','') . " Seconds</i></td></tr>"; <br /> <br />if ( ($total_counts_student_id > 0) && ($total_counts_program_id > 0) && ($total_counts_subject_id > 0) && ($dt_valid == 'True') )? <br />{ <br />echo "<table border=0 cellpadding=0 cellspacing=0 ><caption><h2>Student Marks</h2></caption>"; <br /> <br />So far on our input forms, there are four criteria the user can choose from: <br />Marks Table <br />} <br /> } // end of subject_id loop <br />} // end of program_id loop?? <br />} // end of if <br />SQL statements to build these tables are It’s about time: <br />Programs Table <br />Prerequisites <br />Our interrogate in this function is extracting data from the 4 tables through inner-joins.? You can join more tables as per your requirements. The ask extracts five values, which have been cached in five global arrays. Here, $x is performing as a counter. Every call to this function may increase its value if a record is base. <br /> <br /> <br />$query = "choose s.name , p.program , sb.subject , m.marks , m.entry_date <br /> from students as s inner join marks as m on s.id = m.student_id <br /> inner join programs as p on m.program = p.id <br /> internal combine subjects as sb aboard sb.id = m.subject <br /> where? s.id = $a_no and p.id = $program_id? and sb.id = $subject_id?and m.entry_date >= $dt_from and m.entry_date <=$dt_to " ; <br /> <br /> <br /> <br /> <br /> <br />Next, we initialize three variable for the upper limits of the three nested FOR loops: <br /><?php <br /> $query = "select s.id , s.name from students as s order by s.name"; <br /> $result = mysql_query($query);???? <br /> php?> <br /> <select name= "sel_id[]" size = "10"? multiple? style = "background-color: #ffffe8;" > <br /> <?php <br /> while ($row = mysql_fetch_row($result)) <br /> echo "<option value=" . $row[0] . ">" . $row[1] . "</option>";??? <br /> php?> <br /> </select> <br /> <br />From the three multiple controls more than one choice can be made.? The fourth choice would appear from range of date, which is a unattached choice. <br /> <br /> <br /> Students Programs Subjects Marks <br /> <br />Also, the scope of a date tin be provided as an input from the same page. The code snippet ambition beyond unravel this; it has been reiterated double, once for Date (From) and anew because Date (To). <br /> <br /> <br /> <br /> <br />I shall not go into explaining how these four tables have been populated from the html forms,<a href="http://www.spyderskiwearsale.com/specials.html" target="_blank" class="postlink">spder jacket</a>, as I��m under the impression that this would be a trifling task.? Rather, I shall converge on how the statistical view is created. <br /> <br />$dt_valid serves as a flag.? If it is true, then processing earnings; otherwise, exhibit a pertinent message. We have used our checkdate() function, which returns true or false if the passing contentions are erroneous dates. <br />Statistical view of data in the fashion of a clustered bar chart is somewhat alike to having to select between two attributes of a single thing. However, a real-life circumstance scenario is far more intricate. As in most cases, the position has a lot of entities strongly narrated with each other through E-R diagrams abiding the normalization rules. Moreover, in such cases, data is not merely two-dimensional but, preferably, it may be multi-dimensional. <br /> <br /> <br /> <br /> <br /> student name subject program and range of Date <br /> <br /> <br /> <br /> <br />CREATE TABLE marks ( <br /> id int(11) NOT NULL auto_increment, <br /> student_id int(11) DEFAULT '0' NOT NULL, <br /> program int(11) DEFAULT '0' NOT NULL, <br /> subject int(11) DEFAULT '0' NOT NULL,<a href="http://www.spyderjacketsite.org/" target="_blank" class="postlink">cheap spyder jackets</a>, <br /> marks int(11) DEFAULT '0' NOT NULL, <br /> entry_date date, <br /> PRIMARY KEY (id) <br />); <br /> <br />CREATE TABLE procedures ( <br /> id int(11) NOT NULL auto_increment, <br /> program varchar(255), <br /> PRIMARY KEY (id), <br /> UNIQUE program (program) <br />); <br />Statistical View of Data in a Clustered Bar Chart <br />In this story, I shows us how to go approximately creating a statistical outlook of data, in?the form of a bunched bar chart,<a href="http://www.169video.com/viewthread.php?tid=97478&extra=page%3D1&frombbs=1" target="_blank" class="postlink">spyder jacket channel Two Factors To Consider Before Selecting A Botox Provider_</a>, using PHP and MySQL.? He provides a real-life scenario, onward with accompanying code, to demonstrate how the job can be accomplished. <br />Our input HTML form and associated PHP processing code has been written in such a way that it can be promoted easily. The code snippet for the user input form is composed of three related web controls which pluck the data from three tables. Here, these three controls are web control arrays: <br />You should have Apache web Server with PHP and MySQL escaping.? A just value of perception in PHP is also necessitated. I have provided a zip archive of a demo along with this article. <br />while ($row = mysql_fetch_row($result) ) <br />{ <br /> $student_name[$x] = $row[0];? <br /> $program[$x] = $row[1]; <br /> $subject[$x] = $row[2]; <br /> $student_data[$x] = $row[3];? <br /> $student_dt[$x] =? $row[4]; <br /> <br /> $sum += $row[3]; <br /> $x++; // increment the array counter.... <br />} <br /> <br />Our database is immediately ready to be subjected to actions beneath drawing bar charts. <br />Plotting the clustered bar chart is truly simple, even if we have multi-columned information. The logic is organized to some extent that it can be easily customized according to the requirements.? I have given an fancy how to implement this technique cross multiple tables, particularly in a tightly normalized database. <br />function Collect_Data($a_no , $program_id , $subject_id ) <br />{ <br />global $student_name; <br />global $program; <br />global $subject; <br />global $student_data; <br />global $student_dt; <br />global $sum; <br />global $x; <br />global $dt_from; <br />global $dt_to; <br /><?php $dt_y = intval(date(Y)); php?> <br /> <select name="sel_year_from"> <br /> <?php <br /> for ($i = $dt_y; $i > 2000; $i--) <br /> echo "<option value=" . $i . ">" . $i . "</option>"; <br /> php?> <br /> </select> <br /> </td></tr> <br />echo "<table><tr><td? bgcolor=whitesmoke>" . $msg . "..." . $back . "</td></tr></table>"; <br /> <br />CREATE TABLE students ( <br /> id int(11) NOT NULL auto_increment, <br /> name varchar(100), <br /> PRIMARY KEY (id) <br />); <br /> <br />This is fair a easy way in which to offer more adoptions.? There is quite mini you must do on the processing side.? Also, a new dimension will be processed in your bar chart. <br />The processing PHP code, which is situated in the file statistics_action.php in the aid file , consists of a function named Collect_Data(....) and three FOR loops as the inputs are appearing from three multi-select network controls and one date control. <br />The remaining two web controls are also populated in the same fashion: <br />Let's look by the emulating E-R figure from which we have to present a statistical view (in the form of a clustered bar chart). How can we do this? This article is an venture to explain the solution. <br /> <br /> <br /><tr><td colspan=2 align=center><table border=0> <br /> <tr><td>Date (From)</td> <br /> <td> <br /> <select name="sel_day_from"> <br /> <?php <br /> for ($i = 1; $i < 10 ; $i++) <br /> echo "<option value=0".$i.">" . $i . "</option>"; <br /> for ($i = 10; $i < 32; $i++) <br /> echo "<option value=".$i.">" . $i . "</option>"; <br /> php?> <br /> </select> <br />CREATE TABLE subjects ( <br /> id int(11) NOT NULL auto_increment, <br /> subject varchar(255), <br /> PRIMARY KEY (id),<a href="http://www.canadajacketsale.org/" target="_blank" class="postlink">canada goose jacket</a>, <br /> UNIQUE subject (subject) <br />); <br /> <br /> <br />Subjects Table <br /> <br /> <br /><?php <br /> $query = "select s.id , s.subject from subjects as s array by s.subject"; <br /> $result = mysql_query($query);???? <br /> php?> <br /> <select name= "sel_subject_id[]" size = "5"? multiple? style = "background-color: #ffffe8;" > <br /> <?php <br /> while ($row = mysql_fetch_row($result)) <br /> echo "<option value=" . $row[0] . ">" . $row[1] . "</option>";??? <br /> php?> <br /> </select> <br /> <br />Each of the premier three tables has a one-to-many Relationship with the Marks table. <br />$result = mysql_query($query); <br />An HTML user interface is used to populate all of the four tables. First fill the programs and subjects tables, then populate the students table and in the final,<a href="http://www.allshoesstore.com/specials.html" target="_blank" class="postlink">Cheap Alife Chuck Shoes</a>, give records to the marks table. <br /> <br />The database consists of four tables. <br /> <br />The second-last loop consists of a body with three sections: <br />function getmicrotime() <br /> list($usec,$sec)=explode(" ",microtime()); <br /> return ((float)$usec+(float)$sec); <br /> <br />}? // end of the funciton Collect_Data()....</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" height="1" class="spaceRow"><img src="http://picsrv.fora.pl/xeon/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> </table>
fora.pl
- załóż własne forum dyskusyjne za darmo
xeon Template ©
Digital-Delusion
Powered by
phpBB
© 2001, 2002 phpBB Group
Regulamin
