PHP pg_connect to PostgreSQL

Trying to use PHP to remotely query a PostgreSQL DB on my AWS server..


<?php

    if ( isset($_POST["searchText"]) )
    {
        $searchText  = $_POST["searchText"];
        $searchType  = $_POST["searchType"];
        $searchDb  = $_POST["searchDb"];
    }
   
    $query = "SELECT * FROM " . $searchDb . " WHERE " . $searchType . " = '" . $searchText . "';";
   
    $queryResult = query($searchDb, $query);
    //echo $queryResult;
 
    function query($searchDb, $query)
    {
        $host = "wouldntyouliketoknow.com";
        $user = "username";
        $pass = "password";
        $db = "database";
       
        pg_connect("host=$host port=5432 dbname=$db user=$user password=$pass");
       
        if (!$conn)
        {
            echo "Not connected";
        }
   
        $result = pg_query($conn, $query);
        pg_close($conn);
        return $result;
    }
   
?>

It doesn't throw any errors, the connection request just times out every time after like 15 seconds, then it just echoes "Not connected." Is this an issue with the AWS server, or the server I'm trying to open the connection from?

>>10

Why would I be banned from Stack Overflow? I'm not an aspie like the majority of posters here. As I've said before, the issue is not the code. Prepared statements, non-prepared statements, nigger functions, it makes no difference. The problem is that it times out every time I try to open the database connection.


<?php
    if ( isset($_POST["searchText"]) )
    {
        $searchText  = $_POST["searchText"];
        $searchType  = $_POST["searchType"];
        $searchDb  = $_POST["searchDb"];
    }
   
    $query = "SELECT * FROM " . $searchDb . " WHERE " . $searchType . " = '" . $searchText . "';";
   
    $queryResult = query($searchDb, $query);
    echo $queryResult;
 
    function query($searchDb, $query)
    {
        $host = "fatniggers.com";
        $user = "niggeruser";
        $pass = "niggerpass";
        $db = "niggerdb";
       
        $dbconn = pg_connect("host=$host port=5432 dbname=$db user=$user password=$pass connect_timeout=3<") or die("Could not connect");
       
        $result = pg_prepare($dbconn, "searchQuery", $query);
        $result = pg_execute($dbconn, "searchQuery", array("Search Result")) or die(pg_last_error($dbconn));
       
        pg_close($dbconn);
       
        return $result;
    }   
?>