Learn VBA & Macros in 1 Week!

PHP - Seperate Items From Database With A 'comma'

Full Excel VBA Course - Beginner to Expert

Seperate Items From Database With A 'comma'	View Content

I want to retrieve items from the DB and seperate them using a comma...

while i know how to actually do that, what i want is to automatically have stop adding comas at the last item...

so if there are 4 items i want it to show a comma after each item except the last one (1, 2, 3, 4).

Does anyone know of a function or can give me an example on how i can do this.

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Need A Php Code To Delete Selected Items Of Database Items Using Checkbox

Setting # Of Items Per Row From Database...

Trying To Do A Drop Down Menu Of Items In The Database

Giving Links To The Items In A Database

Can You Do This? Convert List Items Into Entries In Database And More...

Trying To Convert Code To Use Arrays Instead Of Mysql Database For Items

Moved: Displaying Items That Start With A Number From The Database

Generate Random Items/numbers From Data In A Database

Seperate Number From End Of Url

Seperate Words In Url With ;

Seperate Slashes Into Links?

Seperate Array By 5's Into Individual Div Containers

Pulling And Updating Data From A Seperate Db Table

How To Display Print_r Array In Seperate Columns

How Can My Php Website Use A Ms Access Db Kept On A Seperate Computer In My Shop

Seperate Results By Change In First Order By Term

Displaying Multiple Files With Seperate Topic Names

Mysql Insert Into Putting Array On Seperate Table Rows

Remove The Last Comma

Separating By Comma

Learn VBA & Macros for Excel in 1 Week!

Need A Php Code To Delete Selected Items Of Database Items Using Checkbox

Similar Tutorials

I have a webpage where all the database items are displyes in a table format.The table also has a check box.Upon clicking the delete button i need to delete all the items whish has the checkbox checked.
How will i do that

Setting # Of Items Per Row From Database...

Similar Tutorials

I am trying to do something like this

but the code I have doesn't seem to do what I want...

Code: [Select]
<?php
   while($item_rows = mysql_fetch_array($item_result))
   {
      $output = "
              <tr bgcolor=\"#000000\">
                <td align=\"center\"><p><img src=\"../images/".$item_rows['item_id'].".gif\" width=\"45\" height=\"45\" /></p>
                  <p>".$item_rows['name']."<br />
                    Attack: +".$item_rows['attack']."<br />
                    <img src=\"../images/credit.gif\" width=\"17\" height=\"17\" />$".$item_rows['sell_price']."</p>
                  <p>[Equipt|Destory]<br />
                  </p>
                </td>";
          $remainder = $i % 5;

  echo ($remainder == 0 ? ($i == 0 ? "" : "\n</tr>")."\n$output " : $output);
   }
       $colspan = (4 - $remainder);
   $last_row = $colspan ? "  <td ".($colspan? "colspan=$colspan" : "")."></td>" : "";
   echo $last_row. "
        </tr>
      </table>";
?>

Trying To Do A Drop Down Menu Of Items In The Database

Similar Tutorials

I'm trying to make it so that someone can add an item to the shop based upon the current items within the database.

How do I go about doing that? I know i have to change <input> to <select>, but beyond that, how do I code it so I can run an array to get all the current items from the table `items` and list them by their `name` field?

Thanks in advance!

Here is what I have so far:

function addshopinv($id) {
error_reporting(E_ALL);
ini_set('display_errors', 1);
   if (isset($_POST["submit"])) {
        extract($_POST);
        $errors = 0;
        $errorlist = "";
        if ($name == "") { $errors++; $errorlist .= "Name is required.<br />"; }
else if ($errors == 0) {
$dbh=dbconnect() or die ("Userlist read error: " . mysql_error()."<br>");
mysql_select_db("XXX");
$query = mysql_query("SELECT id FROM items WHERE name='$name'");
while ($result = mysql_fetch_array($query)){
$item_id = $result['id'];
$query1 = mysql_query("INSERT INTO sale SET shop_id='$id', item_id='$item_id'");
}
            admindisplay("Inventory Item Added.","Add New Inventory Item");
        } else {
            admindisplay("<b>Errors:</b><br /><div style=\"color:red;\">$errorlist</div><br />Please go back and try again.", "Add New Item to Shop");
        }
   }

   $page = <<<END
<b><u>Add New Inventory Item</u></b><br /><br />
<form action="admin_panel.php?do=addshopinv:$id" method="post">
<table width="90%">
<tr><td width="20%">Name:</td><td><input type="text" name="name" size="30" maxlength="255" value="" />*255 character max</td></tr>
</table>
<input type="submit" name="submit" value="Submit" /> <input type="reset" name="reset" value="Reset" />
</form>
END;
    $page = parsetemplate($page, $row);
    admindisplay($page, "Add New Inventory Item");
}

Giving Links To The Items In A Database

Similar Tutorials

I have a php page where I have posts about different topic.
I have a menu listing all this categories of topics . Some topics may belong to more than one category.

So when i click on a particular menu item, the topic belonging to that category will be displayed.
While displaying it is in this format---Topic Heading,Belongs to which all categories,date posted and the description.

All this are taken from database.

Now my actual issue is I am not able to give links to the categories dispalyed ,if the category exceeds more than 1.
For eg:
Global Warming
Posted on March 11,2011 in News, Issue
-----------description of global warming goes here.

In the above eg: News and issue are the two categories,when i click on News it should display all the items in news category,and when i click on issue it should display all items of issue category.
But I am not able to give this link to the categories.

Code: [Select]
while($row = mysql_fetch_array($q)) {
if($row[6]=='News'){
$c='<a href="category_disp.php?category=news">News</a>';
}
if($row[6]=='Issues'){
$c='<a href="category_disp.php?category=issues">Issues</a>';
}

echo "<tr><td><p >$row[1]</p><br></td></tr>";
echo "<tr><td> <div >".
"<p><span>$row[4]</span> <span>".
"<a href='$row[6]' >$row[6]|<a href='$row[5]'> Post Comments</a></span></p>".
"<p> </p></div><br></td></tr>";
echo "<tr><td><p >$row[2]</p><br></td></tr>";
echo "<tr><td><p ><a href='$row[3]' >Click Here to read more...</a></p></td></tr>";
echo "</div></td></tr>";
}

echo" </table>

Can You Do This? Convert List Items Into Entries In Database And More...

Similar Tutorials

I coded the following but some parts are not working (the "curveball" mentioned at the end).
How would YOU do this?

I have a page (A) displaying a form with a textarea field using a WYSIWYG interface.
The user will enter a list of unordered items and upon submit the string will look something like this:

This is my list of food items:
<ul>
<li> Lettuce </li>
<li> Tomatoes </li>
<li> Eggs </li>
<ul>

Upon submit, I need to give each list item an unique id and store this id along with the text next to it in a separate table:

List_item_id List_item_text List_item_state
food_1 Lettuce
food_2 Tomatoes
food_3 Eggs

The user will then land in another page with a form displaying the list. The text is now in the page itself and not in a textarea.
Instead of the bullets a dropdown list appears, and the user can select "buy" or "sell" for each list item.
This page (B) looks something like this:

<form>
This is my list of food items:
<br><select name="food_1">
   <option value="buy">Buy</option>
   <option value="sell">Sell</option>
</select>
Lettuce

<br><select name="food_2">
   <option value="buy">Buy</option>
   <option value="sell">Sell</option>
</select>
Tomatoes

<br><select name="food_2">
   <option value="buy">Buy</option>
   <option value="sell">Sell</option>
</select>
Eggs

<input type=submit value="submit">
</form>

When the user hits "submit" the table with the list items will be updated with the values selected in the dropdown list:

List_item_id List_item_text List_item_state
food_1 Lettuce Buy
food_2 Tomatoes Buy
food_3 Eggs Sell

The next time the user goes to Page B the list will remember the states.

Here's the curveball: At any point the user may click on "EDIT LIST" on Page B so they may add more items (at the begining, middle or end of the string). On edit mode the list items should appear as bullets again inside the WYSIWYG interface.

Keep in mind that some of the text in the string may not be a list item (ie, "this is my list of food...")

Trying To Convert Code To Use Arrays Instead Of Mysql Database For Items

Similar Tutorials

I've been playing around with this code from http://v3.thewatchmakerproject.com/journal/276/building-a-simple-php-shopping-cart

Objective: I'm trying to make the scripts work but without pulling the data from MySQL Database.
Instead, I created an array and inserted some info there and trying to replicate the same results but getting confused.

For example, on the Index.php file, I made the following changes:

<?php

// Start the session
session_start();

// Include functions
require_once('inc/functions.inc.php');

// Products multidimensional Array
$products = array("book" => array(  'id' => '1',
                                    'title' => 'Learn Your ABC\'s',
                                    'author' => 'John Doe',
                                    'price' => '14.95'),
                    "video" => array('id' => '2',
                                    'title' => 'Visual Guide to learn',
                                    'author' => 'Adam Smith',
                                    'price' => '21.38'),
                    "puzzle" => array('id' => '3',
                                    'title' => 'Can You Solve?',
                                    'author' => 'Sara Brown',
                                    'price' => '9.41'),
                    "exam" => array('id' => '4',
                                    'title' => 'Test Your Knowledge',
                                    'author' => 'Kim Carver',
                                    'price' => '11.15'));

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#0183; Bookshop</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="booklist">

<h1>Books In Our Store</h1>

<?php
/*
$sql = 'SELECT * FROM books ORDER BY id';
$result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': $'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
}
$output[] = '</ul>';
echo join('',$output);
*/
?>

<?php
$output[] = '<ul>';
foreach ($products as $product => $product_item) {
// $flavor is the key and $piece is the value
foreach ($product_item as $item => $piece) {

    if ($item == "id") {                            # Conditional logic defined to map specific keys to specified name value
        $row['id'] = $piece;
//        echo "The id is ". $id."<br />";                            // set just to confirm value correct for variable
    }  elseif ($item == "title")  {                        # Conditional logic defined to map 1st key to price value
        $row['title'] = $piece;
//        echo "The title is ". $title."<br />";                            // set just to confirm value correct for variable
    }  elseif ($item == "author")  {                        # Conditional logic defined to map 1st key to price value
        $row['author'] = $piece;
//        echo "The author is ". $author."<br />";                            // set just to confirm value correct for variable
    }  elseif  ($item == "price")   {                    # Conditional logic defined to map 1st key to shipping value
        $row['price'] = $piece;
//        echo "Price: ". $price."<br /><br />";                        // set just to confirm value correct for variable
    }

$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': $'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
$output[] = '</ul>';
echo join('',$output);

}
}

?>
</div>

</body>
</html>

And here's the original index.php before my edits which show the sql query to the db:

<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session
session_start();
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#0183; Bookshop</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="booklist">

<h1>Books In Our Store</h1>

<?php
$sql = 'SELECT * FROM books ORDER BY id';
$result = $db->query($sql);
$output[] = '<ul>';
while ($row = $result->fetch()) {
$output[] = '<li>"'.$row['title'].'" by '.$row['author'].': £'.$row['price'].'<br /><a href="cart.php?action=add&id='.$row['id'].'">Add to cart</a></li>';
}
$output[] = '</ul>';
echo join('',$output);
?>

</div>

</body>
</html>

Also, I included the zipped file of the entire script setup.

Again, I'm trying to figure out how to make the cart work with using an array for the product instead of MySQL database.
My goal is to remove ALL SQL statements from the scripts but stuck with the looping portion to display the title, author, and price from the array as shown above.

Moved: Displaying Items That Start With A Number From The Database

Similar Tutorials

This topic has been moved to MySQL Help.

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

Generate Random Items/numbers From Data In A Database

Similar Tutorials

Hi,

What I'm trying to do is create a script that generates a random list of cars whenever it is run. I have a list of available cars in a MySQL database. I'm just not sure how to get php to generate a list of, say, 20 cars, that are randomly picked from the cars in the database. I may also want to add other statistics like MPG (also already in the database). Can anyone show me how to do this? And is it possible to format the returned data in a table or div format?

Thanks in advance
Unk

Seperate Number From End Of Url

Similar Tutorials

Hi

I need to take the number off of the end of a url and do some processing with it.

so for example:

www.something.com/something/10001

i will need to seperate them into 2 different variables, for example:

$var1 = www.something.com/something/
$var2 = 10001

is this possible?

Thanks

Seperate Words In Url With ;

Similar Tutorials

Hi there,

I'm making an online clothing store for the brick and mortar shop we have and would like the customer to be able to refine their search by size, colour etc.

The size options will be XS, S, M etc etc where XS is 0, S is 1 and so on. So when they select XS it will add ?size=0 to the URL, if they select XS and S it will be ?size=0;1

What I need to know is how to make some PHP code which can recognise the ; is a break and know that both sizes are selected.

Hope that makes sense and thanks in advance

Seperate Slashes Into Links?

Similar Tutorials

Ok so I'm coding up a file tree for a script and I've got the system setup so that when a user clicks on a folder it adds that folder to the path. The path is stored in a variable, but I'd like to allow the user to be able to go down multiple directories at once. To do this I'm going to seperate each folder name in the path and link to it so as an example:

$path = './home/public_html/folder1/folder2';

how can I separate each of those so I can make a link to that folder so that:

/home goes to $path = './home/';
/public_html goes to $path = './home/public_html';
etc...
---
Basically just seperate the slashes into an array and seperate each of them off based on how far along it is but I don't know how to do that...

Seperate Array By 5's Into Individual Div Containers

Similar Tutorials

I figure I'd use array_chunk to divide my array by 5's, but how can I get each set of five to be enclosed in div tags. My array is a list of images in a directory which I need inserted into a format like the example code on this page. http://flowplayer.org/tools/demos/scrollable/index.html. Thanks for any help.

Pulling And Updating Data From A Seperate Db Table

Similar Tutorials

Hello:

I have a DB table with this structu
Code: [Select]
CREATE TABLE `gallery_category` (
`category_id` bigint(20) unsigned NOT NULL auto_increment,
`category_name` varchar(50) NOT NULL default '0',
PRIMARY KEY (`category_id`),
KEY `category_id` (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

What I am trying to do id pull this data into my "Edit Product" page and populate a SELECT menu with it.

I want the user to be able to re-assign a product to a new category if they chose to do so.

I want to add the data (and update the DB) to this area:
Code: [Select]
<div style="float: left; width: 550px;">
<select name='category_name'>
<option></option>
</select>

</div>

This is the full page code that allows users to update product info:
Code: [Select]
<?php

include('../include/myConn.php');
include('../include/myCodeLib.php');
include('include/myCheckLogin.php');
include('include/myAdminNav.php');
include('ckfinder/ckfinder.php');
include('ckeditor/ckeditor.php');

$photo_id = $_REQUEST['photo_id'];

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$photo_title = mysql_real_escape_string($_POST['photo_title']);
$photo_price = mysql_real_escape_string($_POST['photo_price']);
$photo_caption = mysql_real_escape_string($_POST['photo_caption']);

$sql = "

UPDATE gallery_photos
   SET
      photo_title = '$photo_title',
      photo_price = '$photo_price',
      photo_caption = '$photo_caption'
  WHERE photo_id = $photo_id
  ";

mysql_query($sql) && mysql_affected_rows()

?>
<?php
}

$query=mysql_query("SELECT photo_title,photo_price,photo_caption FROM gallery_photos") or die("Could not get data from db: ".mysql_error());

while($result=mysql_fetch_array($query))
{
  $photo_title=$result['photo_title'];
  $photo_price=$result['photo_price'];
  $photo_caption=$result['photo_caption'];
}
?>

<!DOCTYPE HTML>

<html>
<head>

</head>

<body>

<div id="siteContainer">

<p>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
echo "<span class=\"textError\">". $photo_title ." successfully updated!</span>"
?>
</p>

<p>

<form method="post" action="<?php echo $PHP_SELF;?>">
<input type="hidden" name="POSTBACK" value="EDIT">
<input type='hidden' name='photo_id' value='<?php echo $photo_id; ?>' />

<div style="float: left; width: 120px; margin-right: 30px;">
Category:
</div>

<div style="float: left; width: 550px;">
<select name='category_name'>
<option></option>
</select>

</div>

<div style="float: left; width: 120px; margin-right: 30px;">
Title:
</div>

<div style="float: left; width: 550px;">
<input type="text" name="photo_title" size="45" maxlength="200" value="<?php echo $photo_title; ?>" />
</div>

<div style="clear: both;"><br /></div>

<div style="float: left; width: 120px; margin-right: 30px;">
Price:
</div>

<div style="float: left; width: 550px;">
<input type="text" name="photo_price" size="45" maxlength="200" value="<?php echo $photo_price; ?>" />
</div>

<div style="clear: both;"><br /></div>

Description:<br />
<textarea cols="107" rows="1" name="photo_caption"><?php echo $photo_caption; ?></textarea>

<div style="clear: both;"><br /></div>

<br />

<input type="submit" value="Submit" />

</form>

</p>

</div>

</body>

</html>

How can I do this? I'm stumped ...

Thanks!

How To Display Print_r Array In Seperate Columns

Similar Tutorials

i have checkboxes on the database page and if checked they send to the shopping basket i have the items selected to display but like this Array ( [0] => Imagine DragonsImagine DragonsRockI Bet My LifeKIDinaKORNER1.25Brand new single from the incredible Imagine Dragons )

How Can My Php Website Use A Ms Access Db Kept On A Seperate Computer In My Shop

Similar Tutorials

Hi,

I have a challenging dilema. A client keeps track of his stock using a microsoft access database in store. His ecommerce website which is hosted elsewhere uses php and mysql.

Is it possible to to integrate the 2 so that when someone buys a product from the website, the store MS access database is updated to reflect this and vice versa?

If so how would I go about it?

Thanks in advance.

P.S: I'm extremely tempted to suggest that he should stop using his ms access db and instead reccommend that I set him up a suitable backend on his website for keeping stock control, then he just login to that in the store.

Seperate Results By Change In First Order By Term

Similar Tutorials

Here's the query:
Code: [Select]
$sql = mysql_query("SELECT * FROM resources WHERE gameCat = '' ORDER BY systemCat,order_id");
I want something to happen when the systemCat changes in the results. Like this:

Code: [Select]
if($row['systemCat'] CHANGES){
echo '<div id="seperator"></div>';
}

Any ideas? Thank you!

Displaying Multiple Files With Seperate Topic Names

Similar Tutorials

hmm im having some trouble tackling this problem

i have a database table with topicname then 3 columns with 3 pdfs in each one
all the files are stored in a directory called topicfiles in the server
so like 3 topicnames with 3 files in each one

with this page i want to make
i want to display each topic name with the files under it calling it from the server
like

Code: [Select]
topic 1
file1.pdf
file2.pdf
file3.pdf

topic 2
file4.pdf
file5.pdf
file6.pdf

topic 3
file71.pdf
file8.pdf
file9.pdf

i tried using dhandler to access all files in the folder and only managed to display all of the files in rows using foreach loop
was thinkin of using mysql query to access the topic name and then each file for that topic but not sure hmmm

Mysql Insert Into Putting Array On Seperate Table Rows

Similar Tutorials

Hi again all,

Why does the foreach loop im doing, put the array values from collection, into seperate table rows rather than 1 row per whole array?

    <?php
        class registration{
            public $fields = array("username", "email", "password");
            public $data = array();
            public $table = "users";
            public $dateTime = "";
            public $datePos = 0;
            public $dateEntryName = "date";
            public $connection;

            function timeStamp(){
                return($this->dateTime = date("Y-m-d H:i:s"));
            }

            function insertRow($collection){
                    //HERE
                    foreach($this->fields as $row => $value){
                        mysql_query("INSERT INTO $this->table ($value)
                        VALUES ('$collection[$row]')");
                    }

                    mysql_close($this->connection->connectData);
            }

            function validateFields(){

                $this->connection = new connection();
                $this->connection->connect();

                foreach($this->fields as $key => $value){
                    array_push($this->data, $_POST[$this->fields[$key]]);
                }
                $this->dateTime = $this->timeStamp();
                array_unshift($this->data, $this->dateTime);
                array_unshift($this->fields, $this->dateEntryName);

                foreach($this->data as $value){
                    echo "$value";
                }

                $this->insertRow($this->data);
            }
        }

        $registration = new registration();
        $registration->validateFields();
    ?>

I end up with 3 rows

row 1: username
row 2: email
row 3 : password

rather than row 1:username email password.

Remove The Last Comma

Similar Tutorials

Hi All,
I'm sure there is an easy solution for this but I am unable to find it.
I am new to PHP and after a little help...

the via data is stored in a database in this format... |51.105166,-1.695971|51.011055,-2.1068|50.945233,-2.617664||||

I'm trying to find a way of loosing the last comma if there are 1 or more entries, any ideas guys.

What I'm getting is : Code: [Select]
var points = [{location: '51.105166,-1.695971'},{location: '51.105166,-1.695971'},];
What I'm after is: Code: [Select]
var points = [{location: '51.105166,-1.695971'},{location: '51.105166,-1.695971'}];

Code: [Select]
<?php
if($via != null){
echo "var points = [";
foreach($via as $point){
if($point != ""){
echo "{location:";
echo " '".$point."'";
echo "},";
}
}
echo "];\n";
}
?>

Separating By Comma

Similar Tutorials

Lets say I pull a value from a database field that has a value of 1,2 and what I want to do is seperate them and then run each of those values against a separate table how would that be accomplished.