[JSON] Autosuggest

[Kavvson]

I tried to connect 2 values that it would get . Player and players lvl it looks like this

<?php


    //connection information
    $host = "localhost";
    $user = "root";
    $password = "";
    $database = "test";
    $param = $_GET["term"];

    //make connection
    $server = mysql_connect($host, $user, $password);
    $connection = mysql_select_db($database, $server);
    
    //query the database
    $query = mysql_query("SELECT name,level FROM players WHERE name REGEXP '^$param' LIMIT 30");
    
    //build array of results
    for ($x = 0, $numrows = mysql_num_rows($query); $x < $numrows; $x++) {
        $row = mysql_fetch_assoc($query);
    
        $players[$x] = array("name" => $row["name"]);
        $players1[$x] = array("level" => $row["level"]);            
    }
    
    //echo JSON to page
    $response = $_GET["characters"] . "(" . json_encode($players) . ")";
        $response1 = $_GET["characters"] . "(" . json_encode($players1) . ")";
    echo "".$response."". $response1."";

    
    mysql_close($server);
    
?>

But it dont work.


Basic script:

<?php


    //connection information
    $host = "localhost";
    $user = "root";
    $password = "";
    $database = "test";
    $param = $_GET["term"];

    //make connection
    $server = mysql_connect($host, $user, $password);
    $connection = mysql_select_db($database, $server);
    
    //query the database
    $query = mysql_query("SELECT name FROM players WHERE name REGEXP '^$param' LIMIT 30");
    
    //build array of results
    for ($x = 0, $numrows = mysql_num_rows($query); $x < $numrows; $x++) {
        $row = mysql_fetch_assoc($query);
    
        $players[$x] = array("name" => $row["name"]);        
    }
    
    //echo JSON to page
    $response = $_GET["characters"] . "(" . json_encode($players) . ")";
    echo $response;
    
    mysql_close($server);
    
?>

Thx foe help

 

[Chris]

<?PHP

    // connection information
    $host = 'localhost';
    $user = 'root';
    $password = '';
    $database = '';
    $param = isset( $_GET['term'] ) ? $_GET['term'] : null;
    
    // connect to the database
    $server = mysql_connect( $host, $user, $password );
    $connection = mysql_select_db( $database, $server );
    
    // cast a query
    $query = mysql_query( 'SELECT name, level FROM players WHERE name LIKE \''.$param.'%\' LIMIT 30;' );
    
    // create empty variables
    list( $players, $x ) = array( array( ), 0 );
    
    // build an array of the result
    while( $row = mysql_fetch_assoc( $query ) )
    {
        $players[$x++] = $row;
    }

    // close connection
    mysql_close( $server );
    
    // JSON
    echo json_encode( $players );

?>

 

[Kavvson]

Thanks but (zoom in). It dont shows me the nicks. I had the same error when i made my code @up. It works with 1 query or w/e :///

 

[Chris]

I'm not getting any errors, did you alter the code?

 

[Kavvson]

I dont

 

[Chris]

Show me the JavaScript code, and please stop sending me a private message after every single one of your posts. I have subscribed to the topic and will notice your reply eventually.

 

[Kavvson]

<script>
$(function(){
				//attach autocomplete
				$("#search").autocomplete({
					//define callback search format results
					source: function(req, add){
						//pass request search server

						$.getJSON("/show.php?characters=?", req, function(data) {
							//create array for response objects
							var suggestions = [];
							//process response
							$.each(data, function(i, val){								
								suggestions.push(val.name);
							});
							//pass array search callback
							add(suggestions);
						});
					},
				});
			});
			
		function fill(thisValue) {
		$('#search').val(thisValue);
	}

</script>

 

[Chris]

Try this.

<script type="text/javascript">
    $(function(){
        //attach autocomplete
        $("#search").autocomplete({
            //define callback search format results
            source: function(req, add){
                //pass request search server
                $.getJSON("/show.php?characters=?", req, function(data) {
                    //create array for response objects
                    var suggestions = [];
                    //process response
                    $.each(data, function(i, val){                                
                        suggestions.push(val.name);
                    });
                    //pass array search callback
                    add(suggestions);
                });
            }
        });
    });
    
    function fill(thisValue) {
        $('#search').val(thisValue);
    }
</script>

 

[Kavvson]

Still not working :/