Padasalai TrbTnpsc Padasalai

2y ago
25 Views
2 Downloads
516.14 KB
10 Pages
Last View : 12d ago
Last Download : 2m ago
Upload by : Adalynn Cowell
Transcription

laalia. i.laalia. i.laalia. i.laalia. ssssadaadaCHAPTER – wwwwwwwwwwwwwwwwwwwwCONNECTINGPHP AND dadaadadamysqli()adadaadadaadadaB) mysqli w2. Whichone is correct way, wwecan retrieve the datawinthe result set of Mysqlgrgrg php? D)all aaaallllllllasa3. How can we createasaa database using phpasandasaaslaaliaa .P.name”).P.P.P.PwwwwwwwwwwA)mysqli create db(“databasewwwwwwwwwwwwwwwwwwww4. Which is the correct function to execute the sql queries in php? A)grgrgrgrgrgrgrgrgOOOOOOOO.iiiimysqli aalalalalalalalalalaalia.aaaaassssssssssada function closingain php?adaada 5. Which PPP.wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwA)mysqli close(“connectionobject”);6. Whichgrgrg is the correcti.functionrgrg to establish connectionrgrg in php?rgrgOOOOOOOO.iiiiiiiaaaaaaaalllllaalia.l A)mysqli connect(“serverlll �,”dbaaaassssssssssadaadaada 7. Which is.theadanotadaada in n.wwwwwwwwwwwwwwwwwwwwwwwwwwwwwC)mysqli select data()functiongrgrg many parameterrgrgrequired for mysqlirgrgrgrg48.Howareconnectfunction llaaaaaaaaassssssssssaaaaaaare required aformysqliquery functiondadaadada 9. How manyaparameteradadina php? nctionin php?A)1 wwwwwww for mysqli closewwww parameter are requiredwwwwwwwww11.Whichversion of php supportsmysqli function?g gD) version 5.0gggggrrrrrgrgrrOOOOOO. i.the rversidewebininternetaaaallllllllasaasaasaasa php l .P.P.P.P.P.P.P.P.P.Pwwwwwwwwwwwwwextensionwwgives access to the www function mysqli wwwwwwwwww13. wiswin php whichmysql14.communitysupport scriptinggrgrg is open soure andrgrgrgrg language php i.O.OrgrgOOOOOO.iiiiiiiaaaaa percentage sofaslawebsitelal15.lbylalalaalia.lalaphp and mysql abasetablequerywwwwwwwwwwwwwwwwwwwwwwwwwwwwww17. is an open-source relational database management system mysqlgrgrg is an organized icollectionrgrg of data, a number of affecteddaada affected rowsPadaadada in the previousadaada 19. it returnsadatheadaarowsaquery.wP.P.wP.P.wP.P.wP.P. .Pwwwwwwwwwwwrow as an associativewwww20.iswused to fetches a resultarray. Fetch daPPPPPPPPPP.wwwwwwwwww

laalia. i.laalia. i.laalia. i.laalia. ssssPart – wwwwwwwwwwwwwwwwwwwwwwwwwwShortgrgrg laalia.llllaaaaaaaaassssssssssaaaaaadadaadtheadada in php?adadaadadaadamysqli function.PP.PP.P.P.are.P.P.P.P1. Whatavailable.wwwwwwwwwwwwwwwwwwwwwwwwwwwwww Mysqli connect()Functiongrgrgrgrg Function i.O.Orgrgrgrg eMysqli saaslaaliasssss mysqli select db()Functionaaaaaaaaaaadadadadadadadadadad.P.P. P.P.P.P.P.P.P.Pwwwwwmysqli affected rows()Functionwwwwwwwwwwwwwwwwwwwwwwwww mysqli connect error() Functiongrgrgrgrgrgrgrgrg mysqli fetch aadaPPPPPPPPPP.wwwwis mysqli function?wwwwwwwwwwwwwww2. Whatwwww wwwwwwwisof mysqli queryggrgrg Mysqli functionrgrexecutionrgrg on the web. aaaaassssssssssadaadaadtheadaadaavailable php? .P.Padaadaadaadaaadatypes mysqli function3. WhatP.PPP.wP.P.ware.wP.P.wwwwwwwww Mysqli connect()wwFunctionwwwwwwwwwwwwwwwwg Mysqli close()rgrgrgrg aalia.llllaaaaaaaaa mysqli select db()Functionssssssssssaaaaadaadadaadmysqli affected rows()adaFunctionadadaadadaada.P.P. P.P.P.P.P.P.P.Pwwwwwwwwwwwwwwwwwwwwwwwwwwww mysqli connect error()Function wwgrgrgrgrgrgrgrgrg mysqli fetch wwwwConnections:grgggrgrg Before accessingrMySQLrgrg to Database aaaaaaaalllllaalia.llllaaaaaaaaassssssssssvia PHPascriptinglanguage usingMysqli i connect(“ServerName “,”User aadato close an mysqli nnectionbetween wwgrgrgPHP scripting andi.OMySQLrgrg Database daadadaadadaP.P.P.P.P.P.Object”);.P.P.P.Pmysqli .ofgrgrgGive few examplesrgrgmysqli queries. adaadaadaadaadaPPPPPPPPPP.wwwwwwwwww

laalia. i.laalia. i.laalia. i.laalia. .P.wP.P.wP.P.wP.Pwwwwwwwwwwwwwww“); con mysqli connect(“localhost”,”my user”,”my password”,”Student DBwwwwwwwwww sql ”SELECTstudent name,student alllllaalia.student”;mysqli query( con, adaadadaPPPPPPPP.P.P.wwwwwwwwww6. Whatwwww is connection string?wwwwwwwwwwwwwwww servername - Database Server Server IP addressgggrrgrg Server User iNamergrgrgrgrOOOOOO. i. username l- aaliasssssaaaaaaaaaa passwordadadadad - Database wwwwwwwww DB Nameww Namewwww - iiiaaaalala 7. What is daadaada data in wwwwwwwwwwBuildwwwwwwwwwwwwwwwwwyour own databasegrgrg Storage the datargrgrgrgrgrgwithouta technical P.wisP.P.wPfunction?.wP.P.wP.P.wwwww8.Whatmysqli fetch assoc()wwwwwwwwwwwwwwwwwwwwthe mysqli fetch assoc() function is used to fetch the data from table orgggrrgrgrgrgrgrgrOOOO. i.O.O.Odatabase ssaaaaaa row mysqli fetch array( P.P.P.P.Pwwwwwwwwwwwwwwwwwwwwwwwwwwwwww9.function. rgrggrgrgDefine mysqli connect Themysqli connect erreo()functionisusedtothrowtheerrorwhile uteadadadadadadqueryfrom the wwwwwwwwExample:- mysqli connect alalalalalalaalia.aaaaassssssssss10.Define mysqli affected PPPPP.wwww mysqli affected rows()ww function is used wthewwwwwwThewwwofwwwwwwwwreturns the numberswwwwwwaffected rows ple:mysqli fetch array( wP.PwwwwwwwwwwwwwwwwwwwwwwwwwPart – lain the wwwwwwwwwwwwwwwwwwwwwwwwww1. Writethe syntax for .wwwwwwwwww

laalia. i.laalia. i.laalia. i.laalia. ssssadaa MySQL and PHPadaconnectivityThe main.Pgoalis to retrieveadaadaadaadofadaadaand manipulate .P.PadaadaPPPPP.wP.P.wwwwww MySQL databasewwwwfromwwwwwwstatements are helpingwwwthe wdataserver. The SQL querywwwwwwwwwwithgrggrgrg PHP MySQL extensionrgrg to achieve thei.objectivergrg of MySQL andrPHPOOOOOOOO.iiiiiiiconnection.”mysqli aaalllllaalia.llllaaaaaaaaassssssssssaaaaada scripting wwwwObject”,”SQLgrgrg mysqli aaaaaaaaadadadadapurposeadad available.adadadad2. Write iswtheof wwwwwwwwwwwww The mysqli functionsallows you to accessmysql database serversgg recently executedrgrgrgrginformation abouti.Orgrmostrgrgquery It alia.aaaaassssssssssa adItand change aconnectionsettings. adaadadaadaadaadaadaadoptionsaadisa used to sets ysqli affected rows()functionandmysqli fetch .P.wwwwwwwwwwwwwwwwwwwwwwwwwwwwwMysqli affected rows()inOgrgrg It returns the numberrgrg of affected rowsi.Orgthergrgrg previous Mysqli fetch assoc()wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwIt is used to fetches a result row as an associative aallllllllasaasaasaasaaslaaliasssssaaaaaaaaaa4. Write mysqlisyntax ame “,”User Name”,”Password”,”DBgrg mysqli ai.iai. requires aserver.Server Name.wwwwwwwwwwManagingDatabase adafeatures.adaadaadaadaadaadamethods .andPPPPPPPP.wP.P.wwwwwwwwwwwwwwwwwwwwwwwwwwwww ?php“localhost”;grgrg servername .llll username “username”;aaaaaaaaassssssssssaaaaaadadaadada “password”;.P.Padadaadadaadada password.P.P.P.P.P.P.P.Pwwwwwwwwwwwww DB namewwwwwwwwwwwwwwwww “School ww

laalia. i.laalia. i.laalia. i.laalia. ssssa conn username,adaadaada admysqli connect( wP.Pwwwwwwwwwwwwwww password, DB name);wwwwwwwwwwgrgrg if (! conn) { failed:“.mysqli connect saaaaaadadaadadaadadaadadaadada} .P.P.P.P.P.P.P.P.P.Pwwwwwwwwwwwwwechowwwwwww “Connected successfully”;wwwwwwwwww? P.PP.PP.P.P.P.wwwwwwwwwwallcomputer and Internetapplications.wwwwwDatawwwrelatedwww is important to wwwwwwwwwNumerous growths of data need a secure and convenient environment to storegrgrg manipulate adaadaadafeatures are availableadaadina Relational DatabaseadaadManagementadaadaPPPPPPPPP.www(RDMS)ww Oracle, IBM DB2,wandwwww MicrosoftwwwwwwwwwwSystemsuch as aaaaaassssssssssda INSERT, SELECT,adaada major operationsadaalikeadaadaUPDATE and DELETEadaada using Structure.P.Padaada.wP.P.wP.P.wP.P.wP.Pwwwwwwwww (SQL).wwwwwwwquery languagewwwwwwwwwwgrgPHP and MySQL.Ohasgrgrg The combinationrofrgrgbecome very lllaalia.llllaaaaaaaaassssssssssaaaaaadada scripting languageadadain wwwwwwwMySQLww language connectivity,ww which covers wwwwwand PHP scriptingwwwwwwwwDatabaseconnection establishment,Database Selection,SQL rt – IVwwExplaingg lalalalalalaalia.aaaaassssssssssadaada 1. Discuss inadaadaabout mysql functionsadaadawith eample. wwwwwwwwwwwwwMySQLi extensioncontains the followingimportant functionswwhicharedatabaseconnectivity Oandgrgrgrelated to MySQLrgrgrgrgmanagement. i.O.OrgrgOOOOO.iiiiiiiaaaaaaaalllllaalia.l Mysqli connect()l Functionllaaaaaaaaassssssssssadaadaadaada Function .P.PadaadaadaadaadaadaPP Mysqli close()PP.wP.P.wP.P.wwwwwwwwwwwwwwwwwwwwwwwwwww wmysqli select db()Functiong rgrgmysqli affected rows()rgrg aalia.llllaaaaaaaaa mysqli connect adada.P.P.P.P.P.P.P.P.P.P mysqli fetch assoc()Functionwwwwwwwwwwwwwwwwwwwwwwwwwwww1 PPPPPPP.wwwwwwwwww

laalia. i.laalia. i.laalia. i.laalia. ada connect to Databaseadaada Server machineadaadaPPPPP.wP.P.wP.P.wwwwwwwwviawww using Mysqli connect()www Function.wwww PHP scripting O.O.iiiiiiiimysqli assssssssssaaaaadada requires histo connect.Ptoserver. .P.PadaP.P.P.P.P. .P.wwwwwwwwwwwwww Server name, Databaseww username, passwordwwand Database Name.wwDatabasewwwwwwwwww2rgrgManaging aaaaaaaadadadadand features. wwwwwwwwwwwwwwwwwww ?php“localhost”;grgrg servername ame”;lalalalalaalia. username aaaaassssssssssadaadaadaada “password”;.P.Padaadaadaadaadaada passwordPPPPPPPP.wwwwwwwwwwwww DB namewwwwwwwwwwwwwwwww “School DB”; username,grgrg conn mysqli connect( lllaalia.llllaaaaa password, DB name);aaaassssssssssadaadaadaada {adaadaadaadaadaadaifw(! wwwwdie(“Connection failed:“ . mysqli connect error());grgrg .P.P.P.P? wwwwwwwwwwwwwwwwwwwwwwwwwwwwInthe above code snippet,three variables are usedto connect to the wwgrgrgDatabase server. llllllasaasa - Database ServeraServerasaaslaaliaasssss .P.P.P.P.P.P.P.P.P.P username- DatabaseServerUserNamewwwwwwwwwwwwwwwwwwwwwwwwwwww password - DatabaseServer Password wwgrgrg DB Name - aaalalalllllllaaaaaaaaassssssssssThe mysqli connectfunctiondusesDatabase dadaaadaadaadaadaa aada these ntedwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwith MySQL error code. Otherwise connection is ssada of MySQL and PHPThe mainretrieveadaadaadagoaladaadaconnectivity is toadaada andadaadaPPPPPPPP.wP.P.wwwwww SQL query wwwwmanipulatethe data fromMySQLdatabase server.wwwwwwwwThewwwwwwwwwwwstatements are helping with PHP MySQL extension to achieve the objectivegrgrgof MySQL and PHPrgconnection.rgrg is a function, ihelpsrgrgtorg“mysqli laaaaaaaaassssssssssaaaaaa query statementsexecute atheSQLadadaadadina PHP scriptin

Jul 12, 2019 · 12.the _ combination became very popular server side web in internet php and mysql 13._ is extension in php which gives access to the mysql function mysqli 14._ is open soure and community support scripting language php 15._ percentage of website has been built by php and mysql seven

Related Documents:

Mar 11, 2018 · www.Padasalai.Net www.TrbTnpsc.com in-12th-and-10th.html 8.

www.Padasalai.Net www.TrbTnpsc.com -syllabus-based.html

www.kalvisolai.com www.Padasalai.Net www.TrbTnpsc.com s-with-key-answers.html

www.Padasalai.Net 12th CHEMISTRY www.TrbTnpsc.com SREE GOKULAM MATRIC Hr.Sec.SCHOOL, PALANIYAPURAM , VAZHAPPADY – SALEM-(Dt) 19. How will you convert C 2 H 5-OH to C 2 H 5-O-C 2 H 5? (Ethyl alc

www.Padasalai.Net www.TrbTnpsc.com materials-tamil-medium-english-medium.html COMMERCE HIGHER SECONDARY - FIRST YEAR

www.Padasalai.Net www.TrbTnpsc.com in-12th-and-10th.html 12. If

Jayabharatham Page 1 of 45 www.Padasalai.Net www.TrbTnpsc.com

Scanned by CamScanner Scanned by CamScanner www.Padasalai.Net TrbTnpsc.com th-study-materials-tamil-medium-english .