Category : database

Currently, my Excel file is being created showing all the records in DB. The problem is that it shows the deleted items too. Here is the code that I’ve for my current excel file: public function collection() { $resultados = collect( DB::select(‘SELECT articulos.id, articulos.codigo_comercial, articulos.codigo_interno, articulos.descripcion, coalesce( articulos.marca, ‘SIN MARCA’ ) as marca, coalesce( articulos.modelo, ..

Read more

I am trying to get all values from database column, using wp get_col(). It seems missing something, here is my query global $wpdb; $table_name = $wpdb->prefix . ‘students’; $results = $wpdb->get_col("SELECT * FROM $table_name WHERE groups = ”"); print_r($results); //Output Array ( [0] => 24 [1] => 25 [2] => 26 [3] => 27 [4] ..

Read more

when it is not hashed it’s inserted but when it is hashed the execute doesnt come through, why? **get data** $voornaam = strip_tags($_POST["voornaam"]); $achternaam = strip_tags($_POST["achternaam"]); $geboortedatum = strip_tags($_POST["geboortedatum"]); $email = strip_tags($_POST["email"]); $ww = strip_tags($_POST["wachtwoord"]); $wachtwoord = password_hash($ww, PASSWORD_DEFAULT); echo $wachtwoord; $adres = strip_tags($_POST["adres"]); $huisnummer = strip_tags($_POST["huisnummer"]); $postcode = strip_tags($_POST["postcode"]); $woonplaats = strip_tags($_POST["woonplaats"]); $rekeningnummer = ..

Read more