Crear cuenta
<button type="button" class="btn btn-primary btn-block">Button 1</button>
<?php
//NUEVA CONSULTA angel $stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt->execute();
if($stmt->rowCount() > 0)
{while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{extract($row);
?>
<div class="col-xs-3">
<p class="page-header"><?php echo $userName." / ".$userProfession; ?></p>
<img src="user_images/<?php echo $row['userPic']; ?>" class="img-rounded" width="250px" height="250px" />
<p class="page-header">
<span>
<a class="btn btn-info btn-block" href="editform.php?edit_id=<?php echo $row['userID']; ?>" title="click for edit" onclick="return confirm('sure to edit ?')"><span class="glyphicon glyphicon-edit"></span> Edit</a>
<a class="btn btn-danger btn-block" href="?delete_id=<?php echo $row['userID']; ?>" title="click for delete" onclick="return confirm('sure to delete ?')"><span class="glyphicon glyphicon-remove-circle"></span> Delete</a>
<a class="btn btn-danger btn-block" href="editformtrabajotodos.php?mostrartrabajos_id=<?php echo $row['userID']; ?>" title="Mostrar todos sus trabajos" onclick="¿Quieres mostrar?')"><span class="glyphicon glyphicon-edit"></span> Mostrar todos sus trabajos</a>
</span>
</p>
</div>
<?php
} }else
{?>
<div class="col-xs-12">
<div class="alert alert-warning">
<span class="glyphicon glyphicon-info-sign"></span> No Data Found ...
</div>
</div>
<?php
}?>
</div>
<div class="col-xs-3">
<div class="col-xs-6 col-sm-4 col-lg-3">
<?php
require_once 'dbconfig.php';if(isset($_GET['delete_id']))
{// select image from db to delete
$stmt_select = $DB_con->prepare('SELECT userPic FROM tbl_users WHERE userID =:uid');
$stmt_select->execute(array(':uid'=>$_GET['delete_id']));
$imgRow=$stmt_select->fetch(PDO::FETCH_ASSOC);
unlink("user_images/".$imgRow['userPic']);
// it will delete an actual record from db
$stmt_delete = $DB_con->prepare('DELETE FROM tbl_users WHERE userID =:uid');
$stmt_delete->bindParam(':uid',$_GET['delete_id']);
$stmt_delete->execute();
header("Location: index2.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" />
<meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no" />
<title>Partes de trabajo</title>
<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="bootstrap/css/bootstrap-theme.min.css">
</head>
<body>
<div class="navbar navbar-default navbar-static-top" role="navigation">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="index2" title='Usuarios'>Usuarios</a>
</div>
</div>
</div>
<div class="container">
<div class="page-header">
<h1 class="h2">Todos los usuarios / <a class="btn btn-default" href="addnew.php"> <span class="glyphicon glyphicon-plus"></span> add new </a></h1>
</div>
<br />
<div class="row">
<?php
//NUEVA CONSULTA angel $stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt->execute();
if($stmt->rowCount() > 0)
{while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{extract($row);
?>
<div class="col-xs-3">
<!--><div class="col-xs-6 col-sm-4 col-lg-3"></-->
<p class="page-header"><?php echo $userName." / ".$userProfession; ?></p>
<img src="user_images/<?php echo $row['userPic']; ?>" class="img-rounded" width="250px" height="250px" />
<p class="page-header">
<span>
<a class="btn btn-info" href="editform.php?edit_id=<?php echo $row['userID']; ?>" title="click for edit" onclick="return confirm('sure to edit ?')"><span class="glyphicon glyphicon-edit"></span> Edit</a>
<a class="btn btn-danger" href="?delete_id=<?php echo $row['userID']; ?>" title="click for delete" onclick="return confirm('sure to delete ?')"><span class="glyphicon glyphicon-remove-circle"></span> Delete</a>
<a class="btn btn-danger" href="editformtrabajotodos.php?mostrartrabajos_id=<?php echo $row['userID']; ?>" title="Mostrar todos sus trabajos" onclick="¿Quieres mostrar?')"><span class="glyphicon glyphicon-edit"></span> Mostrar todos sus trabajos</a>
</span>
</p>
</div>
<?php
} }else
{?>
<div class="col-xs-12">
<div class="alert alert-warning">
<span class="glyphicon glyphicon-info-sign"></span> No Data Found ...
</div>
</div>
<?php
}?>
</div>
<div class="alert alert-info">
<strong>Empresa</strong> <a href="http://www.empresa.com">Empresa</a>!
</div>
</div>
<!-- Latest compiled and minified JavaScript --><script src="bootstrap/js/bootstrap.min.js"></script>
</body>
</html>
<div class="row"><!-- ROWS-->
<div class="col-6 "><p>Ancho 6</p>
<div class="col-6 "><p>Ancho 6 dentro de una col 6. Ocupara la mitad de 6, es decir 3.</p>
</div>
</div>
<div class="container-fluid"><!-- CONTAINER-->
<div class="row"><!-- ROWS-->
<div class="col-6 col-sm-6 col-lg-4 bg-success"><p>col-6 col-sm-9 col-lg-4</p> <button type="button" class="btn btn-danger btn-block">Button 1</button> </div>
<div class="col-6 col-sm-5 col-lg-4 bg-warning"><p>col-6 col-sm-3 col-lg-4</p> <button type="button" class="btn btn-basic btn-block">Button 1</button> <button type="button" class="btn btn-primary btn-block">Button 1</button> </div>
<div class="col-6 col-sm-3 col-lg-4 bg-primary"><p>col-6 col-sm-3 col-lg-4</p> <button type="button" class="btn btn-warning btn-block">Button 1</button> </div>
</div><!-- / ROWS -->
</div><!-- / CONTAINER-->
<?php
require_once 'dbconfig.php';if(isset($_GET['delete_id']))
{// select image from db to delete
$stmt_select = $DB_con->prepare('SELECT userPic FROM tbl_users WHERE userID =:uid');
$stmt_select->execute(array(':uid'=>$_GET['delete_id']));
$imgRow=$stmt_select->fetch(PDO::FETCH_ASSOC);
unlink("user_images/".$imgRow['userPic']);
// it will delete an actual record from db
$stmt_delete = $DB_con->prepare('DELETE FROM tbl_users WHERE userID =:uid');
$stmt_delete->bindParam(':uid',$_GET['delete_id']);
$stmt_delete->execute();
header("Location: index2.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" />
<meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no" />
<title>Partes de trabajo</title>
<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="bootstrap/css/bootstrap-theme.min.css">
</head>
<body>
<div class="navbar navbar-default navbar-static-top" role="navigation">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="index2" title='Usuarios'>Usuarios</a>
</div>
</div>
</div>
<div class="container">
<div class="page-header">
<h1 class="h2">Todos los usuarios / <a class="btn btn-default" href="addnew.php"> <span class="glyphicon glyphicon-plus"></span> add new </a></h1>
</div>
<br />
<div class="container-fluid"><
<div class="row">
<?php
//NUEVA CONSULTA angel $stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt->execute();
if($stmt->rowCount() > 0)
{while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{extract($row);
?>
<div class="col-xs-3">
<!--><div class="col-xs-6 col-sm-4 col-lg-3"></-->
<p class="page-header"><?php echo $userName." / ".$userProfession; ?></p>
<img src="user_images/<?php echo $row['userPic']; ?>" class="img-rounded" width="250px" height="250px" />
<p class="page-header">
<span>
<div class="col-6 col-sm-6 col-lg-4 bg-success"><p>col-6 col-sm-9 col-lg-4</p> <button type="button" class="btn btn-danger btn-block">Button 1</button> </div>
<div class="col-6 col-sm-5 col-lg-4 bg-warning"><p>col-6 col-sm-3 col-lg-4</p> <button type="button" class="btn btn-basic btn-block">Button 1</button> <button type="button" class="btn btn-primary btn-block">Button 1</button> </div>
<div class="col-6 col-sm-3 col-lg-4 bg-primary"><p>col-6 col-sm-3 col-lg-4</p> <button type="button" class="btn btn-warning btn-block">Button 1</button> </div>
</span>
</p>
</div><!-- / ROWS -->
</div><!-- / CONTAINER-->
<?php
} }else
{?>
<div class="col-xs-12">
<div class="alert alert-warning">
<span class="glyphicon glyphicon-info-sign"></span> No Data Found ...
</div>
</div>
<?php
}?>
</div>
<div class="alert alert-info">
<strong>Empresa</strong> <a href="http://www.empresa.com">Empresa</a>!
</div>
</div>
<!-- Latest compiled and minified JavaScript --><script src="bootstrap/js/bootstrap.min.js"></script>
</body>
</html>
<div class="col-xs-3">
<div class="col-xs-6 col-md-4 col-lg-4">
<?php
require_once 'dbconfig.php';if(isset($_GET['delete_id']))
{// select image from db to delete
$stmt_select = $DB_con->prepare('SELECT userPic FROM tbl_users WHERE userID =:uid');
$stmt_select->execute(array(':uid'=>$_GET['delete_id']));
$imgRow=$stmt_select->fetch(PDO::FETCH_ASSOC);
unlink("user_images/".$imgRow['userPic']);
// it will delete an actual record from db
$stmt_delete = $DB_con->prepare('DELETE FROM tbl_users WHERE userID =:uid');
$stmt_delete->bindParam(':uid',$_GET['delete_id']);
$stmt_delete->execute();
header("Location: index2.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" />
<meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no" />
<title>Partes de trabajo</title>
<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="bootstrap/css/bootstrap-theme.min.css">
</head>
<body>
<div class="navbar navbar-default navbar-static-top" role="navigation">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="index2" title='Usuarios'>Usuarios</a>
</div>
</div>
</div>
<div class="container">
<div class="page-header">
<h1 class="h2">Todos los usuarios / <a class="btn btn-default" href="addnew.php"> <span class="glyphicon glyphicon-plus"></span> add new </a></h1>
</div>
<br />
<div class="container-fluid"><
<div class="row">
<?php
//NUEVA CONSULTA angel $stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt->execute();
if($stmt->rowCount() > 0)
{while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{extract($row);
?>
<!--><div class="col-xs-3"></-->
<div class="col-xs-6 col-sm-4 col-lg-4">
<p class="page-header"><?php echo $userName." / ".$userProfession; ?></p>
<img src="user_images/<?php echo $row['userPic']; ?>" class="img-rounded" width="250px" height="250px" />
<p class="page-header">
<span>
<div class="col-6 col-sm-6 col-lg-4 bg-success"><p>col-6 col-sm-9 col-lg-4</p> <button type="button" class="btn btn-danger btn-block">Button 1</button> </div>
<div class="col-6 col-sm-5 col-lg-4 bg-warning"><p>col-6 col-sm-3 col-lg-4</p> <button type="button" class="btn btn-basic btn-block">Button 1</button> <button type="button" class="btn btn-primary btn-block">Button 1</button> </div>
<div class="col-6 col-sm-3 col-lg-4 bg-primary"><p>col-6 col-sm-3 col-lg-4</p> <button type="button" class="btn btn-warning btn-block">Button 1</button> </div>
</span>
</p>
</div><!-- / ROWS -->
</div><!-- / CONTAINER-->
<?php
} }else
{?>
<div class="col-xs-12">
<div class="alert alert-warning">
<span class="glyphicon glyphicon-info-sign"></span> No Data Found ...
</div>
</div>
<?php
}?>
</div>
<div class="alert alert-info">
<strong>Empresa</strong> <a href="http://www.empresa.com">Empresa</a>!
</div>
</div>
<!-- Latest compiled and minified JavaScript --><script src="bootstrap/js/bootstrap.min.js"></script>
</body>
</html>
<p class="page-header"><?php echo $userName." / ".$userProfession; ?></p>
<img src="user_images/<?php echo $row['userPic']; ?>" class="img-rounded" width="250px" height="250px" />
<p class="page-header">
<span>
<a class="btn btn-info btn-block" href="editform.php?edit_id=<?php echo $row['userID']; ?>" title="click for edit" onclick="return confirm('sure to edit ?')"><span class="glyphicon glyphicon-edit"></span> Edit</a>
<a class="btn btn-danger btn-block" href="?delete_id=<?php echo $row['userID']; ?>" title="click for delete" onclick="return confirm('sure to delete ?')"><span class="glyphicon glyphicon-remove-circle"></span> Delete</a>
<a class="btn btn-danger btn-block" href="editformtrabajotodos.php?mostrartrabajos_id=<?php echo $row['userID']; ?>" title="Mostrar todos sus trabajos" onclick="¿Quieres mostrar?')"><span class="glyphicon glyphicon-edit"></span> Mostrar todos sus trabajos</a>
<div class="col-xs-3">
<p class="page-header"><?php echo $userName." / ".$userProfession; ?></p>
<img src="user_images/<?php echo $row['userPic']; ?>" class="img-rounded" width="250px" height="250px" />
<p class="page-header">
<span>
<a class="btn btn-info btn-block" href="editform.php?edit_id=<?php echo $row['userID']; ?>" title="click for edit" onclick="return confirm('sure to edit ?')"><span class="glyphicon glyphicon-edit"></span> Edit</a>
<a class="btn btn-danger btn-block" href="?delete_id=<?php echo $row['userID']; ?>" title="click for delete" onclick="return confirm('sure to delete ?')"><span class="glyphicon glyphicon-remove-circle"></span> Delete</a>
<a class="btn btn-danger btn-block" href="editformtrabajotodos.php?mostrartrabajos_id=<?php echo $row['userID']; ?>" title="Mostrar todos sus trabajos" onclick="¿Quieres mostrar?')"><span class="glyphicon glyphicon-edit"></span> Mostrar todos sus trabajos</a>
</span>
</p>
<?php
require_once 'dbconfig.php';if(isset($_GET['delete_id']))
{// select image from db to delete
$stmt_select = $DB_con->prepare('SELECT userPic FROM tbl_users WHERE userID =:uid');
$stmt_select->execute(array(':uid'=>$_GET['delete_id']));
$imgRow=$stmt_select->fetch(PDO::FETCH_ASSOC);
unlink("user_images/".$imgRow['userPic']);
// it will delete an actual record from db
$stmt_delete = $DB_con->prepare('DELETE FROM tbl_users WHERE userID =:uid');
$stmt_delete->bindParam(':uid',$_GET['delete_id']);
$stmt_delete->execute();
header("Location: index2.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" />
<meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no" />
<title>Partes de trabajo</title>
<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="bootstrap/css/bootstrap-theme.min.css">
</head>
<body>
<div class="navbar navbar-default navbar-static-top" role="navigation">
<div class="container">
<div class="navbar-header">
<a class="navbar-brand" href="index2" title='Usuarios'>Usuarios</a>
</div>
</div>
</div>
<div class="container">
<div class="page-header">
<h1 class="h2">Todos los usuarios / <a class="btn btn-default" href="addnew.php"> <span class="glyphicon glyphicon-plus"></span> add new </a></h1>
</div>
<br />
<div class="container-fluid"><
<div class="row">
<?php
//NUEVA CONSULTA angel $stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt->execute();
if($stmt->rowCount() > 0)
{while($row=$stmt->fetch(PDO::FETCH_ASSOC))
{extract($row);
?>
<!--><div class="col-xs-3"></-->
<div class="col-xs-6 col-sm-4 col-lg-4">
<p class="page-header"><?php echo $userName." / ".$userProfession; ?></p>
<img src="user_images/<?php echo $row['userPic']; ?>" class="img-rounded" width="250px" height="250px" />
<p class="page-header">
<span>
<div class="col-6 col-sm-6 col-lg-4 bg-success"><p>col-6 col-sm-9 col-lg-4</p> <button href="editform.php?edit_id=<?php echo $row['userID']; ?>" type="button" class="btn btn-danger btn-block">Button 1</button> </div>
<div class="col-6 col-sm-5 col-lg-4 bg-warning"><p>col-6 col-sm-3 col-lg-4</p> <button href="?delete_id=<?php echo $row['userID']; ?>" type="button" class="btn btn-basic btn-block">Button 1</button> <button type="button" class="btn btn-primary btn-block">Button 1</button> </div>
<div class="col-6 col-sm-3 col-lg-4 bg-primary"><p>col-6 col-sm-3 col-lg-4</p> <button href="editformtrabajotodos.php?mostrartrabajos_id=<?php echo $row['userID']; ?>" type="button" class="btn btn-warning btn-block">Button 1</button> </div>
</span>
</p>
</div><!-- / ROWS -->
</div><!-- / CONTAINER-->
<?php
} }else
{?>
<div class="col-xs-12">
<div class="alert alert-warning">
<span class="glyphicon glyphicon-info-sign"></span> No Data Found ...
</div>
</div>
<?php
}?>
</div>
<div class="alert alert-info">
<strong>Empresa</strong> <a href="http://www.empresa.com">Empresa</a>!
</div>
</div>
<!-- Latest compiled and minified JavaScript --><script src="bootstrap/js/bootstrap.min.js"></script>
</body>
</html>