Re: [PHP-DB] Executing a query in the future
cron? or if on windows they have a scheduler, and then just run a command line PHP script that checks due dates and sends out emails as necessary, not sure you need a web page to send out email notifications... -B Mark Bomgardner wrote: I am looking for a way in PHP to execute a query at some point in the future. Here is my example; I am writing a page to checkout laptop computers to instructors. I want the person that checks out the laptop to receive an email when the laptop is close to being to, but I want this to be automated. I don't want to have to pull up a page everyday to run the query. Is there something that can run in the background that can run a page at varying intervals? markb -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] use of str_split
This was my initial thought too, but from the manual: If /delimiter/ is an empty string (""), *explode()* will return *FALSE*. If /delimiter/ contains a value that is not contained in /string/, then *explode()* will return an array containing /string/. So, this would not satisfy the functionality the OP alluded to. -B Bastien Koert wrote: explode(delimiter, $string); is the correct function Bastien> Date: Thu, 9 Aug 2007 04:53:53 -0700> From: [EMAIL PROTECTED]> To: php-db@lists.php.net> Subject: [PHP-DB] use of str_split> > Hi> > when i try to use this function> > > str_split()> > it shows me as invalid function> > > what is solution> > i want to split certain length of string into an array> > > bye> > > > > > Asim Jamil - 0092 345 4025907, Pakistan> > -> Luggage? GPS? Comic books? > Check out fitting gifts for grads at Yahoo! Search. _ Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] use of str_split
Looks like the function str_split() is a PHP 5 addition, so I guess it might be because you are using php 4? You can also do this with substr() function... Something like this: HTH -B Asim wrote: Hi when i try to use this function str_split() it shows me as invalid function what is solution i want to split certain length of string into an array bye Asim Jamil - 0092 345 4025907, Pakistan - Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL BETWEEN Problems
Try using the substr, since you are only comparing the first letters... (sorry I did not reply all on the other email, Dan) i.e. select name from users where substr(name, 1, 1) >= 'A' and substr(name, 1, 1) <= 'B'; -B Dan Shirah wrote: So just change it to WHERE last_name BETWEEN 'A' AND 'G' . That'll get you Aa-Fz :) On 5/18/07, Tony Grimes <[EMAIL PROTECTED]> wrote: We tried that and it didn't work. We've also tried every combination of upper and lower case too. Tony On 5/18/07 2:18 PM, "Brad Bonkoski" <[EMAIL PROTECTED]> wrote: > I think you need between 'A' and 'F%' > > Aa is between A and F > but 'Fa' is not between 'A' and 'F' > (but 'Ez' would be between 'A' and 'F') > -B > > > Tony Grimes wrote: >> I'm using BETWEEN to return a list all people who's last names fall between >> A and F: >> >> WHERE last_name BETWEEN 'A' AND 'F' ... >> >> but it's only returning names between A and E. The same thing happens when I >> use: >> >> WHERE last_name >= 'A' AND last_name <= 'F' ... >> >> Shouldn't this work the way I expect it? What am I doing wrong? >> >> Tony >> >> > -- 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] MySQL BETWEEN Problems
I think you need between 'A' and 'F%' Aa is between A and F but 'Fa' is not between 'A' and 'F' (but 'Ez' would be between 'A' and 'F') -B Tony Grimes wrote: I'm using BETWEEN to return a list all people who's last names fall between A and F: WHERE last_name BETWEEN 'A' AND 'F' ... but it's only returning names between A and E. The same thing happens when I use: WHERE last_name >= 'A' AND last_name <= 'F' ... Shouldn't this work the way I expect it? What am I doing wrong? Tony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] echo
elk dolk wrote: thanks to Chris and Dimiter, I think I am close but still the problem is not solved, when I add echo " to the code as it was sugested by Dimiter there is parse Error : PHP Parse error: syntax error, unexpected $end in C:\Inetpub\wwwroot\album\show.php on line 44 line 44 is end of the code just after what does it mean? probably you don't have a semi colon at the end of your echo line nor is there and end double quote. I am storing just the name of photos in the database and the photos are in /img folder ,and there is no permissions issue. My testing server is IIS And the path would be something like this : Inetpub\wwwroot\album\img as I am running out of time! could someone complete this code just with one echo and img src so that I can retrive my photos ? MySQL columns : photoID=seq number photoFileName=name of my photo like 3sw.jpg title=title description=short description - while ($row = mysql_fetch_array($result)) { echo " } mysql_free_result($result); ?> - Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Creating a Table to line query results in php?
How can I create a table...or even something similar...to line information up? echo ""; echo "Header1Header2Header N"; while ($data = mysql_fetch_array($res)) { $idfield = $data['IDFIELD']; $name = $data['Name']; $effect = $data['Effect']; $category = $data['Category']; $origin = $data['Origin']; $image = $data['Image']; echo ", $name, $effect, $category, $origin"; echo "$name$effect$category$origin"; } echo ""; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with ocilogon
Dominik Helle wrote: Hi, I've a problem with php-oci and I hope anybody can help me. I want to connect with ocilogon to an Oracle Database. If i call my php-Script in the browser, this error message turn up: Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in... That is very funny, because if i activate the file on the command line - the connect is possible and no error message turns up. FYI: My System: Ubunutu 6, Apache 2 and php 5-with-oci & Oracle Database 10g (10.1.0.2). Thank you for helping. Dominik I'm assuming since you mention the apache, this is a web application... It looks like the ORACLE_HOME path is not know by apache/PHP. So, you might try stopping apache, and doing something like 'source /etc/profile' or wherever your ORACLE_HOME env variable is set, and then restarting apache and trying again... HTH -B -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SQL Query - Using variable from another SQL Query
Matthew Ferry wrote: Hello Everyone Got a simple / stupid question. Worked on this all night. I'm over looking something very basic here. The query "event_time" brings back the calendar id for each event that is pending in the future. ie 12, 13, 14, 26 (There could be 100 of them out there) The second query "events" needs to meet both reqirements. 1 - cal_category='501' 2 - cal_id= a number from the "event_time" query I think i need to do a loop inside of a loop Thanks... Matt Here is my code: $tstamp", $db); This returns a mysql result set...not the actual data... search php.net for the function mysql_fetch_array or others to actually *get* the data. (Some good examples there will help you sort this out!) $events = mysql_query("SELECT * FROM egw_cal WHERE cal_category='501' and cal_id='$event_time'\n", $db); if ($event = mysql_fetch_array($events)) { echo "\n"; echo "\n"; do { echo "$event[cal_title]- $event[cal_location]\n"; echo "\n"; echo "$event[cal_description]"; echo "\n"; echo "\n"; } while ($event = mysql_fetch_array($events)); } else { echo "No Public Events Are Currently Scheduled..."; } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Installation Problem
Check out the installation instructions for Windows... MYSQL support is not working with your PHP, if memory serves me correctly you just need to uncomment a dll in your php.ini file, but check out: http://www.php.net/manual/en/ref.mysql.php -B Abdou Karim Jallow wrote: I have just upgraded to PHP 5.2 from PHP 4. I am using Apache 2 with MYSQL. Before the upgrade, everything was working well. (Was able to connect to my MYSQL database from PHP interface. However, now with the same PHP codes, I am not able to connect to the MYSQL database instead I am getting errors such as: *Fatal error*: Call to undefined function mysql_connect() in *C:\Program Files\Apache Group\Apache2\htdocs\viewusers.php* on line *7 Line 7 is: $dbc = mysql_connect ('localhost') OR die ('Could not connect to mysql: ' .mysql_error() ); *However, this was working fine before the upgrade. WHAT DO I NEED TO DO. In a second attempt to fix the problem, I dited the system path to the directory where php is installed. Now the error message is gone but still cannot to the database. Whilst I tried to retrieve data from the database using the PHP scripts, nothing comes from the database. Also I tried to post but the data is not put in the data.base Note when I upgraded to PHP 5, I still left the PHP 4 files in the computer. PLEASE HELP ME -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Simple question on auto_increment
mario wrote: Hello, really a mysql question. Pls. help anyway. Is there a simple, common way to implemt the following: Say I have a table with a id autoincrement field. I wish to insert a record but just ist id value, get back the id value, use it to update the record. Do I need three separate mysql queries? Is there some trick I may use? Thanks Regards mario www.php.net/mysql_insert_id --or-- www.php.net/mysqli_insert_id (of course for your example to work all the other fields would have to be nullable) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with Oracle query
Rosen wrote: Hi, I have a problem with PHP and Oracle SQL query. I have 2 tables : Table Main: --- id number text varchar2(100) Table Recs --- id number pos number log varchar2(200) I need to make query to select a list from first table(Main), where somewhere in the second table (Recs), the log field contains some string. The records for one ID from Main table can be many in table Recs. ( Table Recs acts as log for every row from table Main). Can someone help me with this query? Thanks in advance, Rosen select m.id, r.log from main m left outer join recs r on r.id = m.id This will output something like: Id log 1log item 1 1log item 2 1log item 3 2another log etc... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] textarea value assignment
[EMAIL PROTECTED] wrote: Hello how I could assign a textarea with a variable value? Although I tried to achieve an allocation like a normal The code looks like following fragment. $problem_val = mysqlclean($_SESSION, "problem_eb", 500, $connection); cols="1" rows="1" name="problem_eb" value=""> Best regards, Joerg Kuehne There is no value attribute of textarea...to put text in there, you place it between the tags. i.e. cols="1" rows="1" name="problem_eb" > -B -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Page refresh and database updation
I'm sure there are many ways... a few off the top of my head. a). if there is some field or combination of fields that guarantee uniqueness then you can test for their existence before you insert. b). When you insert the first time set some session variable to something, and then don't insert if that session variable exists. c). have some middle page that does your insertion and then immediately redirects to another page which displays results, but has not more POST data associated with it, so refreshing that page will not cause a re-post of your data. HTH -B Tamkhane, Pravin wrote: Hi All, I am a PHP newbie. I am using HTTP POST request to send some data to Apache and then using MySql to store that information. Once information is stored in MySql DB successfully, I display a result page. But the problem I am facing is that, if I refresh the result page displayed after database updation, the information is stored again in database which I don't want to. Please guide me on how I can avoid duplication of information in database on refreshing the page. Thanks in advance! Regards, Pravin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] posting information from a textarea
stripslashes should not be needed... if anything addslashes() may be needed if you have single quotes in the text area. I would say step 1 is to echo out your insert query to the page before you even excute the insert, to verify the query, and that you are getting the proper information from the form. -B Dave W wrote: I seem to be having a problem posting text from a text area. I have a form that posts data into a database and there are input fields which seem to post the data fine. I know this because the entry is changing in the database, but the text area text doesn't seem to be posting. I double checked to make sure i got the names right, but it still doesn't seem to be working. Before I put it into the database I'm using stripslashes. I thought that might of been the problem and I changed it to trim, but that didn't work. In the database, the field that I'm putting it into is a longtext type with fulltext. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Select distinct field won't return distinct value
Perhaps you should fix your data model... but with your current set up, try: select cus_name, cus_id from customers group by cus_name order by cus_name asc -Brad Mohamed Yusuf wrote: I want select distinct field and return value of that field, but I have problem which is: select distinct returns duplicate value. eg, I wan select distinct customer name and id from the customer table. one customer may have different cus_ids since cus_ids are auto increment and depend on the purchased items. so what I want is to select distinct customer name so that I can print customer name and customer id once. here is algorithm; select distinct cus_name, cus_id from customers order by cus_name asc While row is not empty do{ echo"costomer name"; } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] odbc_exec error
Scott Wettstein wrote: I'm pretty new to PHP so I need help. I'm getting this error: Error in updating SQL PHP Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2., SQL state 07001 in SQLExecDirect in c:\Inetpub\wwwroot\shout.php on line 77 Lines 76 and 77: $sql="UPDATE shout SET UserName=$laName,Message=$laMessage WHERE Dat=$laDate"; $updating=odbc_exec($conn,$sql); where $laName, $laMessage, and $laDate are from a POST. I've checked my spelling a million times and changed the names of variables. Why is it still complaining? Please help! it says a SQL error ;-) I would check to see if you need quotes around your variables... like: $sql = "update shout set UserName='$laName', Message='$laMessage' where -Brad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Combining Fields
Grae Wolfe - PHP wrote: Thank you Brad - That is what I was looking for, but now that I see how it behaves, I am thinking that it isn't going to work the way I wanted. I need to then be able to pass the "ID" back to MySQL so that it will retrieve just the one record for editing. I guess I need to go back to making the DB create an auto-incrementing ID number. Hmmm... Thanks!! Well, the unique ID would probably be the *best* way to go, but you could also get the record with the below solution, of course this requires every combination of first and last name is unique... if you do: $id = "Smith,Adam" Then: list($fname, $lname) = explode(",",$id); select * from table where first_name = '$fname' and last_name='$lname' would do the trick... Of course this has many "what-ifs" asociated with it...all of which would be taken care of with an auto-incrementing/primary key ID field for wach record ;-) -Brad "Brad Bonkoski" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Grae Wolfe - PHP wrote: Good Day! I am trying to use my limited knowledge to create a VERY simple process to display some of the information in my table, allow a particular record to be selected, then opened on a page with text boxes to edit the information, after which the UPDATE command will be used to update the database. That being said, I have a way that I think this will work, but I don't have a unique record number in my table for each of the entries. I have tried getting PHPMyAdmin to set this up, but I cannot seem to make it work. SO - I need to try to create that ID on the fly. I figured I could just combine the first and last names to make this ID, but I am not sure what the syntax should be. Here is the code I have dealing with defining the variables... Any help or thoughts would be splendid! while ($row = mysql_fetch_array($result)) { $id = $row['last_name'],$row['first_name']; $fname = $row['first_name']; $lname = $row['last_name']; $option_block .= "$lname, $fname"; Use the dot (.) for appending variables... so it would be: $id = $row['last_name'].$row['first_name']; ...or course if you want that would look like this: 'SmithAdam' if you want 'Smith,Adam' as your id then: $id = $row['last_name'].",".$row['first_name']; -Brad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Combining Fields
Grae Wolfe - PHP wrote: Good Day! I am trying to use my limited knowledge to create a VERY simple process to display some of the information in my table, allow a particular record to be selected, then opened on a page with text boxes to edit the information, after which the UPDATE command will be used to update the database. That being said, I have a way that I think this will work, but I don't have a unique record number in my table for each of the entries. I have tried getting PHPMyAdmin to set this up, but I cannot seem to make it work. SO - I need to try to create that ID on the fly. I figured I could just combine the first and last names to make this ID, but I am not sure what the syntax should be. Here is the code I have dealing with defining the variables... Any help or thoughts would be splendid! while ($row = mysql_fetch_array($result)) { $id = $row['last_name'],$row['first_name']; $fname = $row['first_name']; $lname = $row['last_name']; $option_block .= "$lname, $fname"; Use the dot (.) for appending variables... so it would be: $id = $row['last_name'].$row['first_name']; ...or course if you want that would look like this: 'SmithAdam' if you want 'Smith,Adam' as your id then: $id = $row['last_name'].",".$row['first_name']; -Brad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] allow-url-fopen setting
Manoj Singh wrote: Hello all, Can i change the "allow-url-fopen"(php.ini variable) setting through php code. If any one knows how to do that, please help me. Regards Manoj http://www.php.net/manual/en/ref.filesystem.php Note: This setting can only be set in php.ini due to security reasons. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How can I get in PHP the number of files in a directory
http://www.php.net/manual/en/ref.dir.php suad wrote: Hi, This is for reading a file: How can I get in PHP the number of files in the directory (rasmus) and the files names in a loop? Thanks Suad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL/PHP Left Join Question
Some good examples of how to deal with this in PHP have already been given, especially the associative array solution. The question I have is with something like this, how do you weight out the pros/cons of code development versus speed? i.e. for code development breaking the logic up into 2 queries would yield a much more readable result, but speed wise what is better multiple queries with smaller more precise record sets, or having PHP parse through the result set to properly weed out duplicate titles based on the outer join applied? This is assuming that there is no SQL construct to solve this problem, which personally I know of none. -Brad Andrew Darby wrote: Hello, all. I don't know if this is a php-mysql question or just a mysql, but here goes: I have a list of DVDs that my library loans out, and I'd like to allow people to add comments to each item. Since this list gets regenerated periodically (it's extracted from another system, the library catalog), there isn't a consistent ID in the dvd tables, so I'm using the call number (which will look like DVD 2324) as the key. Anyhow, I join the tables like this to get all the DVDs and all the comments associated with the DVDs: SELECT distinct dvds.title, dvds.publisher, dvds.publication_date, dvds.call_number, comment.id, comment.parent_id, comment.comment, comment.name FROM dvds LEFT JOIN comment ON dvds.call_number=comment.parent_id WHERE dvds.title LIKE 'A%' ORDER BY dvds.title With this, I'll get results like DVD 101A.I. This movie rocked DVD 101A.I. This Movie stunk DVD 102Adaptation . . . DVD 103After Hours . . . When I loop in PHP through the records, of course, I want just the one DVD with however many comments associated with it. Is it possible to do this (i.e., screen out DVD dupes) in MySQL, or do I have to do it in PHP? If this is a dumb question, my humblest apologies, and I'd be interested if there was a better way to handle this . . . . Andrew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Pulling data - stops at spaces
How does the data look in your actual database? Perhaps it was not inserted correctly in the first place? Andres Figari wrote: Hello, I am sort of new to php and mysql (in regards to experience with it as a programmer), so my apologies for the silly questions :) I am trying to pull text that was entered into a table. See code below. The only problem seems to be with lines like this: $rows .= 'Video Title:name=video_title value='.$row['video_title'].' type=text maxlength=60>'; Say the title is "the title", it only pulls out "the". I am wondering if I am using the wrong method for pulling the data, or if I should correct the way I am doing it. Looking at php.net I see these: http://www.php.net/manual/en/ref.msql.php Any suggestions for an alternative method? thank you for your help :) Andres /* Connecting, selecting database */ $link = mysql_connect($mysql_host, $mysql_user, $mysql_password) or die("Could not connect : " . mysql_error()); mysql_select_db($mysql_db) or die("Could not select database"); /* Performing SQL query */ $query = "SELECT * FROM video where video_id=$video_id"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); $query2 = "SELECT * FROM artist"; $result2 = mysql_query($query2) or die("Query failed : " . mysql_error()); /* Converting result of ad_type query into array */ if ($result) { $row = mysql_fetch_array($result); $rows .= 'Video ID: '.$row['video_id'].''; $rows .= 'value='.$row['video_id'].' type=hidden size=20>'; $rows .= 'Video Title:name=video_title value='.$row['video_title'].' type=text maxlength=60>'; $rows .= 'Recording Label:type=text maxlength=60>'; $rows .= 'HTML Attributes'; $rows .= 'Title - HTML Tag:type=text maxlength=60>'; $rows .= 'Video URL:name=video_url value='.$row['video_url'].' maxlength=60>'; $rows .= 'Keywords - Meta Tag:value='.$row['video_meta_keywords'].' maxlength=847>'; $rows .= 'Description - Meta Tag:value='.$row['video_meta_description'].' maxlength=150>'; $rows .= 'Abstract - Meta Tag:value='.$row['video_meta_abstract'].' maxlength=150>'; $rows .= 'Genres Below (more than one can be selected)'; $rows .= 'Electronica:type="checkbox" name="video_category_electronica">'; $rows .= 'Rock:type=checkbox name=video_category_rock>'; $rows .= 'HipHop:type=checkbox name=video_category_hiphop>'; $rows .= 'Eclectic:type=checkbox name=video_category_eclectic>'; $rows .= 'Humor:type=checkbox name=video_category_humor>'; $rows .= 'Other:type=checkbox name=video_category_other value='.$row['video_category_other:q'].'>'; } /*Converting result of artist query into array */ if($result2){ $num_rows2 = mysql_num_rows($result2); for($i=0;$i<$num_rows2;$i++){ $row2 = mysql_fetch_array($result2); $artist_choice .= 'value='.$row2['artist_id'].'>'.$row2['artist_name']; } } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Date Conversion
Mark Bomgardner wrote: PHP 4.4/MySQL 4.0 I am tying to convert a date to put into a database from a string (ie: January, February) to a numeric value (ie: 01,02). I am taking the value from a form, which is a drop down menu listing the months. $sMonth1 = $_POST['Smonth']; returns the money selected from the form. When I go to format the month from a string to numeric with date('m',strtotime($sMonth1)); it returns 12, no matter which month I select. In reading the docs at php.net, date('m',strtotime($sMonth1)); is correct to reformat from a string to a time format. What am I missing. mark bomgardner An idea along a different path would be for your original select box where you pick the month do something like this: January Febuary Then the value passed to your form will be the numeric representation of the month so there will be no need to translate the String --> number.. HTH -Brad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MD5, MySQL, and salts
This begs the question of what would this method buy you over MD5? Some people have "issue" with like passwords looking the same with MD5 encryption, also a one way hash. But if you know the salt, then like passwords would also look the same, right? -B Giff Hammar wrote: For an example, look at how UNIX/Linux stores regular login passwords. In short, the salt is the first two characters in the password. When comparing passwords, you take the salt and the user supplied password, encrypt, then compare the two encrypted strings. If they match, the recently supplied password matches the original. AFAIK, that is the only way to verify passwords encrypted with a one-way algorithm. Giff -Original Message- From: chris smith [mailto:[EMAIL PROTECTED] Sent: Monday, April 17, 2006 4:36 PM To: Sean Mumford Cc: php-db@lists.php.net Subject: Re: [PHP-DB] MD5, MySQL, and salts On 4/18/06, Sean Mumford <[EMAIL PROTECTED]> wrote: Hi Guys, I'm working on securing user passwords in a MySQL 4 database with a PHP5 frontend. I remember being told in one of my classes (I'm currently a college junior) that the best way would be to hash a salt and the password together and then store the hash in the database instead of the plain MD5 hash. My question is, what is a good method for the server and the database to agree on a salt value to use? I know i could use a predefined variable, but I was wondering if something dynamic might be better (timestamp, current date, something like that). Any ideas? Thanks in advance! If it's a dynamic salt, how are you going to access it when you have to compare ? There was an article either on phpsec.org or shiflett.org which talks about this.. can't find the link right now :( -- Postgresql & php tutorials http://www.designmagick.com/ -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Manipulate an image automatically
query google about imagemagick tutorialsassuming you are using Linux... -Brad Henry Ortega wrote: What is the quickest way to manipulate an image? I have a 300x100 image of something (template), and I want text to be inserted to that graphic at a certain coordinate (e.g. lower right), how would I do that? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] session
Look at the URL when you pass it? It does not show anything, in fact the session is still using cookies or other means to tansfer the data. You should also be able to sniff the data being passed by the URL and not see any of the session data. - Original Message - From: "H. J. Wils" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 17, 2004 10:17 AM Subject: Re: [PHP-DB] session hey thanx it works, but why is that? i mean, session are there to save data which te user cant see... isnt there another way to pass the SID? i have the feeling passing the SID trhough the url-paramters is harming the security, am i right? From: "Brad Bonkoski" <[EMAIL PROTECTED]> To: "H. J. Wils" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] session Date: Sun, 17 Oct 2004 09:46:06 -0400 MIME-Version: 1.0 Received: from pb1.pair.com ([216.92.131.4]) by mc5-f14.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Sun, 17 Oct 2004 06:47:55 -0700 Received: (qmail 35123 invoked by uid 1010); 17 Oct 2004 13:47:04 - Received: (qmail 33188 invoked by uid 1010); 17 Oct 2004 13:46:19 - X-Message-Info: JGTYoYF78jGDHqvDtc0+QckXsrFscNGe Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm Precedence: bulk list-help: <mailto:[EMAIL PROTECTED]> list-unsubscribe: <mailto:[EMAIL PROTECTED]> list-post: <mailto:[EMAIL PROTECTED]> Delivered-To: mailing list [EMAIL PROTECTED] Delivered-To: [EMAIL PROTECTED] Delivered-To: [EMAIL PROTECTED] Message-ID: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Symantec AntiVirus Scan Engine Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 17 Oct 2004 13:47:55.0249 (UTC) FILETIME=[E77EF610:01C4B44F] I believe you need to pass the session variable along to the next page... Something like: On page 1: if session is set { $s = SID; echo "Link"; } - Original Message - From: "H. J. Wils" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 17, 2004 9:38 AM Subject: [PHP-DB] session sorry, forgot to change the subject :), just to be sure here is my question again.. Hi everybody, For quite a while i'm struggeled with my session. It doesn't seem to work, can anyone help me? This is my code: page 1: session_start(); $_SESSION["test"] = "tryin..."; if (isset($_SESSION["test"])) { echo "next page"; echo "".session_id(); } page 2: session_start(); if (isset($_SESSION["test"])) { echo $_SESSION["test"]; }else { echo "No sessionvariable found.."; } echo "".session_id().""; On page two, there's always the 'no sessionvariable found...'-message, further the session id also changes... i dont understand what i am doing wrong... _ Play online games with your friends with MSN Messenger http://messenger.msn.nl/ -- 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 _ MSN Search, for accurate results! http://search.msn.nl -- 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] session
I believe you need to pass the session variable along to the next page... Something like: On page 1: if session is set { $s = SID; echo "Link"; } - Original Message - From: "H. J. Wils" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, October 17, 2004 9:38 AM Subject: [PHP-DB] session sorry, forgot to change the subject :), just to be sure here is my question again.. Hi everybody, For quite a while i'm struggeled with my session. It doesn't seem to work, can anyone help me? This is my code: page 1: session_start(); $_SESSION["test"] = "tryin..."; if (isset($_SESSION["test"])) { echo "next page"; echo "".session_id(); } page 2: session_start(); if (isset($_SESSION["test"])) { echo $_SESSION["test"]; }else { echo "No sessionvariable found.."; } echo "".session_id().""; On page two, there's always the 'no sessionvariable found...'-message, further the session id also changes... i dont understand what i am doing wrong... _ Play online games with your friends with MSN Messenger http://messenger.msn.nl/ -- 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] un-encrypting passwords
Typically in these systems you do not send them their password un-encrypted if they lose it because like you said, it is one way. Normally, you collect certain information to validate them, and then generate a new password to email them, so they can get it and once again reset their password if they so choose, or you could force them to. -Brad Sam Folk-Williams wrote: > Hi, > > I've got a PHP/MySQL site that uses a simple user table to check for a valid > username/password match when logging someone in. I encrypted the passwords > using mysql's PASSWORD() function. I now realize that was probably not the > best choice, because I don't think it's possible to un-encrypt them. I want > to add a feature that allows users to request to have their password emailed > to them. > > Can anyone recommend a better method for encypting passwords and how to > unencrypt? (is there a function in PHP for this? Or a different MySQL > function?) > > Thanks, > > Sam > > -- > Sam Folk-Williams > Service Team Leader/Webmaster > Rise, Inc -- Creative Partnerships South > (952) 884 8330 (V); (952) 884 8371 (F) > www.rise.org > > -- > 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] hi (php-SSH)
Well, SSH has a server which woudl answer your requests and a lient to initiate the session, I'm assuming you wish to emulate the client side to initiate the session, of course PHP is a server side language, so it's not adding up. I have seen a JAVA applet that will open in a web browser on the client side to enable you to run an SSH client, perhaps this will server your needs? Try a google search. -Brad Suman Aluru wrote: > hi , > is there any way to write a PHP program for SSH. > I want to establish a SSH connection and work some commands in the remote > system and close the connection. > > Thank You. > > -- > Suman R Aluru > System Administrator > Bacterial Barcodes Inc. > 8080 N.Stadium Dr. > Houston TX-77054 > 713.467.8500 (Off.) > 832.643.9501 (Cell) > > -- > 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] Bar codes in PHP
"CPT John W. Holmes" wrote: > PHP wouldn't have anything to do with it. Your barcode should "fill in" a > text area on a web page, which is the submitted to a PHP file for > processing. You'll need something client site to get the code from the > scanner to the web page. You wouldn't really need a special program, just get a scanner that plugs into the keyboard connection and click on the a text box and scan in, the scanner will then fill in the ASCII representation of the bar code. Or at least that is one option... > > > Unless you're talking about a program that acutally monitors the COM port > that the scanner is plugged into on the server? > > ---John Holmes... > > - Original Message - > From: "Norma Ramirez - TECNOSOFT" <[EMAIL PROTECTED]> > To: "lista php" <[EMAIL PROTECTED]> > Sent: Monday, July 28, 2003 3:19 PM > Subject: [PHP-DB] Bar codes in PHP > > Hi all, does someone know how to capture or read bar codes from php? It will > be great if I could do inputs to my database directly from bar codes in the > products. Ideas??? > Thank´s > Norma Ramirez > Area de Desarrollo Web > [EMAIL PROTECTED] > > -- > 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] MD5()
md5() is a one-way encryption algorithm. So once they are encrypted, you cannot decrypt them. Just look at the md5() function on the php website. It has what you need to do. Of course if you eventually need these back in the clear, then md5 would not be a solution. -Brad Chris Payne wrote: > Hi there everyone, > > I have to store some CC details in a database which are inputted from a form, is > MD5() the best way to secure the data? If so, how do I view MD5() data after it has > been inserted? Any good MD5() tutorials out there? > > Thanks for your help :-) > > Regards > > Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql wildcard
Well, if that is your only condition, why not use: 'select * from offtime' as your query? I believe the % as a wildcard is standard SQL, so I would *think* it should work in mysql, have you tried it? -Brad Edward Peloke wrote: > I have an query: > > select * from offtime where type='$type' > > then I just pass the type variable to the page. Is there a wildcard in > mysql like there is in sqlserver that I can use to grab all the records? > such as select * from offtime where type='%' would grab all. > > Thanks, > Eddie > > -- > 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] newbee in PHP-MySQL- help in relational tables
I would say, that MYSQL is a relational database, thus implying that tables would eb relational and this is a DB forum, so just shot, what's the problem? Phanivas Vemuri wrote: > hi, > I need to knwo if anyone had worked on a php interface for relational tables > in MySql. I have a problem , would be explaning the problem after anyone > responds. > Thankyou, > Phani. > > _ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > -- > 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] Beginner problem: let the user select 1 element
Check out: http://www.phpbeginner.com/columns/joel/mysql There are other tutorials there as well for other databases. Also, phpbuilder.com and devshed.net have good tutorials to check out. HTH -Brad [EMAIL PROTECTED] wrote: > Hi, > I have this problem. > I have a db and I want to let the user modify already inputted data: can > any one show me a way to handle this, I think common, problem, maybe by > showing me a tutorial? > Thanks > ANtonio > > -- > 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] little question from beginner
Well, I would look at 2 possible problems: 1). Submit is an HTML input type, and I would try to avoid using it as a script variable just to make sure avoid confusion. 2). You may not have register_globals turn 'on' in your php.ini file. So, if the form method is POST, try: $_POST['submit']. Or $_SERVER['submit'] HTH -Brad Hermanto Kurniawan wrote: > Hi, > I am having trouble with using PHP for submitting a form. > > I've defined all the inputs for the form. and the html for the button is > like this : > > > when I wanted to process the data of the form using : > if($submit){ > ...//my script here > } > > the browser tell the notice that variable submit isn't defined.. > > why??? thanks for answering > > _ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > -- > 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] database update question
If you wish to update all of them, then just eliminate the id condition. [EMAIL PROTECTED] wrote: > I have a database with several hundred entries of file names that end with > .pdf. I have converted > all those docs to .zip, now I need to change all the entries in the > database to .zip. I tried to use > update table_name set col_name='%.zip' where col_name like '%.pdf' && id > = '11' > but of course that changed the file name for id 11 to %.zip. Is there a way > to change all the > entries from .pdf to .zip without writing an update statement for each > individual row? > > -- > Chip Wiegand > Computer Services > Simrad, Inc > www.simradusa.com > [EMAIL PROTECTED] > > "There is no reason anyone would want a computer in their home." > --Ken Olson, president, chairman and founder of Digital Equipment > Corporation, 1977 > (They why do I have 8? Somebody help me!) > > -- > 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] Next N Interface
That would actually work for just getting a certain number of records from a query, but you would have to execute another query to figure out the navigational links he said he wants on the bottom...like google has, << 1 2 3 4 5 >>. So, when I attacked it I figured one query is better then two even if it returns a whole bunch of records in the result that you are not using for that page. How is that for performance? which would be better? Or even, is there an alternative way to figureing out how many records are in a database? Always more then one way to skin a cat. -Brad Mark Lee wrote: > How about appending " LIMIT _GET[startrow],5" to the end of your query. > > The first parameter to LIMIT is the start position and the second is > the number of rows to return. > > Does this help, or am I misunderstanding your question? > > Mark > > Lucas Novæ Matrix wrote: > > >Hello, > > > >I am trying to create a "next n" interface through php4, using results from > >a mysql query. I did this in the past easily with ColdFusion, but this time > >it's a bit more complicated. > > > >What I need to do basicaly is to have only 5 results per page. The first > >page displays the 5 results and "Next Page >>>" at the bottom, the second > >page displays results 6 to 10 and displays "<<< Previous Page | Next Page > > > " , up until the last page that displays only the previous page, and the > > >last results (from 1 to 5). > > > >I don't necessarely need to have each page as a number at the bottom, just > >the previous and next links. All I need basically is to either get or output > >only 5 rows at a time, with only needing the $_GET['startrow'] variable. > > > >Can anyone help me? (or just throw me a link to an existing page/script) > > > >Thanks, > >Éric. > > > > > > > > -- > 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] Next N Interface
I did something like this with a photo gallery I made. The approach I took is the execute a query, get the number of rows, and divide that number by how ever many records I wanted on that page. Then that would give me the number of total pages I would have for my navigational links at the bottom. Then I would pass a page number from page to page and multiply this by the number of records which would give me the first record to display from the same query. Soem sample code: (I displayed 4 pictures/records per page) $num_rows = mysql_num_rows($result); //Check to see if any rows are present if ($num_rows <= 0) { echo "No Pictures Available in this Album"; exit(1); } $x = ($num_rows/4); $y = intval($x); if ($x > $y) { $num_pages= $y+1; } else { $num_pages= $x; } $curr_row = ($curr_page*4); if ($DEBUG > 0) { echo "Curr_row is: $curr_row"; } mysql_data_seek($result, $curr_row); HTH -Brad "Lucas Novæ Matrix" wrote: > Hello, > > I am trying to create a "next n" interface through php4, using results from > a mysql query. I did this in the past easily with ColdFusion, but this time > it's a bit more complicated. > > What I need to do basicaly is to have only 5 results per page. The first > page displays the 5 results and "Next Page >>>" at the bottom, the second > page displays results 6 to 10 and displays "<<< Previous Page | Next Page > >>>" , up until the last page that displays only the previous page, and the > last results (from 1 to 5). > > I don't necessarely need to have each page as a number at the bottom, just > the previous and next links. All I need basically is to either get or output > only 5 rows at a time, with only needing the $_GET['startrow'] variable. > > Can anyone help me? (or just throw me a link to an existing page/script) > > Thanks, > Éric. > > -- > 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] Flush database
Sounds like we are all on similar pages with timestamping, but if you issue a delete query every time the page is viewed it could create some sub-par performance based on number of hits. i.e. if the site gets 100 hits in the first 10 minutes of operation, it would issue delete logic and queries 100 times, but since they are all *new* the logic would not really do anything, right? So, depening on what kind of traffic you plan to generate a cron job may be your best bet, if you plan to generate a whoel bunch, you may even need to kick it off every hour. -or- you could use this logic, but store in a different table a timestamp for "last delete" and every time view that timestamp, and if more then a hour has passed, then go ahead with your database clean-up routine. -Brad Jim Hunter wrote: > First make sure that you are storing the IP and the time it was saved in the > database. > > Then I would have 3 queries: > > 1) a query to see if the IP address is in the database and less then an hour > old. > > 2) a query to save the IP and time into the database > > 3) a query to delete all entries over 1 hour old. > > Then when you get a new visitor see if the IP address is in the database and > is not less then 1 hour old. Once it clears that test, save the IP and time, > then always run the delete query to clear out entries. If you have a lot of > traffic to your site you are going to generate a lot of database hits. > > Good luck. > > Jim > > > > ---Original Message--- > > > > From: wade > > Date: Friday, September 27, 2002 02:02:50 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Flush database > > > > I am storing IP addresses in a database, but after an hour has passed I > > want to delete all the IP addresses from that database. I want to do > > this based on the server time. Example.. Someone comes to my web page, I > > store their IP address in my database. So now I write a PHP script that > > says if that IP returns to my page within an hour, they can't view my > > page. If they come back after an hour has passed they can view the > > contents of that page. but only after an hour has passed. > > Can anyone help me with the syntax or functions that will clear the > > database after an hour of waiting has passed? > > Is this possible? Any suggestions, logic or any help on this matter will > > be greatly appreciated. > > Thank you > > -- > > Should you have any questions, comments or concerns, feel free to call > > me at 318-338-2033. > > Thank you for your time, > > Wade Kelley, Design Engineer > > > > Bayou Internet...(888) 30-BAYOU...http://www.bayou.com > > Mississippi Internet...(800) MISSISSIPPI...http://www.mississippi.net > > Vicksburg Online...(800) MISSISSIPPI...http://www.vicksburg.com > > > > -- > > 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] Flush database
How about writting the IP address to the database with a timestamp, then when a matching IP address arrives you view the timestamp and if it has been more then a hour, they can view the page, which would force you to update the timestamp. Of course you would probably need to write a stand-alone (i.e. non-web) php script that would act as a cron job to clean out the database periodically, whatever period you define (depending on traffic and size of DB). -Brad wade wrote: > I am storing IP addresses in a database, but after an hour has passed I > want to delete all the IP addresses from that database. I want to do > this based on the server time. Example.. Someone comes to my web page, I > store their IP address in my database. So now I write a PHP script that > says if that IP returns to my page within an hour, they can't view my > page. If they come back after an hour has passed they can view the > contents of that page. but only after an hour has passed. > > Can anyone help me with the syntax or functions that will clear the > database after an hour of waiting has passed? > Is this possible? Any suggestions, logic or any help on this matter will > be greatly appreciated. > > Thank you > > -- > Should you have any questions, comments or concerns, feel free to call > me at 318-338-2033. > > Thank you for your time, > > Wade Kelley, Design Engineer > > Bayou Internet...(888) 30-BAYOU...http://www.bayou.com > Mississippi Internet...(800) MISSISSIPPI...http://www.mississippi.net > Vicksburg Online...(800) MISSISSIPPI...http://www.vicksburg.com > > > -- > 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] Current row of query
Last I checked there was no way to retrieve the current index into the result array, you can set the index manually with mysql_seek_data(), but I don't think that is what you want, so the best solution IMHO, is to do what you are doing and manually keep track of the index. -Brad Patrick Lebon wrote: > Thanks, im currently doing something similar to this but I was wondering if > there was an already defined variable that i could use rather then have to > create a value and increment it myself. I guess am being picky, but was just > curious as im new to php. > > This is how im currently doing it... > > $rowNum = 0; > while ( $row = mysql_fetch_array($result) ) > { > $rowNum++; > if ($rowNum % 2) { $bgCol = "#EADBC6"; } else { $bgCol = "#EFE1CE"; } > echo ".."; > } > > "Brad Bonkoski" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > why not this? > > > > $result = mysql_query("Select * from table'); > > $num_rows = mysql_num_rows($rows); > > > > for ($i=0; $i<$num_rows, $i++) > > { > > $row = mysql_fetch_array($result); > > if ($num_rows is odd) > > { > > print $row with BG color of red; > > } > > else > > { > > printf $row with BG color of purple; > > } > > } > > > > HTH > > -Brad > > > > Patrick Lebon wrote: > > > > > Is there a mysql or array variable for the current row of a query array? > > > I want to alternate background colours for each row of the query output > so i > > > need to know the current row number. > > > > > > Thanks > > > > > > -- > > > 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
Re: [PHP-DB] Current row of query
then add an extra conditional to check if $i is equal to 0, or start $ off as 1so, for ($i=1, $i<$num_rows+1; $i++) -or- if ($i==0) //treat as even either way woudl work. -Brad "Hutchins, Richard" wrote: > Not sure here, but you might also run into a problem if you start your if > statement with $i=0. If PHP does not treat the value 0 as even or odd, your > first row is most likely going to be purple along with your second row. I > know it's nitpicky, but I could see myself spending half an hour trying to > figure out why the code works, but not the way I want it to. > > > -Original Message- > > From: Brad Bonkoski [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, September 26, 2002 11:10 AM > > To: Patrick Lebon; [EMAIL PROTECTED] > > Subject: Re: [PHP-DB] Current row of query > > > > > > oops... > > > > I meant: > > (if $i is odd) > > ... > > > > because $i would be the current index in the array. > > > > > > Brad Bonkoski wrote: > > > > > why not this? > > > > > > $result = mysql_query("Select * from table'); > > > $num_rows = mysql_num_rows($rows); > > > > > > for ($i=0; $i<$num_rows, $i++) > > > { > > > $row = mysql_fetch_array($result); > > > if ($num_rows is odd) > > > { > > > print $row with BG color of red; > > > } > > > else > > > { > > > printf $row with BG color of purple; > > > } > > > } > > > > > > HTH > > > -Brad > > > > > > Patrick Lebon wrote: > > > > > > > Is there a mysql or array variable for the current row of > > a query array? > > > > I want to alternate background colours for each row of > > the query output so i > > > > need to know the current row number. > > > > > > > > Thanks > > > > > > > > -- > > > > 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 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] Current row of query
oops... I meant: (if $i is odd) ... because $i would be the current index in the array. Brad Bonkoski wrote: > why not this? > > $result = mysql_query("Select * from table'); > $num_rows = mysql_num_rows($rows); > > for ($i=0; $i<$num_rows, $i++) > { > $row = mysql_fetch_array($result); > if ($num_rows is odd) > { > print $row with BG color of red; > } > else > { > printf $row with BG color of purple; > } > } > > HTH > -Brad > > Patrick Lebon wrote: > > > Is there a mysql or array variable for the current row of a query array? > > I want to alternate background colours for each row of the query output so i > > need to know the current row number. > > > > Thanks > > > > -- > > 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
Re: [PHP-DB] Current row of query
why not this? $result = mysql_query("Select * from table'); $num_rows = mysql_num_rows($rows); for ($i=0; $i<$num_rows, $i++) { $row = mysql_fetch_array($result); if ($num_rows is odd) { print $row with BG color of red; } else { printf $row with BG color of purple; } } HTH -Brad Patrick Lebon wrote: > Is there a mysql or array variable for the current row of a query array? > I want to alternate background colours for each row of the query output so i > need to know the current row number. > > Thanks > > -- > 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] SQL file,
I don't think it quite works that way through PHP. You could send the _contents_ of the file through PHP, like open the file, and read it into a buffer, and send that as a query. I actually create the files and then go into my database system (MySQL -or- PostgreSQL) and then execute a command. I think for MySQL it is: mysql> \i and then that will step through the file executing the SQL statements. -Brad Bryan McLemore wrote: > So I would send the file through with a sql query? > > -Bryan > - Original Message - > From: "Brad Bonkoski" <[EMAIL PROTECTED]> > To: "Bryan McLemore" <[EMAIL PROTECTED]> > Cc: "PHP DB LIST" <[EMAIL PROTECTED]> > Sent: Saturday, September 21, 2002 8:18 AM > Subject: Re: [PHP-DB] SQL file, > > > Typically, it is a text file that has SQL in it. > > Like: > > CREATE DATABASE some_name ( > > ID int NOT NULL AUTO_INCREMENT PRIMARY KEY, > > NAME varchar(30), > > etc > > > > Usually they are used to store the database information, and can be used > in many of the database systems. Within the database itself, there is a > command to insert from a file. Not sure off the top of my head, but the > help menu should provide that > > information, then the database would go through your file and execute > those commands as if you were entering them in manually on the command line. > Espescially helpful for huge tables where you might be open to a typo, and > have to start all over. > > HTH > > -Brad > > > > Bryan McLemore wrote: > > > > > in an example I saw in a book while I was leafing through it at barnes > and nobles I saw a .sql file. It appeared to have the schema for a db in > it. I was wondering what exactly what it is and how one could use it in a > php application like he was doing. > > > > > > Thanks, > > > Bryan > > > > > > -- > > 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
Re: [PHP-DB] SQL file,
Typically, it is a text file that has SQL in it. Like: CREATE DATABASE some_name ( ID int NOT NULL AUTO_INCREMENT PRIMARY KEY, NAME varchar(30), etc Usually they are used to store the database information, and can be used in many of the database systems. Within the database itself, there is a command to insert from a file. Not sure off the top of my head, but the help menu should provide that information, then the database would go through your file and execute those commands as if you were entering them in manually on the command line. Espescially helpful for huge tables where you might be open to a typo, and have to start all over. HTH -Brad Bryan McLemore wrote: > in an example I saw in a book while I was leafing through it at barnes and nobles I >saw a .sql file. It appeared to have the schema for a db in it. I was wondering >what exactly what it is and how one could use it in a php application like he was >doing. > > Thanks, > Bryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PhpMyAdmin's File Manager and apps
http://sourceforge.net/projects/phpmyadmin/ Russell Griechen wrote: > > Where are the downloads for these apps? > > Russell Griechen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Editor?
1). vi (The best editor for any language, IMHO) 2). Yes Bryan McLemore wrote: > First off, What html/php editor do you guys think is better? > > Secondly, perhaps a little more relevant to the database part of this. I just want >to clarify that with mysql_query() I can send any valid sql expression and it will do >that? > > -Bryan > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] database result: tables with 2 coloumns
How's this? (MYSQL example) $query = "select NAME from table_name"; $result = mysql_query($query) or die("Invalid Query: $query"); $num_rows = mysql_num_rows($result); $counter=1; echo ""; //start of table for ($i=0;$i<$num_rows; $i++) //loop through the number of records { $row = mysql_fetch_array($result); //Get associate row echo "$row[0]"; //Print out the NAME if ($counter == 2) { echo ""; //Make a new Table row $counter=1; //Reset Counter } else { $counter++; //Just increment the counter } } echo ""; mysql_free_result($result); HTH -Brad [EMAIL PROTECTED] wrote: > Hi.. > > I'm creating a database result in a table, but I need to put it into 2 > columns of looping row like this: > > |name1|name2| > |name3|name4| > |name5|name6| > |name7|name8| > |name9|name10 | > etc... > > can anyone help me please... > > iman > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Table formatting a link from a mysql query result
$variable_to_be_passed = 'some value'; echo "I am a link"; I think this should do it, not quite sure what you mean by wrappinga table cell in a anchor tag? Of course if you need to use the results of a database, this can be done too with the same method. HTH -Brad Aaron Merrick wrote: > All, > > How can I display the results of a table so that the first field (column) is > a link to another page that shows the details of that row? Issue #1, I have > to wrap the cell contents in an variable to the referenced page when the link is clicked. Anyone know of > any good examples of this? > > Thanks, > Aaron > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php