PHP :: Best Way To Record "Date" In MySQL

How To Make A "sophisticated" Insert Record Form ?
I have a DB with many inter-related tables (MySQL)
My main table called "content" has almost only foreign keys (integers)
some have a 3 level relation (ex: content->city->region->country)

I would like admins to be able to insert new records including all the
"content" fields (in 1 page form)

But how can I make an insert form that would display the related
tables as list menus instead of a textfield with a number? (ex: select
country from a drop down menu instead of typing the foerign key
number)

Main content Table:
IDRef = primary key
IDLocation = foreign key --related to tables city->region->country
IDDescription = foreign key --related to table Description (=several
big and small text fields)
IDImages = foreign key --related to image (=image and thumbs path, alt
text, etc..)

Do you know any tutorial, help or solution ?

How Do I Do Something Like $color = ("red", "yellow", "blue")[$colornum]?
How do I take an index of a literal array, instead of a variable?

That is, say I want to get the short name of a month. Can I do
something like:

$monthname = ("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
"Sep", "Oct", "Nov", "Dec")[$month];

or do I always have to do:

$blah = array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug",
"Sep", "Oct", "Nov", "Dec");
$monthname = $blah[$month];

It seems a shame to have to create a variable specifically for this
one-shot purpose.

Mysql/php - "LIMIT" And "ORDER"
In the following fragment of code, I am querying a database that in order to display a list of films. The list is very long and I would like to offer the possbility to restrain the range of results showned by page keeping in mind that the user should be able to browse forward or backward data if applicable. I know that I have to add the LIMIT method in the MySQL query but I have a hard time figuring how not to get lost in setting it dynamically in the PHP script.

Then I have a second question. Is there a more elegant / straightforward way to deal with the display order of the data (cf. $ot, $od and $oy)? Code:

Sticking "if" Or Changes Within A MySQL "where" Array?
I'm not exactly sure how to even ask the question, and I know my terminology
is not good as I'm a SQL beginner, but, here goes.

I need to find a way to make an if statement within an array...or, the
"while" portion of a recordset.

The best way I can ask is show what I mean.
http://oscarguy.mechphisto.net/awardbrowse.php
If you go there and select an award (like Best Picture), leave the year
field alone, and select YES and submit, you'll see a lot of results. And I
have HR's dividing each entry.

What I need to do is group all the entries of the same year, or at least
only put HR's between the blocks of years.
So, I'd have all the entries for 2002, an HR, then all for 2001, an HR, etc.

Here at the bottom I'll include my PHP code I'm using so far.
But I have no idea where to even start looking for an answer...if it's even
possible.
If someone can just give me the name of the function or process or
technique, then I can go Web/book searching myself...I just need a direction
of where to go.

PHP:------------------------------------------------------------------------
------
$query_RS_award = "SELECT * FROM $award WHERE id != Ƈ' ORDER BY year DESC,
w DESC";
//$query_RS_award = "SELECT * FROM $award WHERE year =
"$year"";
$RS_award = @mysql_query($query_RS_award, $connection) or
die("Couldn't query: " . mysql_error());
$totalRows_RS1 = mysql_num_rows($RS_award);
while ($row_RS_award = mysql_fetch_assoc($RS_award)) {
$award_id = $row_RS_award['id'];
$award_tblid = $row_RS_award['tblid'];
$award_award = $row_RS_award['award'];
$award_year = $row_RS_award['year'];
$award_category = $row_RS_award['category'];
$award_won = $row_RS_award['w'];
$award_film = $row_RS_award['film'];
$award_nominee = $row_RS_award['nominee'];
$award_note = $row_RS_award['note'];
if (!($award_category)) {
$award_category = "n/a";
} else {
$award_category = $award_category;
}
if ($award_won == "1") {
$award_won = " - Award Winner";
} else {
$award_won = "";
}
$display_block_Award .= "YEAR: <span
class='normalText12White'>$award_year</span><br>FILM: <span
class='normalText12White'>$award_film</span><br>CATEGORY: <span
class='normalText12White'>$award_category</span><br>NOMINEE: <span
class='normalText12White'>$award_nominee</span><span
class='normalText12BoldWhite'>$award_won</span><br><blockquote><span
class='normalText12White'>$award_note</span></blockquote><hr>";
}

Preventing Visitors Ability To "re-visit" A Page Via The "back Button"..
I have a rather complex registration/member sign up form.. which gets a little confused, when a visitor "backs" completely out of the form, then for whatever reason returns to the form. The form contains 'cancel' buttons, which naturally cancel the reg process and redirects them to the document just before they started.

JS provides us with the "location.replace()" method, but I can't seem to find a way to coordinate the use of location.replace() with the posting of the form values. In short, I want to "replace" the first step of the form with the "second step".

I think what's making this tricky, is that each step of the form are located within the "same" page (register.php). The document works like so: The first step is the "Member Agreement" when they click "agree" (submit) the system creates a new row in the temporary register table of the db.

It then issues a registration cookie, which carries the row id, and session value. in addition (for those cookie impared users) we carry the row id and session value in hidden elements. So far, as long as the user continues through the process all is fine, but if they (for whatever reason) back all the way out, and click 'agree' again, the process fails.

I guess I have to find a way to force a reload of the 1st step "if they've gone back" OR "replace()" the first step with the second, so as to prevent the user from going "back" to the 1st step of the register page.

Errors Won't Show Up Even With Error_reporting(E_ALL) And Ini_set("display_errors","1")
Here's my code:

<?php

error_reporting(E_ALL);
ini_set("display_startup_errors","1");
ini_set("display_errors","1");

wefw
wefwef=wefwe
2349023909()
;wrgwrg ====232

phpinfo(); ?>

I get a blank page.

If I take out the crap, it prints phpinfo() just fine.

PHP 4.3.something...

Pagnation - Limit Number Of Pages Between "Previous" & "Next" Hyperlinks
Was hoping for some advice with a part of page navigation....

It works at the moment so there is a "Previous" & "Next" Hyperlink underneath the records. In between the Previous & Next links are the number of pages that there is of these records. e.g:

Previous 1234 Next

This is fine if there are only a few pages of records, but when there are hundreds of pages the numbers are listed and they take up half the web page with them.

How can i make it so only limited 10 numbers of pages say appear between the "Previous" & "Next" Hyperlink and as you progress through the pages they are as do the next 10 numbers of pages? Code:

Setting The "Joined Date" In Phpbb_users Table?
My Saga of integrating phpbb with my own logon system is coming to an end! At the moment when I do an insert into the phpbb_users table the user's Joined Date always sets as "Joined: 01 Jan 1970" . . clearly you dont have to be a webmaster to know thats wrong.

In the field user_regdate it seems to store the date as "1182625180" normally. However when I try and insert the date with my own insert statement, it goes in as a general date format "Tue 26th Jun,2007 04:20 pm" but still displays as..

[regex] Stripping Out "name" And "value" Values Out Of Tags, Aaargh
Searched through the site, but couldn't find the right regex syntax I was looking for.

the thing i want is, to extract with preg_match_all the given values in a tag...

ex.

$str = '<input type="text" name="name" value="value">'
$pattern = some magic stuff I need to know
preg_match_all($pattern, $str, $result);

And in result I want to have the values text, name and value AND it's important that the order doesn't matter
so structure of tags can be <input type =name= value=> or <input name= class= value= type=> etc, etc...

Group Mailing, Want To Suppress All The "to" Addresses In The "to:" Field
I want to do a mass emailing for a club.
I don't want all the clubs members to see all the addresses of the
other club members for privacy reasons.

How do I set up the php mail function to not display the recipients
email addresses, just to display something like, "U7 Soccer Club
Team"?

'Parse Error' Problem In "isset" And "empty"
I've been having some problems with a parse error that I can't figure
out (PHP 4.3.11 on Solaris9). Sample code:

<?php
// getting strange parse errors on this
class A {
var $value;
function A() {
$this->value = 1;
}

function getValue() {
return $this->value;
}
}

$a = new A();
if (!empty($a->getValue())) {
echo "success";
}
else {
echo "failure";
}
?>

The result of this is:

Parse error: parse error, unexpected '(', expecting ')' in
/foo/public_html/parse_errors.php on line 15

I also get the same effect with "isset", however, testing with "is_null"
or "is_int" produces the correct ("success"/"failure") result. Any ideas?

Beginner Problem - Using Date("M", $i) Where $i Is An Integer
I am trying to use the following function:

echo date("M", $i)

to echo the date that the value of a variable, $i, represents (eg. 1 =
Jan, 5 = May, 11 = Nov). Unfortunetely, it returns only Jan for any
number which I assume is the 1970 date that this function returns when
you screw up. I know that when I have the string value of &#55614;&#57157;-05-01'
in a variable, I have to convert it in the following function:

echo date("M", strtotime($strdate))

Is something similar required when I use an integer?

"unexpected Error In Date()"
Could anybody explain to me the cause of an unexpected error in date() after calling the function several times.

"unknown Date" Via Mail()
Probably something simple but all email I send via mail() is received
with an "unknown date" stamp. Am I missing something in my header?
Code as follows:

*****************************
<?php
$headers = <<<END
From: this@email.com
Date: $date
X-Mailer: PHP v$phpversion
MIME-Version: 1.0
Content-Type: multipart/related; boundary="$boundary"
END;
$date = date("D M j G:i:s T Y");
$Email = 'me@myemail.net'
$subject = 'Test Email'
$message = 'test message'
mail($Email,$subject,$message,$headers);
********************************

Date("d")-1 Does Not Work On The 1st Of The Month
Clearly the sql statement below will not work properly on the 1st of the month. The only way I can think of to fix this is using php's mktime(). Is there a better way to fix it?
Code:

$sql = "SELECT COUNT(id) FROM bonds WHERE applyDate = '".(date("Y")."-".date("m")."-".(date("d")-1))."'";

Echo (date("l")-1); Outputs '-1'?
What is the deal (date("l")-1) does not work, but (date("d")-1) works like a charm...I don't get it.

".$data['date']." Formatting
When I insert ".$data['date'].", I receive the date as 2007-10-05.

How can I get this data to display as Friday, October 5, 2007 (%W, %M %e, %Y)?

Echo "";
I have a search script which returns a page of results, however I'd like the returned page to be in the same format as the rest of my site.
To do this I've tried adding the HTML for my site to my PHP page with echo" " commands. This works for the plain HTML, but my regular pages also use SSI to do other stuff (some of them even execute other PHP scripts to generate tables of data etc). I've tried

echo "";
but it doesn't work as I get a parse error. My question is, how do I go about doing this properly? Is this possible at all? And if not have you guys got any suggestions to get around this?

Any File Size Limit In <PARAM Name="***" Value="***"> ?
I embed an applet in my php script which has a parameter providing an
input file for the jar. Does this file has size limit?

The code is as follows:
<APPLET ARCHIVE="myapplet.jar" WIDTH=372 HEIGHT=360 VSPACE=0 HSPACE=0
ALIGN=middle>

<?php echo "<PARAM NAME="data" VALUE="myfile.">";?>

when "myfile" is beyond 15M, my applet cannot load sucessfully, but
while this file is limited like 5M or 7M, it works well.

Does anybody know is the reason caused by php script limit, applet
mechanism, or by different browser?

How To Do PHP "require()" Or TCL "source" In Bash Script
I can't figure out how to explain this any better than
this.

In PHP we have a command "require()" that obtains a file and logically
places it into another file.

I cannot figure out how to do this in bash script as the requirement
is necessary for a migration script to obtain the code from a .cfg
file and then be able for the "parent" script to run the code it
"imported" from the .cfg file, much like PHP's require() or TCL's
"source".

This is what I have so far and it fails:

if [ -f ivc.cfg ]; then
cat ivc.cfg
fi

Anyone really know bash script well please help, it's a barrier for me
not to be able to get just this one piece working.

Error In Page When Checking Http_get_vars("myvar") And "myvar" Was Not Passed In URL String
PHP, coming from ASP coding

if (HTTP_GET_VARS['b']==1){
print "Yes";
}else{
print "No";
}

when "b" is not passed via
(http://www.mydomain.com?b=1

an error occurs and the "NO" is printed but an error is printed too.

How can I check for the value of "b" so that no error occurs if b is
not passed??

example

http=www.mydomain.com

$myvar=HTTP_GET_VARS['b']

causes an error because
"b" does not exist (ie. its not passed in the URL string.

$myvar maybe evaluated as NULL or Empty but the error is printed in
the page, anyway.

From Select To Date("Y-m-d",?)
I am going nuts here.

I have 3 select forms for a birtday

<select name="bmonth">
<select name="bday">
<select name="byear">

$birthday = date("Y-m-d",(int)$_POST['byear'].'-'.(int)$_POST['bmonth'].(int)$_POST['bday']);

Date registerd is allways "1969-12-31" no matter what I select. Why?

Error Using Header("", FALSE) To Show Multiple Images From MySQL Db
Many people seems to have problems when displaying multiple images from their database (mySQL db). Often you can read error statements like "Header already sent out ...". To solve this, people often propose to use include files.

To keep the scipt it would be nice not having this problem, being able to sent out multiple headers to a browser without getting these error messages. In the PHP4 manual, we can read an option that can be added to the header statement, Header("xxx",FALSE). It would enable multiple headers to be sent out.

For instance the following statement:

while ($product = db_fetch_object($result)) {
header("Content-type: pv($product->filetype)",false);
echo pv($product->image)"
}

However, it doesn't work. Anybody has any idea why? Does anybody use this option FALSE with success?

Reading An Array Of Records From MYSQL Then "Save As" Them Back As Copy
Hi all,

Ok here is what I want to do then I will show you what I have. I have some records in a MySQL DB that I want to store in an array and then immediately copy them back where the only thing that would change would be one field - the date. So here is my table:
-------------------------------------
|userName | date | value |
--------------------------------------
| theDano | 200005 | 123 |
--------------------------------------
| theDano | 200005 | 345 |
--------------------------------------
| theDano | 200004 | 678 |
--------------------------------------
| joeUser | 199908 | 897 |
---------------------------------------

So if I am querying for the user "theDano" on a specific date (format yyyymm) in this case 200005 (year 2000 month of May)

Here is my array to query all records to fullfill this request:

if ($update=="future")
{
if ($month!="01")
{
$db = mysql_connect("localhost", "dbuser");
if($db)
{
mysql_select_db("dbName",$db);
$result = mysql_query("SELECT * FROM tableName WHERE userName = '$userName' AND date = '$date' ORDER BY value DESC ",$db);
if ($result)
{
$num=mysql_numrows($result);
$i=0;
while($i < $num)
{
$userName = mysql_result($result,$i,"userName");
$value = mysql_result($result,$i,"value");
echo "<tr>";
echo "<td width=Ê×'>" . $userName . "</td>";
echo "<td width=ï`'><div align='right'>" . $value . "</div></td>";
echo "</tr>";
++$i;
}
}
}
}
}

Now I want to take the array of records queried which was:

| theDano | 200005 | 123 |
--------------------------------------
| theDano | 200005 | 345 |

and copy them to look like this back into the database:

| theDano | 200006 | 123 |
--------------------------------------
| theDano | 200006 | 345 |

so you can see that the only thing changed was increasing the month by one. Would seem simple to most but I am having a tough time wirting the code to read the array and increase each date value by "1".

Thank you in advance for anyone that replies. )

Dano

"Supplied Argument Is Not A Valid MySQL Result Resource"
this is one of the first scripts im writing completely by myself but its driving me crazy. the errors its returning are:

Quote: Warning: Supplied argument is not a valid MySQL result resource in c:apachehtdocsquiz_chap12_view.php on line 16

There are currently in the table: PHP Code:

Why Is My MySQL Table Building An "Overhead"/what Is That/how Can I Prevent It?
I hope you'll be nice to me and let this post go through even know its
mysql and not directly php. But of course my script is php.

The problem is, that my Table (1,8 MIO entries/100 MB/MyISAM) is not
working anymore. Everytime my script wants to write in something the
number of entries decreases, and at the "Overhead" column the number is
growing.

How can I make my table work without that overhead problem, without any
further crashes and without loosing my data?

If I use the repair or optimize function (phpmyadmin) the overhead is
deleted, but the data is still lost, and the next time my script trys
to put in something more entries will be deleted.

PHP/MySql On Window XP "Wrong Username/password"
I installed both, 1st mysql 4.1.7 but heard there was a change
with password hashing so now got 4.0.9

Basically when I choose a page with php_info() I can load it fine,
but when I call a php page with mysql connections I get an Window NT
prompt, which I type either mysql or window username/password
combinations and always get "Wrong username/password"

Any idea what it might be...all permission on the directory are open
for IUSER_MACHINE name which is the account that anonymous access users
come in on. Other pages seem fine, but one that want mysql access do
this funny thing...I did the default mysql installation I think root
password was blank, I set it to something else, but now when I login
using the mysql command line it doesn't like the password I just set...

Problem With ""s Entering Stuff Into A MySQL Database
I have a database which is going to be used partly to store articles, which will basically be free-flowing text. So what if someone puts a single comma ' in? Because I am using the PHP:

$query = "INSERT INTO quasimodo VALUES ($iNum,'$area','$sec1','$sec2','$sec3','$name','$phone','$email','$body')";

So surely when someone types the words it's or something like that with an apostrophe in the middle, it'll screw everything up? The stuff will be entered through a form. Please, how can I get around this problem? A similar problem would arise if i used "$body" instead of '$body' because someone might put a word in "inverted commas".

What Can Cause Mysql To Crash Resulting In "table In Use" Message.
Does this problem sound familiar to anyone? What can be done to prevent the mysql connection from dropping?

Symptoms:

-Simple insert takes "unlimited" time, just stays in processlist.
-I got a 100% idle processor
-Mysql is shutdown until i run mysqld_safe again or reboot, but the tables that i was inserting are in use and unusable after this.

"Please Wait" Page While Php Runs Mysql Queries
Does anyone have any idea what I should google to create a "splash page" that tells the user to wait while a few mysql quieries are run through the php page? It takes anywhere from 5 to 20 seconds, and I don't need a progress meter, just a splash page so they do not go anywhere and the user doesn't think there is a problem with their browser or network connection.

Coding "NEXT" And "PREVOIUS" Buttons
Hi

I am stuck here. I am doing a form which dispalys details of client companies. My query includes this statement:

.... WHERE CompanyName LIKE %$name% ....

What I need is following: if a query returns more then one result I what to "flip" through result with NEXT and PREVIOUS buttons.

Cookies And "include" Or "require"
i'm having a problem with my setcookie() instructions. Although there are absolutely
no html tags in front of them,for some reason PHP3 sends me back the message "oops...php3_SetCookie called after header has been sent"...

I do however use two "require" calls, one to a file with a .php extension, and one to a file with an .inc extension. At the beginning of each files there's a Could the cookie failure and the include functions be related ?

In my text, I have even wiped out any HTML tags such as "bold, paragraph, line break" tags, even in "echo" commands, but to no avail what am i doing wrong ?

FTP_login + $pass="" And $user=""
I use the following scrit in an Intranet with the user name = "" and
the password = "" :

<?php
$ftp_server = "192.168.25.25";
$ftp_user = "";
$ftp_pass = "";

$conn_id = ftp_connect($ftp_server) or die("Couldn't connect to
$ftp_server");

if (@ftp_login($conn_id, $ftp_user, $ftp_pass)) {
echo "Connected at $ftp_user@$ftp_server
";
} else {
echo "Can't connect with $ftp_user
";
}
?>

I have the following message :

Connected to 192.168.25.25
Warning: ftp_login(): 'USER': Invalid number of parameters in
E:www est_ftp.php on line 26

I tried to : ftp_login($conn_id, "", "") but i have the same result...

Alphabetize Results Ignoring "and" And "the"
is there a good way to alphabetize results and ignore articles like "the", "and", "a", and "an" so that it will alphabetize by the next word? just wondering...

Why Use "Stripslashes" And "Addslashes" Function
Can someone let me know why one would use strip slashes or add slashes functions. I know what they do but cannot see the exact use for them e.g. if i have a textfield and encase it in an stripslashes function, it will escape any back slashes etc...

Check Variable Against A List (cf. Mysql "in")
Is there a PHP way to see if a variable is a member of a list? E.g. I want to know if $a is in the following list: "apple", "orange", lemon". I know I could loop through an array of values, or I could do a series of "or"s in an IF statement, but I'm looking for something easier and more elegant.

I know in mysql, I could do a query like 'select * from table where id in ("value1", "value2", "value3")'..

Php+mysql "article Read By" Or Similar
I have an article system which has a very simple user registration system which has usernames and passwords. These are stored in a mysql table called users.
I then have another table called catagories which will list 5 or so different catagories.
There is another table called articles which has all the articles in. All articles have a unique ID.

What i'm looking for is a way so a user can login and view articles that he/she has not read. I also want to be able to mark a whole catagory as read (I can easily do that once i get the first bit sorted) but my main concern right now is how do I store what articles a specific user has read?

I'm using php and mysql running on a cpanel hosting account. If anyone has any ideas and if possible example code to help me along then I would be very greatful. I'm not asking to do it all for me, just point in the the right direction with what should be stored where and what to use to check what.

One idea I had was have another field in the users table and give each user a unique ID, then have another field in the articles table and list all the ID's that have read it. I just cant seem to find a reliable way to store/check if a user has read a particular article.

Checked Mysql Work Back "ok" Or..
how can i make custom page to checked if Mysql is connect/work/online and if it is ok back "ON" if not back "OFF"?

Mysql Field. "" Or Empty?
how would i check if a mysql field is empty.

is it better to use ""

or is there some special function that checks if the field is empty?

Mysql Command "for Each Entry"?
I've got my database with the ID field being a auto-incrementing index. Now, I also have a field myID, which I want to keep as a identifying number of each record, from 1 to whatever - without the gaps that exist in ID from records being deleted. I now have it set up to delete the column and re-create it, but I know this is not efficient. Is there any other way to do this? My only other thought is to use code similar to this:

function resetMyID($table) {
$result = mysql_query("SELECT * FROM $table", $link);
$count = 0;
??? for each successive entry {
??? $query2 = "UPDATE $table SET myID = $count WHERE ???";
mysql_query($query2);
}}

I can't say where id= whatever, because the id has holes in it ... any ideas?

Repopulate "select" From Mysql
I have a form that is use to add new and update members. There is a "select" list used as a category for these members. I would like to use the same list for the update of the member. But when I select the data from mysql and repopulate the form, it does not select the same category as was originally put in, it defaults to the first category on the list. Below is a snip of my code. This is the form I am using for both new and updated members.

<tr>
<td align="right" width="250"><font face="Verdana" size="2">Category filed under
</td>
<td><select name="category" value="<? echo $row[category] ?>"size="1" width="50">
<option value="act">Accountants</option>
<option value="ad">Advertising and Media</option>
<option value="ads">Advertising Specialties</option>
<option value="ag">Agricultural Services</option>
<option value="air">Airport</option>

HELP "Cannot Load Mysql Extension"
Fedora Core 2 server with httpd-2.0.54-10.2 php-4.3.10-2.4
php-mysql-4.3.10-2.4 It had MySQL 3.23.58.something on it, but the PHP
websites were using a 4.something MySQL on another machine. I updated
the MySQL on this machine to mysql-4.1.20-1.FC4.1 and now no PHP sites
come up. But mysql.so is right where it's always been:

[root@web1 abtech]# ls -l /usr/lib/php4/mysql.so
-rwxr-xr-x 1 root root 44364 Dec 21 2004 /usr/lib/php4/mysql.so

And the extension line has been commented out of /etc/php.ini and Apache
restarted.

Parse Errors With "case "action":
I want to call an action that is in a file called "configm.php" but I get a parse error on line 8. (the bit that goes 'case "add":') Code:

Extracting Specified "ID" (Mysql DB)
Okay, here goes nothing.

the scenario:
Database contains the data of "2" types:
Type A
Type B

Type A's data is displayed on a document, on only type A's, with a "Previous" and "Next" link at the bottom of the page.

Now, since the database table contains both type and a and b information, this is where my delimma comes in.

TO setup those back/next links, I must obtain the ID value for the back/next rows. And these values should only be a row which contains the data for, in this example, Type A data.

How do I pull this off?

Naturally I would have to find all the rows which contain type A data. Then obtain their row Numbers.

Let's just say for argument sake, there are 5 rows of data.

1 - Type A
2 - Type B
3 - Type A
4 - Type A
5 - Type B

I enter viewing record number 3, my next
button should be for row 4, and my previous should link to row 1.

Since those are the previous and next rows containing "TYPE A" data..

Best Way To Record "Date" In MySQL

which is the most convenient way to record a date (i.e. 2005-12-12) into a MySQL database and then easily manipulate it in PHP...?