zetastreak
-
Content Count
16 -
Joined
-
Last visited
-
import csv in mysql db using ajax and php
zetastreak replied to zetastreak's topic in PHP Coding Help
sure! will work on it, this will enable me to use ajax calls in subjectwise google charts too -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
yea while re-writing my line numbers got changed '-' . well relating to line numbers in your snippet the error was at line 40. -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
Rewriting the function did the thing, you were right! there were hidden characters lurking around only this timme while rewriting it i missed ; in $opts .= "<option>{$s['name']}</option>\n"; that's why i was getting Parse error: syntax error, unexpected '}' on line 35 finally got it working. Thank you for helping me -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
did that, re-wrote the whole function again still getting the error but now it's Parse error: syntax error, unexpected '}' on line 35 -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
well tried this too , error still persists atm , it's exactly your modified code in my files. reading through error documentations if i could find something -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
@Barand i think it's because of the query not being able to execute correctly. i copy pasted your code and modified required parameters still issue persists. can you post your db_inc.php? -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
function nameOptions($connect) { $query = "SELECT DISTINCT name FROM csv ORDER BY name DESC "; $statement = $connect->query($query); $opts = ' '; foreach ($statement as $s) { $opts .= "<option>{$s['name']}</option>\n"; } return $opts; } here ,it's the same as yours -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
I've thoroughly checked the whole file for missing ; i found none still the error persists -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
That's a really optimised way of doing this. thanks for that! I owe you for this project! .-. i modified my code to the same but for some odd reason i'm getting Parse error: syntax error, unexpected '$opts' (T_VARIABLE) in charts.php on line 37 i've checked for unclosed semi-colons there are none -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
@Barand Well first of all many thanks to you for sharing your methods and improving my knowledge regarding these topics and other small issues. I adjusted my code accordingly with your specified edits, but i still get blank page i think i'm still having issues with parsing json data. And Thanks again for those extra efforts you made -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
sure i'll go through the process -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
@gizmola Yes i've checked everything, i'm not getting any errors -
Creating Google Charts with dynamic data
zetastreak replied to zetastreak's topic in PHP Coding Help
@Barand yes mate ._.' it's my first project which involves such use of queries sorry about that. thanks for pointing it out , i made the required changes in the query and the charts still won't load i always get blank page -
i've to populate google charts with dynamic data. the data looks llike. +----+-------+---------+-------+-----------+---------+------+ | id | name | physics | maths | chemistry | biology | sst | +----+-------+---------+-------+-----------+---------+------+ | 1 | Name1 | 10 | 25 | 35 | 42 | 62 | | 2 | Name2 | 80 | 45 | 45 | 45 | 25 | | 3 | Name3 | 63 | 25 | 63 | 36 | 36 | | 4 | Name4 | 82 | 36 | 75 | 48 | 42 | | 5 | Name5 | 45 | 45 | 78 | 25 | 24 | | 6 | Name6 | 36 | 36 | 15 | 75 | 36 | | 7 | Name7 | 99 | 45 | 24 | 24 | 45 | | 8 | Name8 | 45 | 85 | 85 | 85 | 96 | +----+-------+---------+-------+-----------+---------+------+ i have to create google charts based on this such that # namewise - such that when i select a name it displays all subject marks of that particular name in a column chart #markswise - when i select a subject, it displays all the names with marks in that particular subject. conisdiering that data may be added and i've to accumulate that also, for namewise i did // chart.php <?php include("connection.php"); $query = "SELECT name FROM csv GROUP BY name DESC"; $statement = $connect->prepare($query); $statement->execute(); $result = $statement->fetchAll(); ?> <!DOCTYPE html> <html> <head> <title>Google charts</title> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <script src="https://code.jquery.com/jquery-1.12.4.js"></script> </head> <body> <br /><br /> <div class="container"> <div class="panel panel-default"> <div class="panel-heading"> <div class="row"> <div class="col-md-9"> <h3 class="panel-title">Student Wise Marks Data</h3> </div> <div class="col-md-3"> <select name="name" class="form-control" id="name"> <option value="">Select Student</option> <?php foreach($result as $row) { echo '<option value="'.$row["name"].'">'.$row["name"].'</option>'; } ?> </select> </div> </div> </div> <div class="panel-body"> <div id="chart_area" style="width: 1000px; height: 620px;"></div> </div> </div> </div> </body> </html> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {packages: ['corechart', 'bar']}); google.charts.setOnLoadCallback(); function load_student_data(name, title) { var temp_title = title + ' '+name+''; $.ajax({ url:"fetch.php", method:"POST", data:{name:name}, dataType:"JSON", success:function(data) { drawStudentwiseChart(data, temp_title); } }); } function drawStudentwiseChart(chart_data, chart_main_title) { var jsonData = chart_data; var data = new google.visualization.DataTable(); data.addColumn('number', 'Physics'); data.addColumn('number', 'Maths'); data.addColumn('number', 'Chemistry'); data.addColumn('number', 'Biology'); data.addColumn('number', 'SST'); $.each(jsonData, function(i, jsonData){ var Physics = jsonData.Physics; var Maths = jsonData.Maths; var Chemistry = jsonData.Chemistry; var Biology = jsonData.Biology; var SST = jsonData.SST; data.addRows([[Physics,Maths,Chemistry,Biology,SST]]); }); var options = { title:chart_main_title, hAxis: { title: "Subjects" }, vAxis: { title: 'Percentage' } }; var chart = new google.visualization.ColumnChart(document.getElementById('chart_area')); chart.draw(data, options); } </script> <script> $(document).ready(function(){ $('#name').change(function(){ var name = $(this).val(); if(name != '') { load_student_data(name, 'Student wise marks data'); } }); }); </script> and in order to fetch data // fetch.php <?php //fetch.php include('connection.php'); if(isset($_POST["name"])) { $query = " SELECT * FROM csv WHERE name = '".$_POST["name"]."' ORDER BY id ASC "; $statement = $connect->prepare($query); $statement->execute(); $result = $statement->fetchAll(); foreach($result as $row) { $output[] = array( 'Physics' => $row["Physics"], 'Maths' => $row["Maths"], 'Chemistry' => $row["Chemistry"], 'Biology' => $row["Biology"], 'SST' => $row["SST"], ); } echo json_encode($output); } ?> it diplays a blank page. however when i play with singular values i.e one subject at a time it displays fine
-
import csv in mysql db using ajax and php
zetastreak replied to zetastreak's topic in PHP Coding Help
Thanks For the help Barand, pointing out the index errors, i have similiar csv files that are given to me as a part of the project with exact same format . (first 9 rows are blank) and i've to escape them so they don't insert null values. i tried using fgetcsv function and other methods using loops and continue statements however they break the ajax call and nothing happens. p.s. i'll make the switch to PDO.