Jump to content

funbinod

Members
  • Content count

    465
  • Joined

  • Last visited

Community Reputation

3 Neutral

About funbinod

  • Rank
    Member
  • Birthday 05/12/1983

Contact Methods

  • Yahoo
    funbinod
  • Skype
    binod.anuj

Profile Information

  • Location
    Nepal

Previous Fields

  • Languages
    HTML, PHP, JAVASCRIPT
  1. using curl

    <!-- first of all completely sorry if this is not the right forum to ask this. but i've no idea which is the right forum for this ---> hello all! i was learning how to use back4app parse on my website. while going through documentation on parseplatform.org, i found a sample block as below.. curl -X POST \ -H "X-Parse-Application-Id: APPLICATION_ID" \ -H "X-Parse-REST-API-Key: ${REST_API_KEY}" \ -H "X-Parse-Revocable-Session: 1" \ -H "Content-Type: application/json" \ -d '{"username":"cooldude6","password":"p_n7!-e8","phone":"415-392-0202"}' \ https://parseapi.back4app.com/parse/users but i could not understand how to implement this on my php code. this might be because i am completely unfamiliar to curl. UPDATE: while searching the web for more about uses of curl, i found something else that doesn't match the above format given by parseplatform.org. this blew my head more. please someone help me understand all these things.
  2. file exist error

    hello all! i'm new to java and android studio. i was trying to check and create new file and do something in it. if (!file1.exists()) { try { file1.createNewFile(); Toast.makeText(StartActivity.this, "key file created!" + directory, Toast.LENGTH_LONG).show(); Intent intent = new Intent(StartActivity.this, KeyActivity.class); startActivity(intent); StartActivity.this.finish(); } catch (IOException e) { e.printStackTrace(); Toast.makeText(StartActivity.this, "key file creation failed!" + directory + "--" + e, Toast.LENGTH_LONG).show(); } } else { StringBuilder keyData = new StringBuilder(""); try { FileInputStream kfile = openFileInput(keyfile); InputStreamReader kSr = new InputStreamReader(kfile); BufferedReader bufferedReader1 = new BufferedReader((kSr)); String readKey = bufferedReader1.readLine(); if (readKey != null) { keyData.append(readKey); final String key = keyData.toString(); Toast.makeText(StartActivity.this, "found login id and key on " + directory + "! Checking the credentials!", Toast.LENGTH_LONG).show(); new AsyncLogin1().execute(loginId, key); } else { Intent intent = new Intent(StartActivity.this, KeyActivity.class); intent.putExtra("loginID", loginId); startActivity(intent); StartActivity.this.finish(); } kSr.close(); } catch (IOException ioe1) { ioe1.printStackTrace(); Toast.makeText(StartActivity.this, "error: " + ioe1, Toast.LENGTH_LONG).show(); // this is the part that is displayed as error } i tried all these and got unexpected error! while running this, it goes inside the file existence block and returns the IOException error saying "No such file or directory". Please someone guide me where i made mistake. EDIT: this is the file path: File thisdirectory = this.getFilesDir(); File directory = new File(thisdirectory + "/online/is_cool_staffs/"); if (!directory.exists()) { directory.mkdirs(); } File file1 = new File(directory + keyfile); thank you in advance...
  3. /////////// this is a part of the second query ///////////// SELECT SUM(debit) debit, SUM(credit) credit FROM ( SELECT NULL ob, SUM(debit) debit, SUM(credit) credit FROM journal WHERE aid='$aid' AND cid='$cid' AND ay='$ay' UNION SELECT NULL ob, SUM(fee) debit, NULL credit FROM invoice WHERE stuid='$aid' AND cid='$cid' AND ay='$ay' UNION ............. ............. ............. ) as balance /////////// in this second query i use $aid from the previous one... yes.the second query searches data from multiple tables and calculate them according to the data derived from first prepared statement.
  4. hello all! i was trying to run another query inside a while loop of a prepared statement. $qs = $_POST['queryString']."%"; $ledq = $mysqli->prepare("SELECT name, fullid aid, ob FROM account WHERE cid='$cid' AND name LIKE ? AND ac_id IN ('$q') ORDER BY name LIMIT 20"); if (!$ledq) { echo "Error: " . $mysqli->error; } else { $ledq->bind_param('s', $qs); $ledq->execute(); $ledq->bind_result($name, $aid, $ob); $ledq->store_result(); while ($ledq->fetch()) { $balq = $mysqli->query("SELECT SUM(debit) debit, SUM(credit) credit FROM .................."); ............... ............... ............... } $ledq->free_result(); $mysqli->close(); } when i use free result outside the while loop it gives out of sync error. if i use free result inside the while loop and before the next query, it returns only one row. i also tried more_result before executing the next query. but it only worked while testing locally. when i upload it to my server and try, it gives nothing. please someone guide me what is the best solution! thank you in advance..
  5. getting max value in php

    great! i got the point and this solved my problem. thank you.
  6. getting max value in php

    ........... ........... for ($i = 0; $i < $highmq->num_rows; $i++) { .......... .......... .......... $highmarks[] = ($highmarkth + $highmarkpr); } $highmark = implode(',', $highmarks); echo max($highmark); here!
  7. getting max value in php

    thank you @justsomeguy for the reply. your reply helped me to understand some new things. it is fruitful. i want to explain some more about my mysql columns. in the table marksheet, i insert data to only one column at one time. this means in each row, if it has data on marktheory then markpractical is surely empty. and if markpractical has some data in it, then marktheory is surely blank. so now do you think it would be ok if i set $highmarkth and $highmarkpr outside the if statements and set $higmark as an array outside the for loop? and thank you too @Ingolme . your suggested code guided me very nicely. it gave the data with commas in it. but one problem more occurred. when i use max() function, it says it is not an array (Warning: max(): When only one parameter is given, it must be an array in J:\xampp\htdocs\is-cool\test.php on line 23). and i used just mysqli->query in stead of prepared statement because it is executed internally. it has no user submitted data. wouldn't it be ok?
  8. getting max value in php

    they are varchar field and contain 3 types of data on them. the datas are saperated by a hash (#) key. for example "ET001#10#74.5". From this i explode the value and get the last offset for calculation thank you
  9. getting max value in php

    the all i did is the same what i've kept in my question above. i'm putting the code again here. from the query i get values from columns "marktheory" and "markpractical", then calculate them and try to get highest value. in the mentioned code, i expect the values to be in array in "$highmark". when i echo it, i get the value altogether without commas (as i explained above). $cid = 2; $subid = 10; $clas = 'PG'; $highmq = $mysqli->query("SELECT marktheory, markpractical FROM marksheet WHERE studentid IN (SELECT fullid FROM students WHERE class='$clas' AND cid='$cid') AND (marktheory LIKE '%#$subid#%' OR markpractical LIKE '%#$subid#%') AND cid='$cid'"); $highmarkth = array(); for ($i = 0; $i < $highmq->num_rows; $i++) { $rows = $highmq->fetch_assoc(); if ($rows['marktheory'] != "") { $highmarkth = explode("#", $rows['marktheory'])[2]; $highmarkpr = 0; } if ($rows['markpractical'] != "") { $highmarkpr = explode("#", $rows['markpractical'])[2]; $highmarkth = 0; } $highmark = ($highmarkth + $highmarkpr); echo max($highmark); /////////// gives error as the $highmark is not an array echo $highmark //////////////// gives "7474.776.89578.3" /////// i wish this to b as "74,74.7,76.8,95,78.3" } thank you.
  10. getting max value in php

    thank u @Ingolme for the reply! the exactly is my problem. the result i want is derived as string not as an array. as i mentioned above the result i got "7474.776.89578.3" contains FIVE values "74, 74.7, 76.8, 95, 78.3". i wish them as array. and then, i think, the "max()" function will do the rest.
  11. getting max value in php

    hello all! i was trying to get max value from a mysql query derived values but i could not succeed. please guide what i made mistake. below is the code i tried. in this after fetching data from mysql table, i made some calculations and derived data like this ////////////////// 7474.776.89578.3 ////////////////////////// which actually contains 5 values ( 74,74.7,76.8,95,78.3 ) what i want is to select the number 95. what is the proper method? thank u in advance. $cid = 2; $subid = 10; $clas = 'PG'; $highmq = $mysqli->query("SELECT marktheory, markpractical FROM marksheet WHERE studentid IN (SELECT fullid FROM students WHERE class='$clas' AND cid='$cid') AND (marktheory LIKE '%#$subid#%' OR markpractical LIKE '%#$subid#%') AND cid='$cid'"); $highmarkth = array(); for ($i = 0; $i < $highmq->num_rows; $i++) { $rows = $highmq->fetch_assoc(); if ($rows['marktheory'] != "") { $highmarkth = explode("#", $rows['marktheory'])[2]; $highmarkpr = 0; } if ($rows['markpractical'] != "") { $highmarkpr = explode("#", $rows['markpractical'])[2]; $highmarkth = 0; } $highmark = ($highmarkth + $highmarkpr); echo max($highmark); }
  12. not getting $stmt->error message

    ok! i solved this like this if ($sec == 'ALL') { $stmt = $mysqli->prepare("SELECT CONCAT(fname, ' ', lname) AS name, fullid, roll, section FROM students WHERE class=? AND ay='$ay' AND cid='$cid'"); $stmt->bind_param('s', $clas); } else { $stmt = $mysqli->prepare("SELECT CONCAT(fname, ' ', lname) AS name, fullid, roll, section FROM students WHERE class=? AND section=? AND ay='$ay' AND cid='$cid'"); $stmt->bind_param('ss', $clas, $sec); } thank u for being with me and giving some hint! is there any other good idea to do this?
  13. not getting $stmt->error message

    @Ingolme thank u for the reply! i appreciate your suggestion. but my requirement is something different. i have multiple cases for passing variables to the prepared statement. value for $wh and $param differ if the case is different. like - in the above example the value of $wh and $param are set when $sec has different value. but if $sec is not set differently then $wh and $param will have only one parameter. if ($sec == 'ALL') { $wh = 'class=?'; $param = "'s', $clas"; } else { $wh = "class=? AND section=?"; $param = "'ss', $clas, $sec"; } how can i solve this issue then?
  14. not getting $stmt->error message

    hello all! greetings! i'm trying to fetch data from a prepared statement and using some variables to pass the query $wh = "class=? AND section=?"; $param = "'ss', $clas, $sec"; $stmt = $mysqli->prepare("SELECT CONCAT(fname, ' ', lname) AS name, fullid, roll FROM students WHERE $wh AND ay='$ay' AND cid='$cid'"); if (!$stmt->bind_param($param)) { echo "Bind Error: " . $stmt->error; } ?> this is showing error but only "Bind Error:" not the "$stmt->error". i tried to echo $wh and $param value also and they give the same value as i intend. why this is happening? please guide. thanks in advance.
  15. hello all! i am trying to change texts on a div multiple times using jquery. for this i tried the following $('#clickme').on('click', function(e) { $('#msg').text('hello'); $('#msg').delay(500).text('First Change!'); $('#msg').delay(500).text('Second Change!'); }) but this olny displays directly the last option (i.e. 'Second Change!') and none of other. i wish them to change one by one with some delay. please guide me how can i achieve this. thank u in advance...
×