PHP - Php Output From Html Form

I'm trying to display my BLOB images in PHP and I've looked around in Google searches but everyone's examples seem to work for their specific code.

My table is called 'identification'.
Here's my SQL:
Code: [Select]
== Table structure for table identification

|------
|Field|Type|Null|Default
|------
|//**id**//|int(11)|No|
|image|blob|No|
|image_width|char(220)|No|
|image_height|char(220)|No|
|image_type|enum('jpeg', 'pjpeg', 'png', 'gif')|No|
|stickID|int(11)|Yes|NULL

i'm trying to get a php database to output/display on a html webpage
and have no results from cutting and pasting code from online tutorials
i'm saving to a file with a htm extension
i believe i have the connection data right:

$db_host = 'server';
$db_user = 'username';
$db_pwd = 'password';

$database = 'database';
$table = 'table';

if (!mysql_connect($server,$username,$password))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");


$result = mysql_query("SELECT * FROM table")
or die(mysql_error()); 


Can someone please help me?  send code? tell me what i'm doing wrong?  Thanks

I am trying to make PHP output a file in html and using the following code.
Code: [Select]
<?php
                                        readfile("./1/index.html"); 
                                ?>
... but it isn't working. How would I get PHP to output a file as HTML?

Hi guys I am new here

I have had a search around and can't really find out how to do this. Its quite difficult for me to explain and I am really new to PHP / mySQL - just starting out really. I hope to learn from doing small projects like this and seeing how it gets done.

So I have a mySQL DB with two different tables - one is called "notesnew" the other is called "users".

I have modified a common tutorial on how to make a "to do list" for what I am doing here.

Basically users can login and post messages on this list as them self. Each user's post appears as a list item, showing their username, the time they posted the message and the message content. The message content, time and owner of the message is stored in the "notesnew" table.

The list of user's, their passwords and their "avatar/profile" image URL location is stored in the "users" table.

Now I am having trouble getting each user's avatar image from being output next to each of their posts. The part that is confusing me is being able to match up the username's post with their content that is display - because I am posting the user's name along with their post, based on the logged in "session name" as their username. So basically, all the content being listed is being displayed from the "notesnew" table. I need to somehow figure out what each user's profile image is based on what is stored against their entry in the "users" table.

Here is the code I have so far. It is not working properly - it displays all content etc, but displays the avatar / image of the last user that has registered. Can anyone help me out here with some code that works, or pointers to try follow? I know the $finduserprofile part is incorrect in the way it goes through all user's and finds their profileimg, and that the image displayed next to each post is therefore incorrect (as it displays the last member to have registered's avatar, but its just that I don't know how else to do what I am trying to do.

Code: [Select]
<?php
//Connect to the database
$connection = mysql_connect('localhost', 'zzzz' , 'zzzzzzz');
$selection = mysql_select_db('zzzzz', $connection);

$username = $_COOKIE['ID_my_site'];

//Was the form submitted?
if($_POST['submit']){

//Map the content that was sent by the form a variable. Not necessary but it keeps things tidy.
$content = $_POST['content'];

//Insert the content into database
$ins = mysql_query("INSERT INTO `notesnew` (content, owner, dp_time) VALUES ('$content', '$username', NOW())");

//Redirect the user back to the members or index page
header("Location:index.php");
}

/*Doesn't matter if the form has been posted or not, show the latest posts*/

//Find all the notes in the database and order them in a descending order (latest post first).
$find = mysql_query("SELECT * FROM `notesnew` ORDER BY id DESC");
$finduserprofile = mysql_query("SELECT * FROM `users` ORDER BY id DESC");

//Setup the un-ordered list
echo '<ul>';

while($row = mysql_fetch_array($finduserprofile))
{
$imagelocation = $row['profileimg'];
//Continue looping through all of them
while($row = mysql_fetch_array($find))
        {

$owner = $row['owner'];
//For each one, echo a list item giving a link to the delete page with it's id.
echo '<li>' . '<img src ="' . $imagelocation . '">' . $row['owner'] . ' said at ' . $row['dp_time'] . ': ' . $row['content'] . ' <a id="' . $row['id'] . '" href="delete.php?id=' . $row['id'] . '"><img src="delete.png" alt="Delete?" /></a></li>';

}
}

//End the un-ordered list
echo '</ul>';

?>

Hello all!

First, I'm a complete noob when it comes to php coding so bare with me on this. I know this might seem like a super simple thing to do, but as I said I'm a beginner at best.

What I have is a very simple contact form with three fields: name, email, and comments. The way I have it set up is that when someone fills out the form and hits the submit button, it sends me an email via Gmail with the values of the form. Pretty basic stuff.

The thing is, when I get the values in the email, it's all on one line and rather unflattering looking. It works for just me, I don't care really. But I'd like to turn around and use this form/php code I have for a client. The form for them is going to have a lot more input fields and I can only imagine the string of text that it's going to create.

What I would like to do is format the values that I or they receive via email so that it's a bit more presentable.
I have no idea how to do this.

Here's my php code connected to my form:

Code: [Select]
<?php

include_once("phpmailer/class.phpmailer.php");

$name = $_POST['name'];
$email = $_POST['email'];
$comments = $_POST['comments']; 

$mail = new PHPMailer();
$mail->IsSMTP();
$mail->SMTPAuth = true;
$mail->Host = "smtp.gmail.com";

$mail->SMTPSecure = "ssl";
$mail->Port = 465;

$mail->Username = "myemail@gmail.com";
$mail->Password = "xxxxxx";

$mail->AddAddress("mymail@gmail.com");
$mail->From = "mymail@gmail.com";
$mail->FromName = $_POST['name'];
$mail->Subject = "User Comment";
$mail->IsHTML(true);
$mail->Body = "Name: $name\n Email: $email\n Comments: $comments";


if($mail->Send()) {
   echo "Message sent! Thanks for your comments!";
} 
?>


so right now with that I get an email for example that looks like this:

Name: Bob Email: blank@blank.com Comments: I like soda!

where I would rather have something like:

Name: Bob
Email: blank@blank.com
Comments: I like soda!

Any advice would very much appreciated!

Hey Guys,

I've got a section of code that generates a date and time. This is currently standalone however I'm looking to integrate it with a standard page.

This is the code page:

<?php
error_reporting(0);
include("options.php");
include("include/functions.php");
include("include/class.php");


list($year,$month,$day) = explode("-",date("Y-n-j",strtotime($_REQUEST["date"])));
$bookFrom = formatDateByCalendarId($day,$month,$year,$_REQUEST["cid"]);


$sql = "SELECT * FROM ".$TABLES["Calendars"]." WHERE id=".$_REQUEST["cid"];
$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
$Calendar = mysql_fetch_assoc($sql_result);
$CalendarOptions = unserialize($Calendar["options"]);

$fontFamily = $Fonts[$CalendarOptions["fonts"]];
$daysFontSize = $FontSize[$CalendarOptions["daysFontSize"]];
$daysFontStyle = $Styles[$CalendarOptions["daysFontStyle"]];

$availableDaysFontSize = $FontSize[$CalendarOptions["availableDaysFontSize"]];
$availableDaysFontStyle = $Styles[$CalendarOptions["availableDaysFontStyle"]];
$timeSlot=new Timeslot($_REQUEST["cid"]);
$reservations=$timeSlot->getFreeFilter($CalendarOptions["startTime"],$CalendarOptions["endTime"],$year,$month,$day,$CalendarOptions["timeSlot"]);

if (!isset($_REQUEST["view"])) { $view = '1'; } else { $view = $_REQUEST["view"]; };

if ($_REQUEST["ac"]=='book') {

$message ='';

$format = GetCalendarDateFormat($_REQUEST["cid"]);

$sYear = GetYear($format,$_REQUEST["startDate"]);

$sMonth = GetMonth($format,$_REQUEST["startDate"]);

$sDay = GetDay($format,$_REQUEST["startDate"]);

$reservations=$timeSlot->getFreeFilter($CalendarOptions["startTime"],$CalendarOptions["endTime"],$sYear,$sMonth,$sDay,$CalendarOptions["timeSlot"]);

$sDateLong = strtotime($CalendarOptions["startTime"],mktime(0,0,0,$sMonth,$sDay,$sYear));

$first=-1;

$last=-1;

for ($i=0;$i<count($reservations);$i++) {

if (($_REQUEST[$i]=="on")&&((($reservations[$i]>0)&&($reservations[$i]==$_REQUEST["rid"]))||(!$reservations[$i]))) {

if ($first<0) $first=$i;

$last=$i;

}

}

$eDateLong = strtotime("+".($CalendarOptions["timeSlot"]*($last+1))." minutes",$sDateLong);

$sDateLong= strtotime("+".($CalendarOptions["timeSlot"]*$first)." minutes",$sDateLong);

if($_REQUEST["rid"]>0) {

$updateRange = $_REQUEST["rid"];

}

else $updateRange = NULL;

if(! $timeSlot->checkInterval($sDateLong,$eDateLong,$updateRange)){

$message = "Some of the timeslots on the selected date are already booked.";

} else {

$settings["status"]=$CalendarOptions["reservationStatus"];

$settings["notes"]=mysql_escape_string(utf8_encode($_REQUEST["notes"]));

$settings["customerName"]=mysql_escape_string(utf8_encode($_REQUEST["customerName"]));

$settings["phone"]=mysql_escape_string(utf8_encode($_REQUEST["phone"]));

$settings["email"]=mysql_escape_string(utf8_encode($_REQUEST["email"]));

$settings["price"]=$_REQUEST["price"];

if (! isset($updateRange))

$settings["dt"]=date("Y-m-d H:i:s");

if (! $timeSlot->addReservation($sDateLong,$eDateLong,$settings,$updateRange)) $message = 'Failed saving';

else {

if($_REQUEST["findReservation"]=="1") $_REQUEST["ac"]='findReservation'; 

else $_REQUEST["ac"]='view'; 

$_REQUEST["month"] = $sMonth*1;

$_REQUEST["year"] = $sYear;

$search_tokens=array("<Name>","<Email>","<Phone>","<Notes>","<Date>","<StartTime>","<EndTime>","<Price>");

$replace_tokens=array($_REQUEST["customerName"],$_REQUEST["email"],$_REQUEST["phone"],stripslashes($_REQUEST["notes"]),$_REQUEST["startDate"],formatTime($sDateLong,$_REQUEST["cid"]),formatTime($eDateLong,$_REQUEST["cid"]),$_REQUEST["price"]);

$MESSAGE_BODY=$CalendarOptions["emailMessage"];

$MESSAGE_BODY=nl2br(str_replace($search_tokens,$replace_tokens,$MESSAGE_BODY));
          $mailheader    = "From: ".$CalendarOptions["NotificationEmail"]."\r\n";

$mailheader   .= "Reply-To: ".$CalendarOptions["NotificationEmail"]."\r\n";

$mailheader   .= "Content-type: text/html; charset=iso-8859-1\r\n";

  if ($CalendarOptions["NotificationEmail"]<>'') {

if(!mail($CalendarOptions["NotificationEmail"], 'Reservation Confirmation', $MESSAGE_BODY, $mailheader)) 

$message="Failure sending e-mails.<br />";

  

  };

if ($_REQUEST["email"]<>'') {

if (!mail($_REQUEST["email"], 'Reservation Confirmation', $MESSAGE_BODY, $mailheader)) $message="Failure sending e-mails.<br />";

};

if($CalendarOptions["allowPaypal"]=="true" and $CalendarOptions["paypalAddress"]<>"" and $CalendarOptions["depositPayment"]>0 and isset($_REQUEST["price"]) and $_REQUEST["price"]>0){

$price = $_REQUEST["price"];

$deposit = $price * ($CalendarOptions["depositPayment"] / 100);

$_REQUEST["ac"]

= "redirectToPaypal";

}

else {

unset($_REQUEST["ac"]); 

}

$message.='Reservation saved.';

}

}

} 


echo '<div style="font-family:'.$fontFamily.'; color:#'.$CalendarOptions["availableDaysFontColor"].'; font-size:'.$availableDaysFontSize.'px; font-weight:bold">'.$message.'</div>';


if($_REQUEST["ac"]=="redirectToPaypal"){
} else {

?>

<?php

if(isset($_REQUEST["date"])){
?>
<form action="load-bookingform.php" method="post" name="frm" style="margin:0px; padding:0px" onsubmit="return false">
<table width="<?php echo $CalendarOptions["width"]; ?>" border="0" cellspacing="0" cellpadding="2" style='font-family:"<?php echo $fontFamily; ?>"; color:#<?php echo $CalendarOptions["availableDaysFontColor"]; ?>; font-size:<?php echo $availableDaysFontSize; ?>px; <?php echo $availableDaysFontStyle; ?>'>

<tr>

<td width="16%" align="left">Date:</td>

<td width="85%" align="left" name="startDate" id="startDate"><strong><?php echo $bookFrom; ?></strong></td>

</tr>

<?php

$price = 0;

?>

<tr>
       <td colspan="2">
       

<table width="100%" border="0" cellspacing="2" cellpadding="2">
                  <tr>
                    <td width="33%" valign="top" bgcolor="#DDDDDD">Start time</td>
                    <td width="33%" valign="top" bgcolor="#DDDDDD">End time</td>
                    <td colspan="2" valign="top" bgcolor="#DDDDDD">Book </td>
                  </tr>
            <?php 
                
                
                    for ($i=0;$i<count($reservations);$i++) {
            
                ?>
                  <tr>
                      <td align="left" style="border-bottom:1px solid #DFE4E8"><?php if ($CalendarOptions["timeFormat"]=='12') echo date("h:i A",strtotime("+".($CalendarOptions["timeSlot"]*$i)." minutes",strtotime($CalendarOptions["startTime"]))); else echo date("H:i",strtotime("+".($CalendarOptions["timeSlot"]*$i)." minutes",strtotime($CalendarOptions["startTime"]))); ?></td>
                      <td align="left" style="border-bottom:1px solid #DFE4E8"><?php if ($CalendarOptions["timeFormat"]=='12') echo date("h:i A",strtotime("+".($CalendarOptions["timeSlot"]*($i+1))." minutes",strtotime($CalendarOptions["startTime"]))); else echo date("H:i",strtotime("+".($CalendarOptions["timeSlot"]*($i+1))." minutes",strtotime($CalendarOptions["startTime"]))); ?></td>
                      <td width="34%" align="left" valign="top" style="border-bottom:1px solid #DFE4E8"><input  type="checkbox" id="<?php echo $i; ?>" name="<?php echo $i; ?>" <?php if ($reservations[$i]) { echo "checked"; echo ' disabled="disabled"'; } ?>  onclick="selectTimeSlot()" /></td>
                    </tr>
                  <?php 
                    };
            
            ?>
                
            </table>
      </td>
    </tr>

<tr>

<td align="left">&nbsp;</td>

    <td align="left">
        <input type="button" name="Button" value="Book" onclick="pass=checkForm(); if (pass) submitBooking('<?php echo $bookFrom; ?>','<?php echo date("n",strtotime($_REQUEST["date"])); ?>','<?php echo date("Y",strtotime($_REQUEST["date"])); ?>')" />
<input type="button" name="Button" value="Cancel" onclick="javascript: ajaxpage('<?php echo $SETTINGS["installFolder"]; ?>load-bookingform.php?cid=<?php echo $_REQUEST["cid"]; ?>','DateBookings<?php echo $_REQUEST["cid"]; ?>','get'); " />        
        </td>

</tr>

<?php

}
?>
</table>
</form>

<?php
};
?>

I already have a checkout page, that this info needs to be parsed to.

Any ideas how I can integrate it?

I have two (2) forms on the same pages, each with 3 buttons. When a button is clicked, it will include the desired page. Since I have 2 of these forms, clicking one of them will refresh the page thus "delete" the info former retrieved from the other form.

Is there a way to make the page "remember" the last form action?

I am working on a form that takes in 5 numbers as INPUT (the number range is from 1 to 10). Then, the OUTPUT will display the 5 numbers entered with their associated color. I am having problems getting the color value to show on the browser. Can someone please help as to what I am doing wrong?

Below is the code I have so far. 

<?php

error_reporting(0);
$position1 = $_POST['p1'];
$position2 = $_POST['p2'];
$position3 = $_POST['p3'];
$position4 = $_POST['p4'];
$position5 = $_POST['p5'];

 if ($_POST['clear'])
{
 $position1="";
 $position2="";
 $position3="";
 $position4="";
 $position5="";
 $message1="";
 $message2="";
 $message3="";
 $message4="";
 $message5="";
}
 if ($_POST['send'])
 

 {
$message1 = "P1:" ."\r\n" .$position1 ."\r\n" .$color1; // to create space we typed in ."\r\n"
$message2 = "P2:" ."\r\n" .$position2 ."\r\n" .$color2;
$message3 = "P3:" ."\r\n" .$position3 ."\r\n" .$color3;
$message4 = "P4:" ."\r\n" .$position4 ."\r\n" .$color4;
$message5 = "P5:" ."\r\n" .$position5 ."\r\n" .$color5;

$color1 = $position1;

  if ($position1 == "2,4,6,8,10")
    echo "Black";
     elseif ($position1 == "1,3,5,7,9")
      echo "Red";
       else
         echo "Number entered is not in game range.";

$color2 = $position2;

  if ($position2 == "2,4,6,8,10")
    echo "Black";
      elseif ($position2 == "1,3,5,7,9")
        echo "Red";
          else
            echo "Number entered is not in game range.";

$color3 = $position3;

   if ($position3 == "2,4,6,8,10")
     echo "Black";
       elseif ($position3 == "1,3,5,7,9")
         echo "Red";
           else
             echo "Number entered is not in game range.";

$color4 = $position4;

    if ($position4 == "2,4,6,8,10")
      echo "Black";
        elseif ($position4 == "1,3,5,7,9")
          echo "Red";
            else
              echo "Number entered is not in game range.";

$color5 = $position5;

    if ($position5 == "2,4,6,8,10")
      echo "Black";
        elseif ($position5 == "1,3,5,7,9")
          echo "Red";
            else
              echo "Number entered is not in game range.";

 }

?>
</div>

   <!-- START :: Input Form -->
<div align="center">
<form action = "" method = "POST">
<body>
<table border="0">
<tr>
 <td> P1: </td>
 <td> <input type = text name = p1 value = "<?php echo $position1;?>" size="2" autofocus></td>
 <td> P2: </td>
 <td> <input type = text name = p2 value = "<?php echo $position2;?>" size="2"></td>
 <td> P3: </td>
 <td> <input type = text name = p3 value = "<?php echo $position3;?>" size="2"></td>
 <td> P4: </td>
 <td> <input type = text name = p4 value = "<?php echo $position4;?>" size="2"></td>
 <td> P5: </td>
 <td> <input type = text name = p5 value = "<?php echo $position5;?>" size="2"></td>
<tr>
  <td colspan="10">&nbsp;</td>
</tr>
<tr>
 <td colspan="10" align="center">
  <input type = "submit" name="send" value = "GET POSITION COLORS" title="Click here to display color values.">
  <input type = "submit" name="clear" value = "RESET" title="Click here to clear text boxes.">
<?php
echo "<br><br>";
echo "<font face='arial' size='4'>";
echo $message1;
echo "<br>";
echo $message2;
echo "<br>";
echo $message3;
echo "<br>";
echo $message4;
echo "<br>";
echo $message5;
echo "</font>";
?>
 </td>
</tr>
</table>
</form>
 </div>
   <!-- END :: Input Form -->

</body>
</html>

----- EOF ----

I found this site: http://www.wallpaperama.com/forums/how-to-save-html-output-code-from-php-script-t6898.html
it demonstrates how to save html output code from php script. here is an example: http://ads4agents.com/date.php

I cant get it to work on my site...where is the correct place ad these:
ob_start();

$HtmlCode= ob_get_contents();
ob_end_flush();


How can I get this to work in my php?

view_ad.php

<html>
<body>
<center>
<br/>
<h1>Apartment Reference #: <?php
echo $_POST["reference"]; ?><br /></h1>
<br/>
<?php echo $_POST["application"]; ?>, <?php echo $_POST["deposit"]; ?><br />
<?php echo $_POST["pets"]; ?><br />
<br/>
<?php echo $_POST["community"]; ?><br />
<?php echo $_POST["interior"]; ?><br />
<?php echo $_POST["amenities"]; ?><br />
<br/>
<?php echo $_POST["contact"]; ?><br />
<a href="<?php
echo $_POST['website'] ?>"><?php echo $_POST['website'];?></a><br/>
<br/>
<br/>
<br/>
</body>
</html>

Hello! Im new here and want to start my new php carreer 
Well, I'm already working quite hard, but now I don't know what to do

I've got it so far:

<?php echo html::chars($message->text); ?>

Is there any way I could modify the output, so it just displays the first 20 characters or so?


Thank you all very much!

I have noticed that today that some of the content that is saved from my form is printing random characters and crap.

I am using htmlentities on the form input and it seems to be adding more rubbish.

I am using the UTF-8 charset as a meta tag.

Is this the correct way of using htmlentities?

htmlentities($string,  ENT_QUOTES, 'UTF-8')

Also i noticed the other day with a problem I had that using htmlentities was replacing " with &amp;&quot; when i thought it should have just been &quot;

I have a form where people enter in values and I need these values displayed in the proper format.  I need the output string to have a "<" at the beginning and a ">" at the end but whenever I put the code in to add the < in the beginning nothing shows up.  Here is my code.  I am able to get it to work with just adding the > at the end but it seems when I add "<" to the beginning this is where nothing shows up.
Code: [Select]
<?php
$hairbald   = trim($_POST['HairBald']);
$eyes   = trim($_POST['Eyes']);

$test =$eyes.'.'.$hairbald;

if(empty($test)) { $test = $test; }
  else
    $test = '<'.$test.'>';
?>
If the user selects blue eyes and bald head I need the output to be <blue.bald>

Hi,

Ok so I have the youtube url input working and it shows the video fine have a look at
Code: [Select]
http://www.cyberhost.me/test

But now what I need is for the script to display the embed code needed for the user.

This is the script:

Code: [Select]
<?php
 $text = $_POST["text"];
 if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form
 ?>
 <html>
 <head>
 <title>Youtube code generator</title>
 </head>
 <body>
 <p>Copy and paste this url for example: http://www.youtube.com/watch?v=YdDIsImNfBY&feature</p><br/><br/>
 <form method="post" action="<?php echo $PHP_SELF;?>">
 Youtube URL:<input type="text" size="50" maxlength="50" name="text"><br />
 <input type="submit" value="submit" name="submit">
 </form>
 <?php
 } else {
 
 
//space anything that would get included in a link, add the space
$text = str_ireplace(array("<br />","\n","\r"),array(" <br /> "," \n "," \r "),$text);
$text = str_replace("  ", " ", $text);
//explode the text by spaces
$text_explode = explode(" ",$text);
//loop replacing youtube links with embed codes, if not youtube embed return text
foreach($text_explode as $words){
if (preg_match('~(?:youtube\.com/(?:[^/]+/.+/|(?:v|e(?:mbed)?)/|.*[?&]v=)|youtu\.be/)([^"&?/ ]{11})~i', $words, $match)) {
$vidid = $match[1];//the id
$link = "http://youtu.be/$vidid";//short link to video

//grab the title
$visit_url = "http://gdata.youtube.com/feeds/api/videos/".$vidid;
$doc = new DOMDocument;
 @$doc->load($visit_url);
$link_title = $doc->getElementsByTagName("title")->item(0)->nodeValue;
if($link_title == ""){
$link_title = "Click to watch video.";
}
//display a link
echo "<h3><a href='$link' TARGET='_blank'>$link_title</a></h3>";
//embed the video
echo "<div>";
echo "<object style='height: 390px; width: 640px'>
<param name='movie' value='http://www.youtube.com/v/$vidid&fs=1'>
<param name='allowFullScreen' value='true'>
<param name='allowScriptAccess' value='always'>
<embed src='http://www.youtube.com/v/$vidid&fs=1' type='application/x-shockwave-flash' allowfullscreen='true' allowScriptAccess='always' width='640' height='390'></object>";
echo "</div><br />";
} else {
//keep the original words
echo " $words ";
}
}
 }
?>

The code I need displayed below is

Code: [Select]
<p> <img height="350" width="425" class="fw_media_youtube fw-parse" alt="YouTube-CODE PLACED HERE" src="http://thumbs.webs.com/Platform/mediaPreview.jsp?type=YouTube&amp;id=CODE PLACED HERE"/></p>

Where you see "CODE PLACED HERE" is where i need the video id placed and then for it to be displayed.

Any idea how I would do this?

Thanks in advance

Hi,   I need to create a landing page with a form. That form needs to be recorded somewhere instead of sent to email. I know I can write it to a SQL database, and then to an excel file. But I only need a temporary solution so I figured I'd just go straight to CSV.    Is this bad practice? What potential problems might I encounter other than security issues?