|
PHP - Error Getting And Using A String From A Database With Fpdf
Hi,
I'm creating a PDF document using the FPDF library. All is fine, using a sample image that came with the library. However, I need to get the data for the PDF from a database. The data's fine - the query is performed and the data prints out as I need. However, there's one line which takes a value which is a filepath. When I put that into the following line, I get an error from FPDF: Code: $this->Image($row['imgpath'],10,10,190); Error produced: FPDF error: Image file has no extension and no type was specified: However, if I print out the value of $row['imgpath'] and manually insert it into the code as follows, it works fine: Code: $this->Image('../assets/images/products/5777A.jpg',10,10,190); I've come across this problem once before but can't for the life of me remember what the solution was. It was something to do with how I was reading the value into the code, I think. Can anyone jog my memory, please?? Similar Tutorialshi, i'm using the fpdf library to generate PDF's from form input. It all worked well on my local host, but now that i have transferred to a web server it displays the following error when trying to generate a PDF. Warning: require(/fpdf16/fpdf.php) [function.require]: failed to open stream: No such file or directory in /home/ddgq0o2n/public_html/quote_builder/pdf.php on line 2 Fatal error: require() [function.require]: Failed opening required '/fpdf16/fpdf.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/ddgq0o2n/public_html/quote_builder/pdf.php on line 2 i have searched for "include_path", but can't find it anywhere. i'm thinking it's a server problem, where the library may not be compatible or something needs to be switched on, as it worked fine on my local host. any help and suggestions welcome thanks. This topic has been moved to Other Libraries and Frameworks. http://www.phpfreaks.com/forums/index.php?topic=357017.0
In PHP Version 8.0 shows error as : In previous versions of PHP it does not show any error. Please resolve the issue. Hello , I have a made a PHP website where users signup and send their Date of Birth and gets an OTP on their email after signup. The OTP is recieved but when we enter the OTP this problem occurs QuoteError! Something went wrong and I am facing this error in the error log QuotePHP Fatal error: Uncaught Error: Object of class DateTime could not be converted to string This is my config.php code
<?php
session_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Confirmation Page - Kanha Stories</title>
<style>
body
{
background-color: #330000;
background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='100%25' height='100%25' viewBox='0 0 800 400'%3E%3Cdefs%3E%3CradialGradient id='a' cx='396' cy='281' r='514' gradientUnits='userSpaceOnUse'%3E%3Cstop offset='0' stop-color='%23D18'/%3E%3Cstop offset='1' stop-color='%23330000'/%3E%3C/radialGradient%3E%3ClinearGradient id='b' gradientUnits='userSpaceOnUse' x1='400' y1='148' x2='400' y2='333'%3E%3Cstop offset='0' stop-color='%23FA3' stop-opacity='0'/%3E%3Cstop offset='1' stop-color='%23FA3' stop-opacity='0.5'/%3E%3C/linearGradient%3E%3C/defs%3E%3Crect fill='url(%23a)' width='800' height='400'/%3E%3Cg fill-opacity='0.4'%3E%3Ccircle fill='url(%23b)' cx='267.5' cy='61' r='300'/%3E%3Ccircle fill='url(%23b)' cx='532.5' cy='61' r='300'/%3E%3Ccircle fill='url(%23b)' cx='400' cy='30' r='300'/%3E%3C/g%3E%3C/svg%3E");
background-attachment: fixed;
background-size: cover;
padding: 20px;
width: 100vw;
height: 100vh;
display: flex;
align-items: center;
justify-content: center;
color:#ffffff;
overflow-x: hidden;
}
.cont
{
padding: 20px 40px;
position: relative;
border-right: 4px solid rgb(184, 182, 182);
border-bottom: 4px solid rgb(184, 182, 182);
border-radius: 15px;
display: flex;
flex-direction: column;
align-items: center;
}
#left{
float: left;
}
#right{
float: right;
}
input{
margin: 10px 0px;
}
s{
padding: 5px;
}
.error{
padding: 5px;
color: #ffffff;
}
.resend{
color: rgb(14, 14, 196);
padding: 5px;
}
.s:hover{
cursor: pointer;
background-color:gray;
color: rgb(243, 237, 237);
border-radius: 5px;
}
</style>
</head>
<body>
<?php
$code="";
$err="";
$error="";
if(($_SERVER["REQUEST_METHOD"]=="GET" && $_SESSION['xyz'] === 'xyz') || isset($_POST['verify']) || isset($_POST['resend']))
{
unset($_SESSION["xyz"]);
if($_SERVER["REQUEST_METHOD"] ==="POST")
{
if(isset($_POST['verify']))
{
if(empty($_POST['code']))
{
$err="Enter the code!";
}
else
{
$code=$_POST['code'];
if(password_verify($code,$_SESSION['code']))
{
$name=$_SESSION['name'];
$email=$_SESSION['email'];
$tel=$_SESSION['tel'];
$dob=$_SESSION['dob'];
$password=$_SESSION['password'];
$age_category=$_SESSION['age_category'];
require_once('./all_utils/connection.php');
$sql="INSERT INTO identity_table(name,email,password,tel,dob,age_category) VALUES ('$name','$email','".$password."','$tel','$dob','$age_category')";
if(mysqli_query($conn,$sql) === TRUE)
{
unset($_SESSION["name"]);
unset($_SESSION["password"]);
unset($_SESSION["dob"]);
unset($_SESSION["tel"]);
unset($_SESSION["age_category"]);
header("location:welcome/welcome.php");
}
else
{
$err="Error! Something went wrong";
}
}
else
{
$err="Incorrect code!";
}
}
}
elseif(isset($_POST['resend']))
{
require_once('./all_utils/mail.php');
$error="OTP has been sent again!";
}
}
}
else{
header("location:signup.php");
}
?>
<div class="cont">
<h2> Email Verification</h2>
<form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="POST">
<label for="verification">Enter the 5 digit code</label>
<br/>
<p> Didn't got the mail? Please check your spam folder </p>
<input type="text" name="code" placeholder="Eg. 12345" value="<?php echo $code; ?>">
<br/>
<div class="error"><?php echo $err; ?></div>
<div class="resend"><?php echo $error;?></div>
<input type="submit" name="resend" class="s" id="left" value="Resend OTP">
<input type="submit" name="verify" class="s" id="right" value="Verify">
</form>
</div>
</body>
</html>
This is my signup.php code
<?php
session_start();
if(!empty($_SESSION['email']))
{
require_once('./all_utils/connection.php');
$query="SELECT * FROM identity_table WHERE email='".$_SESSION['email']."'";
$result=mysqli_query($conn,$query);
if(mysqli_fetch_assoc($result))
{
header("location:welcome/welcome.php");
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>SignUp - Kanha Stories</title>
<style>
* {
margin: 0;
padding: 0;
}
body {
width: 100vw;
height: 100vh;
display: flex;
align-items: center;
background-color: #ff9d00;
background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='100%25' height='100%25' viewBox='0 0 1600 800'%3E%3Cg stroke='%23000' stroke-width='66.7' stroke-opacity='0' %3E%3Ccircle fill='%23ff9d00' cx='0' cy='0' r='1800'/%3E%3Ccircle fill='%23f27d00' cx='0' cy='0' r='1700'/%3E%3Ccircle fill='%23e55f00' cx='0' cy='0' r='1600'/%3E%3Ccircle fill='%23d84400' cx='0' cy='0' r='1500'/%3E%3Ccircle fill='%23cb2c00' cx='0' cy='0' r='1400'/%3E%3Ccircle fill='%23bf1600' cx='0' cy='0' r='1300'/%3E%3Ccircle fill='%23b20300' cx='0' cy='0' r='1200'/%3E%3Ccircle fill='%23a5000e' cx='0' cy='0' r='1100'/%3E%3Ccircle fill='%2398001c' cx='0' cy='0' r='1000'/%3E%3Ccircle fill='%238b0027' cx='0' cy='0' r='900'/%3E%3Ccircle fill='%237e0030' cx='0' cy='0' r='800'/%3E%3Ccircle fill='%23710037' cx='0' cy='0' r='700'/%3E%3Ccircle fill='%2364003b' cx='0' cy='0' r='600'/%3E%3Ccircle fill='%2358003c' cx='0' cy='0' r='500'/%3E%3Ccircle fill='%234b003a' cx='0' cy='0' r='400'/%3E%3Ccircle fill='%233e0037' cx='0' cy='0' r='300'/%3E%3Ccircle fill='%23310030' cx='0' cy='0' r='200'/%3E%3Ccircle fill='%23210024' cx='0' cy='0' r='100'/%3E%3C/g%3E%3C/svg%3E");
background-attachment: fixed;
background-size: cover;
overflow-x: hidden;
}
.cont {
color: #ffffff;
width: 500px;
margin: auto;
}
h2 {
color: #ffffff;
text-align: center;
padding: 1.5px;
}
.error {
text-align: center;
padding: 20px;
font-size: 1rem;
color: rgb(233, 76, 76);
}
form {
font-size: 1.2rem;
/* width: 40%; */
/* margin: auto; */
}
.in{
margin: 5px 0;
}
input {
border: 2px solid white;
padding: 10px;
margin: 5px 0;
font-size: 1rem;
width: 100%;
}
input:hover {
border: 2px solid rgb(228, 81, 81);
cursor: text;
}
p,a{
text-align: center;
font-size: 1rem;
}
a{
color: deepskyblue;
font-size:20px;
}
#s{
text-decoration:none;
border-radius: 12px;
}
#s:hover {
cursor: pointer;
}
a {
text-decoration: none;
}
@media only screen and (max-width: 600px){
.cont{
width: 300px;
}
.error,input{
font-size: 0.8rem;
}
}
@media only screen and (max-width: 400px){
.cont{
width: 70%;
}
h2{
font-size: 1.3rem;
}
a,p{
font-size: 0.7rem;
}
label{
font-size: 1.0rem;
}
input{
padding: 4px;
}
}
</style>
</head>
<body>
<?php
$name="";
$email="";
$tel="";
$dob="";
$err="";
$name_err="";
$email_err="";
$tel_err="";
$dob_err="";
$password_err="";
if($_SERVER["REQUEST_METHOD"]=="POST")
{
if(isset($_POST['signup']))
{
if(empty($_POST['name']) || empty($_POST['dob']) || empty($_POST['tel']) || empty($_POST['email']) || empty($_POST['password']))
{
if(empty($_POST['name']))
{
$name_err="Name is required!";
}
else{
$name=$_POST['name'];
}
if(empty($_POST['email']))
{
$email_err="Email is required!";
}
else{
$email=$_POST['email'];
}
if(empty($_POST['tel']))
{
$tel_err="Contact Number is required!";
}
else{
$tel=$_POST['tel'];
}
if(empty($_POST['dob']))
{
$dob_err="D.O.B is required!";
}
else{
$dob=$_POST['dob'];
}
if(empty($_POST['password']))
{
$password_err="Password is required!";
}
}
else
{
$today = new DateTime(date('m.d.y'));
$dob = new DateTime($_POST['dob']);
$diff1 = $today->diff($dob);
$age = $diff1->y;
if($age > 15 || $age <3)
{
$dob = $_POST['dob'];
$dob_err = "Age criteria not satisfied , child's age must be between 3-15 years";
}
else
{
require_once("./all_utils/connection.php");
$email=$_POST['email'];
$query="SELECT * FROM identity_table WHERE email='".$email."'";
$result=mysqli_query($conn,$query);
if(mysqli_fetch_assoc($result))
{
$err="Email alredy registered!";
$name=$_POST['name'];
$email=$_POST['email'];
}
else
{
if($age < 7)
{
$_SESSION['age_category'] = '1';
}
else
{
$_SESSION['age_category'] = '2';
}
$_SESSION['name']=$_POST['name'];
$_SESSION['email']=$_POST['email'];
$_SESSION['password'] = password_hash($_POST['password'],PASSWORD_DEFAULT);
$_SESSION['tel']=$_POST['tel'];
$_SESSION['dob']=$_POST['dob'];
$_SESSION['xyz']='xyz';
require_once("all_utils/mail.php");
header("location:conf.php");
}
}
}
}
}
?>
<div class="cont">
<h2>SignUp - Kanha Stories</h2>
<form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF'])?>" method="POST">
<span class="error"><?php echo $err; ?></span>
<br/>
<label for="name">Name</label><br />
<input type="text" name="name" placeholder="Enter your name" value="<?php echo $name; ?>">
<span class="error"><?php echo $name_err; ?></span>
<br/>
<label for="email">Email</label><br />
<input type="email" name="email" placeholder="Enter your Email ID" value="<?php echo $email; ?>">
<span class="error"><?php echo $email_err;?></span>
<br/>
<label for="tel">Mobile Number</label><br />
<input type="tel" name="tel" placeholder="Enter Mobile Number" value="<?php echo $tel; ?>">
<span class="error"><?php echo $tel_err;?></span>
<br/>
<label for="date">D.O.B. of Child (Click on Calander icon)</label><br />
<input type="date" name="dob" placeholder="Enter date of birth " value="<?php echo $dob;?>">
<span class="error"><?php echo $dob_err;?></span>
<br/>
<label for="password">Password</label><br />
<input type="password" name="password" placeholder="Enter your Password">
<span class="error"><?php echo $password_err; ?></span>
<br/>
<div class="sub">
<input type="submit" name="signup" id="s" placeholder="Submit"><br />
</div>
</form>
<p>Already registered? <a href="./login.php">log in here</a></p>
</div>
</body>
</html>
I don't know what I can do now , Please try to give me the solutions as soon as possible. Thanks Hello all, been trying for over a day to get something to work and after searching and searching I could not find what I was looking for. I found people looking to do something similar, but the answers seemed more complicated than I would think they need to be. First off, I'm still horrible at arrays and loops so try not to laugh too hard if my code is waaaayyyy off...haha I am essentially trying to tie products and quantities to a reservation. The user has the ability to add items to the form. I'm using jquery .clone to create each new item product and quantity form fields. When the user submits the form jquery inputs the values of the cloned fields into 2 hidden text fields called "productsField" and "quantitiesField" The values of these fields look something like value="1,2,2,1,3" depending on how many products were added. What I want to do is explode both and then enter them into the database. Seems simple enough, but apparently I am not getting it. I thought something like this would work, but it is not. if (isset($_POST["reserve_button"])) { $theReservationID = $_SESSION['createdReservationID']; $items = explode (",",$_POST['productsField']); $quantities = explode (",",$_POST['quantitiesField']); // loop through array $number = count($items); for ($i=0; $i<=$number; $i++) { // store a single item number and quantity in local variables $itno = $items[$i]; $quant = $quantities[$i]; if ($items[$i] <> '') { mysql_query('INSERT INTO reservation_items (reservationID,productID,productQuantity) VALUES($theReservationID,$itno,$quant)'); } } } Any help would be greatly appreciated. Thanks in advance, Twitch Hello i have a system where leaders add members, i want to display a table of members WHERE the 'leader' field equals 'myusername' so that leaders only see members they added. when using the WHERE function i get a database empty as the result but when i remove the WHERE function i get all the data returned Code: [Select] include("system/include/session.php"); $myUname = $session->username; echo "$myUname"; function displayMembers(){ global $database; $q = "SELECT * " ."FROM ".TBL_MEMBERS." WHERE leader = '$myUname'"; $result = $database->query($q); $num_rows = mysql_numrows($result); if(!$result || ($num_rows < 0)){ echo "Error displaying info"; return; } if($num_rows == 0){ echo "Database table empty"; return; } echo "<table>\n"; echo "<thead> <tr> <th>Full Name</th> <th>Gender</th> <th>DOB</th> <th>Post Code</th> <th>Email Address</th> <th>Edit User</th> </tr> </thead>\n"; for($i=0; $i<$num_rows; $i++){ $Mprefix = mysql_result($result,$i,"prefix"); $Mfname = mysql_result($result,$i,"firstname"); $Mlname = mysql_result($result,$i,"lastname"); $Mgender = mysql_result($result,$i,"gender"); $Mdob = mysql_result($result,$i,"dob"); $Mpostcode = mysql_result($result,$i,"postcode"); $Memail = mysql_result($result,$i,"email"); echo " <tbody> <tr> <td>$Mprefix $Mfname $Mlname</td> <td>$Mgender</td> <td>$Mdob</td> <td>$Mpostcode</td> <td>$Memail</td> <td> <center> <form action=\"system/admin/adminprocess.php\" method=\"POST\"> <input type=\"hidden\" name=\"deluser\" value=\"$uname\"> <input type=\"hidden\" name=\"subdeluser\" value=\"1\"> <input type=\"submit\" class=\"button plain\" value=\"Edit Member\"> </form> </center> </td> </tr> </tbody>\n"; } echo "</table><br>\n"; } all help i am thankful for I need a little help with fpdf: Code: [Select] <?php include_once("connect.php"); if($_POST['submit']){ $startdate=$_POST['startdate']; $enddate=$_POST['enddate']; $sql = mysql_query("SELECT * FROM transactions where date between '$startdate' and '$enddate' "); while($row = mysql_fetch_array($sql)){{ $date = $row["date"]; $product = $row["product"]; $month = $row["month"]; $day = $row["day"]; $year = $row["year"]; $category = $row["category"]; $academy = $row["academy"]; $price = $row["price"]; $priceunit = $row["priceunit"]; $quantity = $row["quantity"]; } // Query member data from the database and ready it for display require('fpdf.php'); class PDF extends FPDF { function EAN13($x=1, $y, $barcode, $h=16, $w=.35) { $this->Barcode(13,5,$barcode,$h,$w,13); } function UPC_A($x, $y, $barcode, $h=16, $w=.35) { $this->Barcode($x,$y,$barcode,$h,$w,12); } function GetCheckDigit($barcode) { //Compute the check digit $sum=0; for($i=1;$i<=11;$i+=2) $sum+=3*$barcode[$i]; for($i=0;$i<=10;$i+=2) $sum+=$barcode[$i]; $r=$sum%10; if($r>0) $r=10-$r; return $r; } function TestCheckDigit($barcode) { //Test validity of check digit $sum=0; for($i=1;$i<=11;$i+=2) $sum+=3*$barcode[$i]; for($i=0;$i<=10;$i+=2) $sum+=$barcode[$i]; return ($sum+$barcode[12])%10==0; } function Barcode($x, $y, $barcode, $h, $w, $len) { //Padding $barcode=str_pad($barcode,$len-1,'0',STR_PAD_LEFT); if($len==12) $barcode='0'.$barcode; //Add or control the check digit if(strlen($barcode)==12) $barcode.=$this->GetCheckDigit($barcode); elseif(!$this->TestCheckDigit($barcode)) $this->Error('Incorrect check digit'); //Convert digits to bars $codes=array( 'A'=>array( '0'=>'0001101','1'=>'0011001','2'=>'0010011','3'=>'0111101','4'=>'0100011', '5'=>'0110001','6'=>'0101111','7'=>'0111011','8'=>'0110111','9'=>'0001011'), 'B'=>array( '0'=>'0100111','1'=>'0110011','2'=>'0011011','3'=>'0100001','4'=>'0011101', '5'=>'0111001','6'=>'0000101','7'=>'0010001','8'=>'0001001','9'=>'0010111'), 'C'=>array( '0'=>'1110010','1'=>'1100110','2'=>'1101100','3'=>'1000010','4'=>'1011100', '5'=>'1001110','6'=>'1010000','7'=>'1000100','8'=>'1001000','9'=>'1110100') ); $parities=array( '0'=>array('A','A','A','A','A','A'), '1'=>array('A','A','B','A','B','B'), '2'=>array('A','A','B','B','A','B'), '3'=>array('A','A','B','B','B','A'), '4'=>array('A','B','A','A','B','B'), '5'=>array('A','B','B','A','A','B'), '6'=>array('A','B','B','B','A','A'), '7'=>array('A','B','A','B','A','B'), '8'=>array('A','B','A','B','B','A'), '9'=>array('A','B','B','A','B','A') ); $code='101'; $p=$parities[$barcode[0]]; for($i=1;$i<=6;$i++) $code.=$codes[$p[$i-1]][$barcode[$i]]; $code.='01010'; for($i=7;$i<=12;$i++) $code.=$codes['C'][$barcode[$i]]; $code.='101'; //Draw bars for($i=0;$i<strlen($code);$i++) { if($code[$i]=='1') $this->Rect($x+$i*$w,$y,$w,$h,'F'); } //Print text uder barcode $this->SetFont('Arial','B',12); $this->Text($x,$y+$h+11/$this->k,substr($barcode,-$len)); } //Instanciation of inherited class function Header() { global $name; global $date; global $product; global $month; global $day; global $year; global $academy; global $price; global $priceunit; global $category; global $quantity; // get the variable $name1 into the scope of this function //Logo //Arial bold 15 $this->SetFont('Arial','B',15); //Move to the right $this->Cell(70); //Title $this->Cell(0,0,'Please bring this to the next Scout Meeting',0,0,C); // Query member data from the database and ready it for display //Line break $this->Ln(20); $this->Cell(0,0,'',1,0); $this->Ln(20); $this->cell(50,10, 'Product:', 1,0); $this->cell(50,10, 'Category:', 1,0); $this->cell(50,10, 'Price:', 1,0); $this->Ln(10); $this->cell(50,10,$product, 'L,R',0); $this->cell(50,10, $category, 'L',0); $this->cell(50,10, $price, 'L,R',0); } //Page footer function Footer() { //Position at 1.5 cm from bottom $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial','B',8); //Page number $this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C'); } }} //Instanciation of inherited class $pdf=new PDF(); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('Arial','B',12); $pdf->Output('ticket.pdf', 'I');}?> Problem I am having is running the code through a loop. I need the products and such to run through the loop of querying the database so that all the entries in database meet the specs. please help:) Hi All, New here to PHP. Was designing a pdf file using FPDF. Here is my problem: I want to display a table. I want to have rows and columns. For example the code below gives me one row perfectly: $this->SetFont('Arial','',10); // Logo //$this->Image(SETTING_MAIN_URL . 'images/logo.png',10,19,33); $this->Image($this->image_folder . 'pdf_logo.png',10,5,33); // Right hand header $this->SetFont('Arial','B',13); $this->Text(45,14,"test test test"); $this->SetFont('','',10); $this->Text(10,22,"Account: "); $this->Text(25,22,Sessionmanager::getUser()->getAccount()); $this->Text(10,27,"Date: "); $this->Text(20,27,$today = date("m.d.y")); $this->Ln(20); $this->Cell(30,7,"Number",1,0,'L'); $this->Cell(33,7,"NAME",1); $this->Cell(33,7,"address",1); $this->Cell(33,7,"address2",1); $this->Cell(33,7,"address3",1); $this->Cell(33,7,"country",1); $this->Ln(10); $i=0; $this->SetFont('Arial','B',5); for($i=0;$i<sizeof($this->list);$i++) { $consignment= $this->list[$i]; $this->Cell(33,7,$consignment->getBIll(),1,'L'); $this->Cell(33,7,"asdfasdfasdf",1,'L'); $this->MultiCell(33,7,$consignment->getCom()."\n".$consignment->AddressLine1()."\n".$consignment->getAddressLine2()."\n".$consignment->getCity()."\n".$consignment->getCountry(),1,'L'); $this->Ln(1); Now When I add this line to the code just before $this->Ln(1) $this->Cell(33,7,"test 4",'L'); It goes to a new line for some reason even before i call the $this->Ln(). Any ideas? I want to display the "test4" in the same row too. So i guess my question basically is that i dont understand how fpdf distinguishes between when to switch to a new row and when to keep on adding to the same row. Thank you very much for your help. I would like to create a page in pdf format and I found it possible by using fpdf, but how would I create a page that looks something like this: 1 Flathead nails 3/4" 1,170.00KG @ 60.00 70,200.00 2 Drip edge using plain G.I sheet 3,304.00PCS @ 80.00 264,320.00 4" x 8" x Ga. #24 including cutting and bending (as per drawing). requirements : 472 sheets 1 sheet = 7 pieces 3 Wall flashing using plain G.I sheet 712.00PCS @ 70.00 49,840.00 4" x 8" x Ga. #24 including cutting and bending (as per drawing) requirements : 89 sheets 1 sheet = 8 pieces ********************* NOTHING FOLLOWS ********************* I really need something like this that shows no border because borders are already pre printed. Before posting here I googled it first And found a code that would possibly create my concern but I found some problem of the code and I need some help to make this working. Existing code: Code: [Select] <?php require('fpdf/fpdf.php'); $pdf = new FPDF(); $pdf->AddFont('Bookman','','Bookos.php'); $pdf->AddPage(); $pdf->SetFont('Bookman','',14); $x=16; $y=26; $width=30; $height=35; $leftmargin=16; $content = "content"; //$content = "This is a very long content, this must goes to the next line. "; for ($r=0;$r<5;$r++){ for ($c=0;$c<6;$c++){ $pdf->SetY($y); //set pointer back to previous values $pdf->SetX($x); $x=$pdf->GetX()+$width; $y=$pdf->GetY(); $pdf->MultiCell($width,$height,$content,1,'L'); } $y+=$height; $x=$leftmargin; $pdf->SetY($y); } $pdf->Output(); ?> There are two problems with this code: 1.) Only the first page is working well. 2.) It will not create a newline in each cell if the content is long.... Tnx in advance to everyone..... pls..... Hello,
I am trying to print the invoice in pdf, using fpdf. i am not getting how to do it. I am able to display line items , but its not in proper format. I tried changing X, Y positions, but its not going into my head . Also i want to display Logo and address in left side, invoice number and order date in right side.
Here is the code i have done so far... Please please help me in this
<?php
require('includes/fpdf/fpdf.php');
//Connect to your database
include("connect/DB_Connect.php");
$id = $_GET['id'];
//Select the Products you want to show in your PDF file
$result=mysql_query("select invoice_no, order_no, order_date, completion_date, artwork, customer_po, order_quantity, comments, order_amount from invoice where invoice_no='".$id."' ") or die(mysql_error());
$number_of_products = mysql_numrows($result);
//Initialize the 3 columns and the total
$column_order_date = "";
$column_order_no = "";
$column_artwork = "";
$column_cpo = "";
$column_order_quantity = "";
$column_order_amount = "";
$column_comments = "";
$total = 0;
//For each row, add the field to the corresponding column
while($row = mysql_fetch_array($result))
{
$order_date = $row["order_date"];
$order_no = $row["order_no"];
$artwork = $row['artwork'];
$cpo = $row['customer_po'];
$oquantity = $row['order_quantity'];
$oamount = $row['order_amount'];
$comments = $row['comments'];
//$price_to_show = number_format($row["Price"],',','.','.');
$column_order_date = $column_order_date.$order_date."\n";
$column_order_no = $column_order_no.$order_no."\n";
$column_artwork = $column_artwork.$artwork."\n";
$column_cpo = $column_cpo.$cpo."\n";
$column_order_quantity = $column_order_quantity.$oquantity."\n";
$column_order_amount = $column_order_amount.$oamount."\n";
$column_comments = $column_comments.$comments."\n";
//Sum all the Prices (TOTAL)
$total = $total+$oamount;
}
mysql_close();
//Create a new PDF file
$pdf=new FPDF();
$pdf->AddPage();
//Fields Name position
$Y_Fields_Name_position = 20;
//Table position, under Fields Name
$Y_Table_Position = 26;
//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(232,232,232);
//Bold Font for Field Name
$pdf->SetFont('Arial','B',12);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(5);
$pdf->Cell(25,6,'Order Date',1,0,'L',1);
$pdf->SetX(30);
$pdf->Cell(50,6,'Graphixide Order No',1,0,'L',1);
$pdf->SetX(75);
$pdf->Cell(40,6,'Artwork',1,0,'L',1);
$pdf->SetX(110);
$pdf->Cell(20,6,'PO #',1,0,'L',1);
$pdf->SetX(130);
$pdf->Cell(20,6,'Quantity',1,0,'L',1);
$pdf->SetX(150);
$pdf->Cell(25,6,'Amount',1,0,'L',1);
$pdf->SetX(175);
$pdf->Cell(25,6,'Comments',1,0,'L',1);
//Now show the 3 columns
$pdf->SetFont('Arial','',12);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(5);
$pdf->MultiCell(25,6,$column_order_date,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(30);
$pdf->MultiCell(80,6,$column_order_no,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(75);
$pdf->MultiCell(40,6,$column_artwork,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(110);
$pdf->MultiCell(20,9,$column_cpo,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(130);
$pdf->MultiCell(20,6,$column_order_quantity,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(150);
$pdf->MultiCell(75,6,$column_order_amount,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(175);
$pdf->MultiCell(25,10,$column_comments,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(150);
$pdf->MultiCell(130,6,'$ '.$total,1,'R');
//Create lines (boxes) for each ROW (Product)
//If you don't use the following code, you don't create the lines separating each row
$i = 0;
while ($i < $number_of_products)
{
$pdf->SetX(45);
$pdf->MultiCell(120,6,'',1);
$i = $i +1;
}
$pdf->Output();
?>
Here is the output of this code
ss.PNG 32.3KB
7 downloads
Hey there... I'm so stuck on this problem I was hoping someone could help... I need to query a MySQL Database using array values... Here is my array ... $query_keywords = Array ( [7] => business [10] => home [11] => depo ) Here is my php ...$query = "SELECT * FROM product WHERE product_name, product_comment IN ($query_keywords)"; $result=mysql_query($query); if(mysql_num_rows($result) > 0) { echo "results"; } else { echo "no results"; } Unfortunately, I get this ... Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in blah\blah\results.php on line 99 Please help me All comments greatly appreciated... Hello, I am attempting to create a script where a user puts a text string into a form and clicking on submit. Then it adds that text string to a mysql database and gives the user a link back to it. Something like mysite.com/key.php?id=4 and when going to that link it will display the text string from the database but printed in an image. I wrote something up but I cannot get it to work. I may be a little in over my head. Any help is appreciated.
The way I coded this all to work is the user inputs the information into index.php which givekey.php inserts that into the database. I have not yet figure out how to do this in one single step. After that I wanted it to navigate directly to key.php which would display the key and the link to that page with the ?key=XX attribute. getkey.php
<?php
require_once 'dbinfo.php';
// database connection
$id = $_GET['id'];
// do some validation here to ensure id is safe
$link = mysql_connect($servername, $username, $password);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
@mysql_select_db($database) or die( "Unable to select database");
$sql = "SELECT ukey FROM keycode WHERE id=$id";
$result = mysql_query("$sql");
$row = mysql_fetch_assoc($result);
mysql_close($link);
header("Content-type: image/png");
echo $row['ukey'];
?>
key.php <html> <head> <title>Your Key Is Ready</title> </head> <body> <img src="getkey.php?id=1" width="175" height="200" /> </body> </html>index.php
<html>
<head>
<title></title>
</head>
<body>
<section id="mid_section">
<div id="boxes">
<h1>
Testing input key
</h1>
<br/>
<form id="myform" action="givekey.php" method="post">
Key:<br />
<input type="text" value="ukey">
Source:<br />
<input type="radio" value="hb">HB<br />
<input type="radio" value="ig">IG<br />
<input type="radio" value="other">Other<br />
<button id="sub">Submit</button>
</form>
</body>
</html>
givekey.php
<?php
include_once('dbinfo.php');
$conn = mysql_connect($servername, $username, $password);
$db= mysql_select_db($database);
$ukey =$_POST['ukey'];
$hb =$_POST['hb'];
$ig =$_POST['ig'];
$other =$_POST['other'];
if(mysql_query("INSERT INTO `keycode`(`ukey`) VALUES ([$ukey]); INSERT INTO `source`(`hb`,`ig`,`other`) VALUES ([$hb],[$ig],[$other]);"))
?>
Edited by chrisb302, 13 November 2014 - 12:18 AM. Hi everyone, I'm new to this group and new to php. I have created a multi-part form that allows the user the option to add multiple input fields to a form to upload images. Here is the form structu Code: [Select] <form action="Scripts/processreports2.php" method="post" enctype="multipart/form-data" name="report_form" target="uploader" class="reportfrm"> <fieldset> <legend>Upload your images</legend> <ol id="add_images"> <li> <input type="file" class="input" name="files[]" /> </li> <li> <input type="file" class="input" name="files[]" /> </li> <li> <input type="file" class="input" name="files[]" /> </li> </ol> <input type="button" name="addFile" id="addFile" value="Add Another Image" onclick="window.addFile(this);"/> </fieldset> <p>* indicates a required field.</p> <input name="submit" type="submit" id="submit" value="Send Info!" /> </form> Through php a maximum of three input fields are fed into an array that checks to make sure that the uploaded files are images and not some other type of file. The uploading porition of this script works. Now I am trying to get the values of the input fields as a string and insert them into the database as one record. Let's say the user has three files they want to upload. I have managed to get the files as a string ie; file1.jpg, file2.jpg, file3.jpg but what is happening is that I am getting three separate records with file1.jpg, file2.jpg, file3.jpg in them. If the user has only two files to upload then I get two separate records with file1.jpg and file2.jpg in them. (Hope that makes sense). I want one record. I have been struggling with this since Monnday and while every day I get closer, this is as close as I can get. Below is the php code. #connect to the database mysql_connect("localhost", "root", ""); mysql_select_db("masscic"); //Upload Handler to check image types function is_image($file) { $file_types = array('jpeg', 'gif', 'bmp'); //acceptable file types if ($img = getimagesize($file)){ //echo '<pre>'; //print_r($_FILES); used for testing //print_r($img); used for testing if(in_array(str_replace('image/', '', $img['mime']), $file_types)) return $img; } return false; } //form submission handling if(isset($_POST['submit'])) { //file variables $fname = $_FILES['files']['name']; $ftype = $_FILES['files']['type']; $fsize = $_FILES['files']['size']; $tname = $_FILES['files']['tmp_name']; $ferror = $_FILES['files']['error']; $newDir = '../uploads/'; //relative to where this script file resides for($i = 0; $i < count($fname); $i++) { //echo 'File name ' . $fname[$i] . ' has size ' . $fsize[$i]; used for testing if ($ferror[$i] =='UPLOAD ERR OK' || $ferror[$i] ==0) { if(is_image($tname[$i])) { //append the tmp_name($tname) to the file name ($fname) and upload to the server move_uploaded_file($tname[$i], ($newDir.time().$fname[$i])); echo '<li><span class="success">'.$fname[$i].' -- image has been accepted<br></span></li>'; }else echo '<li><span class="error">'.$fname[$i].' -- is not an accepted file type<br></span></li>'; } if (is_array($fname)) $files = implode(', ',$fname); //else $files = $fname; $sqlInsert = mysql_query("INSERT INTO files (file_names) VALUES('$files')") or die (mysql_error()); } } I get a t-string error. Any thoughts? $emp = 'SELECT employees.function FROM employees WHERE employees.userid=${r['id']}'; Is there any function i can use to make this T STRING error stop? $desc = "this is a "test" this is a test"; i just want it so everything inside the initial 2 "s are classed as just normal text or whatever? Thanks
I have used this program for many years without problems. I have not altered the file in any way, so why is this happening? Is it to do with PHP upgrade?😖 Here is the file:
<?php
include("connect_Verses4Cards.php");
$conn=get_db_conn_verse();
session_start();
$display_block ="";
$color="";
$r ="";
$g ="";
$b ="";
$image ="";
//Get the Card Variables
$Get_Size_sql = "SELECT * FROM `CSize` WHERE `Size` ='".$_POST["CSize"]."'";
$Get_Size_res = mysqli_query($conn, $Get_Size_sql) or die(mysqli_error($conn));
if (mysqli_num_rows($Get_Size_res) < 1) {
//this Card does not exist
$display_block = "You have selected an invalid Card size.
Please try again.";
} else {
//get the print variables
while ($Size_info = mysqli_fetch_array($Get_Size_res)) {
$BoxX = stripslashes($Size_info['BoxX']);
$Cellw = stripslashes($Size_info['Cellw']);
$Cellh = stripslashes($Size_info['Cellh']);
$SizeI = stripslashes($Size_info['Size']);
$SID = stripslashes($Size_info['SID']);
$floatx = stripslashes($Size_info['floatx']);
$floaty = stripslashes($Size_info['floaty']);
$floatw = stripslashes($Size_info['floatw']);
$floath = stripslashes($Size_info['floath']);
$ort = stripslashes($Size_info['ort']);
}
//create the display string
$display_block = "$ort";
}
//verify the Event exists
//$the_id = mysqli_real_escape_string($mysqli, $_SESSION[VID]);
$Get_Verse_sql = "SELECT id, Event, Sub_Type, Verse FROM verses WHERE id='".$_SESSION['Test']."'";
$Get_Verse_res = mysqli_query($conn, $Get_Verse_sql) or die(mysqli_error($conn));
if (mysqli_num_rows($Get_Verse_res) < 1) {
//this Event does not exist
$display_block = "You have selected an invalid Event.
Please try again.";
} else {
//get the Event ID
while ($Verse_info = mysqli_fetch_array($Get_Verse_res)) {
$Verse = stripslashes($Verse_info['Verse']);
}
//create the display string
$display_block = "$Verse";
//free results
mysqli_free_result($Get_Verse_res);
mysqli_free_result($Get_Size_res);
//close connection to MySQL
}
mysqli_close($conn);
require('fpdf.php');
class PDF extends FPDF
{
var $B;
var $I;
var $U;
var $HREF;
function PDF($orientation='P', $unit='mm', $size='A4')
{
// Call parent constructor
$this->FPDF($orientation,$unit,$size);
// Initialization
$this->B = 0;
$this->I = 0;
$this->U = 0;
$this->HREF = '';
}
function SetStyle($tag, $enable)
{
// Modify style and select corresponding font
$this->$tag += ($enable ? 1 : -1);
$style = '';
foreach(array('B', 'I', 'U') as $s)
{
if($this->$s>0)
$style .= $s;
}
$this->SetFont('',$style);
}
}
$color = $_POST['color'];
$r = substr($color,0,3);
$g = substr($color,3,3);
$b = substr($color,6,3);
$image=$_POST['image'];
$pdf = new PDF($ort,'mm','A4');
$pdf->AddPage();
$pdf->AddFont('French Script MT','','/frscript.php');
$pdf->AddFont('Batavia','','Batavia_.php');
$pdf->AddFont('Algerian','','Alger.php');
$pdf->AddFont('Bladerunner','','BLADRMF_.php');
$pdf->AddFont('Brush Script','','BRUSHSCI.php');
$pdf->AddFont('Helterskelter','','Helte___.php');
$pdf->AddFont('Justice','','Justice_.php');
$pdf->AddFont('Magneto','','MAGNETOB.php');
$pdf->AddFont('Old English','','OldEngl.php');
$pdf->AddFont('Sneakerhead Outline','','Sneabo__.php');
$pdf->AddFont('Trendy','','Trendy__.php');
$pdf->AddFont('Vladimir Script','','VLADIMIR.php');
$pdf->SetLeftMargin('float0');
$pdf->SetTextColor($r,$g,$b);
$pdf->SetFont($_POST['fontface'],'',$_POST['font']);
$pdf->SetXY($BoxX, $_POST['Top']);
$pdf->Image($image,$floatx,$floaty,$floatw,$floath,'','');
$pdf->MultiCell($Cellw,$Cellh,$display_block,'' ,'C');
//$pdf->SetDisplayMode('fullpage','');
$pdf->SetFont('');
$pdf->Output('verse.pdf','D');
//end:
?>
This topic has been moved to Other Libraries and Frameworks. http://www.phpfreaks.com/forums/index.php?topic=357112.0 Hi I am using the Quote fpdf library to generate a PDF. What I'm looking to do, is to possibly 'nest' cells inside another cell. Code: [Select] ============================ | Main Cell | | ============= =========== | | Cell 2 | | Cell 3 | | ============= =========== | | ============================ So you can see I have one, main cell, and inside this I have Cell 2 and Cell 3, which I'd like inside/nested the main cell. Is this possible using the fpdf library? Thanks Hi, With my attendance system I generated one fpdf link to generate pdf file. What if I have 50 staff members, Its hard to open the 50 pdf files separately. Is there a away to merge them all in one big pdf file? Edited April 3, 2020 by ramiwahdantypo error |
|||||||