> -----Original Message----- > From: Ethan Rosenberg [mailto:ethros@xxxxxxxxxxxxx] > Sent: Tuesday, October 19, 2010 12:05 AM > To: php-general@xxxxxxxxxxxxx > Subject: Re: Questions from a Newbie > > Tamara - > > Thanks. > > No error_log. > The error log only exists if he configures it properly and the script has error. IE: log_errors & error_log. Like I said, Ethan should start from the beginning of the manual. It covers the configuration of PHP in addition to the fundamentals of PHP. > This works ... > > <html><body> > <?php phpinfo(); ?> > </body></html> > > Ethan > ++++++++++ > At 02:23 AM 10/19/2010, Tamara Temple wrote: > >On Oct 18, 2010, at 11:01 PM, Ethan Rosenberg wrote: > > > >> > >>I've added the code you suggest, and I still get a blank screen. > >>Should I be explicitly be using mysqli functions; eg mysqli_connect? > >Odd you should still get a blank screen and nothing in the error_log... > > > >Does phpinfo() work? > > > >>Ethan > >>++++++++ > >>At 11:00 PM 10/18/2010, you wrote: > >>>Where do you set $host, $user and $password? > >>> > >>>You should add the following after the new mysqli statement: > >>> > >>>if ($mysqli->connect_error) { > >>> die('Connect Error (' . $mysqli->connect_errno . ') ' > >>> . $mysqli->connect_error); } > >>> > >>>Tamara Temple > >>>-- aka tamouse__ > >>><mailto:tamara@xxxxxxxxxxxxxxxx>tamara@xxxxxxxxxxxxxxxx > >>> > >>> > >>>"May you never see a stranger's face in the mirror." > >>> > >>>On Oct 18, 2010, at 4:09 PM, Ethan Rosenberg wrote: > >>> > >>>>At 05:37 PM 10/17/2010, Tamara Temple wrote: > >>>>>gah, i botched that up. > >>>>> > >>>>>For the first part, you want the following: > >>>>> > >>>>> $cxn = new mysql($host, $user, $password); > >>>>> $res = $cxn->query("create database test22:); > >>>>> if (!$res) { > >>>>> die("Failed to create database test22: " . > >>>>> $cxn- >error()); > >>>>> } > >>>>> > >>>>>Then, reopen the connection with the new data base: > >>>>> > >>>>> $cxn = new mysql($host, $user, $password, "test22"); > >>>>> > >>>>>Then the following code will work. > >>>>> > >>>>> > >>>>>Tamara Temple > >>>>> -- aka tamouse__ > >>>>><mailto:tamara@xxxxxxxxxxxxxxxx>tamara@xxxxxxxxxxxxxxxx > >>>>> > >>>>> > >>>>>"May you never see a stranger's face in the mirror." > >>>>> > >>>>>On Oct 17, 2010, at 4:26 PM, Tamara Temple wrote: > >>>>> > >>>>>> > >>>>>>On Oct 17, 2010, at 1:22 PM, Ethan Rosenberg wrote: > >>>>>>>At 01:41 AM 10/17/2010, Tommy Pham wrote: > >>>>>>>> > I cannot get the following to work. In my Firefox > >>>>>>>> > [Iceweasel] > >>>>>>>>browser, I > >>>>>>>> > enter the following URL: [w/ the http] > >>>>>> > >>>>>>Whenever you get a blank screen running a php application, the > >>>>>>place to look is the http server's error_log. This is frequently > >>>>>>found in / var/log/httpd/error_log or /var/log/apache2/error_log. > >>>>>>(If your system is hosted someplace else, it could very easily be > >>>>>>in a different place). Typically you need root permission to read > >>>>>>this file. Tail the file after you run your PHP script to see the > >>>>>>most recent errors. > >>>>>> > >>>>>>>> > The code contained in the file CreateNew.php is: > >>>>>>>> > > >>>>>>>> > /* > >>>>>>>> > * Create Database test22 > >>>>>>>> > */ > >>>>>>>> > <html><body> > >>>>>>>> > <?php > >>>>>>>> > $cxn = mysqli_connect("$host",$user,$password); > >>>>>> > >>>>>>Better to use the OO approach: > >>>>>> > >>>>>> $cxn = new mysqli($host, $user, $password); > >>>>>> > >>>>>>>> > echo "Create database test22;" > >>>>>> > >>>>>>Instead of echo statements (which would just echo the contents to > >>>>>>the output, i.e., your browser, you want to assign them to a > >>>>>>variable, such as: > >>>>>> > >>>>>> $sql = "create database test22; use test22"; > >>>>>> > >>>>>>Then you need to execute the sql statement: > >>>>>> > >>>>>> $res = $cxn->query($sql); > >>>>>> if (!$res) { > >>>>>> die("Could not create database test22: " . > >>>>>> $cxn- >error()); > >>>>>> } > >>>>>> > >>>>>>>> > echo "Create table Names2 > >>>>>> > >>>>>> $sql = "create table Names2 > >>>>>> > >>>>>>>> > ( > >>>>>>>> > RecordNum Int(11) Primary Key Not null default=10000 > >>>>>>>>auto_increment, > >>>>>>>> > FirstName varchar(10), > >>>>>>>> > LastName varchar(10), > >>>>>>>> > Height decimal(4,1), > >>>>>>>> > Weight0 decimal(4,1), > >>>>>>>> > BMI decimal(3,1) > >>>>>>>> > Date0 date > >>>>>>>> > );" > >>>>>> > >>>>>> ; // to close off the php statement > >>>>>> $res = $cxn->query($sql); > >>>>>> if (!$res) { > >>>>>> die("Could not create table Names2: " . $cxn- >error()); > >>>>>> } > >>>>>> > >>>>>>>> > > >>>>>>>> > echo" Create table Visit2 > >>>>>> > >>>>>> $sql = "create table Visit2 > >>>>>> > >>>>>>>> > ( > >>>>>>>> > Indx Int(7) Primary Key Not null auto_increment, > >>>>>>>> > Weight decimal(4,1) not null, > >>>>>>>> > StudyDate date not null, > >>>>>>>> > RecordNum Int(11) > >>>>>>>> > );" > >>>>>> > >>>>>> ; // again, to close off the php statement > >>>>>> $res = $cxn->query($sql); > >>>>>> if (!$res) { > >>>>>> die("Could not create table Visit2: " . $cxn- >error()); > >>>>>> } > >>>>>> > >>>>>>>> > > >>>>>>>> > $sql= "SHOW DATABASES"; > >>>>>> > >>>>>>This doesn't work in a programmatic setting. > >>>>>> > >>>>>>Terminate the database connection: > >>>>>> > >>>>>> $cxn->close(); > >>>>>> > >>>>>>>> > ?> > >>>>>>>> > </body></html> > >>>>>> > >>>>>>>> > I would also like to be able to add data to a table, using > >>>>>>>>PHP, > >>>>>>>>which I > >>>>>>>>can do > >>>>>>>> > in MySQL as: > >>>>>>>> > load data infile '/home/ethan/Databases/tester21.dat.' > >>>>>>>> > replace > >>>>>>>>into table > >>>>>>>> > Names fields escaped by '\\' terminated by '\t' lines > >>>>>>>>terminated by '\n' > >>>>>>>>; > >>>>>> > >>>>>>That's a specific feature of the mysql program. You'd have to > >>>>>>write something in php to be able to parse the file and insert the > >>>>>>data. > >>>>>>There are examples all over the net. Then you would need to set up > >>>>>>sql insert or replace statements to actually get the data into the > >>>>>>data base using mysqli::query. There are numerous examples of this > >>>>>>as well. > >>>>>> > >>>>>>Here's one example: > >>>>>> > >>>>>><?php > >>>>>> > >>>>>> $host = "localhost"; > >>>>>> $user = "root"; > >>>>>> $pwd = "rootpassword"; > >>>>>> $db = "test22"; > >>>>>> $table = "table_to_insert_into"; > >>>>>> > >>>>>> $cxn = new mysql($host, $user, $pwd, $db); > >>>>>> > >>>>>> $filename = "tab-delimited.txt"; > >>>>>> $contents = file($filename); // returns the contents of > >>>>>>the file into an array, one line of file per array > >>>>>> > >>>>>> $columns = explode("\t", $contents[0]); // get the column > >>>>>>names from the first line of the file > >>>>>> > >>>>>> $sql = "insert into $table set "; > >>>>>> for ($i=1; $i<count($contents) ; $i++) { > >>>>>> $data = explode("\t", $contents[$i]); > >>>>>> $j = 0; > >>>>>> foreach ($columns as $column) { > >>>>>> $insertdata[] = "$column='" . > >>>>>> $cxn- >real_escape_string($data[$j+ +]) . "'"; // this assumes > >>>>>>the column names in the tsv file match the column names in your > >>>>>>data base table exactly. It also assumes that all your data are > >>>>>>strings, not numerics. > >>>>>> } > >>>>>> $sql .= implode(",",$insertdata); > >>>>>> $res = $cxn->query($sql); > >>>>>> if (!res) die ("Error inserting data: " . > >>>>>> $cxn- >error()); > >>>>>> } > >>>>>>?> > >>>>>><html><head><title>Imported data</title></head> <body> <p>Data > >>>>>>just imported:</p> <table border="1" cellpadding="2px" > >>>>>>cellspacing="2px"> <thead> <tr style="color: white; > >>>>>>background-color: black; text-align: > >>>>>>center"> > >>>>>><? > >>>>>> > >>>>>> $res = $cxn->query("select * from $table limit 1"); // get > >>>>>>one row from table for generating column names > >>>>>> if (!res) die ("Query failed for table $table: " . > >>>>>> $cxn- >error()); > >>>>>> $row = $res->fetch_assoc(); > >>>>>> foreach ($row as $column => $value) { > >>>>>> echo "<th>" . $column . "</th>"; > >>>>>> } > >>>>>>?> > >>>>>></tr> > >>>>>></thead> > >>>>>><tbody> > >>>>>><? > >>>>>> > >>>>>> $res = $cxn->query("select * from $table"); > >>>>>> if (!res) die ("Query failed for table $table: " . > >>>>>> $cxn- >error()); > >>>>>> while ($row = $res->fetch_assoc()) { > >>>>>> echo "<tr>"; > >>>>>> foreach ($row as $column => $value) { > >>>>>> echo "<td>" . $value . "</td>"; > >>>>>> } > >>>>>> echo "</tr>\n"; > >>>>>> } > >>>>>>?> > >>>>>></tbody> > >>>>>></table> > >>>>>></body> > >>>>>></html> > >>>>>> > >>>>>> > >>>>>> > >>>>>>>As I stated, I am a newbie. > >>>>>>> > >>>>>>>1] I am trying to shorten the learning curve by asking some > >>>>>>>questions, which I understand are probably trivial. A whole > >>>>>>>MySQLi list of functions at this point is to much for me. I have > >>>>>>>to break the problem into manageable parts. > >>>>>> > >>>>>>Important, most used mysqli functions: > >>>>>> > >>>>>>Creating the database connection: $cxn = new mysqli( host, user, > >>>>>>password, database ); (mysqli::__construct function) > >>>>>> > >>>>>>Submitting queries: $result = $cxn->query( sql ); (mysqli::query > >>>>>>function) > >>>>>> > >>>>>>Working with results: $row = $result->fetch_assoc(); -- returns an > >>>>>>associative array of a sql select statement result, subsequent > >>>>>>calls return the next row in the result until the results are > >>>>>>exhausted. > >>>>>> > >>>>>>Syntax errors: $cxn->error() -- reports the mysql error of the > >>>>>>last query. > >>>>>> > >>>>>>These will get you started quite well. > >>>>>> > >>>>>>>2] It has been my experience that using a GUI does not teach the > >>>>>>>whole subject. Linux, which is the OS I use cannot be run from a > >>>>>>>GUI. > >>>>>>> > >>>>>>>In the code being discussed, I wish to create a database and add > >>>>>>>two tables. I also note a MySQL statement that can be used to > >>>>>>>add data to an existing table, and wish to be able to execute > >>>>>>>this statement using PHP. > >>>>>> > >>>>>>mysql(1) is an interactive program that does a lot of things to > >>>>>>help you interact with mysql databases. It's functions are not all > >>>>>>duplicated in the programmatic interface to mysql(i) -- i.e. you > >>>>>>have to write them yourself. > >>>>>> > >>>>>>>So, therefore...... > >>>>>>> > >>>>>>>Let us try to answer the following two(2) questions: > >>>>>>> > >>>>>>>a] What changes [other than moving the simicolons] have to be > >>>>>>>made to correct the code. > >>>>>> > >>>>>>See above > >>>>>> > >>>>>>>b] What books can you suggest to help w/ MySQL and PHP? I > >>>>>>>already have the SQL, MySQL & PHP, and HTML books in the ..... > >>>>>>>for Dummies series. I need something with a little more depth > >>>>>>>and detail. > >>>>>> > >>>>>>Personally, Dummies books don't provide the necessary information > >>>>>>to actually become proficient at any particular topic. > >>>>>> > >>>>>>My personal favourite books are in the O'Reilly catalog, although > >>>>>>some are dated: > >>>>>> > >>>>>>- Head First PHP and MySql: > >>>>>>http://oreilly.com/catalog/9780596006303/ > >>>>>>- PHP Cookbook: http://oreilly.com/catalog/9780596101015/ > >>>>>>- Learning PHP, MySQL, and JavaScript: > >>>>>>http://oreilly.com/catalog/9780596157135/ > >>>>>>- MySQL Cookbook (oreilly.com is currently returning a server > >>>>>>error on this title, unfortunately) > >>>>>> > >>>>>> > >>>>>>Tamara > >>>>> > >>>>> > >>>>>-- > >>>>>PHP General Mailing List (http://www.php.net/ ) To unsubscribe, > >>>>>visit: http://www.php.net/unsub.php > >>>> > >>>>Tamara - > >>>> > >>>>Excellent!! > >>>> > >>>>Can you [or someone else] help w/ this .... > >>>> > >>>>I followed the instructions to create the database and the tables. > >>>>No errors appear on the screen, which is also blank, and the error > >>>>logfile was never written. I cannot find the database > >>>>tester22 or the tables Names2 and Visit2. Where should I look, or > >>>>did I make a mistake? > >>>> > >>>>Here is the code: > >>>> > >>>>/* > >>>>* Create Database test22 > >>>>*/ > >>>><html><body> > >>>><?php > >>>> { > >>>> $cxn = new mysql($host, $user, $password); > >>>> $res = $cxn->query("create database test22"); > >>>> if (!$res) > >>>> { > >>>> die("Failed to create database test22: " . $cxn- >error()); > >>>> } > >>>> > >>>> $cxn = new mysql($host, $user, $password, "test22"); > >>>> $sql = "create table Names2"; > >>>> $res = $cxn->query($sql); > >>>> if (!$res) > >>>> die("Could not create table Names2: " . $cxn- >error()); > >>>> $sql = "create table Visit"; > >>>> $res = $cxn->query($sql); > >>>> if (!$res) > >>>> > >>>> die("Could not create table Visit2: " . $cxn- >error()); > >>>> $cxn->close(); > >>>>?> > >>>></body></html> > >>>> > >>>>Thanks. > >>>> > >>>>Ethan > > > > -- > PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: > http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
