PHP - Convert Html Table To Comma Separated Values

I need to loop through my db and create strings from 2 columns on my db.

data in column1 is '22,33,33,33,25,25,25,14,14,14,14,14,14'
data in column2 is '11am,12pm,1pm,2pm,3pm,4pm,5pm,6pm,7pm,8pm,9pm,10pm, 11pm'

the end result I need is a string such as:

$body= "11am, 22 <line break> 12pm, 33 <line break> ......

If anyone has any examples of something like this or can get me started it would be much appreciated.

Hello Guys,

I am trying to insert a value in my table like this
image.jpg,image2.jpg,image3.jpg
Currently it just runs the image names together

Here is my code.. I tried to use explode, but it just adds the word "array" in the table.

Please advise


$filename2 = $phstring;
}

$csv = $filename2;

$fphoto = explode(',', $csv);

// Insert ad details into mysql
$query = "INSERT INTO ads (ad_type,ad_title,ad_body,ad_category,ad_photo,ad_member,ad_status,ad_city,ad_state,ad_zip)VALUES('".$ad_type."','".$ad_title."','".$ad_body."','".$catid."','".$fphoto."','".$vname."','".$ad_status."','".$city."','".$state."','".$zip."')";

How can i save array from inputs, witch is $igraci and it have 5 values, to mysql base, i tryed but in mysql it shows Array.
This is form:
        <form action="dodaj_klan.php" method="post" >
            <p>
            <label>Naziv klana:</label>
            <input name="naziv" type="text" size="20%" />
            <label>Web Sajt:</label>
            <input name="website" type="text" size="20%" />
            <label>E-Mail:</label>
            <input name="email" type="text" size="20%" />
            <br /><br />
            <label>Igraci klana(5):</label>
            <input name="lider" type="radio" value="1" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="2" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="3" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="4" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="5" />
            <input name="igraci[]" type="text" size="20%" />
            <label><i>(obelezi lidera klana)</i></label>
            <br /><br />
            <input class="button" type="submit" name="submit" value="Dodaj" />&nbsp;&nbsp;
            </p>
        </form>
Now i wonna save this igraci[] array in mysql, i tried like this but it doesn't work:
$igraci = $_POST['igraci'];
$query = "INSERT INTO klanovi (naziv, website, email, igraci) VALUES ('{$naziv}', '{$website}', '{$email}', '{$igraci}')";
$result = mysql_query($query, $connection);

How can i do this?
Thanks..

So I'm trying to create an Array from a comma separated string containing array{s}. How can I take a string full of comma separated hex values such as : 

<?php
    $myStr = (
        "00ffff", "00cccc", "009999", 
        "007777", "004444", "001111", 
        "01ffff", "01cccc", "019999"
    );
?>

& turn it into 3 separated arrays like : 

<?php
    $myNewArrs = [
        Array1 ( 3 ), 
        Array2 ( 3 ), 
        Array3 ( 3 ), 
    ];
?>

which REALLY looks like : 

<?php
    $myNewArrs = [
        Array ( "00ffff", "00cccc", "009999" ), 
        Array ( "007777", "004444", "001111" ), 
        Array ( "01ffff", "01cccc", "019999" ), 
    ];
?>

?

Any assistance is most-definitely appreciated!

Thank you & have a great afternoon!

 

 

Edited May 27 by AquariaXI

Is there a way to take data that is listed like a,b,c,d,e and turn that into an unordered list?

Basically, I'm going to have a list of schools that will be listed with comma separators.  I'll print that data out in two places, one will be printed as it's in the database.  The other I would like to echo as an unordered list.

Say you have a string that you know has two, and exactly two, periods in it, like this...

$string = "3.12.8"

How can you grab the three different values that are separated by periods (in this case, 3, 12 and ?   I was thinking use strpos to find the position of the first period, then could use that info to grab everything up to that position.  But then I couldn't figure out how you would find the position of the SECOND period.   And even if I could get the exact positions of the two periods, it seems like there should be an easier way to simply retrieve values separated by specific characters.     Is there a specific function for this type of thing, or was my initial though correct with having to do it in two parts essentially (find positions of periods, then use that knowledge to get the values)?   Thanks!

Hi all!!! I could really use some help. I'm burning my brain out trying to figure out the easiest way to go about this.
Here is what I am trying to do (in a nutshell) so I could really use full coding examples.

I need to create a text area with simple formatting tools such as Bold, Italics, Underline, Bullets, and Numbering.
After formatting the text with only those available formatting tools, everything in the text area needs to be converted into html tags.
After the conversion, the HTML data that is create is submitted into a single field into a SQL database.


Any help will be greatly appreciated!!!

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?



Thanks in advance,
Vero

I am trying to give role based access here. I want to display the pages which user has access in checkbox format. Here is my code

$sql = "SELECT p.page_id AS pid, 
                            p.page, 
                            p.href, 
                            ra.pages AS rpage 
             FROM pages p 
             INNER JOIN role_access ra 
             WHERE p.page_id IN (ra.page) 
             AND ra.role=1";

$query = mysqli_query($con, $sql) or die(mysqli_error($con));

$checked_arr = array();

while($row = mysqli_fetch_array($query)) { 
$checked_arr = explode(",",$row['rpage']);

foreach ($checked_arr as $page) {

    echo "<br/><input type='checkbox' name=\"pages[]\" value='$page' />$page<br>";
}

My tables are like this

ROLE

CREATE TABLE `role` (
  `rid` int(5) NOT NULL,
  `role_name` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `role` (`rid`, `role_name`) VALUES
(1, 'Admin'),
(2, 'Others');

ALTER TABLE `role`
  ADD PRIMARY KEY (`rid`);


ROLE-ACCESS

CREATE TABLE `role_access` (
  `id` int(10) NOT NULL,
  `page` varchar(160) NOT NULL,
  `role` int(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `role_access` (`id`, `page`, `role`) VALUES
(1, '1,2,3,4,5', 1),
(2, '2,4,5', 2);

ALTER TABLE `role_access`
  ADD PRIMARY KEY (`id`);



PAGES

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL,
  `code` varchar(10) NOT NULL,
  `page` varchar(100) NOT NULL,
  `href` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `pages` (`page_id`, `code`, `page`, `href`) VALUES
(1, 'Patient', 'Registration', '/patient_registration.php'),
(2, 'Patient', 'List', '/patient_list.php'),
(3, 'Patient', 'Edit', '/edit_patient.php'),
(4, 'Patient', 'Export', '/export_patient.php'),
(5, 'Patient', 'MRD', '/patient_MRD.php');

ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`);

 

 

In above query i get result like this

But required result is

if i change checkbox display like

while($row = mysqli_fetch_array($query)) { 
$checked_arr = explode(",",$row['rpage']);
$pname = $row['page'];
foreach ($checked_arr as $page) {

    echo "<br/><input type='checkbox' name=\"pages[]\" value='$page' />$pname<br>";
}
}

i get result

 

How to get the names for that file.

 

 

 

This topic has been moved to Application Design.

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

I created a simple search box which will query my table and match the input value to one of my columns. two of these columns store comma separated values. if i query a column other than a column which stores my csv i can see my search results. if i query a column which stores my csv i will not see results unless the search value matches the first value within the column. how would i be able to get say the second or third or forth value. here is the code i am using to query the table any help would be appreciated thanks.

Code: [Select]
$q = $this->db->query("SELECT * FROM table WHERE col1 LIKE 'searchvalue'".
             " OR col2 LIKE 'searchvalue'".
             " OR col3 LIKE 'searchvalue'".
             " OR col4 LIKE 'searchvalue'".
             " OR FIND_IN_SET('searchvalue', col5) > 0 ".
             " OR FIND_IN_SET('searchvalue', col6) > 0");

I have a kind of search and react on my site. The user can search for a number in a column as below

$search = mysqli_real_escape_string($link, $_POST["query"]);

$query = "SELECT * FROM $table[$i] WHERE oemnr LIKE '".$search."%' ORDER BY model";

 

The code works fine but I want to expand the function to get match for other numbers also. The oemnr column today can be 12345 which shows up if the user type 12.... 

I want to expand the oemnr column as

12345/03124/34713, numbers separated with / or another character.

If the user type 03... or 34... I want to find and show 12345 because it is on the same row and corresponds to the numbers on the same row. Is it possible to do in mysql? In php that kind of operation can be done with the explode function but I don't know how to use with mysql.

Edited February 14 by jigga

I have a stdClass Object array with nested User arrays as a value that I would like to display in a table cell.

I am struggling and have exhausted a lot of time. I am hoping to get a shove in the right direction if possible.

The image below will show what I am trying to do.

 

$someArray = json_decode($token_result);

foreach ($someArray as $key => $value) {
    $combined[] =
        "<tr><td>" .
        $value->customer .
        "</td><td>" .
        $value->city .
        '</td>
           <td>' .
        $value->state .
        "</td><td>" .
        $value->zipcode .
        '</td>
           <td>' .
        $value->totalUsers .
        "</td><td>" .
        $value->totalActiveUsers .
        "</td><td>" .
        $value->totalInActiveUsers .
        '</td><td>
           <a href="">' .
        $value->users .
        "</a></td></tr>";
}

foreach ($combined as $value) {
    print $value;
}

Here is what my Array and Objects look like

Array
(
    [0] => stdClass Object
        (
            [customer] => SWSH
            [city] => Thomasville
            [state] => GA
            [zipcode] => 31792
            [totalUsers] => 6
            [totalActiveUsers] => 6
            [totalInActiveUsers] => 0
            [users] => Array
                (
                    [0] => stdClass Object
                        (
                            [firstName] => xxx
                            [lastName] => xxx
                            [phoneNumber] => 
                            [userName] => cb_igwrth@xxx.com
                            [createdBy] => 
                            [isActive] => 1
                        )

                    [1] => stdClass Object
                        (
                            [firstName] => Dan
                            [lastName] => Stewart
                            [phoneNumber] => +11111111111
                            [userName] => dan.sxx@xxx.ga.gov
                            [createdBy] => kwilliams@xxx.com
                            [isActive] => 1
                        )
                )

        )

    [1] => stdClass Object
        (
            [customer] => xxxx
            [city] => Carver
            [state] => MA
            [zipcode] => 02330
            [totalUsers] => 3
            [totalActiveUsers] => 3
            [totalInActiveUsers] => 0
            [users] => Array
                (
                    [0] => stdClass Object
                        (
                            [firstName] => Leo
                            [lastName] => Furtado
                            [phoneNumber] => 781-000-0000
                            [userName] => LFurtado@xxx.com
                            [createdBy] => TConger@ccccc.com
                            [isActive] => 1
                        )                

                )

        )
)

Table is attached

 

How does everyone take data input from an HTML Form and convert it into an Object in OOP?

I am thinking it would be better if user inputs resided in an object so that I could manipulate the data in OOP terms instead of referencing the Form procedurally.


TomTees