Yoel Rodriguez's questions

I have the following situation. I am uploading multiple files to the server but I need that once the file is on the server it shows me the name of the one that was uploaded and so on with the ones that follow. The process is being done through ajax and php . The files upload without problem but the message I receive is the last file and not while they are uploading. I leave the code to see if you can help me.

Thank you

HTML

<div id="myModalmultpl" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
    <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
        <h3 id="myModalLabel">Subir doctumento</h3>
    </div>
    <div class="modal-body">
        <?php echo for_open('#', array('class' => 'form-signin', 'id' =>'form-polizam')); ?>
        <div id="idsubiendo"></div>
        <input type="file" name="uploadfile[]" id="uploadfile[]" multiple />
        <input type="hidden" name="tipoupload" id="tipoupload" value="1" >
        <input type="button" name="submit" id="idsubmit" value="Subir">
        <?php echo for_close(); ?>
    </div>
    <div class="modal-footer">
        <button class="btn" data-dismiss="modal" aria-hidden="true">Cerrar</button>
    </div>
</div>

JavaScript

$("#idsubmit").on('click', function () {

 try {

  //obtenemos un array con los datos del archivo
  var dataString = new FormData($("#form-polizam")[0]);
  $.ajax({
   url: 'index.php?c=gpagar&f=setgdrive',
   type: 'POST',
   data: dataString,
   cache: false,
   contentType: false,
   processData: false,
   dataType: 'json',
   beforeSend: function () {
    $("div#idsubiendo").html('<div class="alert alert-success"><b>Subiendo ...</b></div>');
   },
   //una vez finalizado correctamente
   success: function (data) {
    console.log(data);
    bootbox.alert("<h6>El fichero ha sido subido al Google Drive: "+data.error+"</h6>");
   },
   //si ha ocurrido un error
   error: function (data) {
    console.log(data);
    $("div#idsubiendo").html('');
    bootbox.alert("A ocurrido un error por favor contacte con  el administrador");
   }
  });

 } catch (err) {
  bootbox.alert(err);
 }
});

php

   foreach($datos as $val){
     unset($_SESSION['idPol']);
     $nombre = $val['name'];
     $ext = pathinfo($nombre, PATHINFO_EXTENSION);
     $aNombre = explode("-",$nombre);
     $fecha = $aNombre[0]."-".$aNombre[1]."-".$aNombre[2];
     //Traemos el id del movimiento.
     $idmov = preg_replace('/[^0-9]+/','', $aNombre[4]);  
     $objMov = $gpa->get_movAutoId($idmov, $fecha);
     $_SESSION['idPol'] = $objMov->id;
     //Conformamos el nombre del fichro
     $nameFile = $gpa->set_namefile($objMov->id_mov);

     $path = "lib/gdriver/files/";
     $nom = $path.$nombre;
     $nom2 = $path.$nameFile.".".$ext;
     rename($nom, $nom2);
     //Extraemos el id de la empresa.
     $obj = $emp->get_empresaNomId($aNombre[3]);
     $fileid = $gpa->set_datagdrive($nameFile.".".$ext, $obj->id, $fecha);
     $jdata['error'] = $fileid;
     echo json_encode($jdata);
   }

I have the following situation, I was asked to make a project with an SQL database already created but I find that the names of the tables and the fields of the tables are written with spaces and when I try to execute my query it sends me a syntax error . This database is working with an application made in Visual Basic and I am making a web application with php. Here is my code:

Select Customer.AR Cust Password, Customer.AR Cust User Name FROM AR Customer AS Customer

Mistake:

19:04:05 Kernel error: [FreeTDS][MSSQL Server] , Server EC2AMAZ-977S99A\APPBSC, Line 1 Incorrect syntax near 'Password'.

I have the following situation:

I am attaching a pdf file , which is in google drive using phpmailer . What happens to me is that when I send the email with the attachment, when I download the file to the machine it tells me that it cannot be opened and if I try to open it from the Gmail client it opens it but not as a pdf document but rather as a document that can be edited.

When I try to open the pdf document with the pdf reader it gives me the following message:

The file type HTML document (text/html) is not allowed

The code I'm using to attach the file is as follows:

File reading:

    $path = "https://drive.google.com/open?id=18hMk_9TmC3dsCjwe0RQ1Ka-qaqs4uMcD"
    $fichero = file_get_contents($path);

phpmailer methods for attachment

$xmail->addStringAttachment($fichero,comprobante.pdf);

Thanks.

I have the following situation, I have in my google drive several directories that have the same name. These are located in another directory with a different name than this if it would be different.

Example:

1. EME/2019-04-APR
2. JBL/2019-04-APR

The root directories are EME and JBL and inside it I have the directory that is repeated to me 2019-04-ABR . The problem that is being presented to me is that when I want it to give me the id of the 2019-04-ABR directory that is inside EME , it gives me the JBL one . It asks me the following how I can obtain the id of the directory that is inside EME when I require it and vice versa. Here I leave the code to see if you can help me.

Thanks.

   $pageToken = null;
    do {

        $response = $driveService->files->listFiles(array(
            'q' => mimeType='application/vnd.google-apps.folder' and name contains '2019-04-ABR',
            'spaces' => 'drive',
            'pageToken' => $pageToken,
            'fields' => 'nextPageToken, files(id, name)',
        ));

        foreach ($response->files as $file) {
            $idFolder = $file->id;
        }

        $pageToken = $repsonse->pageToken;
    } while ($pageToken != null); 

I have the following situation: I have a table, where I keep the daily records of a water meter. While I was taking a daily reading and capturing it in the system, I had no problem since it reflected my daily consumption well. The problem occurs to me when I do more than one reading per day since they have the same registration date. When I make two captures of the meter reading, on the same day at different times, instead of obtaining the previous record (1), I go to the one with the previous date (2) . and needing the record of the example (1) to be able to calculate consumption during the day.

Ex:

1 -The previous record of the date of 03-26-2019:

2019-03-26 06:53:37 2019-03-26 339304.00 Mar 2.02

2 -The record that the SQL query returns:

2019-03-25 09:09:57 2019-03-25 339102.00 Mon 5.95

The capture of the reading can be done all the same day, so I cannot use the id , since the system operator can load the readings in a disorderly way.

(Ex: first you can load me the 2019-03-26 and then load the 2019-03-25.)

Then I leave the query and the screen where the error is appearing to see if you can help me.

Thanks.

Query to get the old record:

SELECT medidor_dias.* FROM (`medidor_dias`) WHERE `fecha_medida` <  '2019-03-26'   AND `id_tipo_medidor` = '4'  AND `medidor_dias`.`fecha_medida` >= '2019-02-26' AND `medidor_dias`.`fecha_medida` <= '2019-03-28'  ORDER BY `id_tipo_medidor` ASC, `fecha_medida` DESC , medidor_dias.hora_ejecutado DESC LIMIT 1

Image of the Error on 03-26-2019:

In the image you can see that the day: 03-26-2019 was captured twice, so it shows two records. In the second reading of that day it is the total accumulated of the two readings, with respect to the day 03-25-2019. The value that should go in the consumption of the second reading is 2.47 and not 4.49 , which is what it has. The formula that I am using for the calculation is the following (Last record - Previous record = consumption)

I have the following situation. I am trying to place an image from a C# script in Unity 3d, when reading a pattern with Vuforia . What is happening to me is that from the moment I create the public variable for the image, it tells me that it is ambiguous .

In that same scene I have a text that I insert from a database, inside a UI element type text and the image must be above that text. With the text I have no problem. The problem is appearing to me with the image. if I remove UnityEngine.UI the conflict with the image is removed but I can't use the text UI. Now if I remove Vuforia there if I don't have the conflict with the image but reading the pattern doesn't work for me. Below I leave the code to see if you can help me to be able to work with the two elements without sending me the ambiguous message .

Thanks.

Mistake:

error CS0104: Image' is an ambiguous reference between Vuforia.Image' and `UnityEngine.UI.Image'

Code

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

using Vuforia;
using UnityEngine.UI;

using Mono.Data.Sqlite;
using System.Data;
using System;
using System.IO;

public class reproduccionAudio : MonoBehaviour, ITrackableEventHandler


{

 private TrackableBehaviour mTrackableBehaviour;

    //public AudioClip otherClip;
    private AudioSource audio;
    private AudioSource[] allAudioSources;
    public Text textoLibro;
    private SqliteConnection dbconn;
    private SqliteCommand dbcmd;
    private SqliteDataReader reader;
    private string conn;
    private string namedb = "usuario.bytes";
    public int nParrafo;
    public Image imgEscena;

        void Start()
        {
            //Traemos el valor del GameObject y lo acipnamos el audioSouce
            audio = GetComponent<AudioSource>();

            imgEscena = GameObject.Find ("Escenas").GetComponents<Image> ();

            mTrackableBehaviour = GetComponent<TrackableBehaviour>();
            if (mTrackableBehaviour)
            {
                mTrackableBehaviour.RegisterTrackableEventHandler(this);
            }

        }

        public void OnTrackableStateChanged( TrackableBehaviour.Status previousStatus, TrackableBehaviour.Status newStatus){


        /*
        if(audio.isPlaying ){
            audio.Stop ();
        }*/ 

        if (newStatus == TrackableBehaviour.Status.DETECTED ||
                  newStatus == TrackableBehaviour.Status.TRACKED ||
                  newStatus == TrackableBehaviour.Status.EXTENDED_TRACKED) {

            allAudioSources = FindObjectsOfType (typeof(AudioSource)) as AudioSource[];
            foreach (AudioSource audioS in allAudioSources){
                audioS.Stop ();
            }
            textoLibro.text = "";

            if (!audio.isPlaying) {
                audio.Play ();
            } 

            //Colocamos el texto de la naración en pantalla.
            getOpenDb();

            string sqlQuery = "Select * From textoLibros WHERE nParrafo = "+ nParrafo +" AND idusuario = 0";
            dbcmd = dbconn.CreateCommand();
            dbcmd.CommandText = sqlQuery;
            reader = dbcmd.ExecuteReader ();
            while(reader.Read()){
                string names = reader.GetString (2);
                textoLibro.text = names;

                //Debug.Log (" Nombre"+ names);
            }

            imgEscena.sprite = Resources.Load<Sprite> ("escenas-RA/EscenaRa-01");

            getCloseDb ();

        } 
      }

    //
    //  Creamos la conexion con la bd SQlite
    //
    public void getOpenDb(){

        if (Application.platform != RuntimePlatform.Android) {

            conn = Application.dataPath + "/StreamingAssets/" + namedb;

            if(!File.Exists(conn)){
                File.Create (conn);
            }

        } else {

            conn = Application.persistentDataPath + "/" + namedb;

            if (!File.Exists(conn))
            {
                // if it doesn't ->
                // open StreamingAssets directory and load the db ->
                WWW loadDB = new WWW("jar:file://" + Application.dataPath + "!/assets/" + namedb);  // this is the path to your StreamingAssets in android
                while (!loadDB.isDone) { }  // CAREFUL here, for safety reasons you shouldn't let this while loop unattended, place a timer and error check
                // then save to Application.persistentDataPath
                File.WriteAllBytes(conn, loadDB.bytes);
            }
        }

        dbconn = new SqliteConnection ("URI=file:" + conn);
        dbconn.Open ();

    }

    //
    //Cerramos la conexión Sqlite
    //
    public void getCloseDb(){

        reader.Close ();
        reader = null;
        dbcmd.Dispose ();
        dbcmd = null;
        dbconn.Close ();
        dbconn = null;

    }

   }

I have the following situation, I have a table where I am managing data of people, which I am saving by month and by type of insurer. The amount of data I'm saving for each person in a month can range from 1 to n . I have to place this data in a graph, so I need it to look like this:

January, February, March...December

Performing subquery I get them but it takes me a long time, the operations to perform. I have placed the indexes in the search and sum fields and even so it is very slow for me, it can take up to 15 minutes. In the table I am handling around 15,000 records. Then I leave the query to see if you can help me.

Thanks.

    SELECT @var2 := tabla1.id_insured AS id_insured, @var1 := tabla1.pyear AS anio,
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '01') AS ene, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '02') AS feb, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '03') AS mar, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '04') AS abr, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '05') AS may, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '06') AS jun, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '07') AS jul, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '08') AS ago, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '09') AS sep, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '10') AS octb, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '11') AS nov, 
    (SELECT SUM(tabla1.commission) FROM tabla1 WHERE tabla1.id_insured = @var2 AND tabla1.pyear = @var1 AND tabla1.month = '12') AS dic 
    FROM tabla1 
    WHERE tabla1.pyear = '2018'
    GROUP BY tabla1.id_insured 

I am using the fedex api to generate a guide, from my web application. When running the example script from the browser or from the command line, it sends me the following message and does not generate the guide. The example I downloaded came with version 21 and I had to switch to version 23 in ->setMajor(23) . I'm doing the tests with the php version 7.2 .

Thanks.

Message sent to me:

object(FedEx\ShipService\ComplexType\ProcessShipmentReply)[34]
protected 'name' => string 'ProcessShipmentReply' (length=20)
protected 'values' =>

array (size=3)
  'HighestSeverity' => string 'ERROR' (length=5)
  'Notifications' => 
    array (size=1)
      0 => 
        object(FedEx\ShipService\ComplexType\Notification)[54]
          ...
  'Version' => 
    object(FedEx\ShipService\ComplexType\VersionId)[84]
      protected 'name' => string 'VersionId' (length=9)
      protected 'values' => 
        array (size=4)
          ...

My code:

use FedEx\ShipService;
use FedEx\ShipService\ComplexType;
use FedEx\ShipService\SimpleType;

$userCredential = new ComplexType\WebAuthenticationCredential();
$userCredential
    ->setKey(FEDEX_KEY)
    ->setPassword(FEDEX_PASSWORD);

$webAuthenticationDetail = new ComplexType\WebAuthenticationDetail();
$webAuthenticationDetail->setUserCredential($userCredential);

$clientDetail = new ComplexType\ClientDetail();
$clientDetail
    ->setAccountNumber(FEDEX_ACCOUNT_NUMBER)
    ->setMeterNumber(FEDEX_METER_NUMBER);

$version = new ComplexType\VersionId();
$version
    ->setMajor(23)
    ->setIntermediate(0)
    ->setMinor(0)
    ->setServiceId('ship');

$shipperAddress = new ComplexType\Address();
$shipperAddress
    ->setStreetLines(['Address Line 1'])
    ->setCity('Austin')
    ->setStateOrProvinceCode('TX')
    ->setPostalCode('73301')
    ->setCountryCode('US');

$shipperContact = new ComplexType\Contact();
$shipperContact
    ->setCompanyName('Company Name')
    ->setEMailAddress('[email protected]')
    ->setPersonName('Person Name')
    ->setPhoneNumber(('123-123-1234'));

$shipper = new ComplexType\Party();
$shipper
    ->setAccountNumber(FEDEX_ACCOUNT_NUMBER)
    ->setAddress($shipperAddress)
    ->setContact($shipperContact);

$recipientAddress = new ComplexType\Address();
$recipientAddress
    ->setStreetLines(['Address Line 1'])
    ->setCity('Herndon')
    ->setStateOrProvinceCode('VA')
    ->setPostalCode('20171')
    ->setCountryCode('US');

$recipientContact = new ComplexType\Contact();
$recipientContact
    ->setPersonName('Contact Name')
    ->setPhoneNumber('1234567890');

$recipient = new ComplexType\Party();
$recipient
    ->setAddress($recipientAddress)
    ->setContact($recipientContact);

$labelSpecification = new ComplexType\LabelSpecification();
$labelSpecification
    ->setLabelStockType(new SimpleType\LabelStockType(SimpleType\LabelStockType::_PAPER_7X4POINT75))
    ->setImageType(new SimpleType\ShippingDocumentImageType(SimpleType\ShippingDocumentImageType::_PDF))
    ->setLabelFormatType(new SimpleType\LabelFormatType(SimpleType\LabelFormatType::_COMMON2D));

$packageLineItem1 = new ComplexType\RequestedPackageLineItem();
$packageLineItem1
    ->setSequenceNumber(1)
    ->setItemDescription('Product description')
    ->setDimensions(new ComplexType\Dimensions(array(
        'Width' => 10,
        'Height' => 10,
        'Length' => 25,
        'Units' => SimpleType\LinearUnits::_IN
    )))
    ->setWeight(new ComplexType\Weight(array(
        'Value' => 2,
        'Units' => SimpleType\WeightUnits::_LB
    )));

$shippingChargesPayor = new ComplexType\Payor();
$shippingChargesPayor->setResponsibleParty($shipper);

$shippingChargesPayment = new ComplexType\Payment();
$shippingChargesPayment
    ->setPaymentType(SimpleType\PaymentType::_SENDER)
    ->setPayor($shippingChargesPayor);

$requestedShipment = new ComplexType\RequestedShipment();
$requestedShipment->setShipTimestamp(date('c'));
$requestedShipment->setDropoffType(new SimpleType\DropoffType(SimpleType\DropoffType::_REGULAR_PICKUP));
$requestedShipment->setServiceType(new SimpleType\ServiceType(SimpleType\ServiceType::_FEDEX_GROUND));
$requestedShipment->setPackagingType(new SimpleType\PackagingType(SimpleType\PackagingType::_YOUR_PACKAGING));
$requestedShipment->setShipper($shipper);
$requestedShipment->setRecipient($recipient);
$requestedShipment->setLabelSpecification($labelSpecification);
$requestedShipment->setRateRequestTypes(array(new SimpleType\RateRequestType(SimpleType\RateRequestType::_PREFERRED)));
$requestedShipment->setPackageCount(1);
$requestedShipment->setRequestedPackageLineItems([
    $packageLineItem1
]);
$requestedShipment->setShippingChargesPayment($shippingChargesPayment);

$processShipmentRequest = new ComplexType\ProcessShipmentRequest();
$processShipmentRequest->setWebAuthenticationDetail($webAuthenticationDetail);
$processShipmentRequest->setClientDetail($clientDetail);
$processShipmentRequest->setVersion($version);
$processShipmentRequest->setRequestedShipment($requestedShipment);

$shipService = new ShipService\Request();
$shipService->getSoapClient()->__setLocation('https://ws.fedex.com:443/web-services/ship');
$result = $shipService->getProcessShipmentReply($processShipmentRequest);

var_dump($result);
// Save .pdf label
// file_put_contents('/path/to/label.pdf', $result->CompletedShipmentDetail->CompletedPackageDetails[0]->Label->Parts[0]->Image);
var_dump($result->CompletedShipmentDetail->CompletedPackageDetails[0]->Label->Parts[0]->Image);

I have the following situation, using the Instascan javascript plugin . What is happening is that the reading of the image of the QR code is giving it to me inverted, which can be seen with the text below the QR. This is causing me to slow down the reading of the QR code. Here is my code to see if you can help me.

Note: I am doing the tests with an android 4.4.2 Lenovo tablet

Code:

      let scanner = new Instascan.Scanner({ video: document.getElementById('preview') });
  scanner.addListener('scan', function (content) {
    //console.log(content);
    window.location = "index.php?c=cajas&f=etiqueta&idqr="+content; 
  });
  idCam = 1;
  Instascan.Camera.getCameras().then(function (cameras) {
    if (cameras.length > 0) {
      var selectedCam = cameras[idCam];
      $.each(cameras, (i, c) => {
          if (c.name.indexOf('back') != -1) {
              selectedCam = c;
              return false;
          }
      });          
      scanner.start(cameras[idCam]);
    } else {
      console.error('No cameras found.');
    }
  }).catch(function (e) {
    console.error(e);
  });   

I have the following situation, I am creating an object within a for loop and then inserting it into an array . The object is conforming to me without problem, I have the detail at the time I insert the data in the array, since when inserting the last record it changes the previous ones and places the last one in all the items . Here is the code to see if you can help me.

Thanks.

My code:

    let arrayval = _data.valdatos.split("~");
    var datagrapharray = []; 
    var datagraphobj = new Object();
    for(i=0; i < arrayval.length; i++){
        linegrafph = arrayval[i].split("#");
        datagraphobj["label"] =  linegrafph[1];
        datagraphobj["backgroundColor"] = linegrafph[2];
        datagraphobj["borderColor"] = linegrafph[3];
        datagraphobj["borderWidth"] = 1;
        datagraphobj["data"] = linegrafph[0].split(",");
        console.log(datagraphobj);
        datagrapharray.push(datagraphobj);
    }   
    console.log(datagrapharray);

My objects:

{label: "Objeto1", backgroundColor: " rgba(255,0,0,0.2)", borderColor: " rgba(255,0,0,1)", borderWidth: 1, data: Array(12)}
{label: "Objeto2", backgroundColor: " rgba(0,64,128,0.2)", borderColor: " rgba(0,64,128,1)", borderWidth: 1, data: Array(12)}
{label: "Objeto3", backgroundColor: " rgba(0,0,0,0.2)", borderColor: " rgba(0,0,0,1)", borderWidth: 1, data: Array(12)}

My array:

0: {label: "Objeto3", backgroundColor: " rgba(0,0,0,0.2)", borderColor: " rgba(0,0,0,1)", borderWidth: 1, data: Array(12), …}
1: {label: "Objeto3", backgroundColor: " rgba(0,0,0,0.2)", borderColor: " rgba(0,0,0,1)", borderWidth: 1, data: Array(12), …}
2: {label: "Objeto3", backgroundColor: " rgba(0,0,0,0.2)", borderColor: " rgba(0,0,0,1)", borderWidth: 1, data: Array(12), …}

I have the following situation. I am using tabs to manage different contents within my web page, where there is a form in each one of them.

What is happening to me is that when I want to capture the form id of the active tab, it always takes the one of the first tab. I capture the id when performing an onChange event on an input file . Here is the code to see if you can help me.

Thanks.

Html from tab 1

<form class="form-signin" id="idfrom" method="post" action=""> 
      <label><strong>Subir Documentos (Solo JPG, JPGE, DOC, PDF XLS)</strong></label>
      <input type="file" name="uploadfile" id="uploadfile">
</form> 

html from tab 2

<form class="form-signin" id="fidcoment" method="post" action=""> 
      <label><strong>Subir Documentos (Solo JPG, JPGE, DOC, PDF XLS)</strong></label>
      <input type="file" name="uploadfile" id="uploadfile">
</form> 

JavaScript code

$(":file").change(function(){
    var idFormula =  $("form").attr('id');
});

The result of idFormula is always idfrom

I have the following situation, I am using the Google Driver API from my php to upload files from my system. What is happening to me is that it generates a permission error when executing the script when I go to upload the file. I verified my token and it tells me that it has not expired yet. Below I leave the error, the result of the token and the code that I am using to see if you can help me.

Thanks.

Token

{
  "issued_to": "569124525622-smkdbucj6bj8t87ptisvd2sdma3v747o.apps.googleusercontent.com",
  "audience": "569124525622-smkdbucj6bj8t87ptisvd2sdma3v747o.apps.googleusercontent.com",
  "scope": "https://www.googleapis.com/auth/drive.metadata.readonly",
  "expires_in": 1512,
  "access_type": "offline"
} 

error being generated

Fatal error: Uncaught exception 'Google_Service_Exception' with message ' in /opt/lampp/htdocs/gdriver/vendor/google/apiclient/src/Google/Http/REST.php on line 118

Google_Service_Exception: { "error": { "errors": [ { "domain": "global", "reason": "insufficientPermissions", "message": "Insufficient Permission" } ], "code": 403, "message" : "Insufficient Permission" } } in /opt/lampp/htdocs/gdriver/vendor/google/apiclient/src/Google/Http/REST.php on line 118

My code

require __DIR__ . '/vendor/autoload.php';
$client = getClient();
$service = new Google_Service_Drive($client);
$fileMetadata = new Google_Service_Drive_DriveFile(array(
    'name' => 'sql_query.jpg'));
$content = file_get_contents('files/sql_query.jpg');
$file = $service->files->create($fileMetadata, array(
    'data' => $content,
    'mimeType' => 'image/jpeg',
    'uploadType' => 'multipart',
    'fields' => 'id'));
printf("File ID: %s\n", $file->id);

I have the following situation, I am uploading a code from Php to html with jquery . What is happening to me is that from the code that I am printing from Php when it shows it to me in the html it does not recognize the jquery selector ( a.deleteComec ) that I am printing from Php . Then I leave the code to see if you can help me. Thanks.

php code

        foreach ($datos as $val){ 
            if($usuario == $val['idusuario']){ 
            echo '<div class="panel panel-success">
                <div class="panel-heading">
                    <h3 class="panel-title" >'.$val['nombre']." ".$val['fechahora'].'<div class="text-right"><a class="deleteComec" id="'.$val['id'].'" href="#" title="Borrar">Borrar</a></div></h3>
                </div>
                <div class="panel-body">'. 
                        $val['comentario']
                .'</div>
            </div>';

            }else{ 

            echo '<div class="panel panel-warning ">
                <div class="panel-heading">
                    <h3 class="panel-title" >'.$val['nombre']." ".$val['fechahora'].'<div class="text-right"><a class="deleteComec" id="'.$val['id'].'" href="#" title="Borrar">Borrar</a></div></h3>
                </div>
                <div class="panel-body">'.
                     $val['comentario']
                .'<div>
            </div>'; 
            }
        } 

Loading the content to the html with jquery

var cargarmensaje = function(){
    idcoment = $("input#id").val();  
    $.post("index.php?c=pendientes&f=getcomentario",{id: idcoment},function(data){
        $("#listcomentario").html( data );
    });  
}

Where the selector is executed (a.deleteComec)

$('a.deleteComec').on("click",function () {
    id = $(this).attr('id');
    bootbox.confirm("Está eguro que desea borrar. Recuerde que al borrar, se eleminaran todos los datos asociados en Cascada", function (result) {
        if (result) {
            $("div#idloader").addClass("loader");
            $.post('index.php?c=' + a_id[1] + '&f=delComec', {id:id}, function (data) {
                cargarmensaje();    
                $(".loader").fadeOut("slow");                
            });
        }
    });
});

How the code is displayed in the browser

<a class="deleteComec" id="144" href="#" title="Borrar">Borrar</a>

I have the following situation: I have a class called primary to which I make an extension to a class called user. In the primary class, I call in a __construct in which I start a connection to mysql , I want to use that connection in my user class to avoid calling it in all my classes, which extends from the primary . I have declared a variable of type protected ($db) for the connection but what is happening to me is that when I try to access my connection from the extended class it sends me the following error:

Fatal error: Call to a member function query() on null in /opt/lampp/htdocs/pendientes/models/usuario_model.php on line 17

Primary Class:

class primary_model {

    protected $db;
    public $aplicacion;

    public function __construct() {
        $this->db = classDb::conexion();
        $this->aplicacion = array();
    }
}

User Class:

class usuario_model extends primary_model {

    public function get_usuarionum($search){
        $query = $this->db->query("select * from user WHERE 1 ".$search."");
        return mysqli_num_rows($query);
    }
}

I have the following situation, I am using two identical images, which have a different color to read it in Vuforia 's AR . When creating the database, I defined each one with a pattern, in this case it would be one in purple and the second in pink. Add two ImageTargets in which I defined a Spirte in each according to the color of the image.

What is happening to me is that whenever I read one or the other, the same Sprite always loads me even though they are different. What I want is that when I read purple, the one that responds to that color will load me and so on with the other.

Note: I am not using any script to do this action.

I have the following problem, when reading an xml of an invoice I am presented with a Warning with a specific invoice format. This is not happening to me with another group of invoices that I can process. Then I leave the Warning that is generating me.

Warning:

Warning: SimpleXMLElement::__construct(): tmp/CAMF840207IB3-20180108T181935.xml:20: namespace error : xmlns:schemaLocation: ' http://www.sat.gob.mx/registrofiscal http://www.sat.gob. mx/sitio_internet/cfd/cfdiregistrofiscal/cfdiregistrofiscal.xsd ' is not a valid URI in /opt/lampp/htdocs/cajachica/models/archivo_model.php on line 75

Line code 75

$xml = new SimpleXMLElement($path."/".$archivo,null,TRUE);

The line where the error is being generated is the following:

<cfdi:Complemento>
<registrofiscal:CFDIRegistroFiscal xmlns:schemaLocation="http://www.sat.gob.mx/registrofiscal http://www.sat.gob.mx/sitio_internet/cfd/cfdiregistrofiscal/cfdiregistrofiscal.xsd" Version="1.0" Folio="XXXXXXXXXXXX" xmlns:registrofiscal="http://www.sat.gob.mx/registrofiscal"></registrofiscal:CFDIRegistroFiscal>

The section of code where I'm registering to the namespace :

 $xml->registerXPathNamespace('reg',$namespaces['registrofiscal']);

I have the following situation, I want to pass data from one selectto another but keep it in the source. I leave the code to see if you can help me.

Example: have the value 10203 Shirt T-03 both in the origin and in the destination.

	$().ready(function() 
		{
		$('.pasar').click(function() { return !$('#origen option:selected').appendTo('#destino'); });  
		$('.quitar').click(function() { return !$('#destino option:selected').remove().appendTo('#origen'); });
		$('.pasartodos').click(function() { $('#origen option').each(function() { $(this).appendTo('#destino'); }); });
		$('.quitartodos').click(function() { $('#destino option').each(function() { $(this).remove().appendTo('#origen'); }); });
		$('.submit').click(function() { $('#destino option').prop('selected', 'selected'); });
	});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<select name="origen[]" id="origen" multiple="" class="span5" size="9">
  <option value="">Producto</option><option value="10202">10202 Playera T-02</option>
  <option value="10203">10203 Playera T-03</option><option value="10204">10204 Playera T-04</option>       <option value="10206">10206 Playera T-06</option><option value="10208">10208 Playera T-08</option>
  <option value="10210">10210 Playera T-10</option><option value="10212">10212 Playera T-12</option>       <option value="10214">10214 Playera T-14</option><option value="10216">10216 Playera T-16</option>
  <option value="10218">10218 Playera T-18</option>
 </select>
 <input type="button" class="pasar izq" value="Pasar »">&nbsp;<input type="button" class="pasartodos izq" value="Pasar Todos »"><br /><br />		
 <select name="destino[]" id="destino" multiple="" class="span5" size="9" required="true">
			</select>
<input type="button" class="quitar der" value="« Quitar">&nbsp;<input type="button" class="quitartodos der" value="« Quitar Todos">      

I have the following problem, I want to make an array in C# where the key is a string and then separate the key from the value with a foreach in php I make the array as follows Ex.:

$array['key_name'] = "value1";

I have searched a bit on the internet and found the following:

    var datos = new Dictionary<string, string>();
    datos ["fondo"] = "LA9018-58-896.png";
    datos ["codigo"] = "LA9018";

and to extract the value it would only be like this:

string aValue = datos["fondo"];

what i get

LA9018-58-896.png

The problem I have is that I only get a single key and what I want is to do it dynamically with a foreach . Saving the key in one variable and the value in another .

I have the following problem: I have a script in unity (C#) which establishes a connection with the database. It provides it alone, in a GameObject and it works without any problem for me by placing the method with the name Start , I can see the database records without any problem. The problem comes to me when I change the name of the method to Dbcontec and I try to call it in another script at the time of compiling, it generates an error. Below I leave the code of the scripts to see if they can help me.

Connection with the database.

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using System;
using System.Data;
using Mono.Data.Sqlite;

namespace Dbconection {
    public class Dbcnx : MonoBehaviour {

        public int Idrow;

        // Use this for initialization
        public void Dbcontec () {

            string conn = "URI=file:" + Application.dataPath + "/db_cuentos.s3db"; //Path to database.
            IDbConnection dbconn;
            dbconn = (IDbConnection) new SqliteConnection(conn);
            dbconn.Open(); //Open connection to the database.
            IDbCommand dbcmd = dbconn.CreateCommand();

            string sqlQuery = "SELECT * " + "FROM data_cuent Where id = '"+Idrow+"'";
            dbcmd.CommandText = sqlQuery;
            IDataReader reader = dbcmd.ExecuteReader();
            while (reader.Read())
            {
                int id = reader.GetInt32(0);
                string nombre = reader.GetString(1);
                //int rand = reader.GetInt32(2);

                Debug.Log( "id= "+id+"  nombre ="+nombre);
            }
            reader.Close();
            reader = null;
            dbcmd.Dispose();
            dbcmd = null;
            dbconn.Close();
            dbconn = null;

        }
    }

}

Script where I am calling the connection

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using Dbconection;

public class Inicio : MonoBehaviour {

    public Dbcnx dbcnx;
    public int Idrow;

    // Use this for initialization
    void Start () {
        dbcnx.Dbcontec();

    }
}

Error that is generated.

NullReferenceException: Object reference not set to an instance of an object Start.Start () (at Assets/Start.cs:13)

I have the following problem, by increasing the time of setInterval .

I explain what it is about, I have two texts, one on the right side and the other on the left side. In the one on the right side I have a word which I look for in a group of words that I have on the left side and I change its color. What is happening to me is that at an interval of 1000 ms , it works without problem, but when I reduce it to 500 ms , the effect of changing the color of the word in the text on the left side no longer occurs. I leave the javascript code to see if you can help me.

var xa = "primario|comida, nopal, tahúr, cartílago, foto, expulsión, primario, siglo, yerba, grasa, tesis, minuto~zacate|vegetal, zacate, sabor, veneno, horario, sexual, anacoreta, aceptar, inventar, zacate, protesta, arrojar~rito|frustración, rito, ensalzar, filósofo, léxico, rito, avalar, luz, esquimal, rito, ministro~cabra|tauro, palo, cabra, indigno, bienvenida, sopa, insípido, hablar, causa, farol, armazón, consejo~urbe|anfitrión, rival, domar, olivo, mano, urbe, desenfoque, acento, pastel, maduro, cordones, urbe~milenio|milenio, mejor, hortaliza, norteño, jade, milenio, pequeño, garbo, plata, naturales, milenio, yogur~hostal|invierno, hostal, mamut, sonrisa, niño, futbolista, noria, divisiones, servicio, consomé, bigotes, hundir";
var tipo = '';
var interval = '';
var npal = 0;
var tpal = '';
get_palmin(60, set_buspal);

function set_buspal(){
	 	var a = xa.split("~");
		len = a.length;
		tprt = tpal - 1000;
		var i = Math.floor((Math.random() * len) + 1);
		$("#text1").addClass('txt-mitad2');
		$("#text2").addClass('txt-mitad2');
		//Separamos las parte del segundo array.
		if((npal + 1) == len){
			$("#text1").show('fast',function(){
				a2 = a[npal].split("|");
				$(this).html(a2[0]);
				$("#text2").html("");
				setTimeout(function(){
						wd = a2[1];
						$("#text2").html(wd);
						setTimeout(function(){
							if(tipo == 21){
								var search = a2[2].trim();						
							}else{
								var search = a2[0].trim();						
							}
							$("#text2:contains('"+search+"')").each(function () {
						        var regex = new RegExp(search,'gi');
						        $(this).html($(this).text().replace(regex, '<span style="color: #00ff00">'+search+'</span>'));
						    });
					  		npal = 0;						    					
						},tprt);
				},tprt);				
			});
		}else{
			$("#text1").show('fast',function(){
				a2 = a[npal].split("|");
				$(this).html(a2[0]);
				$("#text2").html("");
				setTimeout(function(){
						wd = a2[1];
						$("#text2").html(wd);
						setTimeout(function(){
							if(tipo == 21){
								var search = a2[2].trim();						
							}else{
								var search = a2[0].trim();						
							}
							$("#text2:contains('"+search+"')").each(function () {
						        var regex = new RegExp(search,'gi');
						        $(this).html($(this).text().replace(regex, '<span style="color: #00ff00">'+search+'</span>'));
						    });
					  		npal++;						    					
						},tprt);
				},tprt);				
			});
		}
	}
  
function get_palmin(val = '', fn = '', wd = true) {
  if (wd != '' && (tipo == 19 || tipo == 21)) {
    if (wd) {
      n_wd = 10;
    } else {
      n_wd = wd.split(" ").length;
    }
    pal = (60 / val) * n_wd;
    tpal = pal * 1000;
  } else {
    pal = 60 / val;
    tpal = pal * 1000;
  }
  clearInterval(interval);
  interval = setInterval(fn, tpal);
}

$("#rango").change(function() {
  var val = $(this).val();
  get_palmin(val, set_buspal);
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<div class="row show-grid" style="margin-top: 50px;">
  <div class="span2" id="text1" style="color: #0000ff; height:40px; " align="right"></div>
  <div class="span7" id="text2" align="left"></div>
</div>
<div style="margin-top: 50px;">
  <div><input type="range" name="rango" class="input-xxlarge" id="rango" step="1" min="1" max="2000" value="60"></div>
</div>

Note: the value is set to 60 wpm and the get_palmin function is where the setInterval value is set