i'm using php & mysql.
i want retrieve records table in database , print them pdf file.
i write code retrieves first record in table , not retrieved other records.
here code:
<?php $con = mysql_connect("localhost","root","") or die("failed connect server: " . mysql_error()); mysql_select_db("users") or die("failed connect database: " . mysql_error()); $query = mysql_query("select * reservations"); $numrows = mysql_num_rows($query); if($numrows > 0) { while($result = mysql_fetch_assoc($query)) { $db_id = $result['id']; $db_fname = $result['fname']; $db_lname = $result['lname']; $db_email = $result['email']; $db_phone = $result['phone']; $db_day = $result['day']; $db_time = $result['time']; $db_cartype = $result['car_type']; $db_carcolor = $result['car_color']; $db_carmodel = $result['car_year']; $db_carno = $result['car_no']; $db_problem = $result['problem']; $db_status = $result['status']; $db_remtime = $result['remaining_time']; $db_cost = $result['cost']; $db_payment = $result['payment']; $db_date = $result['date']; require("fpdf/fpdf.php"); $pdf = new fpdf(); $pdf->addpage(); $pdf->setfont("arial","b","15"); $pdf->cell(0,10,"freedom car: total reservations",1,1,"c"); $pdf->image("porchue.jpg"); $pdf->setfont("arial","","10"); $pdf->write(5,"id: $db_id\n"); $pdf->write(5,"first name: $db_fname\n"); $pdf->write(5,"last name: $db_lname\n"); $pdf->write(5,"email address: $db_email\n"); $pdf->write(5,"phone number: $db_phone\n"); $pdf->write(5,"reserved day: $db_day\n"); $pdf->write(5,"reserved time: $db_time\n"); $pdf->write(5,"car type: $db_cartype\n"); $pdf->write(5,"car color: $db_carcolor\n"); $pdf->write(5,"car model: $db_carmodel\n"); $pdf->write(5,"car number: $db_carno\n"); $pdf->write(5,"car problem: $db_problem\n"); $pdf->write(5,"car status: $db_status\n"); $pdf->write(5,"remaining time: $db_remtime\n"); $pdf->write(5,"total cost: $db_cost\n"); $pdf->write(5,"payment method: $db_payment\n"); $pdf->write(5,"reservation date: $db_date\n\n"); $pdf->output(); } } else echo "<h4>sorry, no reservations @ time.</h4>"; ?>
firstly need create array , set data array after make $pdf->write(); comment work. cannot write because data in while.
while($result = mysql_fetch_assoc($query)) { // create array or call data here ! } // use forachone array main kame loop , start code. it retrieves first record because need data set once ! writepdf commant in while loop retrieves first data , cannot pass data.
