Raadha

my php code is working and is giving an output.. but the pie chart (html part) is not working.. can anyone help me solve this?? <?php $con=mysqli_connect("localhost","root","","test"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } if(isset($_POST['pie1'])) { $to= $_POST['to']; $from= $_POST['from']; $query = mysqli_query($con,"SELECT COUNT(mrd),del …

can any one help me.. how to export a table echoed in php to an excel through a button ??

i have a result of say.. 6 records.. fectched from db. each containing values a 10 b 20 c 10 a 30 c 50 a 05 i need to get printed as a 45 b 20 c 60 how to get the distinct results with the sum in the next …

what i need is a single set of output for each procedures, but my this query is giving me 2-3 sets of answers, between this time period.. i need distinct set of answers.. if(isset($_POST['submit'])) { $to= $_POST['to']; $too = date("d/m/y",strtotime($_POST['to'])); $from= date('Y-m-d');; echo " <br><h2> PROCEDURE REPORTS UPTO <b>'$too' </b> …

i have a database 'phar' which need to subract its values 'stk' through the request made and gets updated to the db. i used arrays to do subraction.. but not able to store back the values to the db in its position.. my calculations work perfect, but not able to …

<?php $con=mysqli_connect("localhost","root","","trial"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } if(isset($_POST['submit'])) { $billno=$_POST['billno']; $doa=$_POST['doa']; $dod=$_POST['dod']; $dbcd=$_POST['dbcd']; $acno=$_POST['acno']; $dosub=$_POST['dosub']; $suby=$_POST['suby']; $dop=$_POST['dop']; $credate=$_POST['credate']; $paytype=$_POST['paytype']; $sql="UPDATE cust SET doa ='$doa', dod = '$dod', dbcd='$dbcd', acno='$acno', dosub='$dosub', suby='$suby', dop='$dop', credate='$credate' ** WHERE billno = '$billno'";** print $sql; if (!mysqli_query($con,$sql)) …

<?php $con=mysqli_connect("localhost","root","","trial"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } echo "<table border='1' style='border-collapse: collapse;border-color: silver;'>"; echo "<tr style='font-weight: bold;'>"; echo "<td width='200' align='center'>Customer</td><td width='200' align='center'>Amount</td>"; echo "</tr>"; if(isset($_POST['submit'])) { $custype = $_POST['custype']; $from = $_POST['from']; $to = $_POST['to']; echo "<br><br>"; echo " <h2> Grand …

<?php $con=mysqli_connect("localhost","root","","trial"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } if(isset($_POST['submit'])) { $day = $_POST['day']; { $result = mysqli_query($con,"SELECT * FROM cust WHERE DATE(day)= '$day'");} while($row=mysqli_fetch_array($result)) { echo " <br><br><h2> EDIT Record of " . $row['name'] . " for the day " .$row['day'] . "</h2>"; …

Please i need someone who can help me Display Date from Mysql which is in format YYYY/MM/DD to DD/MM/YYYY the code below sends data to mysql but when i`m displaying date it comes in YYYY/MM/DD. [code] <?php include"config.php"; $comment=$_POST['comment']; $news_id=$_POST['news_id']; $name=$_POST['name']; //$rece_user=$_POST['rece_user']; $query="INSERT INTO newscomment (name,news_id,time,comment,date) VALUES('$name','$news_id',CURTIME(),'$comment',CURDATE())"; $result=mysql_query($query); if($result){ //echo"<i><b><font …