PHP variable inside the inline css

Question

I need to display the elearning progress of each user. This value is retrieved from the database using PHP. The progress bar i'm using is with bootstrap and it requires that I put the progress value inside the width property found in the inline css. Is this possible? This is what I've tried but it's not displaying anything:

CODES

<?php
            include('../../dbconnect.php');
            $id = $_SESSION['ID'];
            $sql = "SELECT * FROM progress WHERE lectureID=1 AND chapterID = 1 AND currentLevel='novice' AND ID = '$id';";

            $query = mysqli_query($con, $sql) or die('Query failed');

            while ($result = mysqli_fetch_array($query)) {
                $value = $result['chapterPerc'];
                ?>

                <div class="progress-bar progress-bar-striped active" role="progressbar"
                     aria-valuenow="0" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $value ?> %;"> <!--tried this-->
                </div>
                <?php
            } //while loop closes here

            ?>
        </div>

Any help will be appreciated thanks.

Yes. Should work fine. Verified that $value is what you expect? What does the source output look like? Might just be the space before the %? — ficuscr
– ficuscr, Commented Apr 1, 2016 at 19:16
Try removing the space between <?php echo $value ?> and % in the inline CSS. — D4V1D
– D4V1D, Commented Apr 1, 2016 at 19:17
Good opportunity to consider starting to use <?= $value ?>... Keeps things neater I find. Just an observation. — ficuscr
– ficuscr, Commented Apr 1, 2016 at 19:19
Does it actually return a value? just echo out first the value before putting it in the progress bar. Just to make sure. There may be a return, but if the field you specified is wrong when you assign it to the value variable, (mistakes are easily made) it may come up empty — Dorvalla
– Dorvalla, Commented Apr 1, 2016 at 19:35

Mawia HL · Accepted Answer · 2016-04-02 04:17:38Z

2

You don't need to loop since you are printing a single row:

<?php
$sql = "SELECT * FROM progress WHERE lectureID='1'  
        AND currentLevel='novice' AND ID = '$id'";//; removed
$query = mysqli_query($con, $sql) or die('Query failed');  
$result = mysqli_fetch_array($query);
?>
<div class="progress-bar progress-bar-striped active" role="progressbar"
 aria-valuenow="<?php echo $result['chapterPerc'];?>" 
 aria-valuemin="0" aria-valuemax="100" 
 style="width:<?php echo $result['chapterPerc'];?>%;"> 
</div>

Hope this will work. I have tested and it is working fine.

edited Apr 2, 2016 at 4:17

answered Apr 1, 2016 at 19:21

Mawia HL

3,6751 gold badge28 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Manisha Singh Sanoo Over a year ago

It was a simple mistake with the query there's no chapterID 1 in the table. All fixed now. Amended my code to yours. Thanks.

Mawia HL Over a year ago

@Damini, please click the tick icon above to accept if it helps.

Arshid KV · Accepted Answer · 2016-04-01 19:20:38Z

2

Try as follows

style="width:<?php echo $value.'%'; ?>;"

edited Apr 1, 2016 at 19:20

answered Apr 1, 2016 at 19:18

Arshid KV

10k3 gold badges37 silver badges37 bronze badges

5 Comments

Arshid KV Over a year ago

Please check it now.

Barmar Over a year ago

@D4V1D ; isn't needed before ?>.

D4V1D Over a year ago

@Barmar: How come? Every PHP statements must finish with a ; right?

Barmar Over a year ago

It's a special case, since ?> ends PHP statement parsing, so it also ends the statement.

D4V1D Over a year ago

Fair enough, didn't know that. I still think, even though not needed, ; should be there just to be consistant.

user5672329 · Accepted Answer · 2016-04-01 19:17:07Z

1

Try this:

<?php
            include('../../dbconnect.php');
            $id = $_SESSION['ID'];
            $sql = "SELECT * FROM progress WHERE lectureID=1 AND chapterID = 1 AND currentLevel='novice' AND ID = '$id';";

            $query = mysqli_query($con, $sql) or die('Query failed');

            while ($result = mysqli_fetch_array($query)) {
                $value = $result['chapterPerc'];
                ?>

                <div class="progress-bar progress-bar-striped active" role="progressbar"
                     aria-valuenow="<?php echo $value; ?>" aria-valuemin="0" aria-valuemax="100" style="width:<?php echo $value; ?>%;">
                </div>
                <?php
            } //while loop closes here

            ?>
        </div>

It shoud works, beacause you didn't specified the width in the aria-valuenow property

Also, try about making print_r($value); to be sure it's what you are excepting for.

answered Apr 1, 2016 at 19:17

user5672329

1 Comment

D4V1D Over a year ago

The aria-valuenow is not mandatory to see the progress bar actually.

Funk Forty Niner · Accepted Answer · 2016-04-01 22:07:23Z

1

"The problem was with the query itself there's no chapterID 1 should have written 2. Thanks for the insight. :) – Damini 2 hours ago."

Rather than or die('Query failed') what you should have used was or die(mysqli_error($con)) in order to get the real error.

answered Apr 1, 2016 at 22:07

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

Collectives™ on Stack Overflow

PHP variable inside the inline css

4 Answers 4

2 Comments

5 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

5 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related