StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POposting from java to php and inserting it into mysql database
primarykey
Id
16098293
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2013-04-19T06:07:40.827
FavoriteCount
0
LastActivityDate
2013-04-19T07:10:12.907
LastEditDate
2013-04-19T07:10:12.907
LastEditorUserId
2254780
OwnerUserId
2254780
ParentId
0
PostTypeId
1
Score
1
ViewCount
1183
LastEditorDisplayName
text
Body
I write a simple post from java to my php backend. After I run the script I am getting the output that I am passing in filename, filesize etc.. <pre><code>int filesize=25; String filetype=".txt"; String hash="sdfjksdfhljahe8wr897348957jsdfajlsdhfl48"; String email="sangwan.ritesh@yahoo.in"; String filename="songs.txt"; String urlParameters = "filename="+filename+"&filesize="+filesize+"&filetype="+filetype+"&filehash="+hash+"&email="+email; URL url = new URL("myurl"); HttpURLConnection hp=(HttpURLConnection)url.openConnection(); hp.setDoInput(true); hp.setDoOutput(true); hp.setInstanceFollowRedirects(false); hp.setRequestMethod("POST"); hp.setRequestProperty("Content-Type", "application/x-www-form-urlencoded"); hp.setRequestProperty("charset", "utf-8"); hp.setRequestProperty("Content-Length", "" + Integer.toString(urlParameters.getBytes().length)); hp.setUseCaches (false); DataOutputStream wr = new DataOutputStream(hp.getOutputStream ()); wr.writeBytes(urlParameters); wr.flush(); String line; BufferedReader reader = new BufferedReader(new InputStreamReader(hp.getInputStream())); line = reader.readLine(); System.out.println(line); wr.close(); reader.close(); hp.disconnect(); </code></pre> The problem is I want to insert these values into my mysql database running on server so I write the following php code. <pre><code><?php include('dbc.php'); $filename=$_POST['filename']; $filesize=$_POST['filesize']; $filetype=$_POST['filetype']; echo $POST['email']; $filehash=$_POST['filehash']; $email=$_POST['email']; $query = "INSERT INTO files ( `email`, `file_name`, `file_ext`, `file_size`, 'file_hash') VALUES ( '$email', '$filename', '$filetype', '12584', 'filehash')"; $result=mysqli_query($dbc,$query); if(mysqli_affected_rows($dbc) == 1) { // DO Nothing } echo $_POST['filehash']; echo $_POST['email']; echo $_POST['filename']; echo $_POST['filesize']; echo $_POST['filetype']; ?> </code></pre> The data is being is posted and I am getting the same back in my java application but data is not being entered in mysql database. I have a table name files with the same columns described above. I tried to get error from mysql_error but I am not getting any error. UPDATE: Problem solved silly sql syntax mistake using ' instead of ` near file_hash
Tags
<java><php><mysql>
Title
posting from java to php and inserting it into mysql database
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USRitesh Sangwan
UserOwnerUserId
1. USRitesh Sangwan
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
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.