Skip to main content

Home/ PHP Programming/ Group items tagged sql

Rss Feed Group items tagged

javatpoints

Introduction to SQL | SQL Tutorial for Beginners and Professional - JavaTpoint - 0 views

  •  
    JavaTpoint Provides a SQL Tutorial for Beginners and Professionals. JavaTpoint Covers a all SQL Topics such as what is SQL, Introduction to SQL, what is database, SQL database,SQL Table etc.
renews_

Doctrine - PHP Object Relational Mapper - 0 views

  •  
    Doctrine is an object relational mapper (ORM) for PHP 5.2.3+ that sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication.
javatpoints

PHP Training | PHP Training institute in Noida, Delhi/NCR -... - JavaTpoint- Training |... - 0 views

  •  
    JavaTpoint.Tumblr is a Official Javatpoint blog who's share a articles for beginners and Professionals such as java , android, php, android, html, sql, oracle, ,mysql,css, jquery and python etc.
sloansteddi

How to use PHP and PEAR MDB2 (Tutorial) | David and Katherine Goodwin - 0 views

    • sloansteddi
       
      Prepare takes the $sql (with '?'s where data will go), along with the TYPES (array) of data to prepare the sql for, and a 3rd paramater for manipulating or result-getting (see next paragraph). It assigns this to $prepared_statement. Another array is created with the data (in the same order as the types, of course), and the RESULT is aquired by running the execute() method on the $prepared_statement object, passing the execute method the "$data" array to fill in the '?'s After this do everything as normal.
  • column = ?
  • id = ?
  • ...1 more annotation...
  • I have a feeling that MDB2 lower cases all field names - so you'll probably need : echo $row['name'] A good idea would be to print_r($row) or similar, to see what's in it
  •  
    A great walk through on getting started with MDB2
Sarah HL

Building semantic Web CRUD operations using PHP - 0 views

  • When developing a Web application, it's standard practice to create a database structure on which server-side code is placed for the logic and UI layers. To connect to the database, the server-side code needs to do some basic creating, updating, deleting, and — most importantly — reading of records.
    • Sarah HL
       
      Interet du CRUD
  • SPARQL — Simple Protocol and RDF Query Language
    • Sarah HL
       
      PHP works with SPARQK to implement CRUD
  • Why move from SQL to SPARQL? There are many reasons why you would want to move from SQL to SPARQL. The details extend beyond the scope of this article, but you could be motivated by the following points: You want a more distributed data solution. You want to expose your data on the Web for people to use and link to. You may find Node-Arc-Node relationships (triple) easier to understand than relational database models. You may want to understand your data in a pure object-oriented fashion to work with an OOP paradigm (PHP V5 and later supports OOP). You want to build generic agents that can connect to data sources on the Web.
    • Sarah HL
       
      Interest of SPARQL
  •  
    "When developing a Web application, it's standard practice to create a database structure on which server-side code is placed for the logic and UI layers. To connect to the database, the server-side code needs to do some basic creating, updating, deleting
rucoven

Design Pattern MVC - zoom sur la couche modèle : DAL / DAO / ORM / CRUD | Vin... - 0 views

  •  
    Design Pattern MVC Voilà deux ans que je fais un cours, suivi d'un petit projet traitant du design Pattern MVC.  Le projet est à écrire en PHP5, avec une base de données MySQL comme support de stockage des données, l'architecture MVC est donc à implémenter dans un contexte purement web. Le paradigme objet est tout indiqué quand il s'agit d'écrire et d'agencer des composants logiciels, c'est donc celui qui sera adopté dans toute la suite. Il y a bien entendu beaucoup de projets existants implémentant le design Pattern MVC en PHP, mais le propos du cours est plutôt de réaliser un cas pratique d'implémentation afin de bien saisir les bien faits du design pattern  MVC. En effet l'utilisation d'un design pattern architectural en PHP, s'oppose à la pratique empirique de ce langage qui consiste à mélanger les connexions et accès à la base de données, avec le traitement des données et leur affichage. Dans ce cas il est alors commun d'avoir dans un seul script: du PHP, du SQL, du Javascript et du CSS dans les attributs des balises HTML soit pas moins de 5 langages distincts.
sloansteddi

MDB2 | Prepare & Execute - 0 views

  •  array('integer'), array('text', 'text')
    • sloansteddi
       
      Make sure to pass TWO types arrays when selecting data with a where clause: prepare($sql, $typesIN, $typesOUT) inserting just takes one...
  • $sth = $mdb2->prepare('INSERT INTO numbers (number) VALUES (?)', array('integer'), MDB2_PREPARE_MANIP); $sth->execute(1); $sth->execute(8);
  •  
    walk through of preparing and executing statements
1 - 7 of 7
Showing 20 items per page