connection php and postgreSQL - connection php and postgreSQL

我遇到了一个问题。我想连接PHP和PostgreSQL，但不知道如何。

HTML:

<?php
?>
<!DOCTYPE html>
<html lang = "pt-br">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- Título -->
    <title>test</title>
    <!-- Bootstrap CSS -->
    <link href="css/bootstrap.css" rel="stylesheet">
    <!-- Font-Awesome CSS -->
    <link href="css/font-awesome.min.css" rel="stylesheet">
    <!-- Ubicua-cloud CSS -->
  </head>
  <body>
    <form action = "" name = "f1" method = "post" style = "">
      <input type = "text" id = "telefone">
      <button type = "button" id = "init">iniciar sessão</button>
    </form>
    <!-- jQuery -->
    <script src="js/jquery.min.js"></script>
    <!-- Bootstrap JS -->
    <script src="js/bootstrap.min.js"></script>
    <!-- Ubicua-cloud-js -->
    <script src="login.js"></script>
  </body>
</html>

DB连接:

<?php 
 $connect=pg_connect ("host=localhost dbname=test port=5432 user=postgres password=28974220")or
 die("Error");
?>

JS捕捉用户信息

$(document).ready(function(){
    $('#init').click(function(){
        var telefone=$('#telefone').val();
        alert(telefone);
        $.ajax({
            type:"POST",
            dataType:'json',
            url:'login.Ajax.php',
            data:{telefone:telefone},
            success: function(response){
                if(response.resposta==true){
                    $('#msg').html(response.msg);
                    window.location='test.php';
                }
                else{
                    $('#msg').html(response.msg);
                }
            },error:function(){
                alert('error');
            }
        });
    });
});

验证信息的PHP代码:

<?php
    include_once('includes/connect.php');
    $msg_ok=false;
    $msg_error='O sistema está indisponível.';
    if(isset($_POST['telefone']))
        if($_POST['telefone']!="")
            $telefone=$_POST['telefone'];
            $consulta=pg_query($connect, ("Select * from test where telefone='$telefone"));
            if(pg_num_rows($consulta)>0)
                $msg_ok=true;
                $usua=pg_fetch_array($consulta);
                session_start();
                $_SESSION['id']=$usua[0];
                $_SESSION['telefone']=$usua[1];
                $msg_error='Logado';
            else
                $msg_error='Telefone não existe.';
            endif;
        else
            $msg_error='Telefone incorreto.';
        endif
    else
        $msg_error='Erro.';
    endif;
    $saidaJson=array('resposta' => $msg_ok, 'msg' => msg_error);
    echo json_encode($saidaJson);
?>

我收到了错误信息来捕获用户信息，help, please.

我假设您正在使用PDO。如果是这样，则需要对数据库连接文件进行更改(用数据库值替换变量):

<?php 
   $db = new PDO("pgsql:dbname=$dbname;host=$host";port=$port, $dbuser, $dbpass); 
?>

我解决了这个问题，但现在我需要在php和js之间交换信息…我有一个脚本，模拟一个人打字，需要它说话的用户叫他们的专有名称，但我不知道如何，我需要在JS连接一个变量，但在此之前，我需要存储一个PHP变量在一个JS变量。

var init = document.getElementById('init_text');
var init_text = 'Hi <nome>, I'm your friend!';
function digit(str, el) {
  var char = str.split('').reverse();
  var typer = setInterval(function () {
  if (!char.length) return clearInterval(typer);
    var next = char.pop();
    el.innerHTML += next;
  }, 60);
}
digit(init_text, init);