Solde en php
cricriazer
Bonjour,
j'ai un petit probleme avec mon code , j'aimerai accocier a mon espace membre, code :
<?php
if(empty($_SESSION['membre_site'])) { header('location: espace_client.php'); }
$datauser=mysql_query('SELECT * FROM user WHERE username = "'.$_SESSION['membre_site'].'"');
$user=mysql_fetch_array($datauser);
$achat = Securise($_GET['achat']);
if($achat == "mysqlmini")
{
if($user['point'] >= 50)
{
$sql =
$stock2 = mysql_query("SELECT * FROM stock WHERE utilise = '0' LIMIT 1");
$stock = mysql_fetch_array($stock2);
mysql_query("UPDATE user SET point = point - 50 WHERE id = '".$user['id']."'") or die(mysql_error());
mysql_query("INSERT INTO transaction (username,quoi,quand) VALUES ('".$user['username']."','commande service MySQL -50 points ','".FullDate('full')."')");
mysql_query("INSERT INTO service_mysql (username,service,valable,fin,phpmyadmin,acces_utilisateur,acces_mdp,hote,statut) VALUES ('".$user['username']."','MySQL Mini','1 mois','".FullDate('default')."','pma.master-db.fr','".$stock['identifiant']."','".$stock['pass']."','mysql.master-db.fr','1')") or die (mysql_error());
mysql_query("DELETE FROM stock WHERE id = '".$stock['id']."' LIMIT 1");
header('Location: commande.php?achat=ok');
}
else
{
header('Location: commande.php?achat=non');
}
}
if(isset($_GET['achat']))
{
$achat = Securise($_GET['achat']);
if($achat == "ok") { $message = '
<div class="alert alert-dismissible alert-success">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong><center>Bravo! votre service viens d\'être livré.</center></strong>
</div>
'; }
elseif ($achat == "non") { $message = '
<div class="alert alert-dismissible alert-danger">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong><center>Vous n\'avez pas assez de points. <a href="recharge">clic ici</a> pour en acheter</center></strong>
</div>
'; }
elseif(empty($achat)) { header('Location:./index.php'); }
}
?>
a mon espace membre mais je n'y arrive pas ..voila le code de mon espace membre :
<?php
if(session_status() == PHP_SESSION_NONE){
session_start();
}
?>
<?php
require 'inc/functions.php';
require_once 'inc/db.php';
if(!empty($_POST)){
if(empty($_POST['password']) || $_POST['password'] != $_POST['password_confirm']){
$_SESSION['flash']['danger'] = "Les mots de passes ne correspondent pas";
}else{
$user_id = $_SESSION['auth']->id;
$password= password_hash($_POST['password'], PASSWORD_BCRYPT);
require_once 'inc/db.php';
$pdo->prepare('UPDATE users SET password = ? WHERE id = ?')->execute([$password, $user_id]);
$_SESSION['flash']['success'] = "Votre mot de passe a bien été mis à jour";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.4.0/css/font-awesome.min.css">
<link rel="stylesheet" href="css/style.default.css" type="text/css" />
<link rel="stylesheet" href="css/bootstrap-fileupload.min.css" type="text/css" />
<link rel="stylesheet" href="css/bootstrap-timepicker.min.css" type="text/css" />
<script type="text/javascript" src="js/jquery-1.9.1.min.js"></script>
<script type="text/javascript" src="js/jquery-migrate-1.1.1.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.9.2.min.js"></script>
<script type="text/javascript" src="js/bootstrap.min.js"></script>
<script type="text/javascript" src="js/bootstrap-fileupload.min.js"></script>
<script type="text/javascript" src="js/bootstrap-timepicker.min.js"></script>
<script type="text/javascript" src="js/jquery.uniform.min.js"></script>
<script type="text/javascript" src="js/jquery.validate.min.js"></script>
<script type="text/javascript" src="js/jquery.tagsinput.min.js"></script>
<script type="text/javascript" src="js/jquery.autogrow-textarea.js"></script>
<script type="text/javascript" src="js/charCount.js"></script>
<script type="text/javascript" src="js/colorpicker.js"></script>
<script type="text/javascript" src="js/ui.spinner.min.js"></script>
<script type="text/javascript" src="js/chosen.jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.cookie.js"></script>
<script type="text/javascript" src="js/modernizr.min.js"></script>
<script type="text/javascript" src="js/custom.js"></script>
<script type="text/javascript" src="js/forms.js"></script>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title><?php echo $title_prefix; ?>Inscription</title>
<script type="text/javascript" src="includes/jscript/jquery.js"></script>
</script>
<script src='https://www.google.com/recaptcha/api.js'></script>
<script type="text/javascript" src="templates/CrazyHost/html/js/jquery_005.js"></script>
<script src="templates/CrazyHost/js/whmcs.js"></script>
<!-- Meta-->
<meta name="keywords" content="" >
<meta name="author" content="" >
<meta name="robots" content="" >
<meta name="description" content="" >
<!-- this styles only adds some repairs on idevices-->
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- Favicon-->
<link rel="shortcut icon" href="templates/CrazyHost/html/images/favicon.ico" />
<!-- ######### CSS STYLES #########-->
<link rel="stylesheet" href="templates/CrazyHost/html/css/reset.css" type="text/css" />
<link rel="stylesheet" href="templates/CrazyHost/html/css/style.css" type="text/css" />
<link rel="stylesheet" href="templates/CrazyHost/html/css/font-awesome/css/font-awesome.min.css" />
<!-- responsive devices styles-->
<link rel="stylesheet" media="screen" href="templates/CrazyHost/html/css/responsive-leyouts.css" type="text/css" />
<!-- Pages-->
<link href="templates/CrazyHost/html/js/mainmenu/sticky.css" rel="stylesheet" />
<link href="templates/CrazyHost/html/js/mainmenu/bootstrap.min.css" rel="stylesheet" />
<link href="templates/CrazyHost/html/js/mainmenu/demo.css" rel="stylesheet" />
<link href="templates/CrazyHost/html/js/mainmenu/menu.css" rel="stylesheet" />
<!--Revolutionslider Style-->
<link rel="stylesheet" type="text/css" href="templates/CrazyHost/html/js/revolutionslider/css/style.css" media="screen" />
<!--Revolutionslider Style Settings-->
<link rel="stylesheet" type="text/css" href="templates/CrazyHost/html/js/revolutionslider/rs-plugin/css/settings.css" media="screen" />
<!--Simple line icons-->
<link rel="stylesheet" type="text/css" href="templates/CrazyHost/html/css/Simple-Line-Icons-Webfont/simple-line-icons.css" media="screen" />
<!-- forms -->
<link rel="stylesheet" href="templates/CrazyHost/html/js/form/sky-forms.css" type="text/css" media="all" />
<!--Flexslider-->
<link rel="stylesheet" href="templates/CrazyHost/html/js/flexslider/flexslider.css" type="text/css" media="screen" />
<!--Accordions-->
<link rel="stylesheet" href="templates/CrazyHost/html/js/accordion/accordion.css" type="text/css" media="all" />
<!--Tabs-->
<link rel="stylesheet" type="text/css" href="templates/CrazyHost/html/js/tabs/assets/css/responsive-tabs.css" />
<link rel="stylesheet" type="text/css" href="templates/CrazyHost/html/js/tabs/assets/css/responsive-tabs2.css" />
<link rel="stylesheet" type="text/css" href="templates/CrazyHost/html/js/tabs/assets/css/responsive-tabs11.css" />
<!--VPS Plan slider Price Selector content-->
<style>
#s_1 { background-image:url(templates/templates.html/'. {
$template
}
.'/html/images/servers1.png');
}
#s_2 { background-image:url(templates/templates.html/'. {
$template
}
.'/html/images/server2.png');
}
#s_3 { background-image:url(templates/templates.html/'. {
$template
}
.'/html/images/server3.png');
}
#s_4 { background-image:url(templates/templates.html/'. {
$template
}
.'/html/images/server4.png');
}
.ui-slider .ui-slider-handle { position: absolute; z-index: 2; cursor: pointer; background: url(templates/templates.html/'. {
$template
}
.'/html/images/slider/pointer.png') no-repeat 50% 50%;
outline: none;
border:none;
top: -22px;
}
.ui-slider .ui-slider-range-min { background: url(templates/templates.html/'. {
$template
}
.'/html/images/slider/filled.png') repeat-x;
z-index:1;
}
.ui-slider { background: url(templates/templates.html/'. {
$template
}
.'/html/images/slider/unfilled.png') repeat-x;
z-index:1;
}
</style>
<style>
@media only screen and (min-width: 768px) and (max-width: 999px) {
.section_holder2.two { display:none; }
}
@media only screen and (min-width: 480px) and (max-width: 767px) {
.section_holder2.two { display:none; }
}
@media only screen and (max-width: 479px) {
.section_holder2.two { display:none; }
}
</style>
</head>
<body>
<div class="site_wrapper">
<?php include_once('headermenu.php');?>
<?php include_once('menu.php');?>
</header>
</div>
<?php include_once('header.php');?>
<center>
<h4><strong><font color='black'>Information de votre compte</font></strong></h4>
<p><br>
<font color='black'> Bonjour,</font> <font color='#3A8EBA'> <?= $_SESSION['auth']->username; ?><br>
</font>
<font color='black'> Votre id est le n°</font> <font color='#3A8EBA'> <?= $_SESSION['auth']->id; ?><br>
</font>
<font color='black'> Votre identifiant est : </font><font color='#3A8EBA'> <?= $_SESSION['auth']->indentifiant; ?></font><br>
<font color='black'> Vous avez actutellement :</font> <font color='#3A8EBA'><?= $_SESSION['auth']->point; ?>€<br>
</font>
<font color='black'> Votre email : </font><font color='#FF0000'> <?= $_SESSION['auth']->email; ?></font></p>
<br /><br /><br /><label for="">Changer le mot de passe de votre compte :</label><br />
<center><form action="" method="post" enctype="multipart/form-data">
<div class="form-group">
<input class="input-xxlarge" type="password" name="password" placeholder="Changer de mot de passe"/>
</div>
<div class="form-group">
<input class="input-xxlarge" type="password" name="password_confirm" placeholder="Confirmation du mot de passe"/><br /><br />
</div>
<button class="btn btn-primary">Changer mon mot de passe</button>
</form><br /> <br />
</div> <!---sidebar-right-close--->
<?php include_once('footer.php');?>
<a href="#" class="scrollup"></a> </div>
<!--/ scrollup-->
<script type="text/javascript" src="templates/CrazyHost/html/js/style-switcher/styleswitcher.js"></script>
<div id="style-selector">
<div> <br />
<br />
<!-- end BG Patterns-->
</div>
</div>
<!-- ######### JS FILES #########-->
<!-- get jQuery from the google apis-->
<!--<script type="text/javascript" src="templates/CrazyHost/html/js/universal/jquery.js"></script> -->
<!-- style switcher-->
<script src="templates/CrazyHost/html/js/style-switcher/jquery-1.js"></script>
<script src="templates/CrazyHost/html/js/style-switcher/styleselector.js"></script>
<script src="templates/CrazyHost/html/js/jquery-ui.js" type="text/javascript"></script>
<!-- SLIDER REVOLUTION 4.x SCRIPTS-->
<script type="text/javascript" src="templates/CrazyHost/html/js/revolutionslider/rs-plugin/js/jquery.themepunch.tools.min.js"></script>
<script type="text/javascript" src="templates/CrazyHost/html/js/revolutionslider/rs-plugin/js/jquery.themepunch.revolution.min.js"></script>
<script type="text/javascript" src="templates/CrazyHost/html/js/revolutionslider/custom1.js"></script>
<!-- Pages-->
<script src="templates/CrazyHost/html/js/mainmenu/bootstrap.min.js"></script>
<script src="templates/CrazyHost/html/js/mainmenu/customeUI.js"></script>
<!-- sticky menu-->
<script type="text/javascript" src="templates/CrazyHost/html/js/mainmenu/sticky.js"></script>
<script type="text/javascript" src="templates/CrazyHost/html/js/mainmenu/modernizr.custom.75180.js"></script>
<!-- tabs-->
<script src="templates/CrazyHost/html/js/tabs/assets/js/responsive-tabs.min.js" type="text/javascript"></script>
<!-- accordion-->
<script>
(function() {
var $container = $('.acc-container'),
$trigger = $('.acc-trigger');
$container.hide();
$trigger.first().addClass('active').next().show();
var fullWidth = $container.outerWidth(true);
$trigger.css('width', fullWidth);
$container.css('width', fullWidth);
$trigger.on('click', function(e) {
if( $(this).next().is(':hidden') ) {
$trigger.removeClass('active').next().slideUp(300);
$(this).toggleClass('active').next().slideDown(300);
}
e.preventDefault();
});
// Resize
$(window).on('resize', function() {
fullWidth = $container.outerWidth(true)
$trigger.css('width', $trigger.parent().width() );
$container.css('width', $container.parent().width() );
});
})();
</script>
<script type="text/javascript" src="templates/CrazyHost/html/js/custom_002.js"></script>
<!-- scroll up-->
<script src="templates/CrazyHost/html/js/scrolltotop/totop.js" type="text/javascript"></script>
<!-- Flexslider-->
<script src="templates/CrazyHost/html/js/flexslider/jquery.flexslider.js"></script>
<script src="templates/CrazyHost/html/js/flexslider/custom.js"></script>
<script src="templates/CrazyHost/html/js/open-sans.js"></script>
</body>
</html>
voici la db
merci de m'aider