Ajax call PHP Mysql public static function

Question

Im getting a hard time with this guys, How can i call this kind of php class? Here rest my problem remote: 'myData.php?jquery=%jquery' What's the correct call format?

myData.php

public static function getproduct($p){
        $sql = "select * from products where code like '%$p%' or name like '%$p%' or id like '%$p%'";
        $query = Executor::doit($sql);
        return Model::many($query[0],new ProductData());
    }

From Js/Ajax like:

$(document).ready(function() {

            $('input.city').typeahead({
                name: 'city',
                remote: 'myData.php?jquery=%jquery'

            });

        })

Thanks!

inside myData.php, include/use the file where your class is defined and call ClassName::getproduct($p) — Ima
– Ima, Commented Nov 22, 2016 at 6:59
@user3099298 Im really stupid i didnt get it. Could you give me an more simple example?. Cheers. — fecapeluda
– fecapeluda, Commented Nov 22, 2016 at 7:09
@Ima The posted PHP/Mysql function is already inside myData.php (Who has 2 more functions), so, is like i'm calling it directly, is this wrong? — fecapeluda
– fecapeluda, Commented Nov 22, 2016 at 7:12
Ypu cannot call directly from javascript, you have to call a url with javascript (via Ajax) and that url should be handled in a php file. That php file can invoke any php function you want. Read for more info on ajax: w3schools.com/xml/ajax_intro.asp — Ima
– Ima, Commented Nov 22, 2016 at 7:45

Gayan · Accepted Answer · 2016-11-22 07:47:58Z

2

Product.php file represents your class file. viewProduct.php is your view file. When you enter text on city input field, jQuery will pass that value to class file using GET method. If class file get a value from myRequest, then it will call static function and send output to the view file.

Product.php

class Product{
    public static function getproduct($p){
        // add your SQL queries
        return "This is return value ".$p;
    }
}

// call static function 
if(isset($_GET['myRequest'])) {
     echo Product::getproduct($_GET['myRequest']);
}

viewProduct.php

<input type="text" name="city" id="city"/>

<span id="result"></span>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
    $("#city").keyup(function(){
        var txt = $(this).val();
        $.get("product.php", {myRequest: txt}, function(result){
            $("#result").html(result);
        });
    });
});
</script>

edited Nov 22, 2016 at 7:47

answered Nov 22, 2016 at 7:31

Gayan

2,9458 gold badges36 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

fecapeluda Over a year ago

Now I'm Getting an Parse error: syntax error, unexpected 'class' (T_CLASS), expecting function (T_FUNCTION) . I leave you a pastebin to see how my myData.php looks pastebin.com/CExBQdsd

Gayan Over a year ago

@fecapeluda Create two files in separate directory(not your actual project folder) and run above code, then you can understand how it is working. Then apply the concept to your actual project.

Collectives™ on Stack Overflow

Ajax call PHP Mysql public static function

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related