Retrieving css from tables in mysql using php

[gXion]

hi there,,
I searched b4 I submit this post.

so,
let say:
if I have a css data stored in mysql.
the data looks like :

.name 
{
background-color: #0000EE;
color: #0000EE
text-decoration: italic;
}
 
.age
{
background-color: #00FF00;
color: #0000FF
text-decoration: bold;
}
 

OK ?

now, if I want to split this data into a form ..
the form contains of tow tables..
each table name will be ( the class name ).

the properties will break into <td>'s.
here is a picture of what I want but could'nt do ( I made it in MS Word ) :

how can i do that with php ?
is it about preg_match_all() ?
if so, what will be the table structure and php code ?

thank you even if you don't have an answer ..
your solutions helped me many times when I was a Guest.
I hope you help my as a Member.

[ronverdonk]

Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.

MODERATOR

[arggg]

So you're wanting to display what is in the database into a table or you are wanting whatever css is in the database to be the css the site runs off of?

[gXion]

ronverdonk
sorry ,, i sweer the god i would do that but i frogot.

So you're wanting to display what is in the database into a table or you are wanting whatever css is in the database to be the css the site runs off of?

I want to display what is in the database into a table. ( like the picture above )
the first choise :)

breaking data into <td>'s.
to display the current css settings [ not using the css in <style> tag ].
just to show it ( in the admin settings site );
thanks.

[Atli]

Hi.

I'm not entire sure what you are talking about...

Are you trying to parse actually CSS code into PHP and echo the the results in a table?
To do that you may want to familiarize yourself with some of the String Functions. Most important of which are stripos, substr and explode
Unless you want to go with some sort of regex solution, in which case I'm close to useless :P

Is the CSS data already parsed in a table inside your database?
If that is the case, assuming each row has a column for each CSS attribute, you would simply have to:

# Query the data
$tableName = "myTable";
$result = mysql_query("SELECT atrribute1, attribute2, (...) FROM $tableName");
 
# Display table
echo "<table><tr><td colspan=2>$tableName</td></tr>";
while($row = mysql_fetch_assoc($result))
{
    foreach($row as $_k => $_v) 
    {
      echo "<tr><td>$_k</td><td>$_v</td></tr>";
    }
}
echo "</table>";
 

If none of this is of any help, please try to explain exactly where and how your data is stored.

[gXion]

Hi.

I'm not entire sure what you are talking about...

Are you trying to parse actually CSS code into PHP and echo the the results in a table?
To do that you may want to familiarize yourself with some of the String Functions. Most important of which are stripos, substr and explode
Unless you want to go with some sort of regex solution, in which case I'm close to useless :P

well, this is something.

I want exactly what you understand ( parse actually CSS code into php .. etc ).
I don't want to create a unique table for css.
just one column with type MEDIUMTEXT in a table.

in fact I tried this php code :
( forget about mysql right now , let's make the next code working, if so, i can try it in mysql myself )

[PHP]<?php

$css_is = "

body
{
background: #FEFDF0;
color: #000000;
font: bold 12pt arial;
margin: 0px 0px 0px 0px;
padding: 0px;
}

.special
{
background: #FAF1D5 url(images/design-body.jpg) repeat-x top left;
color: #000000;
font: bold 8pt tahoma;
}

";
/*

NOW we have a text variable which contains CSS code. Which we want to break it into <td>s like
<table><tr>
<td>body></td>
<tr>
<td>background</td><td>#FAF1D5 url(images/design-body.jpg) repeat-x top left</td>
</tr>
and so on.

*/

$css_parsed = explode("\n",$css_is);
foreach($css_parsed as $css_now)
{
// my stupid old code was here;
}
?>[/PHP]

lets say when I use echo ,it prints the { symbol as well . I don't now how to extract only the class name and the class properities into

[PHP]$some_array[$class_name][$class_properities][/PHP]

I tried also [PHP]preg_match_all("/[(.*)][\{(.*)\}]/",$css_is ,$css_parsed );[/PHP]
now it prints $css_parsed like separated letters each letter printed in one line .

what i want from this code : is to create a html table filled in with $some_array.

I don't want to cry.

hope i explained it well.

[gXion]

so .. ?************************

[Atli]

Forgive the delayed answer. I have been away for a while.
To answer your question...

You will simply have to build a code that dissects the CSS code and cuts it into usable pieces.

There is always the possibility of using some elaborate regex solution, but that is a whole another bowl of wax.

So, using PHP's String functions, we could start by cutting each class into it's own array element by exploding the CSS file on each end bracket:

// Cut the raw CSS text into classes
$rawClass = explode("}", $cssString);
 

Then, to clean this up, we could cut each class into two elements, the first containing the name and the second the raw text containing it's members:

// Create class array
$classes = array();
 
// Loop through all the raw classes
foreach($rawClass as $_v)
{
    // Make sure that the class isn't empty
    $_v = trim($_v);
    if(empty($_v)) continue;
 
    // Cut the raw class
    $rawClassBuffer = explode("{", $_v);
 
    // Create the class buffer and add the name
    $classBuffer = array();
    $classBuffer['Name'] = trim($rawClassBuffer[0]);
 

Now we would seperate each member of each class and seperate that into name and value:

    // Seperate each line of members
    $rawMember = explode(";", $rawClassBuffer[1]);
 
    // Create member buffer
    $members = array();
 
    // Seperate the name and value for each member
    foreach($rawMember as $_v2)
    {
        // Make sure the member isn't empty (again)
        $_v2 = trim($_v2);
        if(empty($_v2)) continue;
 
        // Seperate the names and values
        $rawMemberBuffer = explode(":", $_v2);
 
        // Add a name and value for each member to the member array
        $memberBuffer = array();
        $memberBuffer['Name'] = trim($rawMemberBuffer[0]);
        $memberBuffer['Value'] = trim($rawMemberBuffer[1]);
 
        $members[] = $memberBuffer;
    }
 

And to finish it off, we add the class members to the class buffer and the class buffer to the class array:

    // Add the members array to the class buffer
    $classBuffer['Members'] = $members;
 
    // Add the class to the class array
    $classes[] = $classBuffer;
}
 

And finally, now that we have an array, to display it we could simply do:

// Show each class as a table
foreach($classes as $_class)
{
    // Print table header and class name
    echo "<table style='width: 250px;' border='1'>";
    echo "<tr><td colspan='2' style='text-align:center;'>{$_class['Name']}</td></tr>";
 
    // Show each member
    if(count($_class['Members']) > 0)
    {
        foreach($_class['Members'] as $_member)
        {
            // Print row and columns for names and values
            echo "<tr><td>{$_member['Name']}</td><td>{$_member['Value']}</td></tr>";
        }
    }
 
    // Close table
    echo "</table>";
}
 

Put that all together and provide a valid CSS string and you should see all your classes in neat little tables :)

Hope this helps.