StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCan't use if statement to check for POST data.
primarykey
Id
15462265
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2013-03-17T15:04:51.070
FavoriteCount
0
LastActivityDate
2013-03-17T16:38:14.177
LastEditDate
2013-03-17T15:22:45.260
LastEditorUserId
1873508
OwnerUserId
1873508
ParentId
0
PostTypeId
1
Score
0
ViewCount
223
LastEditorDisplayName
text
Body
I am using ajax call to grab some data from my mysql database. This is my ajax call: <pre><code> $.ajax({ type: "POST", url: "fetch.php", data: id, success: function(msg) { var record = JSON.parse(msg); $("#name").val(record.name); $("#description").val(record.description); switch(record.category) { case ("Residential"): $("#category").val("residential"); break; case ("Modernisation & Domestic Extensions"): $("#category").val("modernisation"); break; case ("Feasibility Layouts"): $("#category").val("feasibility"); break; case ("Master Planning"): $("category").val("master"); break; default: $("category").val(""); }; switch(record.featured) { case ("y"): $("#featured").val("y"); break; default: $("featured").val("n"); }; } }) </code></pre> and this is my php file: <pre><code> <?php $dbc = mysqli_connect('XX','XX','XX','XX'); $id = $_POST['id']; if($dbc) { $row = fetchDataFromRecordWithId($dbc,$id); } else { echo 'Database error'; } function fetchDataFromRecordWithId($dbc,$id) { $q = "SELECT * FROM Projects WHERE id = ".$id; $r = mysqli_query($dbc, $q); $row = mysqli_fetch_array($r, MYSQLI_ASSOC); mysqli_close($dbc); return $row; } echo json_encode($row); ?> </code></pre> Everything work flawless but soon when I try to add if statement in my php file to check if there is any POST data than my ajax call is not getting any response. I tried different methods : <pre><code> <?php if(isset($_POST)) { .. my whole php code here .. } ?> <?php if(!empty($_POST)) { ..my whole php code here .. } ?> <?php if($_POST) { .. my whole php code here .. } ?> <?php if($_POST['id']) { .. my whole php code here .. } ?> </code></pre> but nothing work! Ajax call is not getting json data back when I will use any of these if statements listed above. I could not check for POST data and leave it like it is but I want to do is in proper way. It seems like if statement is not executed (but POST data must be there as I am able to fetch <code>$_POST['id']</code> value when if statement not used). I also tried to put <code>echo json_encode($row)</code> outside if statement but it didn't help either. Any ideas what is wrong?
Tags
<php><javascript><jquery><ajax><json>
Title
Can't use if statement to check for POST data.
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USGuferos
UserOwnerUserId
1. USGuferos
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.