Moteur de recherche
Pour exclure des mots de votre recherche, vous devez ajouter des signes '-' devant ces mots là.
Exemple : une recherche 'apache -mysql' recherchera tout ce qui contient le mot 'apache' mais pas le mot 'mysql'.
Vous être un utilisateur de Firefox ? Ajouter le moteur de recherche du site à votre navigateur favori !
Résultats de votre recherche dans le manuel Pear
page 1 page 2
- ->joinAdd() - DB_DataObject - Bases de données - Paquets - Manuel Pear
# 4 : ->joinAdd()
# 7 : ->joinAdd() -- Ajout un autre objet de données pour construire une requête de jointure
# 16 : void $DB_DataObject->joinAdd ([object $dataobject [, string $joinType [, string $joinAs [, string $joinCol]]]])
# 25 : Construit une requête de jointure, en ajoutant un autre objet de données à celui déjà présent. Soyez prudent lorsque vous utilisez cette méthode, les requêtes simples seront plus claires que lors de l'utilisation de joinAdd().
# 39 : object $obj - l'objet à joindre (aucune valeur effacera la jointure courante)
# 44 : string $joinType - "LEFT" | "INNER " | "RIGHT" | ""
# 46 : INNER est la valeur par défaut, "" indique juste une requête du type 'select ... from a,b,c' sans jointure et les liens seront ajoutés dans les éléments 'where'.
# 53 : string $joinAs - si vous voulez sélectionner la table sous un autre nom ; utile lorsque vous voulez sélectionner plusieurs colonnes depuis une seconde table.
# 58 : string $joinCol - La colonne de cet objet qui correspond, nécessaire si cette table est liée à un fils de l'objet en plusieurs endroits e.g.
# 66 : Exemple 39-1. Utilisation de colonnes de jointure spécifiques - Introduction - URI_Template - Réseau - Paquets - Manuel Pear
# 112 : $t = new URI_Template("http://example.org/?{-join|&|a,data}");
# 115 : $t = new URI_Template("http://example.org/?d={-listjoin|,|points}&{-join|&|a,b}");
# 118 : $t = new URI_Template("http://example.org/?d={-listjoin|,|list0}&{-join|&|foo}");
# 121 : $t = new URI_Template("http://example.org/?d={-listjoin|&d=|points}"); - PEAR2 Policies - A propos de PEAR - Manuel Pear
# 65 : All alpha/devel stability packages have no claim to a package name. If a better package comes along that does the same thing, wants your package's name and achieves beta status, you have to either join forces or change the name of your package. The limit is that newer packages have to be unarguably better in implementation. It is up to the Collective to define "unarguably better" - Introduction - XML_sql2xml - XML - Paquets - Manuel Pear
# 105 : Transformation basé sur des jointures de requêtes
# 107 : Si le résultat de votre requête est basé sur des jointures de tables, une structure de données XML peut représenter comment le DBMS joint les tables. Pour activer ou désactiver ce comportement, utilisez
# 120 : $xmlstring = $sql2xmlclass->getxml("select * from bands left join albums on bands.id = bandsID");
# 195 : $xmlstring = $sql2xmlclass->getxml("select * from bands left join albums on bands.id = bandsID"); - Selecting Specific data (SELECT) - DB_DataObject - Bases de données - Paquets - Manuel Pear
# 17 : The DB_DataObject can now handle JOIN queries, however please read the introduction to linking and Joining before jumping in and using the Join feature, as you may be trading the use of a cool feature, against the readibility of your code. - DB_Table_Database Class Tutorial - DB_Table - Bases de données - Paquets - Manuel Pear
# 31 : Automated construction of join conditions for inner joins of any number of tables, based on a list of table names and/or a list of desired column names.
# 155 : autoJoin()
# 474 : A table may be declared to be a "linking" table that establishes a many-to-may relationship between two others. The only effect of such a declaration is to change the action of the autoJoin method: If a table named $link is declared to be a linking table that creates a many-to-many relationship between tables named $table1 and $table2, then the autoJoin method may use the linking table to join $table1 and $table2, if necessary.
# 499 : The addLink() method will not prevent one from declarating more than one linking table for the same two linked tables. Doing so would make the link declaration useless, however, because the autoJoin() method will fail if it needs to use a linking table to join a pair of tables, but finds that more than one of linking table is declared for those two tables.
# 875 : autoJoin()
# 877 : autoJoin() - accepts an array parameter containing the names of desired columns and/or an array of tables names, and returns a query array containing a WHERE clause with automatically generated join conditions.
# 882 : array|PEAR_Error autoJoin([array $cols], [array $tables], [string $filter
# 885 : Here, $cols is a sequential array of the names of the desired columns, $tables is a sequential array of names of tables to be joined, and $filter is an SQL logical statement that may be used to limit the results. The $filter clause is added (i.e., ANDed) to the end of the the 'where' element, after the automatically generated join conditions. Both the $col and $tables parameter are optional, but at least one of them must be supplied. The query returned by autoJoin is an inner join of a set of tables containing all of those listed in the $tables parameter, all of the tables containing the columns listed in the $cols parameter, and any linking tables required to join these tables.
# 887 : The following example generates and submits query that selects a result set in which each row contains a person's name, home phone number and address, based on knowledge of the names of the desired columns. In our example database, this requires that all four tables be joined.
# 891 : $report = $db->autoJoin($cols, "Phone.PhoneType = 'HOME'"); - DB_Table Class Tutorial - DB_Table - Bases de données - Paquets - Manuel Pear
# 751 : 'join' - any join clauses that should be added to the FROM clause.
# 776 : The values of the 'select', 'from', 'where', 'group', 'having', and 'order' elements are strings that contain the text of corresponding clause of the desired SQL statement, excluding the keywords SELECT, FROM, WHERE, GROUP BY, HAVING, or ORDER, respectively. The value of the 'join' element, if present, is simply concatenated onto the end of the 'FROM' element, and should include the keywords, e.g., 'JOIN', 'INNER JOIN', or 'LEFT JOIN'. - ->selectAs() - DB_DataObject - Bases de données - Paquets - Manuel Pear
# 2 : ->getLinks() ->joinAdd() Niveau superieurSommaire
# 7 : ->selectAs() -- Construit le composant sélectionné d'une requête (habituellement, pour une jointure)
# 27 : Cette méthode est utilisée en conjonction avec joinAdd, afin de permettre le renommage des colonnes, dans un format fixe, lors des conflits de nommage (par exemple, lorsque les tables ont toutes une colonne 'id').
# 51 : string $tableName - ceci est utilisé soit lorsque un tableau est fourni en tant que premier argument, soit lorsque vous joingez une table 'as' un atre nom
# 95 : // utilisation de joinAdd pour ajouter la voiture..
# 96 : $person->joinAdd($car);
# 110 : // donc, nous joingnons la seconde voiture "FROM person INNER JOIN car ..... , car as secondcar WHERE .....
# 111 : $person->joinAdd($secondcar,'','secondcar');
# 135 : ->getLinks() ->joinAdd() Niveau superieurSommaire - Quick API reference - MDB_QueryTool - Bases de données - Paquets - Manuel Pear
# 19 : autoJoin()
# 21 : Join the given tables, using the column names, to find out how to join the tables; i.e., if table1 has a column named "table2_id", this method will join "WHERE table1.table2_id=table2.id". All joins made here are only concatenated via AND.
# 254 : setJoin($table, $where, $joinType)
# 256 : Sets the join condition which is used for the current instance.
# 261 : setLeftJoin($table, $where)
# 263 : Sets a left join on $this->table.
# 268 : addLeftJoin($table, $where, $type)
# 270 : Adds a left join to the query.
# 275 : setRightJoin($table, $where)
# 277 : Sets a right join on $this->table. - Automatic Table Linking and Joins - DB_DataObject - Bases de données - Paquets - Manuel Pear
# 4 : Automatic Table Linking and Joins
# 7 : Automatic Table Linking and Joins -- Automatic Table Linking - ::getLink(), ::getLinks(), ::joinAdd(), ::selectAs()
# 17 : Automated links are supported by a databasename.links.ini file. which stores the relations ship between tables, maping one tables column to anothers. This databasename.links.ini file is used by the getLinks() and joinAdd() Method, to either retrieve related information of a primary object, or quickly build complex multitable queries.
# 21 : The goal of getlinks and joinAdd is to make connecting two tables as simple and fast as possible, while still ensuring that the code is reasonably comprehensable. In the example below, It is demostrated how getlinks() can be used to fetch more data about an object after the initial fetch, and it can also be used to test the links file prior to building a full blown join Query.
# 29 : Exemple 39-1. A simple introduction to links and joins
# 69 : // and finally the most complex, using SQL joins and select as.
# 85 : $person->joinAdd($car);
# 117 : If you use a 'full stop' in the key (link from column), getLinks() will look up in the table with the column name matching the string to the left of the 'full stop', and replace the 'full stop' with and underscore and assign the object variable to that name. Or you may wish to use the selectAs() method to decide how you want columns from different objects to be returned (when using joinAdd())
# 156 : It is also possible to create joins on keys consisting of more than one column. Use the following syntax:
# 181 : This will lead to the following select statement (here using the INNER JOIN syntax):
page 1 page 2
Remonter 
