DaniWeb Forum Index > Web Development > PHP

Translate attempt

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2007

Posts: 34

Reputation: chicago1985 is an unknown quantity at this point

Solved Threads: 0

chicago1985 chicago1985 is offline

Offline

Light Poster

Translate attempt

Jun 29th, 2008

I am trying to translate the PHP script into Java. If anything please advise what or how this translates?

PHP:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
if(isset($_GET['getClientId'])){  
  $res = mysql_query("select * from tableOne where clientID='".$_GET['getClientId']."'") or die(mysql_error());
  if($inf = mysql_fetch_array($res)
 
...
if(isset($_GET['getClientId'])){  
  $res = mysql_query("select * from tableOne where clientID='".$_GET['getClientId']."'") or die(mysql_error());
  if($inf = mysql_fetch_array($res)

...

My attempt in Java and it is giving me errors with getClientId part and lost in fetching array part.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
//db connection part here...
 
try {
String res = "";
if(getParameter("getClientId")) {
   res = stmt.executeQuery("select * from tableOne where clientID='" + getParameter("getClientId") + "');
 
String $inf []; 
if($inf.equals(getParameterValues($res)) {
 
....
 
//db connection part here...

try {
String res = "";
if(getParameter("getClientId")) {
   res = stmt.executeQuery("select * from tableOne where clientID='" + getParameter("getClientId") + "');
  
String $inf []; 
if($inf.equals(getParameterValues($res)) {

....

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Re: Translate attempt

Jun 29th, 2008

are you wanting us to translate it into java for you or just explain what the php is doing so you can make it into java.

Last edited by kkeith29; Jun 29th, 2008 at 5:23 pm.

•

Join Date: Nov 2007

Posts: 34

Reputation: chicago1985 is an unknown quantity at this point

Solved Threads: 0

chicago1985 chicago1985 is offline

Offline

Light Poster

Re: Translate attempt

Jun 29th, 2008

•

Originally Posted by kkeith29

are you wanting us to translate it into java for you or just explain what the php is doing so you can make it into java.

I tried translating it to Java and its not working. I am trying (in Java) to take the results and return it as an array, where each field of the row is in an array key.

Please correct my translation attempt in Java if possible.