sql queries on ajax php page
-1
i am trying to get content inside a div using ajax, on the php page that am accessing using ajax, i want to fill dropdown options using another query but it just closes the select tag before the options.
<select class="form-control data" data-t="integer" name='role' required/>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select>
But here is what i get inside the div
<select class="form-control data" data-t="integer" name="role"
required=""></select>
<option value='1' >option1</option>
<option value='2' >option2</option>
<option value='3' >option3</option>
php ajax
asked Nov 11 at 9:08
akshay sharma
357
add a comment |
-1
i am trying to get content inside a div using ajax, on the php page that am accessing using ajax, i want to fill dropdown options using another query but it just closes the select tag before the options.
<select class="form-control data" data-t="integer" name='role' required/>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select>
But here is what i get inside the div
<select class="form-control data" data-t="integer" name="role"
required=""></select>
<option value='1' >option1</option>
<option value='2' >option2</option>
<option value='3' >option3</option>
php ajax
asked Nov 11 at 9:08
akshay sharma
357
add a comment |
-1
-1
-1
i am trying to get content inside a div using ajax, on the php page that am accessing using ajax, i want to fill dropdown options using another query but it just closes the select tag before the options.
<select class="form-control data" data-t="integer" name='role' required/>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select>
But here is what i get inside the div
<select class="form-control data" data-t="integer" name="role"
required=""></select>
<option value='1' >option1</option>
<option value='2' >option2</option>
<option value='3' >option3</option>
php ajax
asked Nov 11 at 9:08
akshay sharma
357
i am trying to get content inside a div using ajax, on the php page that am accessing using ajax, i want to fill dropdown options using another query but it just closes the select tag before the options.
<select class="form-control data" data-t="integer" name='role' required/>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select>
But here is what i get inside the div
<select class="form-control data" data-t="integer" name="role"
required=""></select>
<option value='1' >option1</option>
<option value='2' >option2</option>
<option value='3' >option3</option>
php ajax
php ajax
asked Nov 11 at 9:08
akshay sharma
357
asked Nov 11 at 9:08
akshay sharma
357
asked Nov 11 at 9:08
akshay sharma
357
asked Nov 11 at 9:08
akshay sharma
357
asked Nov 11 at 9:08
akshay sharma
357
357
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
6
please remove forward / at the end of opening select tag as below:
<select class="form-control data" data-t="integer" name='role' required>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select>answered Nov 11 at 9:22
Khalifa Nikzad
68811
oh snap! XD what the... XD sorry that was such an embarrassing mistake :D Btw... why did it work in the first place, i mean i used the same select (closed in the opening tag itself) on another page (not accessed by an ajax call). I just copied this dropdown from there.... it was working as required on that page, even with this error...
– akshay sharma
Nov 11 at 9:32
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53247276%2fsql-queries-on-ajax-php-page%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
6
please remove forward / at the end of opening select tag as below:
<select class="form-control data" data-t="integer" name='role' required>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select>answered Nov 11 at 9:22
Khalifa Nikzad
68811
oh snap! XD what the... XD sorry that was such an embarrassing mistake :D Btw... why did it work in the first place, i mean i used the same select (closed in the opening tag itself) on another page (not accessed by an ajax call). I just copied this dropdown from there.... it was working as required on that page, even with this error...
– akshay sharma
Nov 11 at 9:32
add a comment |
6
please remove forward / at the end of opening select tag as below:
<select class="form-control data" data-t="integer" name='role' required>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select>answered Nov 11 at 9:22
Khalifa Nikzad
68811
oh snap! XD what the... XD sorry that was such an embarrassing mistake :D Btw... why did it work in the first place, i mean i used the same select (closed in the opening tag itself) on another page (not accessed by an ajax call). I just copied this dropdown from there.... it was working as required on that page, even with this error...
– akshay sharma
Nov 11 at 9:32
add a comment |
6
6
6
please remove forward / at the end of opening select tag as below:
<select class="form-control data" data-t="integer" name='role' required>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select>answered Nov 11 at 9:22
Khalifa Nikzad
68811
please remove forward / at the end of opening select tag as below:
<select class="form-control data" data-t="integer" name='role' required>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select><select class="form-control data" data-t="integer" name='role' required>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select><select class="form-control data" data-t="integer" name='role' required>
<option value="">--Select--</option>
<?php
foreach($con -> query("select id,name,permissions from role") as $role)
?>
<option value="<?php echo $role['id']; ?>"><?php echo $role['name']; ?></option>
<?php
?>
</select>answered Nov 11 at 9:22
Khalifa Nikzad
68811
answered Nov 11 at 9:22
Khalifa Nikzad
68811
answered Nov 11 at 9:22
Khalifa Nikzad
68811
answered Nov 11 at 9:22
Khalifa Nikzad
68811
68811
oh snap! XD what the... XD sorry that was such an embarrassing mistake :D Btw... why did it work in the first place, i mean i used the same select (closed in the opening tag itself) on another page (not accessed by an ajax call). I just copied this dropdown from there.... it was working as required on that page, even with this error...
– akshay sharma
Nov 11 at 9:32
add a comment |
oh snap! XD what the... XD sorry that was such an embarrassing mistake :D Btw... why did it work in the first place, i mean i used the same select (closed in the opening tag itself) on another page (not accessed by an ajax call). I just copied this dropdown from there.... it was working as required on that page, even with this error...
– akshay sharma
Nov 11 at 9:32
oh snap! XD what the... XD sorry that was such an embarrassing mistake :D Btw... why did it work in the first place, i mean i used the same select (closed in the opening tag itself) on another page (not accessed by an ajax call). I just copied this dropdown from there.... it was working as required on that page, even with this error...
– akshay sharma
Nov 11 at 9:32
oh snap! XD what the... XD sorry that was such an embarrassing mistake :D Btw... why did it work in the first place, i mean i used the same select (closed in the opening tag itself) on another page (not accessed by an ajax call). I just copied this dropdown from there.... it was working as required on that page, even with this error...
– akshay sharma
Nov 11 at 9:32
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53247276%2fsql-queries-on-ajax-php-page%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
