Hi guys. I'm trying to perform a post method action in my php and the site that I post to returns "This site require javascript to be enabled". Now the problem is that this is a backend php script that is sending this post method. The site is http://mlungisi.0fees.us

How can I solve this?

How can I use google sheets to use a web calculator.
Enter Amount, Term, & Interest Rate & return the 2 resulting values given by the calculator into the google sheet

FORM: 'application.php'
ELEMENT:  a listbox named: 'lstgroup'

when the user select a item, the value (group_id)  is needed in sql WHERE clausule  (application.php)
variable 'group_id' is send with AJAX to application.php

-Function postgroupid() works fine
-$AJAX works fine
-Call php function sendgroupid() works fine

But the $_POST['group_id'] is empty and echo returns :"Hello php! But no group_id"
I spend a week to find a solution with all kind of suggestions from internet, but nothing helps me
Here is my code:

<script type="text/javascript">

   function postgroupid() {
   
    var x = document.getElementById("lstgroup").selectedIndex;
    var y = document.getElementById("lstgroup").options;
    var group_id = y[x].value;
    document.getElementById("edtgroupid").value=group_id;
       $.ajax({
                    type: "POST",
                    url : 'application.php';
                    data: { 'group_id' : group_id }
                   }).done(function(response){alert('succes');
                  }).fail(function(jqXHR, textStatus, errorThrown){
  alert('FAILED! ERROR: ' + errorThrown);
});
 
var result="<?php sendgroupid();?>";
alert(result);
return false;
  }
 
</script>

Select all Open in new window

<?php
function sendgroupid()
{
if (isset($_POST['group_id']) && !empty($_POST['group_id'])) {
    echo $_POST['group_id'];
  }
   else
   {
   echo 'Hello php! But no group_id';
   }
}
?>

Select all Open in new window

PHP number format.  A college of mine installed a wholesale plugin on a WooCommerce Site.  This brilliant Plugin over wrote all sales prices in the DB.  If the sale price had no decimal point it got rid of the decimal point.  If the decimal point had two decimal points, it added 2 more zeros onto the sales price.  WooCommerce wants all prices to have two decimal points so show properly.

I am writing a piece of code for my functions.php file to update all sales prices in the DB and make sure they have 2 decimal points.

I have 2 questions;
1. This will out put a number with 2 decimal points, even if there are no decimal points on the number, correct?
$meta_value = number_format( $result->meta_value, 2 );
2. Can you see anything wron with the following code?

</php
global $wpdb;
$postmeta = $wpdb->prefix . "postmeta";
$posts = $wpdb->prefix . "posts";

// 1. First query: Get all prices
$results = $wpdb->get_results( "
    SELECT $postmeta.*
    FROM $postmeta
    INNER JOIN $posts ON $postmeta.post_id = $posts.ID
    WHERE $posts.post_type ='product'
    AND $postmeta.meta_key ='_sale_price'
    AND $postmeta.meta_value != ''
    ORDER BY $postmeta.meta_id ASC
" );

// iterating through each price and update it
foreach($results as $result){
    $meta_id    = $result->meta_id;
    $post_id    = $result->post_id;
    $meta_key   = $result->meta_key;
    $meta_value = number_format( $result->meta_value, 2 );

    // 2. Udating prices query
    $wpdb->query( 

Select all Open in new window

…

I have been struggling with the following code for some time. I get the following eror: {"error":"invalid_request","error_description":"invalid grant type"}.

Some more documentation on the API that I am working on is available here:

<?php

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => "https://id.shoeboxed.com/oauth/token",
   CURLOPT_RETURNTRANSFER => true,
  CURLOPT_SSL_VERIFYPEER => false, 
  CURLOPT_POST => 1,  
  CURLOPT_POSTFIELDS => "{\"code\": \"['code']\",\"grant_type\":\"authorization_code\",\"redirect_uri\": \"http://website.com/foursquare2.php\",\"client_id\": \"f8de67be8dc84e449203fcdd4XXXXXXX\",\"client_secret\": \"HS5ZeIVsKW0/qqiO9/XcdeWqnF8vtzQrpY8gcdrxg0BXNZXXXXXXX\"}",
  CURLOPT_HTTPHEADER => array(
    "application/x-www-form-urlencoded" 
  )
));


/*
//Another Attempt at it is below
curl -d code=['code'] \
    -d grant_type=authorization_code \
    --data-urlencode redirect_uri='http://website.com/foursquare2.php' \
    -u f8de67be8dc84e449203fcdd44abad5a:HS5ZXXXXXXX/qqiO9/XcdeWqnF8vtzQrpY8gcdrxg0BXNXXXXXXX \
    -XPOST https://id.shoeboxed.com/oauth/token 
*/


$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

?>

Select all Open in new window

Problem installing phpMyAdmin

I am trying to build a LAMP stack for a test server and I am getting these errors

Installed:
  yum-plugin-priorities.noarch 0:1.1.31-42.el7

Complete!
[root@ip-172-31-13-158 httpd]# nano /etc/yum.repos.d/remi.repo
[root@ip-172-31-13-158 httpd]# rpm -iUvh http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
Retrieving http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
curl: (22) The requested URL returned error: 404 Not Found
error: skipping http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm - transfer failed
[root@ip-172-31-13-158 httpd]# yum -y update
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
 * base: mirror.cs.pitt.edu
 * epel: mirror.beyondhosting.net
 * extras: mirror.vtti.vt.edu
 * remi-safe: repo1.ash.innoscale.net
 * updates: mirrors.lga7.us.voxel.net
No packages marked for update
[root@ip-172-31-13-158 httpd]# yum -y install phpmyadmin
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
 * base: mirror.cs.pitt.edu
 * epel: mirror.beyondhosting.net
 * extras: mirror.vtti.vt.edu
 * remi-safe: repo1.ash.innoscale.net
 * updates: mirrors.lga7.us.voxel.net
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.4.15.10-2.el7 will be installed
--> Processing Dependency: php-gd >= 5.3.7 for package: phpMyAdmin-4.4.15.10-2.el7.noarch…

I've got a script that I've been asked to alter by initiating a command line dynamic so as to avoid a situation where things are otherwise timing out.

What's happening is that the user will click a button that's grabbing a series of files and converting them to pdf documents. At the end of the script, it then takes the directory that has all of these new files and zips it up and makes it available to the user as a downloadable entity. It works great right up until the point where you're having to process 600+ docs, now you're looking at 20 minutes plus and it's a mess.

At the risk of providing too much info, here's the "machine" as it exists right now.

User clicks the button and you get "  function init_genPSM($empID_sel=NULL,$hID_sel=NULL,$item_sel=NULL,$cpID_sel=NULL, $orderID=NULL, $quantity=500) {"

That's the method that initiates the merry go round. Here it is in its entirety:

function init_genPSM($empID_sel=NULL,$hID_sel=NULL,$item_sel=NULL,$cpID_sel=NULL, $orderID=NULL, $quantity=500) {
        global $S;
        global $A;
        $R = new xajaxResponse();
        $R->appendResponse(Application::InitializeClass());


        if (strpos($item_sel, 'prime') !== false) {
            //ini_set('max_execution_time', $quantity > 120 ? $quantity : 120);
			//I set the max_execution_time to 500 to accommodate larger files that were showing up as empty zip files because of the system timing out (Bruce Gust 4/20/2018)
			ini_set('max_execution_time', 

Select all Open in new window

…

how to dynamically select columns in stored procedure

//There are six variables

• var_order -> toggle between first name and last name first. The columns are generated from php
• var_limit  -> limit on sql query
• var_user -> user id
• var_status -> "active"
• var_activity -> activity id
• var_team ->  team id

//var_order is either passed as a string for either p.first_name," ", p.last_name or p.last_name, ", ", p.first_name

DELIMITER $$

CREATE PROCEDURE brings_schedule( IN var_order VARCHAR(255), IN var_limit INT, IN var_user INT, IN var_status VARCHAR(1), IN var_activity INT, IN var_team INT )

BEGIN
	    
	SELECT 
		s.id, s.item, s.description, 
		CONCAT(var_order) AS user, p.id AS userId, p.unique_name,
		r.teamId, 
		q.uniqueName
	FROM brings AS s
	JOIN users AS p ON p.id = s.userId AND p.status != var_user
	JOIN `teams-roster` AS r ON r.teamId = var_team AND r.userId = var_user AND r.status = var_status
	JOIN teams AS q ON q.id = r.teamId
	WHERE s.status = var_startus AND s.teamId = var_team AND s.activityId = var_activity
	GROUP BY s.id
	ORDER by p.first_name
    LIMIT var_limit;

END;

$$

DELIMITER ;

Select all Open in new window

i have A PHP Error was encountered
Severity: Warning

Message: mysqli_query() expects at least 2 parameters, 1 given

Filename: models/m_peminjaman.php

Line Number: 7 and 8

This Scipt:
class M_Peminjaman extends CI_Model{
    private $table="transaksi";
   
    function nootomatis(){
        $today=date('Ymd');
        $query=mysqli_query("select max(id_transaksi) from transaksi where id_transaksi like '$today%'");
        $data=mysqli_fetch_array($query);
        $lastNoFaktur=$data['last'];
       
        $lastNoUrut=substr($lastNoFaktur,8,3);
       
        $nextNoUrut=$lastNoUrut+1;
       
        $nextNoTransaksi=$today.sprintf('%03s',$nextNoUrut);
       
        return $nextNoTransaksi;
    }

I have a PHP script, signup.php inside this directory: /var/www/html/signup.php
Inside this signup.php file, I have the below lines of code to copy file between sub-directories:

$avatar = "images/avatardefault.png";
        $avatar2 = "var/www/html/user/avatardefault.png";
        if (!copy($avatar, $avatar2)) {
            echo "failed to create avatar.";
        }

Select all Open in new window

But when I run this script, I get an error:

PHP Warning:  copy(var/www/html/user/avatardefault.png): failed to open stream: No such file or directory in /var/www/html/signup.php

Select all Open in new window

Please what could be my mistake?

jQuery loop. I wordpress I have a section that I add logos to.  At anytime there can be any number of logos.  Sometimes more, sometimes less.  I have them fading in and it is all hard coded.  I want to make a loop to cut down on the amount of code and also be more efficient with my coding.  Depending upon how many logos there are, my php loop on the front end makes a number  addition to the ID.  So id="customer1" id="customer2", id="customer3', etc...

My jQuery is the following and I would like to turn it into an intuitive loop.  Any suggestions?

<script>
$('#customer1').addClass('visible');
            setTimeout(function () {
                $('#customer2').addClass('visible');
            }, 100);
            setTimeout(function () {
                $('#customer3').addClass('visible');
            }, 200);
            setTimeout(function () {
                $('#customer4').addClass('visible');
            }, 300);
            setTimeout(function () {
                $('#customer5').addClass('visible');
            }, 400);
            setTimeout(function () {
                $('#customer6').addClass('visible');
            }, 600);
etc.....

Select all Open in new window

In symfony 4 i have a form to manage user details.

There is a one-to-many relationship between User class and SecurityGroup class.

In my form i would like to have all SecurityGroup listed with checkboxes.
I've managed to do it, but if i check a checkbox the group is not added to the user after the handle request. (In the request dump i see my 2 checked groups)

Form Field:

->add('SecurityGroups', EntityType::class, [
                'class'     => 'App\Entity\SecurityGroup',
                'choice_label' => 'displayname',
                'query_builder' => function (SecurityGroupRepository $repo) {
                    return $repo->createQueryBuilder('f')
                        ->where('f.id > :id')
                        ->setParameter('id', 1);
                },
                'label'     => 'Member Of?',
                'expanded'  => true,
                'multiple'  => true,
            ])

Select all Open in new window

Controller

public function edit(Request $request, $id)
    {

        $user = new User();

        if ($id == -1) {
            $module_title = 'Create a new User';
        }
        else
        {
            $module_title = 'Edit User';
            $user = $this->getDoctrine()->getRepository("App:User")->find($id);
        }

        $form = $this->createForm("App\Form\UserType", $user);


        $form->handleRequest($request);

        $current_user = $this->getUser();
        dump($request);
        dump($form);

        if ($form->isSubmitted() && $form->isValid())
        {

            $user = $form->getData();
            dump($user);
            
            $em = $this->getDoctrine()->getManager();
            $em->persist($user);
            $em->flush();
            $this->redirectToRoute('admin_user');
        }



        return $this->render('user/edit.html.twig', ['edit_form' => $form->createView(), 'module_title' => $module_title]);
    }

Select all Open in new window

Dumps

Request {#86 ▼
  +attributes: ParameterBag {#70 ▶}
  +request: ParameterBag {#69 ▼
    #parameters: array:1 [▼
      "user" => array:8 [▼
        "username" => "admin"
        "email" => "email@email.email"
        "password" => ""
        "isActive" => "1"
        "DisplayName" => "admin"
        "SecurityGroups" => array:2 [▼
          0 => "2"
          1 => "4"
        ]
        "save" => ""
        "_token" => "YaqXjd73ZhrX8p1eOiFWZi1JWivaCLKMGZbulTsiRgE"
      ]
    ]
  }

Select all Open in new window

Below is the code  from @Leonidas Dosas which will display google map with a SelectBox. The select box contains few countries. When user select a country from a dropbox then a map will be changed according to that country.

My Requirement: Now I have a database and I have longitude and latitude values of around 50 countries in a table. I am finding a way to get a country name based on the longitude and latitude value stored in a database and display that country name in the selectbox. So that when user select a country then it works and it work previously.
I am using mysql database and PHP as a Language.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
      xmlns:v="urn:schemas-microsoft-com:vml">
  <head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
    <title>Google Maps JavaScript API Example: Geocoding Cache</title>

    <script src="http://maps.google.com/maps?file=api&amp;v=2.x&amp;key=AIzaSyDxexZDrPusqY36snWHfW7gBrzozeNWUYE"
      type="text/javascript"></script>
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.0/umd/popper.min.js" integrity="sha384-cs/chFZiN24E4KMATLdqdvsezGxaGsi4hLGOzlXwp5UZB1LY//20VyM2taTB4QvJ" 

Select all Open in new window

…