Vani Sweety

hello
i have been writing this piece of code that tahkes values from a javascript file and do som orepation in php
but i am getting an error
:
Parse error: syntax error, unexpected '$Rname' (T_VARIABLE) in C:\xampp\htdocs\vehicle\reviews.php on line 18

<?php $servername = "localhost"; $username = "root"; $password = "vani"; $dbname = "vehiclesdb"; $port = "3306"; $Rname = $_POST['id']; $Rdate = $_POST['yr']; // Create connection $conn = new mysqli($servername, $username, $password, $dbname, $port); // Check connection if ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error); } //retrieve data from database $sql = "SELECT * FROM final_review1 WHERE vehicle='"$Rname"' AND year='"$Rdate"'"; $sql1 = "SELECT * FROM final_review2 WHERE vehicle='"$Rname"' AND year='"$Rdate"'"; $result = $conn->query($sql); $result1 = $conn->query($sql1); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $pos1= $row['pos']; $neg1 = $row['neg']; $tot1 = $row['total']; if ($result1->num_rows > 0) { while($row = $result1->fetch_assoc()) { $pos2=$row['pos']; $neg2 = $row['neg']; $tot2 = $row['total']; //do average ($result & $result1) $positive = ($pos1+$pos2)/2; $negative= ($neg1+$neg2)/2; $total= ($tot1+$tot2)/2; echo "<pre>"; echo "$total"; echo "</pre>"; echo "<pre>"; echo "$positive"; echo "</pre>"; echo "<pre>"; echo "$negative"; echo "</pre>"; } } else{ echo "<pre>"; echo $tot1; echo "</pre>"; echo "<pre>"; echo $pos1; echo "</pre>"; echo "<pre>"; echo $neg1; echo "</pre>"; } } } else{ while($row = $result1->fetch_assoc()) { $pos2=$row['pos']; $neg2 = $row['neg']; $tot2 = $row['total']; //while($row = $result1->fetch_assoc()) { echo "<pre>"; echo $tot2; echo "</pre>"; echo "<pre>"; echo $pos2; echo "</pre>"; echo "<pre>"; echo $neg2; echo "</pre>"; //} } } $conn->close(); ?>

how can i alert the php variables $total, $positive, $negative in the javascript file?

i have included the pre tag in php and it is working correctly
now i have to display it usung javascript
and it is not working

php code
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "vani"; $port = "3307"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname, $port); // Check connection if ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error); } //get data from two table and average them $sql = "SELECT * FROM final_review1 WHERE vehicle='toyota' AND year='4'"; $sql1 = "SELECT * FROM final_review2 WHERE vehicle='toyota' AND year='4'"; $result = $conn->query($sql); $result1 = $conn->query($sql1); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $pos1= $row['pos']; $neg1 = $row['neg']; $tot1 = $row['total']; if ($result1->num_rows > 0) { while($row = $result1->fetch_assoc()) { $pos2=$row['pos']; $neg2 = $row['neg']; $tot2 = $row['total']; $positive = ($pos1+$pos2)/2; $negative= ($neg1+$neg2)/2; $total= ($tot1+$tot2)/2; echo "<pre>"; echo "$total"; echo "</pre>"; echo "<pre>"; echo "$positive"; echo "</pre>"; echo "<pre>"; echo "$negative"; echo "</pre>"; }    } else{ echo "<pre>"; echo $row['total']; echo "</pre>"; echo "<pre>"; echo $row['pos']; echo "</pre>"; echo "<pre>"; echo $row['neg']; echo "</pre>"; } //do average ($result & $result1) } } else{ while($row = $result1->fetch_assoc()) { echo "<pre>"; echo $row['total']; echo "</pre>"; echo "<pre>"; echo $row['pos']; echo "</pre>"; echo "<pre>"; echo $row['neg']; echo "</pre>"; } } //return $result1 $conn->close(); ?>

code in javascript:
function review(){ var hr; if (window.ActiveXObject) {// code for IE6, IE5 try{ hr = new ActiveXObject("Microsoft.XMLHTTP"); }catch(e){ hr = false; } } else {// code for IE7+, Firefox, Chrome, Opera, Safari try{ hr = new XMLHttpRequest(); } catch(e){ hr = false; } } hr.open("POST", "reviewvani.php", true); hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); alert("working");// working till here hr.onreadystatechange = function() { if(hr.readyState == 4 && hr.status == 200) { alert(hr.responseText); } } }

it works but the answer is being concatenated
if in table 1 i have values for total is 15  pos is 20  neg is 5
and in the second table i have values for total is 9  pos is 8  neg is 2

this is what is displaying:
143.512

how can i print each value in different line so that i can perform the average

note that there is only one value for toyota 4 in both table

hello i have write a php code that retrieve data from a database and assign them to a variable
but i am getting this error
help me sort this out please


Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 22

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 22

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 23

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 23

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 24

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 24

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 27

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 27

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 28

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 28

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 29

Notice: Array to string conversion in C:\xampp\htdocs\webpage\reviewvani.php on line 29
000successful

here is the php code:
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "vani"; $port = "3307"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname, $port); // Check connection if ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error); } //get data from two table and average them $sql = "SELECT * FROM final_review1 WHERE vehicle='toyota' AND year='4'"; $sql1 = "SELECT * FROM final_review2 WHERE vehicle='nissan' AND year='5'"; $result = $conn->query($sql); $result1 = $conn->query($sql1); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $pos1= $row.['pos']; $neg1 = $row.['neg']; $tot1 = $row.['total']; if ($result1->num_rows > 0) { while($row = $result1->fetch_assoc()) { $pos2=$row.['pos']; $neg2 = $row.['neg']; $tot2 = $row.['total']; $positive = ($pos1+ $pos2)/2; $negative= ($neg1+$neg2)/2; $total= ($tot1+$tot2)/2; echo "$positive"; echo "$negative"; echo "$total"; }    } //do average ($result & $result1) else{ echo $row.['total']; echo $row.['pos']; echo $row.['neg']; } } } echo "successful"; $conn->close(); ?>

yes
is there any way i can connect python function so that it display on my html page

hello
i have two piece of code
one i have used python to write some function
now i want to display this function on a html webpage
how can i connect python function using javascript on even click
help please

Intead of retrieving the values and displaying them it is displaying successfull

I have pass the parameter but it is giving me an error in php

<br /> <b>Notice</b>: Undefined index: para1 in <b>C:\xampp\htdocs\webpage\cardetails.php</b> on line <b>8</b><br /> successfull

Actually the value of para1 i am getting if from a javascript function
when clicking on a specific item for example clicking on ch in a list it display all the values comtaining this item form database.
Like
chocolate
choke
now when i click on chocloate it should display all the information about chocolate for example the colour.
here is the code for javascript:
function doit(para1){ var hb; if (window.ActiveXObject) {// code for IE6, IE5 try{ hb = new ActiveXObject("Microsoft.XMLHTTP"); }catch(e){ hb = false; } } else {// code for IE7+, Firefox, Chrome, Opera, Safari try{ hb = new XMLHttpRequest(); } catch(e){ hb = false; } } hb.open("POST", "cardetails.php", true); hb.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); hb.onreadystatechange = function() { if(hb.readyState == 4 && hb.status == 200) { value = hb.responseText.split(" ,"); block1 = document.getElementById("showtabledetails"); for(i=0; i<value.length; i++){ cr1 = document.createElement("li"); lin1 = document.createElement("br"); txt1 = document.createTextNode(value[i]); cr1.appendChild(txt1); block1.appendChild(cr1); block1.appendChild(lin1); } document.getElementById("showtable").style.display = "inline"; } } w= "para1"+para1; hb.send(w); }

and here is the code for php:
<?php //load database connection    $host = "localhost";    $user = "root";    $password = "";    $database_name = "vani"; $port = "3307"; $Rname = $_POST['para1']; // Create connection $conn = new mysqli($host, $user, $password, $database_name, $port); // Check connection if ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error); } $sql = "SELECT colour FROM food WHERE name LIKE'$Rname'"; $result = $conn->query($sql); if ($result->num_rows > 0) {    // output data of each row    while($row = $result->fetch_assoc()) {        echo $row["colour"] . " ,";    } } else {    echo "0 results"; } $conn->close(); ?>

Hello
I want to display results from php by using javascript
but i am getting an error

<br />
<b>Notice</b>:  Undefined index: para1 in <b>C:\xampp\htdocs\webpage\cardetails.php</b> on line <b>8</b><br />
successfull


here is my code for javascript:

function car(elId) { var hr;    ab = document.getElementById(elId).id; if (window.ActiveXObject) {// code for IE6, IE5 try{ hr = new ActiveXObject("Microsoft.XMLHTTP"); }catch(e){ hr = false; } } else {// code for IE7+, Firefox, Chrome, Opera, Safari try{ hr = new XMLHttpRequest(); } catch(e){ hr = false; } } hr.open("POST", "model1.php", true); hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); hr.onreadystatechange = function() { if(hr.readyState == 4 && hr.status == 200) { values = hr.responseText.split(" ,"); block = document.getElementById("showcarsul"); for(i=0; i<values.length; i++){ cr = document.createElement("a"); cr.setAttribute('href',"#"); cr.setAttribute("onclick","javascript:doit(this.text);"); lin = document.createElement("br"); txt = document.createTextNode(values[i]); cr.appendChild(txt); block.appendChild(cr); block.appendChild(lin); } document.getElementById("carmodel").style.display = "none"; document.getElementById("showcars").style.display = "inline"; } } v = "sendab="+ab; hr.send(v); } function doit(para1){ var hb; if (window.ActiveXObject) {// code for IE6, IE5 try{ hb = new ActiveXObject("Microsoft.XMLHTTP"); }catch(e){ hb = false; } } else {// code for IE7+, Firefox, Chrome, Opera, Safari try{ hb = new XMLHttpRequest(); } catch(e){ hb = false; } } hb.open("POST", "cardetails.php", true); hb.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); hb.onreadystatechange = function() { if(hb.readyState == 4 && hb.status == 200) { alert(hb.responseText); } } w= para1; hb.send(w); }

and here is my connection to php

<?php //load database connection    $host = "localhost";    $user = "root";    $password = "";    $database_name = "vani"; $port = "3307"; $Rname = $_POST['para1']; // Create connection $conn = new mysqli($host, $user, $password, $database_name, $port); // Check connection if ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error); } $sql = "SELECT colour FROM food WHERE name LIKE'$Rname'"; $result = $conn->query($sql); if ($result->num_rows > 0) {    // output data of each row    while($row = $result->fetch_assoc()) {        echo $row["colour"] . " ,";    } } else {    echo "0 results"; } $conn->close(); ?>

hello everyone
i really need help for my project
i have a database for car
i am using javascript and php to access the database
upon click a list is displayed and i have use javascipt onclick to implement this. Now
i have to make a search according to its id to go fetch the value which has this id and display the available car version

after displaying the list of car version which is a dynamic list
obtain from the database, the user has to be able to click
the version listed so that all the details according to this version are displayed.

Can anyone suggest me how to proceed with this please.

This is a piece of code  so far
Javascript

function a1() { document.getElementById("malfaromeo").style.display = "inline"; document.getElementById("maudi").style.display = "none"; document.getElementById("maustin").style.display = "none"; document.getElementById("mbmw").style.display = "none"; document.getElementById("mchevrolet").style.display = "none"; document.getElementById("mcitroen").style.display = "none"; document.getElementById("mcooper").style.display = "none"; document.getElementById("mdaewoo").style.display = "none"; document.getElementById("mdaihatsu").style.display = "none"; document.getElementById("mds").style.display = "none"; document.getElementById("mfiat").style.display = "none"; document.getElementById("mford").style.display = "none"; document.getElementById("mgmw").style.display = "none"; document.getElementById("mhino").style.display = "none"; document.getElementById("mhonda").style.display = "none"; document.getElementById("mhynudai").style.display = "none"; document.getElementById("misuzu").style.display = "none"; document.getElementById("mjaguar").style.display = "none"; document.getElementById("mjmc").style.display = "none"; document.getElementById("mkia").style.display = "none"; document.getElementById("mlandrover").style.display = "none"; document.getElementById("mmahindra").style.display = "none"; document.getElementById("mmazda").style.display = "none"; document.getElementById("mmercedes").style.display = "none"; document.getElementById("mmercedesbenz").style.display = "none"; document.getElementById("mmitsubishi").style.display = "none"; document.getElementById("mmini").style.display = "none"; document.getElementById("mnissan").style.display = "none"; document.getElementById("mopel").style.display = "none"; document.getElementById("mperodua").style.display = "none"; document.getElementById("mpeugeot").style.display = "none"; document.getElementById("mporsche").style.display = "none"; document.getElementById("mproton").style.display = "none"; document.getElementById("mrenault").style.display = "none"; document.getElementById("mrangerover").style.display = "none"; document.getElementById("msubaru").style.display = "none"; document.getElementById("msuzuki").style.display = "none"; document.getElementById("mtoyota").style.display = "none"; document.getElementById("mvolkswagen").style.display = "none"; }

function car(elId) { var hr;    ab = document.getElementById(elId).id; if (window.ActiveXObject) {// code for IE6, IE5 try{ hr = new ActiveXObject("Microsoft.XMLHTTP"); }catch(e){ hr = false; } } else {// code for IE7+, Firefox, Chrome, Opera, Safari try{ hr = new XMLHttpRequest(); } catch(e){ hr = false; } } hr.open("POST", "model1.php", true); hr.setRequestHeader("Content-type", "application/x-www-form-urlencoded"); hr.onreadystatechange = function() { if(hr.readyState == 4 && hr.status == 200) { alert(hr.responseText); } } v = "sendab="+ab; hr.send(v); }

this is my php code

<?php //load database connection    $host = "localhost";    $user = "root";    $password = "vani";    $database_name = "food";    $port = "3306"; $Rname = $_POST['sendab']; // Create connection $conn = new mysqli($host, $user, $password, $database_name, $port); // Check connection if ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error); } $sql = "SELECT name FROM start WHERE name='$Rname'"; $result = $conn->query($sql); if ($result->num_rows > 0) {    // output data of each row    while($row = $result->fetch_assoc()) {        echo $row["name"];    } } else {    echo "0 results"; } $conn->close(); ?>

and here is where it is found in my html

<li id="click" onclick="a36()">Subaru</li> <li id="click" onclick="a37()">Suzuki</li> <li id="click" onclick="a38()">Toyota</li> <li id="click" onclick="a39()">Volkswagen</li> </ul> </div> <div id= "carmodel"> <ul id="malfaromeo" hidden> </br> </br> </br> </br> <li id="alfaromeo4c" onclick="car(this.id)">4C</li> <li id="alfaromeoGiulietta" onclick="car(this.id)">Giulietta</li> </ul> <ul id="maudi" hidden> </br> </br> </br> </br> <li id="audiA1" onclick="car(this.id)">A1</li> <li id="audiA3" onclick="car(this.id)">A3</li> <li id="audiA4" onclick="car(this.id)">A4</li> <li id="audiA5" onclick="car(this.id)">A5</li> <li id="audiA6" onclick="car(this.id)">A6</li> <li id="audiA7" onclick="car(this.id))">A7</li>

can you suggest me a link from where i can have an overview of how the urlwatch works so that i can implement it in my python program

hello
i have been using python with pycharm
i have extrated some information from a website
and included them in a database. Now if this website has made some
changes i want to retrieve these changes only
how can i monitor a website automatically using python and pycharm
how to i use urlwatch

who can brief me about data mining
infact i have a project to do about data mining
its about comparing car features
like taking information from different websites and display it in another websites allowing user to compare car features like model, prices...
an example (phone arena where we compare mobile phones)
please help