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
Ce tag se foloseste pentru a include fisier extern CSS in pagina web?
<body> <script> <link>
<link href="/templ/style.css" rel="stylesheet" type="text/css" />
Ce proprietate CSS seteaza marimea textului?
font-weight text-decoration font-size
h2 {
  font-size: 1em;
}
Indicati proprietate JavaScript care poate sa adauge cod HTML intr-un element.
text value innerHTML
document.getElementById("someID").innerHTML = "Continut HTML";
Clic pe functia care returneaza numarul de caractere dintr-un sir in PHP.
count() strlen() stristr()
$str = "http://CoursesWeb.net/";
$nr_chr = strlen($str);
echo $nr_chr;       // 22
Care este forma de feminin a adjectivului "white" (alb)?
white whitea whites
(In limba engleza adjectivele au aceeasi forma pt. ambele genuri)
The snow is white. - Zapada e alba.
Care este forma de feminin a adjectivului "blanco" (alb)?
blanc blance blanca
La nieve es blanca.
- Zapada e alba.
parseCSV

Last accessed pages

  1. Tutorial HTML5 (2732)
  2. Node.js - Lectia de inceput, instalare (967)
  3. Curs si Tutoriale Ajax (38995)
  4. Cursuri si Tutoriale: Engleza, Spaniola, HTML, CSS, Php-Mysql, JavaScript, Ajax (127587)
  5. Verbe - Exercitii si teste engleza incepatori (13210)

Popular pages this month

  1. Cursuri si Tutoriale: Engleza, Spaniola, HTML, CSS, Php-Mysql, JavaScript, Ajax (3898)
  2. Curs HTML gratuit Tutoriale HTML5 (2756)
  3. Curs si Tutoriale JavaScript (2545)
  4. Curs PHP MySQL, Tutoriale si Scripturi PHP (2462)
  5. Curs CSS Online Tutoriale CSS3 (2258)