PHP - Text Columns To Arrays?

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? 

Hi,

I have an ajax response text string that looks something like this: "part2=true;part7=false;part9=false;..."
I would like to turn this string into an array, that looks like this:

part2 = true
part7 = false
part9 = false

I know to use the explode function, but that will only break it into an array either by using the "=" or ";" as a delimiter....
Thank you for any help.

I have this thing that i am trying to make but i cant get it to work.. can anyone help?

Code: [Select]
function sql_read( $dbname,$dbusername,$dbpassword )
{
$names = array();
$password = array();


$connect = @mysql_connect("mysql11.000webhost.com",$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");


$query = mysql_query("select * from users");
$numrows = mysql_num_rows($query);

if ($numrows > 0){

while($row = mysql_fetch_assoc($query)){

$names[] = $row["uname"];
$password[] = $row["password"];
$id = $row["id"];

}
$return = array($names,$password,$id);

}else{
$return = array();
}


return $return[];
}



$names = array();

$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];


The error i get is
Code: [Select]
Parse error: syntax error, unexpected '[' in /home/a5480952/public_html/sql/index.php on line 28
Line 28 is "$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];"

Please help... i REALLLLD need help with this.. ask questions if you want to know more about what i am trying to do... thanks!

I'm having troubling with trying to create a function to spit out a single array with the following array. I can write it in a away that looks through the arrays manually. 

the results i am trying to generate is that each item in generated array.

Array to convert

array(
    "account" => array(
        "login",
        "register",
        "logout",
        "edit",
    ),
    "p" => array( 
        "report",
    ),
    "array1.0" => array( 
        "array2.0" => array(
            "array3.0",
            "array3.1
        ),
        "array2.1",
    ),

generating the array will look like this

 

Array ( 
[0] => account 
[1] => account/login 
[2] => account/register 
[3] => account/logout 
[4] => account/edit 
[5] => p 
[6] => p/report 
[7] => array1.0 
[8] => array1.0/array2.0
[9] => array1.0/array2.0/array3.0
[10] => array1.0/array2.0/array3.1
[11] => array1.0/array2.1

)

The idea is that id generates a single array with combined labels and arrays inside, etc. I just can't figure out how to create a script that will create this array even If I add a new value or array. 

 

I have two arrays, both with the same key values. I'd like to combine them. So for instance...

Code: [Select]
<?php
$array1['abcd'] = array( 'value1' => "blah", 'value2' => "blahblah");
$array1['efgh'] = array( 'value1' => "ha", 'value2' => "haha", 'valuex' => "xyz");

$array2['abcd'] = array('value3' => "three", 'value4' => "four");
$array2['efgh'] = array( 'value3' => "hohoho", 'value6' => "six6");

function combine_arrays($array1,$array2)
{

//*combining*
return $single_array;
}

echo "<pre>";
print_r(combine_arrays($array1,$array2));
echo "</pre>";

/*
would produce 

['abcd'] = ( 'value1'  => "blah",
                 'value2'  => "blahblah",
                 'value3'  => "three",
                 'value4'  => "four" )

['efgh'] = ( 'value1' => "ha",
                 'value2' => "haha",
                'valuex'  => "xyz",
                'value3' => "hohoho",
                'value6' => "six6" )
*/
?>
What's the easiest way to do this?

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

I am editing code to get sku numbers, for now it just prints as below:

SKU: 123
SKU: 322
SKU: 444
SKU: 555
SKU: 666

I want to put them in columns so it prints as:

SKU: 123      SKU: 322     SKU: 444       SKU: 555
SKU: 666      etc.              etc.

So it is devided into 4 columns.

The code that controls is:
Code: [Select]
<?php if (is_array($order->products)) {
                            $context = array(
                              'revision' => 'formatted',
                              'type' => 'order_product',
                              'subject' => array(
                                'order' => $order,
                              ),
                            );
                            foreach ($order->products as $product) {
                              $price_info = array(
                                'price' => $product->price,
                                'qty' => $product->qty,
                              );
                              $context['subject']['order_product'] = $product;
                              $context['subject']['node'] = node_load($product->nid);
                              ?>
                      <?php echo $product->model; ?><br />
                             
                          <?php }
                              }?>
i would appreciate some help

I have a 2 part question i hope is an easy Fix, i know very little about any of this, I have a list of teams that shows up and is is showing in ONE long column, i want to do to things, Make it multiple columns & sort alphabetically

like this:
123
456
789

Here is the link to the test page right now
http://tspclan.com/SS/test.php

And the page code (top half of it anyways)
Code: [Select]

<?php require_once("global.php");
$id = htmlentities($_GET['id']);
$order = mysql_real_escape_string($_GET['order']);
if($order == "levela")
{
$order = "ORDER BY `defwin` ASC";
$l_pre = "<a href='?id=$id&order=leveld'>";
$l_suf = "</a>";
}
elseif($order == "leveld")
{
$order = "ORDER BY `defwin` DESC";
$l_pre = "<a href='?id=$id&order=levela'>";
$l_suf = "</a>";
}
else
{
$order = "ORDER BY `defwin` DESC";
$l_pre = "<a href='?id=$id&order=levela'>";
$l_suf = "</a>";
}
$team = mysql_query(
"SELECT *
FROM
`teams`
WHERE `id`='".$id."'");
$t = mysql_fetch_array($team);
$team_title = mysql_real_escape_string($t['title']);
$t_tag = $t['tag'];
$page1 = $t['page1'];
$user = mysql_query(
"SELECT *
FROM
`users`
WHERE `team`='".$id."'
$order");
?>
<script src="http://tspclan.com/js/fbid.js" type="text/javascript"></script>
<script src="http://tspclan.com/js/pid.js" type="text/javascript"></script>
<script src="http://tspclan.com/js/sorttable.js" type="text/javascript"></script>

<title><?php echo $team_title; ?></title>
</head>
<link href="http://tspclan.com/mkportal/templates/TSP/style.css" rel="stylesheet" type="text/css" />
<body>
<div align="center">
<?php
if(mysql_num_rows($team) == false)
{
$team2 = mysql_query(
"SELECT *
FROM
`teams`");
?>
    <table width="100%" border="0" class="unsortable" cellspacing="0" cellpadding="0">
  <tr>
    <td background="img/hdr_left.jpg">&nbsp;</td>
    <td width="590"><div align="center"><img src="img/hdr.jpg" width="590" height="346" /></div></td>
    <td background="img/hdr_right.jpg">&nbsp;</td>
  </tr>
</table>
<br><br>
<table width="250"  cellspacing="0" class="unsortable" cellpadding="5" border="0" id="mwid">
<tr>
<td align="center" valign="top" class="index_title unsortable" col span="3" >Team Name</td>
</tr>
   
<?php 
while($t2 = mysql_fetch_array($team2))
{
$t_name = "<a  style='font-weight:bold; font color:#333333;' href='?id=".$t2['id']."'>".$t2['title']."</a>"; 

echo "
        <tr> <td valign='top' align='center' width='50' class='row1 b_t' style='border-bottom:none; width:5px; background-color:#333333;'>".$t_name."</td>
";
}
?>

2nd Part of my question, When i call for a team my link is test.php?id=(team id)
Is there a way to bring up multiple teams at the same time?

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!!!  

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>";
}

This topic has been moved to CSS Help.

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

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 />';
      }
?>

Hi all,

This application is given me a nightmare. The code fetches root categories and its sub categories from the a database table. The div table have only 2 columns. I want to add 2 extra columns so that I have 4 columns. Because we have a long list of subcategories meaning I have to scroll down to view the category. Please help

Code: [Select]
{include file='t_javascript_language.tpl'}
{set_css}
{set_js}

<!--<div class="componentheading">{$page_title}</div>-->

<div class="adds_man_list">
<span>{$category_pathway}</span>
{if $current_category->catname!=""}
<div style="border:2px solid #000;">
{include file='elements/display_fields.tpl' position='categoryicon' this_add=$current_category->id}

<strong>{$current_category->catname}</strong>

<div class="adds_subcat" style="text-align:right;background:#F5F5F5; border:1px solid #FFFFFF; " >

{include file='elements/display_fields.tpl' position='categorydetails' this_add=$current_category->id}

<span style="font-size:12px;">

{jtext text="ADS_SUBCATEGORIES"}:   {$current_category->kids} {jtext text="ADS_ADS"}: {$current_category->nr_ads}
<a href="{$current_category->view}" title="{jtext text='ADS_VIEW_LISTINGS'}">
<img src="{$IMAGE_ROOT}view_listings.gif" class="ads_noborder" alt="{jtext text='ADS_VIEW_LISTINGS'}" />
</a>
</span>
</div>
</div>
{/if}
{if $categories|@count<=0}
<h2>{jtext text="ADS_NO_CATEGORIES_DEFINED"}</h2>
{/if}
<table id="adds_categories" class="ads_table">
{section name=category loop=$categories}
{if $smarty.section.category.rownum is odd}
<tr>
{/if}
<td width="50%" class="adsman_catcell" valign="top">
<div class="adds_maincat" {if $categories[category]->watchListed_flag}class="cat_watchlist"{/if}>

{include file='elements/display_fields.tpl' position='categoryicon' this_add=$categories[category]->id}
<a href="{if $categories[category]->kids>0}{$categories[category]->link}{else}{$categories[category]->view}{/if}" >
{$categories[category]->catname}
</a>
{if $categories[category]->is_new}
<!--NEW!!-->
<img src="{$IMAGE_ROOT}new.png" alt="new ads" />
{/if}
<a href="{$categories[category]->view}" title="{jtext text='ADS_VIEW_LISTINGS'}">
<img src="{$IMAGE_ROOT}view_listings.gif" class="ads_noborder" alt="{jtext text='ADS_VIEW_LISTINGS'}" />
</a>
{if $is_logged_in}
{if $categories[category]->watchListed_flag}
<img src="{$IMAGE_ROOT}watchlist.png" width="16"class="ads_noborder" />
{/if}
<a href="{$categories[category]->link_watchlist}">
<img src="{$categories[category]->img_src_watchlist}" width="16" class="ads_noborder" title="{if $categories[category]->watchListed_flag}{jtext text='ADS_REMOVE_FROM_WATCHLIST'}{else}{jtext text='ADS_ADD_TO_WATCHLIST'}{/if}"/>
</a>
{/if}
<br />
</div>

<div class="adds_subcat" style="background:#F5F5F5; border:1px solid #FFFFFF; " >
{include file='elements/display_fields.tpl' position='categorydetails' this_add=$categories[category]->id}
<br />

{section name=subcategory loop=$categories[category]->subcategories}

{include file='elements/display_fields.tpl' position='categoryicon' this_add=$categories[category]->subcategories[subcategory]->id}
<a href="{if $categories[category]->subcategories[subcategory]->kids>0}{$categories[category]->subcategories[subcategory]->link}{else}{$categories[category]->subcategories[subcategory]->view}{/if}">{$categories[category]->subcategories[subcategory]->catname}</a>
{if $categories[category]->subcategories[subcategory]->is_new==1}
<img src="{$IMAGE_ROOT}new.png" alt="new ads" />
{/if}
({$categories[category]->subcategories[subcategory]->nr_a} {jtext text="ADS_ADS"})
{if $categories[category]->subcategories[subcategory]->watchListed_flag}
<img src="{$IMAGE_ROOT}watchlist.png" width="16" class="ads_noborder" />
{/if}
{if $is_logged_in}
<a href="{$categories[category]->subcategories[subcategory]->link_watchlist}">
<img src="{$categories[category]->subcategories[subcategory]->img_src_watchlist}" width="14" class="ads_noborder" title="{if $categories[category]->subcategories[subcategory]->watchListed_flag}{jtext text='ADS_REMOVE_FROM_WATCHLIST'}{else}{jtext text='ADS_ADD_TO_WATCHLIST'}{/if}"/>
</a>
{/if}
<br />
<p style="margin-left:25px;">
{include file='elements/display_fields.tpl' position='categorydetails' this_add=$categories[category]->id}
</p>
{/section}
</div>
</td>
{if $smarty.section.category.rownum is not odd}
</tr>
{/if}
{/section}
</table>
</div>

Many thanks

Hi!
I have a table called "Categories"

Here is the structu
id | Categories               |  ParentCategories
1  | Rings                        | Parent Category
2  | Pendants                  | Parent Category
3  | Ladies Rings             | Rings
4  | Ladies Pendants       | Rings
5  | Gents Rings              | Gents
6  | Necklaces                 | Parent Category

But Necklaces is one of those who is not going to have any subcategories or you can say, it is going to be a category by itself.

So how can I construct a php statement to get data out of MySQL to determine that Necklaces is a Category which does not have subcategories.

Please help !

Thank you !

- Xeirus.

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?