asterion

SELECT facturas.id, SUM(detalle.cantidad*detalle.valor) FROM facturas, detalle WHERE facturas.id = detalle.factura_id GROUP BY facturas.id

asterion

<?php
/* codigo ... */


function svg_mime_type($mime_types){
		$mime_types['svg'] = 'image/svg+xml';
    return $mime_types;
}
add_filter('upload_mimes', 'svg_mime_type', 1, 1);

asterion

<?php

$conn = new PDO("dblib:version=8.0;charset=UTF-8;host=IPSERVIDOR;dbname=NOMBREDB", 'USUARIO', 'PASSWORD');

$id = rand(); 
  
$query = "INSERT INTO Emp VALUES(" . $id .", 'Smith " . $id . "', 'Carpintero', 2, 300)";

$conn->query($query)->execute();

asterion

<?php

$paged = ( get_query_var( 'paged' ) ) ? get_query_var( 'paged' ) : 1;

// The Query
query_posts( 'posts_per_page=3&paged=' . $paged  );
 
// The Loop
while ( have_posts() ) : the_post();
    echo '

asterion

<?php

function allow_contrib_upload() {

    $contrib = get_role( 'contributor' );

    $contrib->add_cap( 'upload_files' );
}
add_action( 'admin_init', 'allow_contrib_upload', 11 );

asterion

SELECT nombre, apellido, MIN(edad) AS edad FROM personas GROUP BY nombre, apellido

asterion

<?php
$uploaddir = trim(ABSPATH, '/') . DIRECTORY_SEPARATOR . 'uploads' . DIRECTORY_SEPARATOR;
$attachments = [];
foreach ($_FILES as $i => $data) {
	$uploadfile = $uploaddir . basename($data['name']);

	if (move_uploaded_file($data['tmp_name'], $uploadfile)) {
		$attachments[$i] = $uploadfile;
	}
}

asterion

<?php
$cod_item = limpiar($_POST['cod_item']);

$sql = "SELECT * FROM content WHERE code = '$cod_item'";

$result = $con->query($sql) or die ($con->error);

if ($result->num_rows > 0) {
}

asterion

update wp_options set option_value = '<aqui debe ir la url/ip>' where option_name = 'home' or option_name = 'siteurl';

asterion

meses = {
  "ENERO"       => [0],
  "FEBRERO"     => [0],
  "MARZO"       => [0],
  "ABRIL"       => [0],
  "MAYO"        => [0],
  "JUNIO"       => [0],
  "JULIO"       => [0],
  "AGOSTO"      => [0],
  "SEPTIEMBRE"  => [0],