searls03 Posted April 17, 2011 Share Posted April 17, 2011 is there a way I can make something like a ticket in pdf format that can have $name or the likes echo in it? if you could help get me started, that would be great! Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 You could use the PHP PDF functions (http://php.net/manual/en/book.pdf.php) or if your host doesn't have them configured you could use FPDF (http://www.fpdf.org/) which is pure PHP. There are some examples on the FPDF website of how to create documents. Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 is there a way I can do it with having data already being there and it is a download link like the website kindof shows? Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 You could have a link to a PHP file which would generate the PDF. Say you had a file with this in it: <?php //FPDF code require_once 'fpdf.php'; $user = $_GET['name']; $pdf=new FPDF(); $pdf->AddPage(); $pdf->SetFont('Arial','B',16); $pdf->Cell(40,10,'Hello ' . $user); $pdf->Output(); ?> It would create a PDF document saying Hello to whatever name you put in the query string. Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 yep, i realized that. haha..........how can I put different borders around text? Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 FPDF manual should help, According to it you change: $pdf->Cell(40,10,'Hello ' . $user); to: $pdf->Cell(80,10,'Hello ' . $user, 1); the 4th parameter is if to have a border around the text so setting it to 1 will make a border. Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 ok, so I am trying to make it echo $name, but it doesn't seem to be working: <?php session_start(); // Must start session first thing /* Created By Adam Khoury @ www.flashbuilding.com -----------------------June 20, 2008----------------------- */ // Here we run a login check if (!isset($_SESSION['id'])) { echo 'Please <a href="login.php">log in</a> to access your account'; exit(); } //Connect to the database through our include include_once "connect_to_mysql.php"; // Place Session variable 'id' into local variable $userid = $_SESSION['id']; // Query member data from the database and ready it for display $sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1"); while($row = mysql_fetch_array($sql)){ $name = $row['name']; $phone = $row["phone"]; $username = $row["username"]; $address = $row["address"]; $city = $row["city"]; $state = $row["state"]; $zip = $row["zip"]; $cell = $row["cell"]; $email = $row["email"]; $accounttype = $row["accounttype"]; $rank = $row["rank"]; $badges = $row["badges"]; } $name1 = '$name'; require('fpdf.php'); class PDF extends FPDF { //Page header function Header() { //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); //Line break $this->Ln(20); $this->Cell(0,0,'',1,0); $this->Ln(20); $this->cell(100,20, 'Registrant:', 1,0); $this->cell(10,20, $name1, 1,0); } //Page footer function Footer() { //Position at 1.5 cm from bottom $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial','I',; //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('Times','',12); $pdf->Output(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> </body> </html> And yes, the session id isset..................how can I make it pull it from the previous page where the link is? do you know......I can't seem to find this on the site? Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 $name1 doesn't exist in the scope of the header function. You would need to either add it as a parameter (preferred) or add global $name1; to the top of the function. For more information see: http://php.net/manual/en/language.variables.scope.php <?php class PDF extends FPDF { //Page header function Header() { global $name1; // 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); //Line break $this->Ln(20); $this->Cell(0,0,'',1,0); $this->Ln(20); $this->cell(100,20, 'Registrant:', 1,0); $this->cell(10,20, $name1, 1,0); } //Page footer function Footer() { //Position at 1.5 cm from bottom $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial','B',; //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(); die(); // Stop execution, don't want to load that HTML in a PDF document it would most likely corrupt it. ?> Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 ok, so i have looked at the manual and cant seem to find how I would echo an addition function that was executed and how I can apply this to the page: <?php session_start(); // Must start session first thing /* Created By Adam Khoury @ www.flashbuilding.com -----------------------June 20, 2008----------------------- */ // Here we run a login check if (!isset($_SESSION['id'])) { echo 'Please <a href="login.php">log in</a> to access your account'; exit(); } //Connect to the database through our include include_once "connect_to_mysql.php"; // Place Session variable 'id' into local variable $userid = $_SESSION['id']; // Query member data from the database and ready it for display $sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1"); while($row = mysql_fetch_array($sql)){ $name = $row['name']; $phone = $row["phone"]; $username = $row["username"]; $address = $row["address"]; $city = $row["city"]; $state = $row["state"]; $zip = $row["zip"]; $cell = $row["cell"]; $email = $row["email"]; $accounttype = $row["accounttype"]; $rank = $row["rank"]; $badges = $row["badges"]; } $name1 = '$name'; require('fpdf.php'); class PDF extends FPDF { //Page header function Header() { global $name; global $total; // 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); //Line break $this->Ln(20); $this->Cell(0,0,'',1,0); $this->Ln(20); $this->cell(50,10, 'Registrant:', 1,0); $this->cell(50,10, 'Events:', 1,0); $this->cell(50,10, 'Price:', 1,0); $this->Ln(10); $this->cell(50,10,$name, 1,0); $this->cell(50,10, $events, 1,0); $this->cell(50,10, $total, 1,0); } //Page footer function Footer() { //Position at 1.5 cm from bottom $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial','I',; //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('Times','',12); $pdf->Output('ticket.pdf', 'I'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> </body> </html> here is the $total:(from previous page) $total = $price1 + $price2 + $price3 + $price4 +$price5 + $price6 + $price7 + $price8; and here is what I want for $events(from previous page): <?php $sql = ("SELECT * FROM Events WHERE eventid='$eventid' && userid='$userid'"); $result = mysql_query($sql) or die(mysql_error()); while($row = mysql_fetch_array($result)){ $event = $row['event']; $startdate = $row['startdate']; $enddate = $row['enddate']; $description = $row['description']; $location = $row['location']; $subevent1 = $row['subevent1']; $subevent1 = $row['subevent2']; $subevent3 = $row['subevent3']; $subevent4 = $row['subevent4']; $subevent5 = $row['subevent5']; $subevent6 = $row['subevent6']; $subevent7 = $row['subevent7']; $subevent8 = $row['subevent8']; } if (!empty($title1)) { echo "<br/>$title1"; } if (!empty($title2)) { echo "<hr><br/>$title2" ; } if (!empty($title3)) { echo "<hr><br/>$title3"; } if (!empty($title4)) { echo "<hr><br/>$title4"; } if (!empty($title5)) { echo "<hr><br/>$title5"; } if (!empty($title6)) { echo "<hr> <br/>$title6"; } if (!empty($title7)) { echo "<hr><br/>$title7"; } if (!empty($title8)) { echo "<hr><br/>$title8"; } ?> can you help me with this? I am not good with the strings from previous pages................. Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 Why not have the code work out the total on the page with the PDF instead of the last one. If you need to do it on both then you will need to use the same code as the last page to calculate the total (maybe put the code into a function and call that from both pages). Alternatively you could store the total in the users session like you have their ID and then on the next page fetch it from the session or if it doesn't matter that they can change it, put the total it in the query string and get it from there. Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 ok, what about the second part? Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 What second part? Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 the thing that I want to have for $events? Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 ok, so for the total I have: <?php session_start(); // Must start session first thing /* Created By Adam Khoury @ www.flashbuilding.com -----------------------June 20, 2008----------------------- */ // Here we run a login check if (!isset($_SESSION['id'])) { echo 'Please <a href="login.php">log in</a> to access your account'; exit(); } //Connect to the database through our include include_once "connect_to_mysql.php"; // Place Session variable 'id' into local variable $userid = $_SESSION['id']; // Query member data from the database and ready it for display $sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1"); while($row = mysql_fetch_array($sql)){ $name = $row['name']; $phone = $row["phone"]; $username = $row["username"]; $address = $row["address"]; $city = $row["city"]; $state = $row["state"]; $zip = $row["zip"]; $cell = $row["cell"]; $email = $row["email"]; $accounttype = $row["accounttype"]; $rank = $row["rank"]; $badges = $row["badges"]; } $sql = mysql_query("SELECT * FROM Events WHERE userid='$userid' && eventid='$eventid'"); while($row = mysql_fetch_array($sql)){ $price1 = $row['price1']; $price2 = $row["price2"]; $price3 = $row["price3"]; $price4 = $row["price4"]; $price5 = $row["price5"]; $price6 = $row["price6"]; $price7 = $row["price7"]; $price8 = $row["price8"]; } $total = $price1 + $price2 + $price3 + $price4 +$price5 + $price6 + $price7 + $price8; require('fpdf.php'); class PDF extends FPDF { //Page header function Header() { global $name; global $total; // 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); //Line break $this->Ln(20); $this->Cell(0,0,'',1,0); $this->Ln(20); $this->cell(50,10, 'Registrant:', 1,0); $this->cell(50,10, 'Events:', 1,0); $this->cell(50,10, 'Price:', 1,0); $this->Ln(10); $this->cell(50,10,$name, 1,0); $this->cell(50,10, $events, 1,0); $this->cell(50,10, $total, 1,0); } //Page footer function Footer() { //Position at 1.5 cm from bottom $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial','I',; //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('Times','',12); $pdf->Output('ticket.pdf', 'I'); ?> but it keeps on displaying zero when it should display 64 because 8 events are registered and are $8 each. I want to use userid and eventid from previous page to gather the info. I am confused on this...........sorry Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 Is the query definitely fetching the data? Where dose $eventid in the query get set? Try dumping the $row variable with var_dump like this: <?php $sql = mysql_query("SELECT * FROM Events WHERE userid='$userid' && eventid='$eventid'"); $row = mysql_fetch_array($sql); // don't need to loop since there should only be one result? var_dump($row); // dump all the rows data die(); //stop execution ?> Dose it show all the data? Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 i believe if I can get this page to link to /ticket.php?eventid=_______ it will work.........I cant seem to make it get the eventid though: <?php session_start(); // Must start session first thing /* Created By Adam Khoury @ www.flashbuilding.com -----------------------June 20, 2008----------------------- */ // Here we run a login check if (!isset($_SESSION['id'])) { echo 'Please <a href="login.php">log in</a> to access your account'; exit(); } //Connect to the database through our include include_once "connect_to_mysql.php"; // Place Session variable 'id' into local variable $userid = $_SESSION['id']; // Query member data from the database and ready it for display $sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1"); while($row = mysql_fetch_array($sql)){ $name = $row["name"]; $phone = $row["phone"]; $username = $row["username"]; $address = $row["address"]; $city = $row["city"]; $state = $row["state"]; $zip = $row["zip"]; $cell = $row["cell"]; $email = $row["email"]; $accounttype = $row["accounttype"]; $rank = $row["rank"]; $badges = $row["badges"]; } // Query member data from the database and ready it // Process the form if it is submitted // Set error message as blank upon arrival to page $errorMsg = ""; // First we check to see if the form has been submitted if (isset($_POST['eventid'])){ $name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters $event = ereg_replace("[^A-Z a-z0-9]", "", $_POST['event']); // filter everything but spaces, numbers, and letters $eventid = ereg_replace("[^A-Z a-z0-9]", "", $_POST['eventid']); // filter everything but spaces, numbers, and letters $userid = ereg_replace("[^A-Z a-z0-9]", "", $_POST['userid']); $title1 = ereg_replace("[^A-Z a-z0-9]", "", $_POST['title1']); // filter everything but spaces, numbers, and letters $title2 = ereg_replace("[^A-Za-z0-9]", "", $_POST['title2']); // filter everything but lowercase letters $title3 = ereg_replace("[^A-Za-z0-9]", "", $_POST['title3']); // filter everything but lowercase letters $title4 = ereg_replace("[^A-Za-z0-9]", "", $_POST['title4']); // filter everything but lowercase letters $title5 = ereg_replace("[^A-Za-z0-9]", "", $_POST['title5']); // filter everything but lowercase letters $title6 = ereg_replace("[^A-Z a-z0-9]", "", $_POST['title6']); // filter everything but $title7 = ereg_replace("[^A-Z a-z0-9]", "", $_POST['title7']); // filter everything but $title8 = ereg_replace("[^A-Z a-z0-9]", "", $_POST['title8']); // filter everything but $email = ereg_replace("[^A-Z a-z0-9.@]", "", $_POST['email']); // filter everything but $id = ereg_replace("[^A-Z a-z0-9.@,]", "", $_POST['id']); if (isset($_POST['title8'])) { $price8 = $_POST['price8']; } else { $price8 = ""; } if (isset($_POST['title7'])) { $price7 = $_POST['price7']; } else { $price7 = ""; } if (isset($_POST['title6'])) { $price6 = $_POST['price6']; } else { $price6 = ""; } if (isset($_POST['title5'])) { $price5 = $_POST['price5']; } else { $price5 = ""; } if (isset($_POST['title4'])) { $price4 = $_POST['price4']; } else { $price4 = ""; } if (isset($_POST['title3'])) { $price3 = $_POST['price3']; } else { $price3 = ""; } if (isset($_POST['title2'])) { $price2 = $_POST['price2']; } else { $price2 = ""; } if (isset($_POST['title1'])) { $price1 = $_POST['price1']; } else { $price1 = ""; } // filter everything but $sql = "REPLACE INTO Events (name, event, eventid, userid, title1, title2, title3, title4, title5, title6, title7, title8, email, id, price1, price2, price3, price4, price5, price6, price7, price8) VALUES('$name','$event','$eventid','$userid','$title1','$title2','$title3','$title4','$title5','$title6','$title7','$title8','$email','$id','$price1', '$price2', '$price3','$price4','$price5','$price6','$price7','$price8')"; $rs = mysql_query($sql) or die ("Problem with the query: $sql<br>" . mysql_error()); $total = $price1 + $price2 + $price3 + $price4 +$price5 + $price6 + $price7 + $price8; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Thank you for Registering</title> <style type="text/css"> #editregion { position:absolute; left:-8px; top:272px; width:1293px; height:354px; z-index:1; text-align: center; clear: none; float: none; } body { background-image: url(button/boyscout1.png); background-repeat: no-repeat; position: relative; } #menu { position:relative; left:160px; top:0px; width:931px; height:59px; z-index:19; } #menu #MenuBar1 li a { color: #000; border-top-style: outset; border-right-style: outset; border-bottom-style: outset; border-left-style: outset; width: 100px; } #status { position:relative; left:16px; top:180px; width:124px; height:44px; z-index:14; } </style> <script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script> <script type="text/javascript"> function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } </script> <style type="text/css"> #apDiv1 { position:absolute; left:260px; top:89px; width:229px; height:75px; z-index:21; } </style> <link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" /> <style type="text/css"> #logout { position:relative; left:0px; top:0pxpx; width:134px; height:38px; z-index:20; font-weight: bold; font-size: 24px; } #logout a { color: #000; } #status { text-align: center; } #logout1 { position:absolute; left:1071px; top:191px; width:224px; height:61px; z-index:2; } #menu2 { position:absolute; left:-1px; top:172px; width:497px; height:92px; z-index:20; } #footer { position:fixed; left:-10px; top:0px2 width:1290px; height:63px; z-index:300; color: #000; background-color: #000; right: 0px; bottom: 0px; } #editregion p { text-align: left; } </style> </head> <body> <div id="menu2"><div id="menu"> <ul id="MenuBar1" class="MenuBarHorizontal"> <li><a href="myprofile.php">My Profile</a> </li> <li><a href="register.php">Register</a></li> <li><a href="projects.php">Projects</a> </li> <li><a href="news.php">News</a></li> <?php if ($accounttype == "Admin") { ?> <li><a href="membermanager.php">Scout Manager</a></li> <li><a href="eventmanager.php">Event Manager</a></li> <li><a href="newsmanager.php">News Manager</a></li> </ul><?php } ?> </div></div> <div id="logout1"><div id="logout"><a href="logout.php">Logout</a></div></div> <div id="status"><?php echo "$accounttype"; ?> <br /><?php echo "$name"; ?> <p> </p> </div> <div id="editregion"> <p> Thank you for registering for <?php echo $event; ?>. We have sent an email to your inbox at <?php echo $email; ?>. If you do not recieve this email, please check your spam folder and add "events@final.net46.net" to your address book to ensure you will recieve all confirmations in the future. Please click the file below to print your ticket and please bring it to the next scout meeting. If you cannot print, please email "<a href="mailto:searls03@gmail.com">searls03@troop078.net46.net</a>" to let him know you have registered. Thanks. <a href="ticket.php">Ticket</a> <p> <p> <div id="apDiv1"> <table width="453" border="1" cellspacing="2" cellpadding="2"> <tr> <th width="167" scope="col">Events:</th> <td width="266" scope="col"> <?php $sql = ("SELECT * FROM Events WHERE eventid='$eventid' && userid='$userid'"); $result = mysql_query($sql) or die(mysql_error()); while($row = mysql_fetch_array($result)){ $event = $row['event']; $startdate = $row['startdate']; $enddate = $row['enddate']; $description = $row['description']; $location = $row['location']; $subevent1 = $row['subevent1']; $subevent1 = $row['subevent2']; $subevent3 = $row['subevent3']; $subevent4 = $row['subevent4']; $subevent5 = $row['subevent5']; $subevent6 = $row['subevent6']; $subevent7 = $row['subevent7']; $subevent8 = $row['subevent8']; } if (!empty($title1)) { echo "<br/>$title1"; } if (!empty($title2)) { echo "<hr><br/>$title2" ; } if (!empty($title3)) { echo "<hr><br/>$title3"; } if (!empty($title4)) { echo "<hr><br/>$title4"; } if (!empty($title5)) { echo "<hr><br/>$title5"; } if (!empty($title6)) { echo "<hr> <br/>$title6"; } if (!empty($title7)) { echo "<hr><br/>$title7"; } if (!empty($title8)) { echo "<hr><br/>$title8"; } ?> </td> </tr> <tr> <th>Price:</th> <td><?php echo $total; ?></td> </tr> <tr> <th>Registrant:</th> <td><?php echo $name; ?></td> </tr> </table> </div> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> <?php if ($accounttype == "Admin") {echo '<div id="footer"><img src="footer_admin.png" width="1290" height="63" border="0" usemap="#Map" /> <map name="Map" id="Map"> <area shape="rect" coords="10,5,112,32" href="myprofile.php" /> <area shape="rect" coords="153,5,235,31" href="register.php" /> <area shape="rect" coords="277,7,333,32" href="news.php" /> <area shape="rect" coords="471,7,682,33" href="scoutmanager.php" /> <area shape="rect" coords="726,5,874,34" href="membermanager.php" /> <area shape="rect" coords="906,3,1058,34" href="eventmanager.php" /> <area shape="rect" coords="1092,6,1226,32" href="newsmanager.php" /> </map> </div>'; } else if ($accounttyp="scout"){echo '<div id="footer"><img src="footer_scout.png" width="1290" height="63" border="0" usemap="#Map" /> <map name="Map" id="Map"> <area shape="rect" coords="526,6,632,34" href="myprofile.php" /> <area shape="rect" coords="668,5,752,32" href="register.php" /> <area shape="rect" coords="789,5,850,34" href="news.php" /> </map> </div>';} else {echo '<div id="footer"><img src="footer_admin.png" width="1290" height="63" border="0" usemap="#Map" /> <map name="Map" id="Map"> <area shape="rect" coords="10,5,112,32" href="myprofile.php" /> <area shape="rect" coords="153,5,235,31" href="register.php" /> <area shape="rect" coords="277,7,333,32" href="news.php" /> <area shape="rect" coords="471,7,682,33" href="scoutmanager.php" /> <area shape="rect" coords="726,5,874,34" href="membermanager.php" /> <area shape="rect" coords="906,3,1058,34" href="eventmanager.php" /> <area shape="rect" coords="1092,6,1226,32" href="newsmanager.php" /> </map> </div>'; } ?> <?php $to = "$email"; // Change this to your site admin email $from = "events@final.net46.net"; $subject = "Thank You for Registering for $event. "; </body> </html> PS. if I put in a textfield and value is set as $eventid.........it displays correct id..........cant seem to make it link to it though...............right after body begins. Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 Dose: <?php echo '<a href="/ticket.php?eventid=' . $eventid . '">Download Ticket</a>'; ?> not work? If not what about: <?php var_dump($eventid); ?> Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 yep worked, now what about the $events? :confused: :confused: :confused: Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 Could you not select that from the DB using the eventid? Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 well, I need to know how to set it up so that it can be echoed? Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 also, real easy probably, I cant seem to figure out how to display a $ in front of $total: $this->cell(50,10, $total, 1,0); Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 For event something like: <?php $result = mysql_query("SELECT * FROM Events WHERE eventid = '" . mysql_real_escape_string($_GET['eventid']) . "' AND userid = '" . mysql_real_escape_string($userid) . "' LIMIT 1"); $event_data = mysql_fetch_assoc($result); $event = $event_data['event']; ?> To add a dollar to the front do: $this->cell(50,10, '$' . $total, 1,0); Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 no didnt work........this is what i want basically: <?php $sql = ("SELECT * FROM Events WHERE eventid='$eventid' && userid='$userid'"); $result = mysql_query($sql) or die(mysql_error()); while($row = mysql_fetch_array($result)){ $event = $row['event']; $startdate = $row['startdate']; $enddate = $row['enddate']; $description = $row['description']; $location = $row['location']; $subevent1 = $row['subevent1']; $subevent1 = $row['subevent2']; $subevent3 = $row['subevent3']; $subevent4 = $row['subevent4']; $subevent5 = $row['subevent5']; $subevent6 = $row['subevent6']; $subevent7 = $row['subevent7']; $subevent8 = $row['subevent8']; } if (!empty($title1)) { echo "<br/>$title1"; } if (!empty($title2)) { echo "<hr><br/>$title2" ; } if (!empty($title3)) { echo "<hr><br/>$title3"; } if (!empty($title4)) { echo "<hr><br/>$title4"; } if (!empty($title5)) { echo "<hr><br/>$title5"; } if (!empty($title6)) { echo "<hr> <br/>$title6"; } if (!empty($title7)) { echo "<hr><br/>$title7"; } if (!empty($title8)) { echo "<hr><br/>$title8"; } ?> Quote Link to comment Share on other sites More sharing options...
searls03 Posted April 17, 2011 Author Share Posted April 17, 2011 one last thing............after the $events of course................how can I make it so that a random verification code is put into here: $this->Cell(0,10,' ',0,0,'C'); doesn't need to be in database.............just some random letters and numbers............ Quote Link to comment Share on other sites More sharing options...
analog Posted April 17, 2011 Share Posted April 17, 2011 If you set $ventid and $userid in the code you posted what is the error? To generate a random string: <?php <?php // from http://www.lost-in-code.com/programming/php-code/php-random-string-with-numbers-and-letters/ function genRandomString($length = 10) { $characters = '0123456789abcdefghijklmnopqrstuvwxyz'; $string =''; for ($p = 0; $p < $length; $p++) { $string .= $characters[mt_rand(0, strlen($characters))]; } return $string; } $this->Cell(0,10,genRandomString(),0,0,'C'); ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.