Re: [PHP-DB] strings of variables,php, sql
On Mon, 24 Nov 2003 21:36:29 -0800 (PST) Joffrey Leevy <[EMAIL PROTECTED]> wrote: > Would appreciate in anyone can help me. > > Let's say I do a query in php, eg. $query = "select > shed from structure"; With the mysql_fetch_array > function and a loop I could see all the values stored > in the column, shed, using the command: echo $shed; > > Let's say now that I am carrying over a variable from > a form called $form where $form = shed. I can still > say $query = "select $form from structure"; because > $form = shed. > > The problem I have now is with the strings and how do > I see my column values. > > Using echo $$value; or echo $($value) or echo \$$value > or echo $"$value" does not give me the values stored > in the column shed. > > Help anyone? > thanks > Joffrey, First it is easier for us if you just paste the relevant code but I'll try and assist without. Before you can fetch a record you must query the database.. $result=mysql_query($query) or die( "Bad Query=> $query\n". mysql_error() ); The die() function will print an error if there is something wrong with the query such as database not opened first. You are fetching a row (or record) from the database. $row=mysql_fetch_array($result); therefore the value of shed column will be contained within $row. It can be accessed by either of the two lines below. echo $row[0]; #by numeric index.. echo $row["shed"]; #or by column name.. If you wish to find out all the column names and values, try print_r($row); George Patterson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] strings of variables,php, sql
Would appreciate in anyone can help me. Let's say I do a query in php, eg. $query = "select shed from structure"; With the mysql_fetch_array function and a loop I could see all the values stored in the column, shed, using the command: echo $shed; Let's say now that I am carrying over a variable from a form called $form where $form = shed. I can still say $query = "select $form from structure"; because $form = shed. The problem I have now is with the strings and how do I see my column values. Using echo $$value; or echo $($value) or echo \$$value or echo $"$value" does not give me the values stored in the column shed. Help anyone? thanks __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Extracting values from an array (I think)
[EMAIL PROTECTED] wrote: But the variable variable thing does not seem to be working, either with or without the $ for the 'counter' inside the brackets. ${$sLabel_ . $counter} = $row['short_label']; $counter++; ${'sLabel_' . $count} = $row['short_label']; Any reason you're not just doing $data[] = $row['short_label']; and loop through that? or $data['sLabel_' . $count] = $row['short_label']; "variable variables" are just a poor man's array... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Splitting a CSV file
Chris, If you are on a Redhat machine, you could try running a CLI command on this. Try looking up the 'split' command, it may solve your problem if you combine it with some PHP. -Matt On Mon, 2003-11-24 at 19:14, Chris Payne wrote: > Hi there everyone, > > I'm writing an automation system to automatically insert data into a mysql database > from a CSV file, and it works great - until I try to insert a large file, then it > just doesn't do anything. > > I've set my PHP filesize to 10 Megs so that's not the issue, and a server timeout > isn't the issue either. So, is that a way that I can split a CSV file into 2 files > if it's larger than a certain size so that I can still use the automation I am > working on? > > Actually, I won't see the files as it's for a company who just wants to be able to > select their CSV file (No matter what size) and it will insert it automatically, and > as I said it does work on small files but not large :-( > > Any help would really be appreciated. > > Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Subject: Extracting values from an array (I think)
Get your array from mysql_fetch_assoc() you can then use as an alternative, the extract() function : http://uk2.php.net/manual/en/function.extract.php Cheers - Neil. At 20:04 24/11/2003 +, you wrote: To: [EMAIL PROTECTED] MIME-Version: 1.0 From: [EMAIL PROTECTED] Date: Mon, 24 Nov 2003 12:44:37 -0600 Subject: Extracting values from an array (I think) Hello All, I'm familiar and comfortable with selecting and utilizing one record at a time in my php-mysql gui / application. But now I'm faced with having to select one field from 24 records and assign the results to 24 different variables. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Send formmail data to Email and Database
At 20:04 24/11/2003 +, you wrote: From: "howard gramer" <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Send formmail data to Email and Database What a sweet way to greet someone on their first post! Nice to meet you too! I''m not here to hold your hand or monitor for new group members - we're all busy in here. Some lists want code off the bat and some do not! Now I know it's ok to post it without it being requested. Fair point. Down to business : I would attend to your HTML oddly enough, as the PHP doesn't ring any alarm bells : Check out your FORM elements, you have two (Don't know if this will post right to the list) : http://www.friendlyhousebuyers.com/cgi-sys/formmail.pl"; method="POST"> followed by The first form tag outside the second will kill the form action you think you are getting, as it's invalid HTML : Many browsers will treat it in different ways and give unpredictable results. You need to dump DW for complex forms and head down into the code - leave DW to make light work of fidgetty table layouts. It will probably work again if you remove this. Else, try printing out a few key things like the SQL statement which is produced by the sprintf line. Hope that helps, Cheers - Neil. (PS Please do not post to this email address - all mail from hotmail addresses is filtered out - house policy, sorry !) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Splitting a CSV file
Hi there everyone, I'm writing an automation system to automatically insert data into a mysql database from a CSV file, and it works great - until I try to insert a large file, then it just doesn't do anything. I've set my PHP filesize to 10 Megs so that's not the issue, and a server timeout isn't the issue either. So, is that a way that I can split a CSV file into 2 files if it's larger than a certain size so that I can still use the automation I am working on? Actually, I won't see the files as it's for a company who just wants to be able to select their CSV file (No matter what size) and it will insert it automatically, and as I said it does work on small files but not large :-( Any help would really be appreciated. Chris
[PHP-DB] ibase_fetch_object(): request synchronization error
Hi, I've got a problem with Firebird 1.0 and PHP 4.3.3 (had same problem with older release also). When I want to do ibase_execute() in recursion I take an error $subject and I didn't find anything about that in the Internet. Could you help me. Thanks a lot! I have found something, that describe this error for Interbase 5.X and there was written that problem could be in recursive trigger. My code is in PHP but it is recursion also. It would be very unhappy for me, if it wouldn't work, because using ibase_query in my recursion is not good idea. --ogee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Extracting values from an array (I think)
I'm getting the correct output from the following query: > $selectLabelQuery = "SELECT short_label > FROM config > ORDER BY meter_num"; > > $resultSelectLabelQuery = mysql_query($selectLabelQuery) or > die("can't select short label"); > which is processed here: > $counter = 1; > while($row=mysql_fetch_assoc($resultSelectLabelQuery)) > { But the variable variable thing does not seem to be working, either with or without the $ for the 'counter' inside the brackets. >${$sLabel_ . $counter} = $row['short_label']; >$counter++; > } When I WATCH $counter and $row['short_label'], their values are 1 through 24, and short_label_1 through short_label_24, respectively, so the problem is in this part ... ${$sLabel_ . $counter} or even when like this ${$sLabel_ . counter} . TIA, David
Re: [PHP-DB] PHP problem
4 words! i dont believe you! -- Kim Steinhaug --- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. --- "Unknown Sender" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Unfortunately, it doesn't work, > the same situation > > > > Sorry to be a little bit off topic > > > i have code that generates: > > > LONG TEXT 1 > > > > use: > > long text 1 > > > > mvgr, > > Joffrey van Wageningen > > > > -- > > .-[ Joffrey van Wageningen | WoLFjuh | [EMAIL PROTECTED] ]-- > > | Networking Event 2000 - www.ne2000.nl - IRCnet:#ne2000, Undernet:#clue > > | PGP:1024D/C6BA5863 - 3B93 52D3 CB91 9CB7 C50D FA79 865F 628A C6BA 5863 > > | * We demand guaranteed rigidly defined areas of doubt and uncertainty. > > | -- Douglas Adams > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > > Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! > [ http://oferty.onet.pl ] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Mail problem
Well, i've developed such a system, MarketMAX. And ill just give you a little tip here : 1. Dont use BCC field, it look bad and your not able to populate the emails from your database, eg. Dear %username% Ofcourse if your bulksend the same message, always, then BCC could spare your from headache. 2. THE TIMEOUTS! Be aware, very aware, not only do you need to account for php timeout, you also should be very aware of standard sendmail configuration regarding spam. Most installations ive encountered does not like say. 500 emails dumped at them during a few seconds. They will probably detect you as spam, and all the mails are deleted. The best part, all cases Ive encountered, you dont get an error so you think everyuthing is swell -> It isnt! What you need to do is a) create a cron job that bulk sends. eg. 50 emails each 10 second or such. My sollutions was to create a batch system that pulls the 50 last entries from the batch list, prints out the html page with a 5sec meta refresh. This keeps looping till there is no emails left. You might be lucky to be on a system that doesnt care how many emails sendmail spews out, but this is in fact bad. If this is happening, you probably will experience someone taking advantage of the system resulting in the server IP getting blacklisted -> and this is very bad for all users. But if you do it right, and also create a lot of "what if" scenarios, you should be just fine. Happy programming! -- Kim Steinhaug --- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. --- "Craig Roberts" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > It might be a good idea to set a cron job to send say, 100 at a time over > the space of a few hours, to avoild killing the mail server or the server > blocking connections from you. > > Also - use the BCC field to send the mail, this means only one connection > will need to be made to the mail server per batch of addresses, as opposed > to a connection per address (saves bandwidth and mail server!). The mail > server will then send the messages where they need to go and hide all the > other recipents. > > Craig Roberts > > > "Mak" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Beware though...if there are too many addresses in the db, you may > encounter > > timeouts, or your browser may crash (very likely). Increase the timeout > > before you do such a mass-mail job. > > > > Also, my comment: If you do not want your receivers to find out who else > you > > sent the mail to, don't use the CC method. Just: > > > > for(until max. users reached){ > > send out new mail to current user > > } > > > > Yours sincerely, > > Mak > > > > "Jj Harrison\" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > > > > maybe use a for loop and mail command. > > > > should work > > > > > > Or put all the addresses in a CC/BCC field maybe sending every 100 > emails > > to > > > prevent a mail overload/blockage due to to many recipients etc. > > > > > > Hint: look here: http://www.php.net/manual/en/language.variables.php and > > you > > > can find a way to append more to an existing variable. Very useful in > your > > > case. > > > > > > > > > -- > > > JJ Harrison > > > [EMAIL PROTECTED] > > > www.tececo.com > > > > > > > "Unknown Sender" <[EMAIL PROTECTED]> wrote in message > > > > news:[EMAIL PROTECTED] > > > > Sorry to be a little bit off topic. > > > > > > > > I need a tool or script in PHP, that will automaticaly send e-mails to > > > > receipients taken from database. > > > > For example 1 the same e-mail to 1000 receipients. B > > > > > > > > Mail server is on different machine. > > > > > > > > Thanks in advance > > > > > > > > > > > > > > > > > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: sendmail
You should check out phpmailer at sourceforge. It solved all my problems, and will probably solve all yours to. As a bonus, you get a mailer that has a lot of more functions, like attachements and HTML mail and such. -- Kim Steinhaug --- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. --- "Unknown Sender" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi Sorry to be off topic but I have problem with sendmail If anyone know sth about sendmail please e-mail priv. Sorry once more [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Get query value from URL?
I got the solution: Adding this line before if($id): $id = $_GET['id']; Similarily, may add $submit=$_POST['submit'];,$firstname=$_POST['firstname']; if handle forms, like insertion a record into database. On Mon, 24 Nov 2003, Mingyan Shao wrote: > Hi, there, > > I am learning PHP/MySQL now, and got an sample code from > http://hotwired.lycos.com/webmonkey/99/21/index3a_page3.html?tw=programming, > but when I test the code on my machine, it does not work as it > suppose to. > > What it should do is: when you first run the php code, it > gives the names of the employees, each of which creates a link to the > detail info, for example, %s %s\n", > $PHP_SELF, $myrow["id"], $myrow["last"], $myrow["position"]>. When you > click any name, it should get the query value($id) from the URL, and use > it to search in the database. > > It seems can't get the $id from the URL querystring, i.e., the html page > does not change after I click a specific name. > > > The code is the following: > > > $db = mysql_connect("localhost", "root"); > > mysql_select_db("mydb",$db); > > // display individual record > > if ($id) { > >$result = mysql_query("SELECT * FROM employees WHERE id=$id",$db); > >$myrow = mysql_fetch_array($result); > >printf("First name: %s\n", $myrow["first"]); > >printf("Last name: %s\n", $myrow["last"]); > >printf("Address: %s\n", $myrow["address"]); > >printf("Position: %s\n", $myrow["position"]); > > } else { > > // show employee list > >$result = mysql_query("SELECT * FROM employees",$db); > > if ($myrow = mysql_fetch_array($result)) { > > // display list if there are records to display > > do { > > printf("%s %s\n", $PHP_SELF, > $myrow["id"], $myrow["first"], $myrow["last"]); > > } while ($myrow = mysql_fetch_array($result)); > > } else { > > // no records to display > > echo "Sorry, no records were found!"; > > } > > } > > ?> > > > > Any comments and suggestions are appreciated. > > -Mingyan > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Extracting values from an array (I think)
Thanks for your kind reply, John. I've not used the variable variable technique before but do recall reading about it in the PHP Bible. I'll give it a try. David John Krewson <[EMAIL PROTECTED]> 11/24/2003 01:33 PM To: [EMAIL PROTECTED] cc: Subject: Re: [PHP-DB] Extracting values from an array (I think) If you have to assign 24 unique variables rather than storing this data in an array, then you could apply some variable variable action. Here is a code sample that assumes you are looping through a result set from a database: query ="SELECT short_label FROM config ORDER BY meter_num"; $result= @MSSQL_QUERY($query) or die("Can't connect or something painfully obscure"); while($row = mysql_fetch_assoc($result)) { ${$short_label}=$row["short_label"]; } That will, I believe, give you a list of variables/values such as: $short_label_1 = short_label_1 $short_label_2 = short_label_2 You can also adjust the variable name to your liking, such as: ${$short_label._counterPerhaps}=$row["short_label"]; The above should be correct, but I do admit that I don't use this technique daily. To bad you cannot just throw your values into an associative array and pluck them when needed using $key => $value type of combinations. -John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Quering the mySQL DB for statistics results - best way of doing
Thanks for your ideas, im sitting here drinking beer and drinks, so Im having a little difficulty grasping the whole idea with this new SQl statement, but it works! Thanks a lot. To help the other people reading this who might not get it I did some benchmarking, my method (mentioned in the beginning in the thread) : Time -> 0.3663 I altered the routine, from 114 nested queries (my dataset) into 1 single query from Justin Patrin like this : $sql = "select ip, count(*) as ipcount FROM stats Group By ip"; $allrecords = query($sql); for ($i = 0; $i < mysql_num_rows($allrecords) ; $i++) { $record=mysql_fetch_object($allrecords); echo $record->ipcount . '-'; } Time -> 0.0101 Remarkable difference indeed! Im just happy that I just made 1 single report script at the moment using my rather terrible queries... :) Thanks for the help Justin! -- Kim Steinhaug --- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. --- "Justin Patrin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Whoops, forgot the rest of the fields. > > SELECT COUNT(*) AS count, * FROM stats GROUP BY ip > > Note that this will not work on Oracle and some other DBs. It will work > in MySQL. Oracle will only let you do: > > SELECT COUNT(*) count, ip, FROM stats GROUP BY ip > > Justin Patrin wrote: > > > You can do it all in one query, just as you're already doing it: > > > > SELECT COUNT(*) AS count FROM stats GROUP BY ip > > > > Kim Steinhaug wrote: > > > >> Hello, > >> > >> Im about to write a script that will generate several reports from > >> a database which loggs all visits. I see that my script will need > >> alot of queries against the database whenever a report is generated, > >> and I would love to get some input from you if my way of solving > >> this is bad. > >> > >> Example, I have a database filled with informations stored from > >> each visit, I will only focus on the IP data just here. What I want to > >> do is, pull out the visits ald present theese on the screen. This is 1 > >> query, and the result gives me a mile long page. To make it a little > >> better I want to group all the IP, this will give me a much shorter list. > >> From what Ive understood the "group by" statement will solve this, > >> but then I wont know the exact number of each IP. I therefore > >> need to do an extra database query for each and every IP, right? > >> > >> Look at this code : > >> > >> function query(){ // DB Abstraction layer } > >> $allrecords = query("select * from stats group by ip"); > >> for ($i = 0; $i < mysql_num_rows($allrecords) ; $i++) { > >> $record=mysql_fetch_object($allrecords); > >> $temp = mysql_fetch_object(query("select count(*) as count from stats > >> where > >> ip='".$record->ip."'")); > >> $ipcount = $temp->count; > >> echo 'Echo out needed $record data, this ip has ' . $ipcount . ' > >> entries.'; > >> } > >> echo $i . " Records total"; > >> > >> This code will generate a heck of a lot of queries againt the mySQL > >> database, but is it possible to do this another way? This is just one > >> problem, other reports may dig further into the database and require > >> more queries if using the above method. > >> > >> By the way, if you know of any recourses for report making and such I > >> would love to see them, :) > >> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Extracting values from an array (I think)
If you have to assign 24 unique variables rather than storing this data in an array, then you could apply some variable variable action. Here is a code sample that assumes you are looping through a result set from a database: query ="SELECT short_label FROM config ORDER BY meter_num"; $result= @MSSQL_QUERY($query) or die("Can't connect or something painfully obscure"); while($row = mysql_fetch_assoc($result)) { ${$short_label}=$row["short_label"]; } That will, I believe, give you a list of variables/values such as: $short_label_1 = short_label_1 $short_label_2 = short_label_2 You can also adjust the variable name to your liking, such as: ${$short_label._counterPerhaps}=$row["short_label"]; The above should be correct, but I do admit that I don't use this technique daily. To bad you cannot just throw your values into an associative array and pluck them when needed using $key => $value type of combinations. -John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Sessions and input form
Dear Jeffrey, Yes that is clear thank you... I have used this technique in the past But wanted to give sessions a try. I did manage to get it working. Seems That typing code at midnight can lead to frustrating and volatile results.. Thanks again for your response... Aleks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 12:30 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Sessions and input form Dear Aleks: What I usually do for a situation like this is... 1) User fills out form and data is INSERTed into the table. If you use auto_increment for the row id, use PHP's mysql_insert_id to get the id and use this for step 2. 2) Page confirms data by SELECTing the data from the MySQL table and inserting it into the form. 3) If the user makes changes, it is UPDATEd in the MySQL table. I hope this is clear. Good luck, Jeffrey Baumgartner > Hi all, > > I have a form that when populated and submitted is entered into a MySQL dB. > What I would like to do is be able to present the submitter with a > confirmation page listing the information from the form and then ask > them to confirm their submission. Also, if there is a problem or want > to change something, they can use the browser back button to go to the > previous page and make corrections. > > At first I thought that using Sessions to add the form values would > allow this to work.. I have gone threw this twice since last night and > find that my logic is flawed... It works once... then when another > submissions is attempted the process hangs and returns a CGI timeout. > > I am by no means a newbie but obviously I am not doing something right > with regards to session use. So I ask you more knowledgeable then I > for your input and advise. In hind sight I think my problem is that > once the information is confirmed and supposed to be entered into the > dB I am not destroying the session... Like I said, I think my approach > is all wrong here. I already have a login routine that uses sessions > and works flawlessly..[at least in appearance]. > > Any help would be very much appreciated. > > TYIA > > Aleks > > -- > PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: > http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Extracting values from an array (I think)
Hello All, I'm familiar and comfortable with selecting and utilizing one record at a time in my php-mysql gui / application. But now I'm faced with having to select one field from 24 records and assign the results to 24 different variables. Table structure: CONFIG +--+--+ | Field | Type | +--+--+ | meter_num | int(11) | primary key | x | double| | y | double| | z | double| | cc_val| varchar(64) | | cc_date | date | primary key | esn | varchar(64) | | dsn | varchar(64) | | csn | varchar(64) | | comm_setup| varchar(128) | | multi_port| varchar(16) | | threshold | double| | short_label | varchar(20) | | label | varchar(80) | | comments | varchar(255) | | mod_date | datetime | +-+--+--+---+ query ="SELECT short_label FROM config ORDER BY meter_num"; There will be 24 records max in this table, and meter_num is a primary key with values 1- 24 . If I run this query in the MySQL client, I get a result set like this: short_label_1 short_label_2 // // short_label_24 And I'd like to be able to do this: $sLabel_1 = short_label_1; $sLabel_2 = short_label_2; etc... These variables / values then get displayed in an HTML table in the appropriate place. I know that I can add a where clause to the query to select / assign each label individually, but that's 24 queries just for this one piece of data. Seems to me there must be a more efficient way to do this, but I'm runnin' out of ideas. Hope someone is thinking more clearly than I am right now. Thanks. David
[PHP-DB] Get query value from URL?
Hi, there, I am learning PHP/MySQL now, and got an sample code from http://hotwired.lycos.com/webmonkey/99/21/index3a_page3.html?tw=programming, but when I test the code on my machine, it does not work as it suppose to. What it should do is: when you first run the php code, it gives the names of the employees, each of which creates a link to the detail info, for example, %s %s\n", $PHP_SELF, $myrow["id"], $myrow["last"], $myrow["position"]>. When you click any name, it should get the query value($id) from the URL, and use it to search in the database. It seems can't get the $id from the URL querystring, i.e., the html page does not change after I click a specific name. The code is the following: ", $myrow["first"]); printf("Last name: %s\n", $myrow["last"]); printf("Address: %s\n", $myrow["address"]); printf("Position: %s\n", $myrow["position"]); } else { // show employee list $result = mysql_query("SELECT * FROM employees",$db); if ($myrow = mysql_fetch_array($result)) { // display list if there are records to display do { printf("%s %s\n", $PHP_SELF, $myrow["id"], $myrow["first"], $myrow["last"]); } while ($myrow = mysql_fetch_array($result)); } else { // no records to display echo "Sorry, no records were found!"; } } ?> Any comments and suggestions are appreciated. -Mingyan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Quering the mySQL DB for statistics results - best way of doing
Whoops, forgot the rest of the fields. SELECT COUNT(*) AS count, * FROM stats GROUP BY ip Note that this will not work on Oracle and some other DBs. It will work in MySQL. Oracle will only let you do: SELECT COUNT(*) count, ip, FROM stats GROUP BY ip Justin Patrin wrote: You can do it all in one query, just as you're already doing it: SELECT COUNT(*) AS count FROM stats GROUP BY ip Kim Steinhaug wrote: Hello, Im about to write a script that will generate several reports from a database which loggs all visits. I see that my script will need alot of queries against the database whenever a report is generated, and I would love to get some input from you if my way of solving this is bad. Example, I have a database filled with informations stored from each visit, I will only focus on the IP data just here. What I want to do is, pull out the visits ald present theese on the screen. This is 1 query, and the result gives me a mile long page. To make it a little better I want to group all the IP, this will give me a much shorter list. From what Ive understood the "group by" statement will solve this, but then I wont know the exact number of each IP. I therefore need to do an extra database query for each and every IP, right? Look at this code : function query(){ // DB Abstraction layer } $allrecords = query("select * from stats group by ip"); for ($i = 0; $i < mysql_num_rows($allrecords) ; $i++) { $record=mysql_fetch_object($allrecords); $temp = mysql_fetch_object(query("select count(*) as count from stats where ip='".$record->ip."'")); $ipcount = $temp->count; echo 'Echo out needed $record data, this ip has ' . $ipcount . ' entries.'; } echo $i . " Records total"; This code will generate a heck of a lot of queries againt the mySQL database, but is it possible to do this another way? This is just one problem, other reports may dig further into the database and require more queries if using the above method. By the way, if you know of any recourses for report making and such I would love to see them, :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Quering the mySQL DB for statistics results - best way of doing this
You can do it all in one query, just as you're already doing it: SELECT COUNT(*) AS count FROM stats GROUP BY ip Kim Steinhaug wrote: Hello, Im about to write a script that will generate several reports from a database which loggs all visits. I see that my script will need alot of queries against the database whenever a report is generated, and I would love to get some input from you if my way of solving this is bad. Example, I have a database filled with informations stored from each visit, I will only focus on the IP data just here. What I want to do is, pull out the visits ald present theese on the screen. This is 1 query, and the result gives me a mile long page. To make it a little better I want to group all the IP, this will give me a much shorter list. From what Ive understood the "group by" statement will solve this, but then I wont know the exact number of each IP. I therefore need to do an extra database query for each and every IP, right? Look at this code : function query(){ // DB Abstraction layer } $allrecords = query("select * from stats group by ip"); for ($i = 0; $i < mysql_num_rows($allrecords) ; $i++) { $record=mysql_fetch_object($allrecords); $temp = mysql_fetch_object(query("select count(*) as count from stats where ip='".$record->ip."'")); $ipcount = $temp->count; echo 'Echo out needed $record data, this ip has ' . $ipcount . ' entries.'; } echo $i . " Records total"; This code will generate a heck of a lot of queries againt the mySQL database, but is it possible to do this another way? This is just one problem, other reports may dig further into the database and require more queries if using the above method. By the way, if you know of any recourses for report making and such I would love to see them, :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Sessions and input form
Dear Aleks: What I usually do for a situation like this is... 1) User fills out form and data is INSERTed into the table. If you use auto_increment for the row id, use PHP's mysql_insert_id to get the id and use this for step 2. 2) Page confirms data by SELECTing the data from the MySQL table and inserting it into the form. 3) If the user makes changes, it is UPDATEd in the MySQL table. I hope this is clear. Good luck, Jeffrey Baumgartner > Hi all, > > I have a form that when populated and submitted is entered into a MySQL dB. > What I would like to do is be able to present the submitter with a > confirmation page listing the information from the form and then ask them to > confirm their submission. Also, if there is a problem or want to change > something, they can use the browser back button to go to the previous page and > make corrections. > > At first I thought that using Sessions to add the form values would allow this > to work.. I have gone threw this twice since last night and find that my logic > is flawed... It works once... then when another submissions is attempted the > process hangs and returns a CGI timeout. > > I am by no means a newbie but obviously I am not doing something right with > regards to session use. So I ask you more knowledgeable then I for your input > and advise. In hind sight I think my problem is that once the information is > confirmed and supposed to be entered into the dB I am not destroying the > session... Like I said, I think my approach is all wrong here. I already have > a login routine that uses sessions and works flawlessly..[at least in > appearance]. > > Any help would be very much appreciated. > > TYIA > > Aleks > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PostgreSQL
On Monday 24 November 2003 10:58 am, David Kendal wrote: > Hello! I'm new to to Postgre so excuse me, but is Postgre the same as > MySQL? Yes and No. Both are databases. Both can be interfaced to php. But Under the hoods of both, are very different. For more information, http://www.mysql.com/ http://www.postgresql.org/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PostgreSQL
Hello! I'm new to to Postgre so excuse me, but is Postgre the same as MySQL? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Send formmail data to Email and Database
What a sweet way to greet someone on their first post! Nice to meet you too! Some lists want code off the bat and some do not! Now I know it's ok to post it without it being requested. --begin-- function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } $editFormAction = $HTTP_SERVER_VARS['PHP_SELF']; if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) { $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING']; } if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO comments (FIRST_NAME, LAST_NAME, EMAIL, COMMENTS) VALUES (%s, %s, %s, %s)", GetSQLValueString($HTTP_POST_VARS['FIRST_NAME'], "text"), GetSQLValueString($HTTP_POST_VARS['LAST_NAME'], "text"), GetSQLValueString($HTTP_POST_VARS['EMAIL'], "text"), GetSQLValueString($HTTP_POST_VARS['COMMENTS'], "text")); mysql_select_db($database_connGlobal, $connGlobal); $Result1 = mysql_query($insertSQL, $connGlobal) or die(mysql_error()); $insertGoTo = "insertOK.php"; if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } ?> Customer Service
The International Car Rental Specialists Customer Service We value your comments and questions. Please fill out the form below and we'll be sure to answer as quick as possible. http://www.friendlyhousebuyers.com/cgi-sys/formmail.pl"; method="POST"> First Name Last Name Email Address Comments Enter your comments end-- howard grämer New York City [EMAIL PROTECTED] From: Neil Smth <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Send formmail data to Email and Database Date: Mon, 24 Nov 2003 08:28:25 + Since you didn't feel it necessary to include your form processing code, and as we're not mind readers, we are unable to help you. Sorry, better luck next time. Cheers - Neil. At 07:57 24/11/2003 +, you wrote: PHP List stats since 1997: http://zirzow.dyndns.org/html/mlists/ From: "howard gramer" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Sun, 23 Nov 2003 18:49:23 + Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: <[EMAIL PROTECTED]> Subject: Send formmail data to Email and Database (newbie alert!) DWMX, Host: PHP, MySQL, Sendmail, and my own Cgi-Bin I had the database action working well. But then trying to get the email to work I had to switch their positi
[PHP-DB] Re: Send formmail data to Email and Database
Since you didn't feel it necessary to include your form processing code, and as we're not mind readers, we are unable to help you. Sorry, better luck next time. Cheers - Neil. At 07:57 24/11/2003 +, you wrote: PHP List stats since 1997: http://zirzow.dyndns.org/html/mlists/ From: "howard gramer" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Sun, 23 Nov 2003 18:49:23 + Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: <[EMAIL PROTECTED]> Subject: Send formmail data to Email and Database (newbie alert!) DWMX, Host: PHP, MySQL, Sendmail, and my own Cgi-Bin I had the database action working well. But then trying to get the email to work I had to switch their positions in the code. Email now on top and database on bottom. So now the database action is not activated. How can I get the form data to post to the email and the database? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Quering the mySQL DB for statistics results - best way of doing this
Hello, Im about to write a script that will generate several reports from a database which loggs all visits. I see that my script will need alot of queries against the database whenever a report is generated, and I would love to get some input from you if my way of solving this is bad. Example, I have a database filled with informations stored from each visit, I will only focus on the IP data just here. What I want to do is, pull out the visits ald present theese on the screen. This is 1 query, and the result gives me a mile long page. To make it a little better I want to group all the IP, this will give me a much shorter list. >From what Ive understood the "group by" statement will solve this, but then I wont know the exact number of each IP. I therefore need to do an extra database query for each and every IP, right? Look at this code : function query(){ // DB Abstraction layer } $allrecords = query("select * from stats group by ip"); for ($i = 0; $i < mysql_num_rows($allrecords) ; $i++) { $record=mysql_fetch_object($allrecords); $temp = mysql_fetch_object(query("select count(*) as count from stats where ip='".$record->ip."'")); $ipcount = $temp->count; echo 'Echo out needed $record data, this ip has ' . $ipcount . ' entries.'; } echo $i . " Records total"; This code will generate a heck of a lot of queries againt the mySQL database, but is it possible to do this another way? This is just one problem, other reports may dig further into the database and require more queries if using the above method. By the way, if you know of any recourses for report making and such I would love to see them, :) -- Kim Steinhaug --- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php