load a file using variable from client side

Question

I need to load a file inside a container, but using an argument - to get some data from database firstly:

$('#story').load('test.php');

test.php

$st = $db->query("select * from users where id = " . $id);  

... processing variables... load the finished content

Here I need $id from client side. Is it possible?

note that you should be very cautious not injecting directly the variable in your SQL string. bobby tables -> you should use prepared statements, and maybe do some checks first — Kaddath
– Kaddath, Commented Feb 21, 2019 at 8:18
yes, that can be used to get informations about other tables of your DB, using join and such, good habit to take anyway — Kaddath
– Kaddath, Commented Feb 21, 2019 at 8:23

prasanth · Accepted Answer · 2019-02-21 08:17:02Z

5

yes ..you could pass with url query

$('#story').load('test.php?id=1');

test.php

$id = isset($_REQUEST['id'])?$_REQUEST['id']):'';
$st = $db->query("select * from users where id = " . $id);

answered Feb 21, 2019 at 8:17

prasanth

22.6k4 gold badges33 silver badges57 bronze badges

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

2 Comments

Rohit Ghotkar Over a year ago

You can use null coalesce operator instead ternery operator as $id = $_REQUEST['id] ?? '';

prasanth Over a year ago

@RohitGhotkar you are right.But its only supported on php 7 and above.Not with lower version stackoverflow.com/questions/34571330/…

pr1nc3 · Accepted Answer · 2019-02-21 08:19:31Z

You can use ajax request and on success you load your file something like:

                    $.ajax({
                        type: 'POST',
                        url: "test.php", //make sure you put the right path there
                        data: {id: id},
                        dataType: "json",
                        success: function (resultData) {
                            $('#story').load('test.php');
                        }
                    })

Just make sure that your php function returns/echos the id you want.

That way you make a call to your php file and when it's successful you will load your file and you can put extra logic there if you want to return more data to use it of course.

resultData holds the output of your php function so it's up to you what info you want to be there.

Amal US · Accepted Answer · 2019-02-21 08:49:03Z

0

You could use Ajax to post the ID to your php code.

$.ajax({
type: "POST",
url: "test.php",
data: { 'id': foo },
cache: false,
success: function(){
   alert("Order Submitted");
  }
});

php:

<?php
$id = $_POST['id'];

edited Feb 21, 2019 at 8:49

Amal US

213 bronze badges

answered Feb 21, 2019 at 8:20

Alex Thunder

1

Collectives™ on Stack Overflow

load a file using variable from client side

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related