<?php include "controller/function.php"; if (isset($_POST["go"])) { if ($_POST["go"] == "arrmail") { DB::truncate("mailer"); $handle = fopen($_FILES['csv']['tmp_name'], "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $arrInsert = array("email" => $data[0]); DB::insert(DB::insertSql("mailer", $arrInsert), $arrInsert); } fclose($handle); header("Location: " . $_SERVER['REQUEST_URI']); } else { include "classes/class.phpmailer.php"; $mailers = DB::select("mailer"); foreach ($mailers as $mailer) { $mail = new PHPMailer(); $mail->CharSet = 'utf-8'; $mail->From = $_POST['email']; // от кого $mail->FromName = $_POST['name']; // от кого $mail->AddAddress($mailer['email']); // кому - адрес, Имя $mail->IsHTML(true); // выставляем формат письма HTML $mail->Subject = $_POST['subject']; // тема письма if ($_FILES['file']) { $mail->AddAttachment($_FILES['file']['tmp_name'], $_FILES['file']['name']);
/** * DB::truncate tests * * @dataProvider people_provider_bulk */ public function test_truncate($people) { DB::run('delete from people'); DB::insert('people', $people)->run(); $this->assertTrue(DB::count('people') > 0); DB::truncate('people'); $this->assertTrue(DB::count('people') === 0); }
<?php require_once '../config/config.php'; $database = new DB(); if (!$login->getUserActive()) { header("location:/index.html"); } // <br>devolucion // <br>devoluciondet // <br>factura // <br>facturadet // <br>movimiento // <br>Cliente - resetear saldo y total_ultimo a 0 //Truncate a single table, no output display // $truncate = $database->truncate( array('your_table') ); //Truncate multiple tables, display number of tables truncated $cuantos = $database->truncate(array('devolucion', 'devoluciondet', 'factura', 'facturadet', 'movimiento')); //Fields and values to update $update = array('total_ultimo' => '0', 'saldo' => '0'); //Add the WHERE clauses $where_clause = array('1' => '1'); $updated = $database->update('cliente', $update, $where_clause, 1); // $query = "UPDATE cliente set saldo=0,total_ultimo=0"; // $results = $database->get_results( $query ); $location = "Location: /index.php?data=mantenimiento&op=db&err=1&ts={$cuantos}"; header($location);
/** * Truncates the table, this will wipe all data and reset any auto-increment counters. * * @return void. */ public function truncate() { // Truncate the table. DB::truncate($this->name)->execute($this->database); }