PHP - Append Values In Xml

We are getting back each error message, but it only outputs the last error message.   how can we append each error message to the DIV    Here is the code that loops thru each error message  

  
                    if(data.length > 0) {    
$.each(data, function(error_code, message ) {
if(errorCode == $.trim(message.error_code) && errorCode != -1 ){
error_message = message.message;
                           return false; 
}
    });
}
 

    Here is the code that outputs the error message in a drop down. PLEASE ANY HELP

if(BoltNotify === true && multipleNotice === true){ 
      //var error_message += error_message; 
  var spanerrorgen = $('.error.message').contents().find('h4').html(error_message);
  var appenderrorgen = $('.error.message').contents().find('h4');
  $.each(data, function($fieldref) { 
$(spanerrorgen).append(spanerrorgen);
});
 VanillaReload.notify.showNotification(".error");                     
    }
 

I now know how to append GET over normal hyperlinks, but I don't know how to do it with form submissions.

Here's the problem:

I have a form like this one:


<form method="GET" action="">

<?php 
require_once ('sort_category_func.php');
$switch = 1;
sort_category ($switch); 
?>

+ Most Liked <input type='checkbox' value='mostLiked' name='mostLiked' />
<br />
<input type="submit" name="sortSubmit" value='Go' />
<br /><br />
</form>




And the variables:


// DROP DOWN MENU VARIABLES
$select_category = $_REQUEST['sort_category'];
$most_liked = $_GET['mostLiked'];


I'm using a while loop to list user submission, you can also sort them by category which works over GET, this works as long as there is no GET data already in the URL, but as soon as there is GET data it won't work anymore.

Here's an example:

If I have a user profile page opened like this:


profile.php?user=konopkov


And a category has been chosen to sort the user's submissions the URL will change to:


profile.php?sort_category=Logos


INSTEAD it should be:


profile.php?user=konopkov&sort_category=Logos


As I said I know how to achieve this with hyperlinks now, but I have no clue how do it with form submissions.

Any suggestions?

Thanks.

Hello,

Firstly I am only just learning php so please bear with me.

What I want to be able to do is for a user to be able to enter a youtube url eg:
Code: [Select]
http://www.youtube.com/watch?v=8xz7ShMCWls
I want the scrip to take the video ID (after watch?v=) and append it into a html embed code for our forums that do not have the feature to auto embed a youtube vid.

Code: [Select]
<p> <img height="350" width="425" class="fw_media_youtube fw-parse" alt="YouTube-AFTER WATCH?V=CODE" src="http://thumbs.webs.com/Platform/mediaPreview.jsp?type=YouTube&amp;id=AFTER WATCH?V=CODE"/></p>
Where you see AFTER WATCH?V=CODE is where I want it to place the video id and then return this completed code for the user to copy and paste:

Code: [Select]
<p> <img height="350" width="425" class="fw_media_youtube fw-parse" alt="YouTube-8xz7ShMCWls" src="http://thumbs.webs.com/Platform/mediaPreview.jsp?type=YouTube&amp;id=8xz7ShMCWls"/></p>
How would I be able to get this done. I do not expect to be spoon fed but just a litlle help please.

Thank you so much if you do help.

Hello there people.

I'm looking for the easiest & most solid way to append 1 or 2 strings to a certain PDF file. I have an application which a logged-in user will be able to print. When he prints it, his name and a counter string must be appended in a blank space in the application. So I don't need to replace a string in a PDF or something, just append. The PDF file will always be the same: the application to be filled.

I've heard somewhere that you can do it easily with the Zend framework. I've also heard for some other libraries like TCPDF & FPDF.

Any suggestions?

Thanks

i have a long list of numbers like this

36346346
436346
444444
44
666666666666865
4564
.
.
.

and at the beginning and end of each entry i want to append some characters so it looks like this:

-36346346+
-436346+
-444444+
-44+

how do to this with php? thanks

hi all i'm trying to make a quick and simple '.htaccess' installer and i'm using fopen/fwrite to do this but i'm getting an error:

Quote

Parse error: parse error in /var/www/test.php on line 12


here's the code:

Code: [Select]
<?PHP
$File = ".htaccess";
$fh = fopen($File, 'a');
$Data = "\n#test write
<IfModule mod_deflate.c>
   AddOutputFilterByType DEFLATE text/css
   AddOutputFilterByType DEFLATE text/javascript application/javascript application/x-javascript text/x-js text/ecmascript application/ecmascript text/vbscript text/fluffscript
   AddOutputFilterByType DEFLATE image/svg+xml application/x-font-ttf application/x-font font/opentype font/otf font/ttf application/x-font-truetype application/x-font-opentype application/vnd.ms-fontobject application/vnd.oasis.opendocument.formula-template
   AddOutputFilterByType DEFLATE text/xml application/xml
</IfModule>
<IfModule mod_expires.c>
<FilesMatch "\.(ico|gif|jpg|JPG|jpeg|png|PNG|swf|css|js|html?|xml|txt)$">
ExpiresActive On
ExpiresDefault "access plus 1 month"
</FilesMatch>
</IfModule>
#test write\n";
fwrite($fh, $Data);
fclose($fh);
?>
how do i include the code in the $Data string bit?

Hello im looking for a little help with my script,

im hosting the files at  www.1pw.co.uk/demo.php

After dragging an image into the shopping basket, I would like a thumbnail image to appear in the div at the bottom of the page (  .bowlpic)  is this possible and what is the easiest way of going about it?

demo.php
Code: [Select]
<?php

define('INCLUDE_CHECK',1);
require "connect2.php";

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>shop</title>

<link rel="stylesheet" type="text/css" href="demo.css" />

<script type="text/javascript" src="http://code.jquery.com/jquery-1.6.1.min.js"></script>
<script type="text/javascript" src="jquery.ui.main.js"></script>

<!--[if lt IE 7]>
<style type="text/css">
.pngfix { behavior: url(pngfix/iepngfix.htc);}
    .tooltip{width:200px;};
</style>
<![endif]-->


<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/jquery-ui.min.js"></script>

<script type="text/javascript" src="simpletip/jquery.simpletip-1.3.1.pack.js"></script>


<script type="text/javascript" src="script.js"></script>

</head>

<body>

<div id="main-container">
<div class="tutorialzine">
    <h1>Shopping cart</h1>
    <h3>The best products at the best prices</h3>
    </div>

    <div class="container">
   
    <span class="top-label">
            <span class="label-txt">Products</span>
        </span>
       
        <div class="content-area">
   
    <div class="content drag-desired">
           
                <?php

$result = mysql_query("SELECT * FROM internet_shop");
while($row=mysql_fetch_assoc($result))
{
echo '<div class="product"><a href="#" class="item"><img src="img/products/'.$row['img'].'" alt="'.htmlspecialchars($row['name']).'" width="128" height="128" class="pngfix" /></a></div>';

}

?>
               
               
                <div class="clear"></div>
            </div>

        </div>
       
        <div class="bottom-container-border">
        </div>

    </div>



    <div class="container">
   
    <span class="top-label">
            <span class="label-txt">Shopping Cart</span>
        </span>
       
        <div class="content-area">
   
    <div class="content drop-here">
            <div id="cart-icon">
            <img src="img/Shoppingcart_128x128.png" alt="shopping cart" class="pngfix" width="128" height="128" />
<img src="img/ajax_load_2.gif" alt="loading.." id="ajax-loader" width="16" height="16" />
                </div>

<form name="checkoutForm" method="post" action="order.php">
               
                <div id="item-list">
                </div>
               
</form>               
                <div class="clear"></div>

<div id="total"></div>

                <div class="clear"></div>
               
                <a href="" onclick="document.forms.checkoutForm.submit(); return false;" class="button">Checkout</a>
               
          </div>

        </div>
       
        <div class="bottom-container-border">
        </div>

    </div>

</div>

</body>
</html>

script.js
Code: [Select]
var purchased=new Array();
var totalprice=0;

$(document).ready(function(){

$('.product').simpletip({

offset:[40,0],
content:'<img src="img/ajax_load.gif" alt="loading" style="margin:10px;" />',
onShow: function(){

var param = this.getParent().find('img').attr('src');

if($.browser.msie && $.browser.version=='6.0')
{
param = this.getParent().find('img').attr('style').match(/src=\"([^\"]+)\"/);
param = param[1];
}

this.load('ajax/tips.php',{img:param});
}

});

$(".product img").draggable({

containment: 'document',
opacity: 0.6,
revert: 'invalid',
helper: 'clone',
zIndex: 100

});

$("div.content.drop-here").droppable({

drop:
function(e, ui)
{
var param = $(ui.draggable).attr('src');

if($.browser.msie && $.browser.version=='6.0')
{
param = $(ui.draggable).attr('style').match(/src=\"([^\"]+)\"/);
param = param[1];
}

addlist(param);
}

});

});


function addlist(param)
{
$.ajax({
type: "POST",
url: "ajax/addtocart.php",
data: 'img='+encodeURIComponent(param),
dataType: 'json',
beforeSend: function(x){$('#ajax-loader').css('visibility','visible');},
success: function(msg){

$('#ajax-loader').css('visibility','hidden');
if(parseInt(msg.status)!=1)
{
return false;
}
else
{
var check=false;
var cnt = false;

for(var i=0; i<purchased.length;i++)
{
if(purchased[i].id==msg.id)
{
check=true;
cnt=purchased[i].cnt;

break;
}
}

if(!cnt)
$('#item-list').append(msg.txt);

if(!check)
{
purchased.push({id:msg.id,cnt:1,price:msg.price});
}
else
{
if(cnt>=3) return false;

purchased[i].cnt++;
$('#'+msg.id+'_cnt').val(purchased[i].cnt);
}

totalprice+=msg.price;
update_total();

}

$('.tooltip').hide();

}
});
}

function findpos(id)
{
for(var i=0; i<purchased.length;i++)
{
if(purchased[i].id==id)
return i;
}

return false;
}

function remove(id)
{
var i=findpos(id);

totalprice-=purchased[i].price*purchased[i].cnt;
purchased[i].cnt = 0;

$('#table_'+id).remove();
update_total();
}

function change(id)
{
var i=findpos(id);

totalprice+=(parseInt($('#'+id+'_cnt').val())-purchased[i].cnt)*purchased[i].price;

purchased[i].cnt=parseInt($('#'+id+'_cnt').val());
update_total();
}

function update_total()
{
if(totalprice)
{
$('#total').html('total: $'+totalprice);
$('a.button').css('display','block');
}
else
{
$('#total').html('');
$('a.button').hide();
}
}


demo.css
Code: [Select]
body,h1,h2,h3,p,td,quote,small,form,input,ul,li,ol,label{
margin:0px;
padding:0px;
font-family:Arial, Helvetica, sans-serif;
}

body{
color:#555555;
font-size:13px;
background-color:#282828;
}

.clear{
clear:both;
}

#main-container{
width:700px;
margin:20px auto;
}

.container{
margin-bottom:40px;
}

.top-label{
background:url(img/label_bg.png) no-repeat;
display:inline-block;
margin-left:20px;
position:relative;
margin-bottom:-15px;
}

.label-txt{
background:url(img/label_bg.png) no-repeat top right;
display:inline-block;
font-size:10px;
height:36px;
margin-left:10px;
padding:12px 15px 0 5px;
text-transform:uppercase;
}

.content-area{
background:url(img/container_top.png) no-repeat #fcfcfc;
padding:15px 20px 0 20px;
}

.content{
padding:10px;
}

.drag-desired{
background:url(img/drag_desired_label.png) no-repeat top right;
padding:30px;
}

.drop-here{
background:url(img/drop_here_label.png) no-repeat top right;
}


.bottom-container-border{
background:url(img/container_bottom.png) no-repeat;
height:14px;
}

.product{
border:2px solid #F5F5F5;
float:left;
margin:15px;
padding:10px;
}

.product img{
cursor:move;
}

p.descr{
padding:5px 0;
}

small{
display:block;
margin-top:4px;
}

.tooltip{
position: absolute;
top: 0;
left: 0;
z-index: 3;
display: none;

background-color:#666666;
border:1px solid #666666;
color:#fcfcfc;

padding:10px;

-moz-border-radius:12px;
-khtml-border-radius: 12px;
-webkit-border-radius: 12px;
border-radius:12px;
}

#cart-icon{
width:128px;
float:left;
position:relative;
}

#ajax-loader{
position:absolute;
top:0px;
left:0px;
visibility:hidden;
}

#item-list{
float:left;
width:490px;
margin-left:20px;
padding-top:15px;
}

a.remove,a.remove:visited{
color:red;
font-size:10px;
text-transform:uppercase;
}

#total{
clear:both;
float:right;
font-size:10px;
font-weight:bold;
padding:10px 12px;
text-transform:uppercase;
}

#item-list table{
background-color:#F7F7F7;
border:1px solid #EFEFEF;
margin-top:5px;
padding:4px;
}

a.button,a.button:visited{
display:none;

height:29px;
width:136px;

padding-top:15px;
margin:0 auto;
overflow:hidden;

color:white;
font-size:12px;
font-weight:bold;
text-align:center;
text-transform:uppercase;

background:url(img/button.png) no-repeat center top;
}

a.button:hover{
background-position:bottom;
text-decoration:none;
}


a, a:visited {
color:#00BBFF;
text-decoration:none;
outline:none;
}

a:hover{
text-decoration:underline;
}

h1{
font-size:28px;
font-weight:bold;
font-family:"Trebuchet MS",Arial, Helvetica, sans-serif;
}

h2{
font-weight:normal;
font-size:20px;

color:#666666;
text-indent:30px;
margin:20px 0;
}

.tutorialzine h1{
color:white;
margin-bottom:10px;
font-size:48px;
}

.tutorialzine h3{
color:#F5F5F5;
font-size:10px;
font-weight:bold;
margin-bottom:30px;
text-transform:uppercase;
}

.tutorial-info{
color:white;
text-align:center;
padding:10px;
margin-top:-20px;
}

*/ added myself */
.icon-blank{
background:url('icons/blank.gif') no-repeat;
}
.icon-add{
background:url('icons/edit_add.png') no-repeat;
}
.icon-edit{
background:url('icons/pencil.png') no-repeat;
}
.icon-remove{
background:url('icons/edit_remove.png') no-repeat;
}
.icon-save{
background:url('icons/filesave.png') no-repeat;
}
.icon-cut{
background:url('icons/cut.png') no-repeat;
}
.icon-ok{
background:url('icons/ok.png') no-repeat;
}
.icon-no{
background:url('icons/no.png') no-repeat;
}
.icon-cancel{
background:url('icons/cancel.png') no-repeat;
}
.icon-reload{
background:url('icons/reload.png') no-repeat;
}
.icon-search{
background:url('icons/search.png') no-repeat;
}
.icon-print{
background:url('icons/print.png') no-repeat;
}
.icon-help{
background:url('icons/help.png') no-repeat;
}
.icon-undo{
background:url('icons/undo.png') no-repeat;
}
.icon-redo{
background:url('icons/redo.png') no-repeat;
}
.icon-back{
background:url('icons/back.png') no-repeat;
}
.icon-sum{
background:url('icons/sum.png') no-repeat;
}
.icon-tip{
background:url('icons/tip.png') no-repeat;
}

.icon-mini-add{
background:url('icons/mini_add.png') no-repeat 2px 2px;
}
.icon-mini-edit{
background:url('icons/mini_edit.png') no-repeat 2px 2px;
}
.icon-mini-refresh{
background:url('icons/mini_refresh.png') no-repeat 3px 2px;
}

.products{
list-style:none;
padding:0px;
height:100%;
}
.products li{
float:left;
margin:10px;
}
.item{
display:block;
text-decoration:none;
}
.item img{
border:1px solid #333;
}
.item p{
margin:0;
font-weight:bold;
text-align:center;
color:#c3c3c3;
}
.cart{
position:fixed;
right:0;
top:0;
width:300px;
height:100%;
background:#ccc;
padding:0px 10px;
}
.bowlpic {
height:300px;
width:260px;
overflow:none;
background-image:url(bowl.jpg);
background-repeat:no-repeat;
background-color:#FF0000;
float:left;
text-align: left;
}
.total{
margin:0;
text-align:right;
padding-right:20px;
}
#productpics {
height:300px; width:1000px;
}
#arrow {height:300px; width:300px; float:left;
}

Hi, currently in my registration code, the userId allows only six digits as the user ID.
I need help in performing the following task
1. Modify the account creation screen to allow users  to enter EITHER a 6-digit ID OR a 9 character ID.  Any 6-digit PLID will be stored with the perpended B11.
2.Modify the login utility for the users to allow them to use either the 6-digit or 9-character IDs which means you will need to prepend the B11 to any 6-digit PLID to find their record in the database.
3.Convert existing PLIDs in the database to the new format by prepending the B11.

 Any coding help will be greatly appreciated.

I am submitting $_POST data to a results page.  The data comprises of references and text.  Each reference has its own table on the results page.  I need to check if an any of the table id's on the results page are the same as any of the references in $_POST, if any are, I am appending to the table, if not I am creatig a new table for the reference.  How do I check if a table id exists in order to append, then create tables for those that don't  Any help/guidance appreciated.

I append a string to a file by fwrite as

Code: [Select]
$str= 'dynamic text from each run';
$myFile = "testFile.txt";
$fh = fopen($myFile, 'a') or die("can't open file");
$stringData = "$str\n";
fwrite($fh, $stringData);
fclose($fh);
but I want to avoid duplicate to keep the file small. I want to avoid writing if the term is already saved in the file. I want to have a file containing unique lines.

hello i can't figure out how to modify a value from assoc array so with each recursion to add additional string to his:
for example   i have
attribute="";
then call recursive function
and i try to modify its value by concatenating "0"; or "1";
on the next loop  to add again "0" or "1";

Hello,

I am trying to do multiple curl requests and get the response for each one output to the screen.

I have wrote the following code, but only appear to be getting the last response when outputting $result.

What am i doing wrong? Is there a way to wait for each curl request to be completed before appending to $result so I can see them all?

Thanks very much

if (isset($_POST['submit'])) {
	$result = array();
	foreach ($textAr as $line) {
		$ch = curl_init();
		curl_setopt($ch, CURLOPT_URL, $url);
		curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
		curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
		curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true );
		curl_setopt($ch, CURLOPT_ENCODING, "gzip,deflate");
		$result[] = curl_exec ($ch);
	}
	curl_close ($ch);

	echo "<pre>";
	print_r($result);
	echo "</pre>";

}

 

I have the following simple class:

Code: [Select]
class Settings {
  public static $mysql_datetime_format = "%c/%e/%Y %l:%i %p " . date("[T]");
}

And referencing like:

Code: [Select]
echo Settings::$mysql_datetime_format;

But, I am getting the error: Parse error: syntax error, unexpected '.', expecting ',' or ';'.

Why is this invalid?

Dear All Members

here is my table data..

(4 Columns/1row in mysql table)

id                 order_no               order_date                  miles
310                001                   02-15-2020                MI,108.53
                                                                                     Oh,194.57
                                                                                     PA,182.22
                                                                                     WA,238.57

How to split(miles) single column into (state, miles) two columns and output like following 5 columns /4rows in mysql using php code.

(5 Columns in mysql table)
------------------------------------------------------------------------------------

id                  order_no              order_date              state      miles

310                001                   02-15-2020               MI          108.53

310                001                   02-15-2020              Oh          194.57

310                001                   02-15-2020              PA          182.22

310                001                   02-15-2020             WA          238.57
 

------------------my php code -----------

 

<?php
//invoice.php  
include('../includes/config.php');

if(isset($_POST["add"]))
{
$order_no=$_GET['order_no'];
$order_date=$_GET['order_date'];
$miles=$_POST['miles'];

$miles = explode("\r\n", $_POST["miles"]);
$newdata = "'" . implode("','", $_POST["miles"]) . "'";
$sql ="INSERT INTO tble_states_miles(order_no,order_date, miles) VALUES(:order_no, :order_date, :newdata)";

$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);
$query-> bindParam(':order_date', $order_date, PDO::PARAM_STR);
$query-> bindParam(':miles', $newdata, PDO::PARAM_STR);

$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
echo "<script type='text/javascript'>alert('Added Sucessfull!');</script>";
echo "<script type='text/javascript'> document.location = 'ifta_miles_calculationlist_added.php'; </script>";
}
else 
{
$error="Something went wrong. Please try again";
}

if($query->execute()) {

$sql = "update tis_invoice set flag='1' where order_no=:order_no";
$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);

$query->execute();

}
}
?>

----------------- my form code ------------------

 

 <?php
                   $order_no=$_GET['order_no'];
        $sql = "SELECT * from tis_invoice where order_no = :order_no";
        $query = $dbh -> prepare($sql);
        $query->execute(
  array(
   ':order_no'       =>  $_GET["order_no"]
  )
 );
        $result = $query->fetchAll();
        foreach($result as $row)
?>
    
                    <form method="post">
                        <table align="center" style="width: 55%">
                        <tr><td>Invoice Number</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_no"]; ?>" readonly=""></td></tr>
                        <tr><td>Invoice Date</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_date"]; ?>" readonly=""></td></tr>
                        <tr><td>
                               <textarea name="miles" class="form-control" rows="10" placeholder="" required></textarea>
                           </td></tr>
                           <tr><td>
                         
                            <input type="submit" name="add" class="btn btn-primary" value="Add" />
                       </td></tr></table>
                    </form>

-- Can any one help how to correct my code..present nothing inserted on table

 

Thank You

Edited February 8, 2020 by karthicbabu

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites.  When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell.  It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in.  Both cases mess up the table and formatting.  I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<table id="datatables-column-search-select-inputs" class="table table-striped" style="width:100%">

                                        <thead>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                                <th>Actions</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php

                                            //QUERY TO SELECT ALL USERS FROM DATABASE

                                            $query = "SELECT * FROM users";

                                            $select_users = mysqli_query($connection,$query);

                                            

                                            // SET VARIABLE TO ARRAY FROM QUERY

                                            while($row = mysqli_fetch_assoc($select_users)) {

                                                $user_id = $row['user_id'];

                                                $user_firstname = $row['user_firstname'];

                                                $user_lastname = $row['user_lastname'];

                                                $username = $row['username'];

                                                $user_phone = $row['user_phone'];

                                                $user_image = $row['user_image'];

                                                $user_title_id = $row['user_title_id'];

                                                $user_role_id = $row['user_role_id'];

                                            

                                                // POPULATES DATA INTO THE TABLE

                                                echo "<tr>";

                                                echo "<td>{$user_id}</td>";

                                                echo "<td>{$user_firstname}</td>";

                                                echo "<td>{$user_lastname}</td>";

                                                echo "<td>{$username}</td>";

                                                echo "<td>{$user_phone}</td>";

                                            

                                                //PULL SITE STATUS BASED ON SITE STATUS ID

                                                $query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

                                                $select_site = mysqli_query($connection, $query);

                                                while($row = mysqli_fetch_assoc($select_site)) {

                                                    $site_name = $row['site_name'];

                                                    echo "<td>{$site_name}</td>";

                                                }

                                                echo "<td>{$user_title_id}</td>";

                                                echo "<td>{$user_role_id}</td>";

                                                echo "<td class='table-action'>

                                                    <a href='#'><i class='align-middle' data-feather='edit-2'></i></a>

                                                    <a href='#'><i class='align-middle' data-feather='trash'></i></a>

                                                    </td>";

                                                //echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

                                                echo "</tr>";

                                            }   

                                            ?>

 

                                            <tr>

                                                <td>ID</td>

                                                <td>FirstName</td>

                                                <td>LastName</td>

                                                <td>Username</td>

                                                <td>Phone #</td>

                                                <td>Location</td>

                                                <td>Title</td>

                                                <td>Role</td>

                                                <td class="table-action">

                                                <a href="#"><i class="align-middle" data-feather="edit-2"></i></a>

                                                <a href="#"><i class="align-middle" data-feather="trash"></i></a>

                                                </td>

                                            </tr>

                                        </tbody>

                                        <tfoot>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                            </tr>

                                        </tfoot>

                                    </table>