antiblock
https://arwen2.global/
  • Chatbox

    You don't have permission to chat.
    Load More
  • 0
Sign in to follow this  
MorreJaa

[AJUDA] Site de Registo

Question

Boas eu tenho me registar no meu servidor e não consigo porque aparece este erro:

 

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\inc\config.php:16 Stack trace: #0 C:\xampp\htdocs\register.php(2): include() #1 {main} thrown in C:\xampp\htdocs\inc\config.php on line 16

 

no config.php coloquei:

 

<?php 
	/*
	|-------------------------------------------------------------------
	| Datenbank Connection Details
	|-------------------------------------------------------------------
	*/
		$mysql_host 	= "192.168.1.100";
		$mysql_user 	= "root";
		$mysql_pass 	= "12345";
		$mysql_db	= "account";
	/*
	|-------------------------------------------------------------------
	| Datenbank Verbindung herstellen
	|-------------------------------------------------------------------
	*/	
		mysql_connect($mysql_host, $mysql_user, $mysql_pass) OR
		die("Es konnte keine Verbindung zur Datenbank hergestellt werden.<br /> Fehlermeldung: ".mysql_error());	
		
		mysql_select_db($mysql_db) OR
		die("Die Datenbank konnte nicht benutzt werden.<br /> Fehlermeldung: ".mysql_error());
?>

 

e ao registar aparece este erro:

 

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\inc\config.php:16 Stack trace: #0 C:\xampp\htdocs\register.php(2): include() #1 {main} thrown in C:\xampp\htdocs\inc\config.php on line 16

 

 

e a linha do erro no config.php é:

 

mysql_connect($mysql_host, $mysql_user, $mysql_pass) OR

 

o que estou a fazer de mal? eu ja tentei entrar no site atraves de localhost/127.0.0.1 e 192.168.1.100 e da tudo o mesmo erro, a senha do mysql é a mesma do navicat certo? eu pus a senha do navicat será que é outra? se nao for o que estou a fazer de errado?

Share this post


Link to post
Share on other sites

11 answers to this question

  • 0

Boas,

o comando: "mysql_connect" foi deprecated....

 

Usa mysqli_connect ...

 

provavelmente vais ter que resolver muitas outras coisas...

 

 

Cumprimentos

Share this post


Link to post
Share on other sites
antiblock
https://arwen2.global/
  • 0

As funções mysql já foram descontinuadas no PHP 7+.

 

Usa mysqli ou PDO.

Share this post


Link to post
Share on other sites
  • 0

como assim? existe ja algum site simples de registo com essas funcões?

 

Share this post


Link to post
Share on other sites
  • 0
<?php 
	/*
	|-------------------------------------------------------------------
	| Datenbank Connection Details
	|-------------------------------------------------------------------
	*/
		$mysqli_host 	= "192.168.1.100";
		$mysqli_user 	= "root";
		$mysqli_pass 	= "";
		$mysqli_db	= "account";
	/*
	|-------------------------------------------------------------------
	| Datenbank Verbindung herstellen
	|-------------------------------------------------------------------
	*/	
		mysqli_connect($mysqli_host, $mysqli_user, $mysqli_pass) OR
		die("Es konnte keine Verbindung zur Datenbank hergestellt werden.<br /> Fehlermeldung: ".mysqli_error());	
		
		mysqli_select_db($mysqli_db) OR
		die("Die Datenbank konnte nicht benutzt werden.<br /> Fehlermeldung: ".mysqli_error());
?>

 

tentei assim mas nao da na mesma, eu nao entendo de mysql

Share this post


Link to post
Share on other sites
  • 0

O comando mysqli_select_db precisa de uma ligação para saber onde vai selecionar a db...

 

<?php 
	/*
	|-------------------------------------------------------------------
	| Datenbank Connection Details
	|-------------------------------------------------------------------
	*/
		$mysql_host 	= "192.168.1.100";
		$mysql_user 	= "root";
		$mysql_pass 	= "";
		$mysql_db	= "account";
	/*
	|-------------------------------------------------------------------
	| Datenbank Verbindung herstellen
	|-------------------------------------------------------------------
	*/	
		$conn = mysqli_connect($mysql_host, $mysql_user, $mysql_pass) OR
		die("Es konnte keine Verbindung zur Datenbank hergestellt werden.<br /> Fehlermeldung: ".mysqli_error());	
		
		mysqli_select_db($conn, $mysql_db) OR
		die("Die Datenbank konnte nicht benutzt werden.<br /> Fehlermeldung: ".mysqli_error());
?>

Atribuí o mysqli_connect a uma variável e passei essa variável no mysqli_select_db

Share this post


Link to post
Share on other sites
  • 0

Agora está a dar erro no register.php

 

ERRO:

Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\register.php:4 Stack trace: #0 {main} thrown in C:\xampp\htdocs\register.php on line 4

 

Register.php

<?php 
	include('inc/config.php');
	if(isset($_POST['submit']) && $_POST['submit'] == 'Registar') {
		$username = mysql_real_escape_string($_POST['username']);
		$password = mysql_real_escape_string($_POST['password']);
		$social_id = mysql_real_escape_string($_POST['social_id']);
		$real_name = mysql_real_escape_string($_POST['real_name']);
		$email = mysql_real_escape_string($_POST['email']);
		
		$sql = "INSERT INTO account SET login = '".$username."', password = PASSWORD('".$password."'), social_id = '".$social_id."', real_name = '".$real_name."', email = '".$email."'";
		$result = mysql_query($sql);
		if($result)  echo '<script type="text/javascript">
            alert("Registro Efetuado com Sucesso!");
            window.history.go(-1);
        </script>'; else { echo 'NOT'; }
	}
?>

 

Share this post


Link to post
Share on other sites
  • 0

e existe algum site de registo ja com o novo mysql e php? como base? para eu poder começar?

Share this post


Link to post
Share on other sites
  • 0

Não faço ideia, o último que usei fui eu que alterei tudo à mão.

 

No futuro tenciono fazer em Laravel.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this