how to change table cell color depending on values in php -


i started programming in php. want change cell color depending on values. example if quantity < 1000 should display red color. don't understand how it. please me. code. have tried far. please let me know wrong , needs done. thanx in advance

         <div class="c-content-panel">                     <div class="c-label">basic example</div>                     <div class="c-body">                         <div class="row">                             <div class="col-md-12">                                 <table class="table">                                  <caption>optional table caption. </caption>                                    <thead>                                         <tr>                                             <th>#</th>                                             <th>store id</th>                                             <th>item name</th>                                             <th>quantity</th>                                              <th>status</th>                                          </tr>                                     </thead>                                     <tbody>                 <?php while ($row =mysqli_fetch_array($query))                                                                         {                                         echo " <tr>                                         <td>--</td>                                         <td>{$row['store_id']}                                         </td>                                          <td>{$row['store_name']}</td>                                         <td>{$row['quantity']}</td>                                          if($row['quantity']<1000)                                             {                          echo "<td style='background-color: #ff0000;'></td>"                                         }                                        else                                        {                         echo "< td style='background-color: #ffff00;'></td>"                                        }                                           </tr>";                                            echo " <tr>                                         <td>--</td>                                         <td>{$row['store_id']}</td>                                          <td>{$row['mphone']}</td>                                     <td>{$row['quantity_mphone']}</td> </tr>";                                              echo " <tr>                                         <td>--</td>                                         <td>{$row['store_id']}</td>                                          <td>{$row['smart_devices']}</td>                           <td>   {$row['quantity_smart_devices']}</td> </tr>";                                            echo " <tr>                                         <td>--</td>                                         <td>{$row['store_id']}</td>                                          <td>{$row['power']}</td>                                            <td>{$row['quantity_power']}</td>                                            </tr>";                                             echo " <tr>                                         <td>--</td>                                         <td>{$row['store_id']}</td>                                          <td>{$row['audio']}</td>                                            <td>{$row['quantity_audio']}</td>                                                </tr>";}                                           ?>                                       </tbody>                                 </table>                             </div>                         </div>                     </div>                 </div>

you can't write if in echo. have terminate echo before using if

  <div class="c-content-panel">       <div class="c-label">basic example</div>       <div class="c-body">           <div class="row">               <div class="col-md-12">                   <table class="table">                    <caption>optional table caption. </caption>                      <thead>                           <tr>                               <th>#</th>                               <th>store id</th>                               <th>item name</th>                               <th>quantity</th>                                <th>status</th>                            </tr>                       </thead>                       <tbody>    <?php while ($row =mysqli_fetch_array($query))                                                           {                           echo " <tr>                           <td>--</td>                           <td>{$row['store_id']}                           </td>                            <td>{$row['store_name']}</td>                           <td>{$row['quantity']}</td>";                            if($row['quantity']<1000)                               {            echo "<td style='background-color: #ff0000;'></td>";                           }                          else                          {           echo "< td style='background-color: #ffff00;'></td>";                          }                             echo "</tr>";                              echo " <tr>                           <td>--</td>                           <td>{$row['store_id']}</td>                            <td>{$row['mphone']}</td>                       <td>{$row['quantity_mphone']}</td> </tr>";                                echo " <tr>                           <td>--</td>                           <td>{$row['store_id']}</td>                            <td>{$row['smart_devices']}</td>             <td>   {$row['quantity_smart_devices']}</td> </tr>";                              echo " <tr>                           <td>--</td>                           <td>{$row['store_id']}</td>                            <td>{$row['power']}</td>                              <td>{$row['quantity_power']}</td>                              </tr>";                               echo " <tr>                           <td>--</td>                           <td>{$row['store_id']}</td>                            <td>{$row['audio']}</td>                              <td>{$row['quantity_audio']}</td>                                  </tr>";}                             ?>                         </tbody>                   </table>               </div>           </div>       </div>   </div>

Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more