Curs Php-mysql

- parseCSV e o clasa PHP gratuita pentru citire si scriere usor a datelor in format CSV.
- Download parseCSV 0.4.3 beta.

Caracteristici

• Suporta valori inchise, virgule inchise, ghilimele duble si linii noi.
• Detectare automata caracter de delimitare.
• Sortare /filtrare dupa anumite campuri /coloane.
• Comenzi SQL de baza, limitare date returnate.
• Retine datele CSV in array, transforma array in format CSV.
• Detectare erori intr-un mod "inteligent", dar depinde si de structura continutului CSV.
• Suporta conversia caracterelor, folosind functia PHP iconv().

Exemple
- Urmatoarele doua exemple folosesc acest CSV, salvat in "books.csv":
rating,title,author,type,asin,tags,review
0,The Third Secret,Steve Berry,Book,0340899263,,need to find time to read this book
3,The Last Templar,Raymond Khoury,Book,0752880705,,
4,The Da Vinci Code (Hardcover),Dan Brown,"     Book     ",0385504209,book movie danbrown bestseller davinci,

1. Citire fisier CSV (cu auto-detectare caracter de delimitare) si retine datele in array:
<?php
// include clasa parseCSV
include('parsecsv/parsecsv.class.php');

// creaza obiect parseCSV
$csv = new parseCSV();

// Citeste si analizeaza 'books' folosind detectarea automata a delimitarii
$csv->auto('books.csv');

// daca stiti caracterul de delimitare (daca nu e cel standard, virgula ','), il puteti adauga
// $csv->delimiter = "\t"; // delimitator tab

$csvdata = $csv->data; // retine datele csv in array

// afiseaza rezultatul
echo '<pre>';
print_r($csvdata);
echo '</pre>';
?>

Rezulta:
Array
(
 [0] => Array
 (
 [rating] => 0
 [title] => The Third Secret
 [author] => Steve Berry
 [type] => Book
 [asin] => 0340899263
 [tags] => 
 [review] => need to find time to read this book
 )
 [1] => Array
 (
 [rating] => 3
 [title] => The Last Templar
 [author] => Raymond Khoury
 [type] => Book
 [asin] => 0752880705
 [tags] => 
 [review] => 
 )
 [2] => Array
 (
 [rating] => 4
 [title] => The Da Vinci Code (Hardcover)
 [author] => Dan Brown
 [type] => Book 
 [asin] => 0385504209
 [tags] => book movie danbrown bestseller davinci
 [review] => 
 )
)

2. Citeste fisierul CSV, sorteaza datele dupa "title".
<?php
// include clasa parseCSV.
include('parsecsv/parsecsv.class.php');

// creaza obiect parseCSV
$csv = new parseCSV();

$csv->sort_by = 'title';

// Citeste si analizeaza 'books' folosind detectarea automata a delimitarii
$csv->auto('books.csv');

$csvdata = $csv->data; // retine datele din csv in array

// afiseaza rezultatul
echo '<pre>';
print_r($csvdata);
echo '</pre>';
?>

Rezulta:
Array
(
 [The Da Vinci Code (Hardcover)] => Array
 (
 [rating] => 4
 [title] => The Da Vinci Code (Hardcover)
 [author] => Dan Brown
 [type] => Book 
 [asin] => 0385504209
 [tags] => book movie danbrown bestseller davinci
 [review] => 
 )
 [The Last Templar] => Array
 (
 [rating] => 3
 [title] => The Last Templar
 [author] => Raymond Khoury
 [type] => Book
 [asin] => 0752880705
 [tags] => 
 [review] => 
 )
 [The Third Secret] => Array
 (
 [rating] => 0
 [title] => The Third Secret
 [author] => Steve Berry
 [type] => Book
 [asin] => 0340899263
 [tags] => 
 [review] => need to find time to read this book
 )
)

3. Transforma array 2D in CSV, si-l trimite ca fisier la browser ca sa fie descarcat.
<?php
// include clasa parseCSV.
include('parsecsv/parsecsv.class.php');

$csvHeader = array('category', 'link'); // csv header

// array bi-dimensional cu datele pt csv (dupa cum e setat la header)
$csvData = array(
 array('tutorials', 'http://www.coursesweb.net/php-mysql/tutorials_t'),
 array('scripts', 'http://www.coursesweb.net/php-mysql/scripts_s2'),
 array('resources', 'http://www.coursesweb.net/php-mysql/download_l2')
 );

// creaza obiect parseCSV.
$csv = new parseCSV();

// transforma array-ul bi-dimensional in CSV, si-l trimite ca fisier la browser ca sa fie descarcat
// (nume_fisier, date-csv, csv-header, delimitator)
$csv->output('coursesweb.csv', $csvData, $csvHeader, ',');
?>

Rezulta acest CSV:
category,link
tutorials,http://www.coursesweb.net/php-mysql/tutorials_t
scripts,http://www.coursesweb.net/php-mysql/scripts_s2
resources,http://www.coursesweb.net/php-mysql/download_l2

- In arhiva cu clasa parseCSV veti gasi mai multe exemple.
parseCSV Web Site.

Un Test simplu in fiecare zi

HTML
CSS
JavaScript
PHP-MySQL
Engleza
Spaniola
Clic pe tag-ul care creaza o lista ordonata numeric
<ul> <tr> <ol>
<ol>
  <li>List-1</li>
  <li>List-2</li>
</ol>
Care selector reprezinta ID-ul unui element in CSS
.nume #nume nume
#id {
  color: #0110fb;
}
Ce cod creaza un obiect in JavaScript?
{} [] new Date()
var obj = {"site": "CoursesWeb.net", "pr": 5};
alert(obj.site);
Indicati instructiunea prin care se verifica daca o conditie este True sau False
else if() switch()
$var = 8;
if($var == 8) echo $var;
Indicati timpul Prezent pentru verbul "to be" (a fi).
be were is
Now, it is here.
- Acum este aici.
Care este conjugarea la timpul prezent al verbului "divertirse" (a se distra) la forma "yo"?
te diviertas me divierto se divierta
Yo me divierto.
- Eu ma distrez.
parseCSV

Last accessed pages

  1. Verbe Dinamice si Statice - Dynamic and Static Verbs (11433)
  2. Limba spaniola curs online incepatori si avansati (31131)
  3. Cursuri si Tutoriale: Engleza, Spaniola, HTML, CSS, Php-Mysql, JavaScript, Ajax (277910)
  4. Contoar deschidere pagina (276)
  5. Citire, Dezarhivare si Creare Arhive ZIP cu PHP (474)

Popular pages this month

  1. Cursuri si Tutoriale: Engleza, Spaniola, HTML, CSS, Php-Mysql, JavaScript, Ajax (26)
  2. Curs HTML gratuit Tutoriale HTML5 (16)
  3. Coduri pt culori (13)
  4. Limba spaniola curs online incepatori si avansati (9)
  5. Creare si editare pagini HTML (8)