PHP - Format Table According To Data Type

I have a text box that I use to post comments and save them to my database. I can go to the database and the data I entered looks perfect but when I pull it out it all runs together.

 

This is how I entered it and the way it is in the database:

I have a text box that I use to post comments and save them to my database.
I can go to the database, the data I entered looks perfect but when I pull it out and display it it all runs together.
No new lines just all one paragraph.
Can someone help?

This is how it came out:

I have a text box that I use to post comments and save them to my database. I can go to the database, the data I entered looks perfect but when I pull it out and display it it all runs together. No new lines just all one paragraph. Can someone help?

I got it indenting the paragraphs, but I get all the data back I entered all in 1 paragraph, is there something I am missing to be able to recognize the new lines??

My website sends me an e-mail when there is an error, and I would like it to look like this...
Code: [Select]
Date: 2012-03-17 12:36:46pm
Results Code: EMAIL_USER_NOT_LOGGED_IN_2127
Error Page: /members/change_email.php
Member ID: 0
IP Address: 127.0.0.1
Host Name: localhost

However my PHP code isn't giving me that...

$body = "A website error has occurred...\n\n";
$body .= "Date: \t\t" . date('Y-m-d g:i:sa', time()) ."\n";
$body .= "Results Code: \t\t" . $resultsCode . "\n";
$body .= "Error Page: \t\t" . $errorPage . "\n";
$body .= "Member ID: \t\t" . $memberID . "\n";
$body .= "IP Address: \t\t" . $ip . "\n";
$body .= "Host Name: \t\t" . $hostName . "\n";


What is wrong?

Thanks,


Debbie

Is this proper PHP...

    function setHeat(Building $b) {
        $this->hotness = $b->getInsideHeat();
    }

That looks more like Java to me.  I thought you didn't define data-types anywhere in PHP?!


TomTees

Hi Masters,   I'll be making a big ticketing program with PHP and I cant decide what data type to use.   Thanks, Marvin

I have a payment form with the following code...

Code: [Select]
<!-- Expiration Month -->
<span class="group">
<label class="innerlabel" for="expMonth">Month</label><!-- -->
<select id="expMonth" name="expMonth">
<option></option>
<option>01</option>
<option>02</option>
<option>03</option>
<option>04</option>
<option>05</option>
<option>06</option>
<option>07</option>
<option>08</option>
<option>09</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
</span>

How is that data represented as far as Data-Type?? 

Is it treated as a String or an Integer??

How can I ensure that when I sent it to the Payment Gateway that it is treated as a Two-Digit value??

Thanks,



Debbie

This topic has been moved to Other.

http://www.phpfreaks.com/forums/index.php?topic=355929.0

Hi,   I want to display my data in this format  format.JPG   54.52KB   0 downloads   Expense data i am getting like this

 <td><?php
	$in = "SELECT sales_invoice.invoice_id as INID, DATE_FORMAT(sales_invoice.date_invoiced,'%M') AS month, sales_invoice_line_items.invoice_id, SUM(sales_invoice_line_items.sub_total) AS Total, SUM(sales_invoice_line_items.tax_amount) AS total_tax FROM sales_invoice INNER JOIN sales_invoice_line_items ON sales_invoice.invoice_id=sales_invoice_line_items.invoice_id GROUP BY sales_invoice.invoice_id, DATE_FORMAT(sales_invoice.date_invoiced, '%Y-%m')";
	
	$in1 = mysql_query($in) or die (mysql_error());
	$total=0;
	$tax =0;
	while($income = mysql_fetch_array($in1))
	{
		
		$total +=$income['Total']; 
		$tax +=$income['total_tax'];
		echo $total - $tax; }
    ?>
    
    </td>

And Profit i am getting like this

<td><?php
	$in = "SELECT purchase_invoice.invoice_id as INID, DATE_FORMAT(purchase_invoice.date_invoiced,'%M') AS month, purchase_invoice_line_items.invoice_id, SUM(purchase_invoice_line_items.sub_total) AS Total, SUM(purchase_invoice_line_items.tax_amount) AS total_tax FROM purchase_invoice INNER JOIN purchase_invoice_line_items ON purchase_invoice.invoice_id=purchase_invoice_line_items.invoice_id GROUP BY purchase_invoice.invoice_id, DATE_FORMAT(purchase_invoice.date_invoiced, '%Y-%m')";
	
	$in1 = mysql_query($in) or die (mysql_error());
	$total=0;
	$tax =0;
	while($income = mysql_fetch_array($in1))
	{
		
		$total +=$income['Total']; 
		$tax +=$income['total_tax'];
		echo $total - $tax; }
    ?>
    
    </td>

I dont know how to display data like this. Do i need to change the the table structure in my database? Please suggest

I am using a query to select everything out of a table in to an array. I have 4 fields as follows name, email, comment and datatime. What i want to do is use one of the stated function to grab the datetime elements and split them at the break point, but i am displaying more than one record with in the table, i think this is were i am fucking up.

for example i tryied this:
Code: [Select]
                $commentsTable = "comments";
            $comments = "SELECT * FROM  $commentsTable";
$commentResults = mysql_query($comments);
$commentRows = mysql_fetch_array($commentResults);

$dateTimeSplit = explode(" ", $commentRows['datetime']);

               
               <?php while($commentRows = mysql_fetch_array($commentResults)){?>
    <div id="comments">
    <div id="CommentWrapper">
            <div id="comment">
                <div id="UserComment"><? echo $commentRows['comment'];?></div>
                 // here is were am having the problem!!!
                <div id="PostDateTime"><i>Posted: </i><? echo $dateTimeSplit['0'];?><i> Time: </i><? echo $dateTimeSplit['1'];?></div>
            </div>
        </div>
    </div>
<?php } mysql_close(); ?>

any sudgestions?

hello,

lets say i want 3 of the following columns to only display on 1 line always, is there a way to do that?

Code: [Select]
<th align='center'>Date</th>
<th align='center'>Supplier</th>
<th align='center'>Requested By</th>
<th align='center'>Address of Job</th>
<th align='center'>Job Number</th>
<th align='center'>P.O. Number</th>
<th align='center'>Description</th>
<th align='center'>Amount</th>
<th align='center'>Notes</th>
<th align='center'></th>

Hey, I am grabbing a date from a row in my table which is currently formatted as:
date("Y-m-d")
2010-09-29

So in my code I have something like this:

$row['date'];

How do I use this to rearrange the date to look like:

09-29-2010

I looked at the formatting tutorials, but they explain how to format it for the date you are currently setting into a variable.

Hello all,

I just created this function that I want to use in CLi mode. It works perfectly in regular browser mode, but gives me this error on Cli mode if I do convertToCamelCaps('TEST STRING');

PHP Catchable fatal error:  Argument 1 passed to convertToCamelCaps() must be an instance of string, string given in file...


if (!function_exists('convertToCamelCaps')) {
function convertToCamelCaps(string $string, $initialCaps=FALSE) {
if ($words = explode(' ',$string)) {
foreach ($words as $index => &$word) {
$word = strtolower($word);
if($index==0 && $initialCaps===FALSE) { continue; }
$word = ucwords($word);
}
return implode('',$words);
}
return FALSE; 
}
}


If I remove the string datatype requirement in the function before the function argument list, it works fine in CLi mode.

Hi all -

I am parsing info from mysql into a php table but the date being returned is in YYYY-MM-DD format and I want it DD-MM-YYYY. How would I do this?

Code at the moment is:

Code: [Select]
$link = connect();

function get_user_posts(){

$getPosts = mysql_query('SELECT a.id as id,a.post as question, a.answer as answer, a.created as created, a.updated as updated, b.vclogin as admin
FROM user_posts as a, admin as b WHERE a.admin_id=b.adminid',connect());
return $getPosts;
}


Code: [Select]
<table class="list">
<tr>
<th><?php echo getlocal("upost.post") ?></th>
<th><?php echo getlocal("upost.answer") ?></th>
<th><?php echo getlocal("upost.admin") ?></th>
<th><?php echo getlocal("upost.created") ?></th>
<th><?php echo getlocal("upost.updated") ?></th>
<th></th>
<th></th>
</tr>
<?php 
$all_questions = get_user_posts();

while ($question = mysql_fetch_assoc($all_posts)):
?>

<tr>
<td><?php echo $post['post']?></td>
<td><?php echo $post['answer']?></td>
<td><?php echo $post['admin']?></td>
<td><?php echo $post['created']?></td>
<td><?php echo $post['updated']?></td>
<td><a href="javascript:user_post('<?php echo $post['id']?>')">edit</a></td>
<td><a href="javascript:delete_post('<?php echo $post['id']?>')">delete</a></td>
</tr>


THANKS!

can anione help me to display imageid along wid each image in table format...here is my code which takes image from user....n d id can b anithing i mean its ur choice u can start wid first image by giving it imageid 1 n can continue til d image ends


<?php
mysql_connect("localhost","root","");
@mysql_select_db(proj) or die( "Unable to select database");
$query="SELECT * FROM form";
$result=mysql_query($query);

//define a maxim size for the uploaded images in Kb
 define ("MAX_SIZE","100");

//This function reads the extension of the file. It is used to determine if the file  is an image by checking the extension.
 function getExtension($str) {
         $i = strrpos($str,".");
         if (!$i) { return ""; }
         $l = strlen($str) - $i;
         $ext = substr($str,$i+1,$l);
         return $ext;
 }

//This variable is used as a flag. The value is initialized with 0 (meaning no error  found) 
//and it will be changed to 1 if an errro occures. 
//If the error occures the file will not be uploaded.
 $errors=0;
//checks if the form has been submitted
 if(isset($_POST['Submit']))
 {
    //reads the name of the file the user submitted for uploading
    $image=$_FILES['image']['name'];
    //if it is not empty
    if ($image)
    {
    //get the original name of the file from the clients machine
       $filename = stripslashes($_FILES['image']['name']);
    //get the extension of the file in a lower case format
        $extension = getExtension($filename);
       $extension = strtolower($extension);
    //if it is not a known extension, we will suppose it is an error and will not  upload the file, 
   //otherwise we will do more tests
 if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))
       {
      //print error message
          echo '<h1>Unknown extension!</h1>';
          $errors=1;
       }
       else
       {
//get the size of the image in bytes
 //$_FILES['image']['tmp_name'] is the temporary filename of the file
 //in which the uploaded file was stored on the server
 $size=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($size > MAX_SIZE*1024)
{
   echo '<h1>You have exceeded the size limit!</h1>';
   $errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name=time().'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$newname="upload/".$image_name;
//we verify if the image has been uploaded, and print error instead
$copied = copy($_FILES['image']['tmp_name'], $newname);
if (!$copied)
{
   echo '<h1>Copy unsuccessfull!</h1>';
   $errors=1;
}}}}

//If no errors registred, print the success message
 if(isset($_POST['Submit']) && !$errors)
 {
    $sql=mysql_query("INSERT INTO image (img) VALUES('$newname')");
   if($sql)
   {
    echo "<h1>File Uploaded Successfully! Try again!</h1>";
   }
   
 }

 ?>

 <!--next comes the form, you must set the enctype to "multipart/frm-data" and use an input type "file" -->
 <form name="newad" method="post" enctype="multipart/form-data"  action="">
 <table>
 
    <tr><td><input type="file" name="image"></td></tr>
    <tr><td><input name="Submit" type="submit" value="Upload image"></td></tr>
 </table>   
 <p><a href="resizeimg.php">resize the images </a></p>
 </form>
 <p>&nbsp;</p>
 


here is my code for displaying d images

Hi

I have the following for an input form,  I was under the impression that ucwords would format the text into Initial Characters, but this does not do that?  What have I done wrong?

$ven_name = trim(ucwords(mysql_prep($_POST['ven_name'])));

Hi

I have a table that populated by a recordset, and wondered whether is was possible to make a row background colour = red where a particular cell = some text?

I have been searching around and not managed to find anything of use.

Any help would be appreciated.