PHP - Please Help With Displaying Text In Columns

Hi,

I am stuck. I have used dreamweaver to create a master details page with links to the details page successfully, but I would like to display the master details page results in 3 columns rather than the 1 column that dreamweaver defaults. As the site becomes richer the content will increase yielding many results, therfore the content displayed in a single column will require the users to scroll way down the page.

So, as it is now the results display as follows:

Plant1
Plant2
Plant3
Plant4
Plant5
Plant6
Plant7
Plant8
Plant9
etc...

I would like them to display as follows:
Plant1        Plant4        Plant7
Plant2        Plant5        Plant8
Plant3        Plant6        Plant9

Here is my code thus far:
<?php require_once('Connections/connGND.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_connGND, $connGND);
$query_rsBotanicalA = "SELECT * FROM plants WHERE CatIDB = 'A'";
$rsBotanicalA = mysql_query($query_rsBotanicalA, $connGND) or die(mysql_error());
$row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA);
$totalRows_rsBotanicalA = mysql_num_rows($rsBotanicalA);
?>
<table border="0" align="left">
  <?php do { ?>
    <tr>
      <td align="left"><a href="plantdetails.php?recordID=<?php echo $row_rsBotanicalA['PlantID']; ?>"> <?php echo $row_rsBotanicalA['BotanicalName']; ?>&nbsp; </a></td>
    </tr>
    <?php } while ($row_rsBotanicalA = mysql_fetch_assoc($rsBotanicalA)); ?>
</table>

Could someone help me to write this code, as I have been unsuccessful maintaining the links. I have been able get the results to display in the columsn as I would like, but I haven't been able to figure it out while maintaining the links!

Thanks.

i have a file called filename.txt with the csv as below

Date,cet,predict,16d
Wed 02/15 @ 12Z,0.7,3.4,x
Wed 02/15 @ 18Z,0.7,3.3,x
Thu 02/16 @ 00Z,0.7,3.3,x
Thu 02/16 @ 06Z,1.1,3.7,x
Thu 02/16 @ 12Z,1.1,3.7,x

i would like the date to be replaced by numbers 1,2,3... and to be an array, and also the 2nd value in each row to be an array.

the number of rows is not fixed and grows day by day.

so the result would be (1,2,3,4,5) and (0.7,0.7,0.7,1.1,1.1).

can someone please help?

i guessed that some sort of loop is needed to go through row by row, adding values to an array.

I have tried the following with no success:

Code: [Select]
// get data from the file
$data = file_get_contents('filename.txt');

// use the newline as a delimiter to get different rows
$rows = explode("\n", $data);
// go through all the rows starting at the second row
// remember that the first row contains the headings
for($i = 1; $i < count($rows); $i++){
$temp = explode(',', $rows[$i]);
$date = $temp[0];
$cet = $temp[1];
$stack = array($stack);
array_push($stack, $cet);}
print_r ($stack);

I currently am working on a project where I code a "simple" telephone directory.

There are three main tasks that it needs to do:
1. Directory.php(index page) has a "First Name" and "Last Name" field and a search button. When a name is searched from the directory.txt file, it displays First Name, Last Name, Address, City, State, Zip and phone in findinfo.php in designated text boxes...first name, last name, etc.

2. From the findinfo.php, like previously stated, the users information is listed in the appropriate text boxes. From there, there is an update button that will overwrite the user's information to directory.txt if that button is selected. It will then say the write was sucessful.

3. (completed this step) From the index page, there is a link that will take you to addnew.php where you enter First Name, Last Name, Address, City, State, Zip and phone in a web form and write it to directory.txt.

 This is the php code for the third step:

<?php
$newentryfile = fopen("directory.txt", "a+");
$firstname = $_POST['fname'];
$lastname = $_POST['lname'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];
$phone = $_POST['phone'];
$newentry = "$firstname $lastname\n\r $address\n\r $city, $state $zip\n\r $phone\n\r";
if (flock($newentryfile, LOCK_EX)) {
if (fwrite($newentryfile, $newentry) > 0)
echo "<p>" . stripslashes($firstname) . " " .
 stripslashes($lastname) . " has been added to the directory.</p>";
else
echo "<p>Registration error!</p>";
flock($newentryfile, LOCK_UN);
}
else
echo "<p>Cannot write to the file. Please try again later</p>";
fclose($newentryfile);

if(empty($firstname) || empty($lastname) || empty($address) || empty($city) || empty ($state) || empty($zip) || empty($phone))
{
echo "<p>Please go back and fill out all fields.</p>";
}
?>


So to sum it all up, what would be my best approach? I am totally stumped and not sure which function to use. Should I work my way from step 1 to step 2? I see it as when I do the search for the name from directory.php, it takes me to findinfo.php, listing the users information in the text boxes. From there, if I needed to, having the user's information already listed I could hit the update button to overwrite the new information to directory.txt. Doing the update when then tell me that the write was successful.

I have literally been scouring the internet for hours. What would be the best function to do this? I hope I was clear enough. Please help me out and thank you for your time.

Hello,

I have a long list of webpage addresses like this which extends below the fold / the bottom of a user's screen:

Webpage 1
Webpage 2
Webpage 3
Webpage 4
Webpage 5
Webpage 6
Webpage 7
Webpage 8
Webpage 9
Webpage 10
Webpage 11 etc...

I want to take this long list of words and split them into columns so that the reader never has to scroll down. Please can you tell me the best way of going about this? (should I just design for a specific screen resolution? - if so which screen resolution should I design for?).

Many thanks,

Stu

This script is supposed to run in the command line.

Like the title says, I need to:

Import some columns (input the names with an argument) from a .CSV file Split the column into blocks of 500 lines Translate this pieces Put them back into the original file

I already have some code but it is unfinished and not working:
<?php

//name of the .CSV file
$filename = $argv[1];

//name of the column to be translated
$header_name = $argv[2];

//open file
$file_handle = fopen($filename, "r");

$i=0;
$j=0;
$counter = 0;
$translated = '';
$string = '';

while (!feof($file_handle) ) {

$counter++;

$line_of_text = fgetcsv($file_handle, 1024);

//find the column id that contains the header name.
// headers are always on the the first line
if ( $counter == 1 ){
     while ($line_of_text[$i] != $header_name) $i++;
      $header_id = $i;
                              }

//create the blocks
$string .= $line_of_text[$i];

if ($counter % 500 == 0)
   {
  $gt = new GoogleTranslateWrapper();
 $translated .= $gt->translate($string, "en");
    }


}

//Write the translate column in the same .CSV file

fclose($file_handle);


?>

Any help in rewriting this to work? 

I've got a simple internal messaging system that I'm trying to get the text to display the way it was entered when a message was sent.  The messages are inserted into the database using variables generated through this function:

Code: [Select]
<?php
function safe($value){
return mysql_real_escape_string($value);
} 

$staffid=form($_POST['staffid']);
$from=safe($_POST["from"]);
$category=form($_POST['category']);
$subject=safe($_POST["subject"]);
$message=safe($_POST["message"]);
$grade=form($_POST['grade']);
?>

when the text is inserted, there are back slashes automatically inserted behind certain punctuation marks.

For example, is someone sends a message that says, "Someone's using phpfreaks forums."  It would be inserted as, "Someone\'s using phpfreaks forums."

How can I stop this from happening?  Or how can I remove the "\" when displaying the string on the web page?  Any help is greatly appreciated.

I've taken this eg from php manual site for displaying txt on image wonder why it is not working

Code: [Select]
<?php
// Create a 300x150 image
$im = imagecreatetruecolor(300, 150);
$black = imagecolorallocate($im, 0, 0, 0);
$white = imagecolorallocate($im, 255, 255, 255);

// Set the background to be white
imagefilledrectangle($im, 0, 0, 299, 299, $white);

// Path to our font file
$font = './arial.ttf';

// First we create our bounding box for the first text
$bbox = imagettfbbox(10, 45, $font, 'Powered by PHP ' . phpversion());

// This is our cordinates for X and Y
$x = $bbox[0] + (imagesx($im) / 2) - ($bbox[4] / 2) - 25;
$y = $bbox[1] + (imagesy($im) / 2) - ($bbox[5] / 2) - 5;

// Write it
imagettftext($im, 10, 45, $x, $y, $black, $font, 'Powered by PHP ' . phpversion());

// Create the next bounding box for the second text
$bbox = imagettfbbox(10, 45, $font, 'and Zend Engine ' . zend_version());

// Set the cordinates so its next to the first text
$x = $bbox[0] + (imagesx($im) / 2) - ($bbox[4] / 2) + 10;
$y = $bbox[1] + (imagesy($im) / 2) - ($bbox[5] / 2) - 5;

// Write it
imagettftext($im, 10, 45, $x, $y, $black, $font, 'and Zend Engine ' . zend_version());

// Output to browser
header('Content-Type: image/png');

imagepng($im);
imagedestroy($im);
?>

$('input#name-submit').on('click', function() {
var name = $('input#name').val();
if ($.trim(name) != '') {
$.post('play2.php', {name: name}, function(data) {
$('div#name-data').text(data);
});
}
});

data contains html code but when it is displayed it is displayed as text and shows the html, how can I get the html code to function properly?

thanks

So, I'm trying to get this read my text document "news.txt" and display the contents.

My code:
Code: [Select]
div.newscontent{
padding:0px;
margin-top:60px;
margin-bottom:0px;
margin-left:400px;
margin-right:0px;
position:absolute;
width:457px;
height:330px;
text-align:center;
color:#FFFFFF;
}
Code: [Select]

<div class='newscontent'>
<?PHP

$filename = "news.txt";
$arr = file($filename);
foreach($arr as $line){
    print $line . "<br/>";
}

?>
</div>
This is the output I get:
Code: [Select]
"; } ?>
Whats wrong?

Is there a way to echo the results of a query as separate columns as opposed to one under the other?

Hey guys, I have made an array where only the name shows up, but I want the price next to it. I adapted the query, but how do I need to adapt the array? peace
Code: [Select]
<?php

// connect to your database
      
      $DrinkArray=array()   ;
  

      $DrinkResult=mysql_query("SELECT name,price FROM products")or die(mysql_error());

      while($DrinkRow=mysql_fetch_assoc($DrinkResult)){
         $DrinkArray[]=$DrinkRow['name'];

      }

      //check your output with something like this
      foreach($DrinkArray as $value){
         echo $value.'<br />';
      }
?>

Hello - hope you are all well.   I am creating a website for a family friend who has a shop. See preview of the site in this picture ....  Picture1.jpg   40.32KB   0 downloads   Currently the results are showing in one column. I want to show them in three columns in the format of:   1 2 3 4 5 6  7 8 9 etc   But formatted with the picture and then the title and the border.   The current code i have is....     HEAD   <?php $sql = "SELECT * FROM abs_productcat WHERE catid = $catid ORDER BY catid ASC";
$can = mysql_query($sql);
$catname = mysql_fetch_assoc($can); ?>       BODY    <?php while ($row_pro = mysql_fetch_assoc($rs_proddetails)) { ?><tr>
                            <td><table width="243" border="0" align="left" cellpadding="15" cellspacing="0" class="sectionborders">
                             
                              <tr>
                                <td height="120" align="center"><p><strong><a href="indproducts.php?ProductID=<?php echo $row_pro['ProductID']; ?>"><img src="products/product_<?php echo $row_pro['ProductID']; ?>" alt="<?php echo $row_pro['ProductName']; ?>" height="120" class="sectionborders" border="0" /></a></strong></p>
                                  <p><strong><a href="indproducts.php?ProductID=<?php echo $row_pro['ProductID']; ?>" class="products"><?php echo $row_pro['ProductName']; ?></a></strong></p></td>
                              </tr>
                              </table></td>
                          </tr>
                          <tr>
                            <td>&nbsp;</td>
                          </tr> <?php } ?>       THANK YOU FOR YOUR HELP!!!  

I'm working on a site where I've implemented a simple back end wysiwyg editor for content on a page. Then on the public page I run a php query to pull that content and display it. But doing this cancels out the css I have been using to split content into two columns. Is there a way to do this in php, or is there a way to circumvent the problem?  ( also tried echoing the entire css style along with the query result - that didn't work either)

The <p id='container_sub'> is what is split into two columns. I tried it outside of the query, and inside the query around where I echo results. Neither worked.
Here's the basic php code, and further down the css that makes two columns:
Code: [Select]
<?php

$pageid = '2';
  
// Formulate Query
// This is the best way to perform an SQL query
// For more examples, see mysql_real_escape_string()
$query = sprintf("SELECT content FROM tbl_pages WHERE page_id='%s'",
     mysql_real_escape_string($pageid));

// Perform Query
$result = mysql_query($query);

// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}

// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while ($row = mysql_fetch_assoc($result)) {
    echo "<p id='container_sub'>".$row['content']."</p>";

}

// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);
      
?>

The css....
Code: [Select]
#container_sub {-moz-column-count: 2;
-moz-column-gap: 25px;
-webkit-column-count: 2;
-webkit-column-gap: 20px;
column-count: 2;
column-gap: 20px;}

#container_sub2 {-moz-column-count: 2;
-moz-column-gap: 25px;
-webkit-column-count: 2;
-webkit-column-gap: 20px;
column-count: 2;
column-gap: 20px;}

Hi, I have a piece of code which I trying to search two columns but I just cant get it to work.  Instead it just dumps around 30 entries onto the page.  Can anyone point me in the direction of how to search two columns?

Code: [Select]
$query = "SELECT * FROM questions";

if(isset($_GET['question']) && !empty($_GET['notes'] ))
{
/*query the database*/
$question = $_GET['question'];
$notes = $_GET['notes'];
$query .= " WHERE question && notes like '%$question%' LIMIT 0, 10";
}

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

{

$question = $row['question'];
$notes = $row['notes'];

echo "$question
$notes  </br>";
}

I have a page that displays a list of retail locations (est. 100-150 locations).

I have my layout setup to fit 3 columns side by side. Ex:

<div class="col"></div>
<div class="col"></div>
<div class="col"></div>

.. with the "col" class having a specific width and float: left.

Basically, I want to print out the locations in the column and when a column reaches a certain number of locations, it closes that div and starts a new one and continues printing the rest of the locations.

How would I go about making sure that once a column has reached a certain number of locations, it closes the div and starts the new one?