Adding PHP to HTML issue

Question

mpc123 15 Junior Poster in Training

11 Years Ago

HI , I basically have made something that I require work in html but now trying to convert to get the results from data base but get this error and cant work out how to change it, if someone could help

unexpected T_STRING, expecting ',' or ';' on line 69

***********all my css and database connection and query stuff**********************











while($row = mysql_fetch_array($result)){

            echo '<div class="BoxContainer">
    <div class="contentBox">
        <span class="inBoxTitle green">green box</span>



        <!-- Demo Button! -->
        <button class="botGreen" id="botSmallPic1">Picture 1</button>



    </div>






</div> <!-- .BoxContainer -->





<script src="/css/static/js/box.js"></script>


 <script type="text/javascript">



    $("#botSmallPic1").click(function(){
        $.smallBox( 
        {
            title: "",
            content: "",

            color: "#ec008c",
            img: "",
            icon: ""
        }
        );

    });


 </script>';
}

?>
</body>
</html>

php

3 Contributors
10 Replies
149 Views
1 Day Discussion Span
Latest Post 11 Years Ago Latest Post by mpc123

All 10 Replies

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

post complete code, $row is not used anywhere in your code,
so better you write php code where needed,
dont include all static html code in php echo.

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

just need whole code otherwsie cant find error

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

i dont find error in ur code, its compiles well

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

mpc123 15 Junior Poster in Training · Answer 1 · 2013-02-08T17:19:04+00:00

Hi

Thanks for the reply

Yeah im adding the $row info later as there is a lot of it, that why im trying to get rid of these issues first

It looks like the problem is with this area

{
            title: "",
            content: "",
            color: "#ec008c",
            img: "",
            icon: ""
        }
        );
    });



with the fetch result also wanting info between the } this means it obviously thinks it stops there, hoiw do i get round this please?

Thanks

mpc123 15 Junior Poster in Training · Answer 2 · 2013-02-08T17:43:32+00:00

Sorry here you go

<body>
<?php
$con = mysql_connect("","","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("", $con);

$result = mysql_query("my query") or trigger_error(mysql_error().$sql);
while($row = mysql_fetch_array($result)){

            echo '<div class="BoxContainer">
    <div class="contentBox">
        <span class="inBoxTitle green">A box</span>



        <!-- Demo Button! -->
        <button class="botGreen" id="botSmallPic1">Picture 1</button>



    </div>






</div> <!-- .BoxContainer -->





<script src="/css/static/js/box.js"></script>


 <script type="text/javascript">


    // ======== Box
    $("#botSmallPic1").click(function(){
        $.smallBox( 
        {
            title: "",
            content: "",

            color: "#ec008c",
            img: "",
            icon: ""
        }
        );

    });


 </script>';
}

?>
</body>
</html>

mpc123 15 Junior Poster in Training · Answer 3 · 2013-02-08T18:18:02+00:00

thanks for the reply but it says there is an error and I think there is around the

// ======== Box
    $("#botSmallPic1").click(function(){
        $.smallBox( 
        {
            title: "",
            content: "",
            color: "#ec008c",
            img: "",
            icon: ""
        }
        );
    });

    due to the { } which are in the code as the php result code says in between { }. I have no idea how to get round it

urtrivedi 276 Nearly a Posting Virtuoso · Answer 4 · 2013-02-08T18:27:14+00:00

are u sure u going to put some $row value in this javascript?, if not, then just keep this script out of php, becasue if u keep it in loop, the script will generate number of times the records are in ur query.

or use something like,
title="<?php echo $row['somevalue']; ?>";

mpc123 15 Junior Poster in Training · Answer 5 · 2013-02-08T19:15:06+00:00

yes im going to be putting the $row information in, im getting rid of this problem then i can go and add all that information

simplypixie 123 Posting Pro in Training · Answer 6 · 2013-02-09T08:24:37+00:00

Do what urtrivedi has advised and remove all your html and javascript from the php and see if your problem is resolved

while($row = mysql_fetch_array($result)){ ?>

    <div class="BoxContainer">
    <div class="contentBox">
        <span class="inBoxTitle green">A box</span>
        <!-- Demo Button! -->
        <button class="botGreen" id="botSmallPic1">Picture 1</button>
    </div>
</div> <!-- .BoxContainer -->

 <script type="text/javascript">

    // ======== Box
    $("#botSmallPic1").click(function(){
        $.smallBox( 
        {
            title: "",
            content: "",

            color: "#ec008c",
            img: "",
            icon: ""
        }
        );

    });

 </script>

<?php } ?>

And you won't need to call the external js file in your while loop so move <script src="/css/static/js/box.js"></script> to your head

mpc123 15 Junior Poster in Training · Answer 7 · 2013-02-09T19:15:05+00:00

mpc123 15 Junior Poster in Training

11 Years Ago

prefect thanks

Adding PHP to HTML issue

Recommended Answers Collapse Answers

All 10 Replies

Recommended Answers