HelpPlease

Joshy

I am new to php and mysql and am working on a site were it requires me to learn it. Been working hard to figure it out and it has been paying off. But came accross like everybody else into a block. I have 3 questions:
thanks in advanced.

Allow for hidden values of current Date and Time(eastern) to be inserted in the database.

Ex.
<?
function insert_data($date)
{

$date = date("Y-m-d H:i:s");

The date and time should not be visible in the html page but once the user finishes the registration process, the TD should be stored in the database with the rest of the information.

I have 3 form elements. Once the information has been submited. It should be stored into one table column in the database.

Ex.
xxx - xxx - xxxx

Example of this is a phone field with auto tab(working fine) there is 3 fields one for area code, then the 3 numbers and last 4 #.
Had it in the databse as separete colums but the client did not agree.

Validating a State List/menu.
I have all the states in a list, the user should not be able to proceed untill he selects a state.
Was able to get the checkboxand radio buttons to work. but cant get the State List.

any help will be appreciate it :-)

id10t

1) I've not had the pleasure of playing with php and mysql, but in mssql there is a sql command getdate()... so just use the equiv in mysql ...values(getdate(),'Foo','Bar'.42)

2) Just concatenate them together at some point.

3) use --pick one-- as the first value of the select, and have your validation script check the value of it.

bastien

Allow for hidden values of current Date and Time(eastern) to be inserted in the database.

Ex.
<?
function insert_data($date)
{

$date = date("Y-m-d H:i:s");

$thedate=now();

though the simple way to so this is to make the date field a timestamp and have it set automaticallywhen the rest of the data is inserted

The date and time should not be visible in the html page but once the user finishes the registration process, the TD should be stored in the database with the rest of the information.

I have 3 form elements. Once the information has been submited. It should be stored into one table column in the database.

Ex.
xxx - xxx - xxxx

so three text boxes

p1, p2 and p3

to cobmbine them use the concatenation operator (.) the period

$phone=$p1."-".$p2."-".$p3;

may need to modify the above for $-POST OR $_GET depending on version of php

Validating a State List/menu.
I have all the states in a list, the user should not be able to proceed untill he selects a state.
Was able to get the checkboxand radio buttons to work. but cant get the State List.

you don't say whether you want to do this client side (via javascript) or serverside with php (generally doing both is a good idea)
so javascript:

<script langauge = javascript>
function state_set()
{
if (form.state.value!=""){
form.submit();
}
}
</script>

then in the form tag
<form action="insert.php" method="post" onSubmit="state_set();">

to fire the function whent the form is submitted...
the above assumes that
1. the text box is called state
2. the initial option in the select box is
<option value="">Choose state</option>

php version

if (!isset($_POST['state'])){
echo "you have not included a state. please choose one";
show_form();
}

what i do is to make each form a function in a common.php page that i include and can call...this allows the form to be used to modify existing data by using the value attribute of the element's tag

echo "<input type='textbox' name='firstname' value='$fname'>

if the value is not set from a db call for data then the text box is empty, if there is data from a db call, the box then has that data

hth

bastien

Joshy

bastien
I have this code put together, But still cant get it to work.

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "loginDetails")) {
$insertSQL = sprintf("INSERT INTO Users (FirstName, LastName, Address1, Address2, City, State, Day, Evening, Email, password, iAgree. DateTIme) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($HTTP_POST_VARS['FirstName'], "text"),
GetSQLValueString($HTTP_POST_VARS['LastName'], "text"),
GetSQLValueString($HTTP_POST_VARS['Address1'], "text"),
GetSQLValueString($HTTP_POST_VARS['Address2'], "text"),
GetSQLValueString($HTTP_POST_VARS['City'], "text"),
GetSQLValueString($HTTP_POST_VARS['State'], "text"),
GetSQLValueString($HTTP_POST_VARS['p1."-".p2."-".p3'], "text"),
GetSQLValueString($HTTP_POST_VARS['p4."-".p5."-".p6'], "text"),
GetSQLValueString($HTTP_POST_VARS['Email'], "text"),
GetSQLValueString($HTTP_POST_VARS['password'], "text"),
GetSQLValueString($HTTP_POST_VARS['Y-m-d H:i:s'], "text"),
GetSQLValueString(isset($HTTP_POST_VARS['iAgree']) ? "true" : "", "defined","'Y'","'N'"));

and I did understand the state validation up to a point.

and

id10t

Thanks 2

bastien

from your code is that there are some extra quotes in the sql statement

$insertSQL = sprintf("INSERT INTO Users (FirstName, LastName, Address1, Address2, City, [/b]State[b], [/b]Day[/b], Evening, Email, password, iAgree. DateTIme) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",

try taking them out

also you mentioed that you understand the state validation thing up to a point, what point?

Joshy

Am about to try your recomendation on the sql statement.
About the state, I just figured out, appreciate it.

Joshy

I did the fix up and am getting this
"Column count doesn't match value count at row 1"
It looks like a database issue?
Ill Keep looking into it.

Bastien dont mean to bother u but i have another question I have this password reminder. the user inputs there email. and the password is sent to them. The Script is working fine but when i ad the extra code to retrive the users name ($FirstName)and email it to them, They recive there name the same as the password

}
else // email password
{
mysql_connect($DbHostName,$DbUserName,$DbPassWord) or die("Sorry, the system is unable to communicate with database. Please try again in a few minutes.") ;
mysql_select_db($DatabaseName) ;

$result = mysql_query("select password FROM $userDatabase WHERE Email='$email'");
while ($row = mysql_fetch_row($result)) {
$password = $row[0];
if ($password <> "") {

mail("$email", "$title Login Details", "
Dear $FirstName,

Thank you for requesting your password for

Your User ID is: $email
Your Password is: $password

Sow the $FirstName name would be the remaining retrival.
Makes sense?

bastien

$result = mysql_query("select password, firstname FROM $userDatabase WHERE Email='$email'");

Joshy

Ur the Man

$result = mysql_query("select password, firstname FROM $userDatabase WHERE Email='$email'");

Is working. The funny thing is, that is retriving the name in lower case. 😃

bastien

[man]str_to_upper[/man]
[man]str_to_lower[/man]

functions for converting case

Joshy

bastien

I ended up getting to work the time/date and the State validation.

But am still stuck with -->

"to cobmbine them use the concatenation operator (.) the period

$phone=$p1."-".$p2."-".$p3; "

<---
I put a hiden valude and inside it I created this..

value="<? echo $phone=('$p1."-".$p2."-".$p3')"; ?>">

Is working but not properly, the only thing beeing stored is the letter p1.
any suggestions.

bastien

GetSQLValueString($HTTP_POST_VARS['p1."-".p2."-".p3'], "text"),
GetSQLValueString($HTTP_POST_VARS['p4."-".p5."-".p6'], "text"),

from your earlier piece of code then

you may need to take each item separately

GetSQLValueString($HTTP_POST_VARS['p1'], "text"),
GetSQLValueString($HTTP_POST_VARS['p2'], "text"),
GetSQLValueString($HTTP_POST_VARS['p3'], "text"),

then on the server before the insert combine them

$phone = p1."-".p2."-".p3;

I also find it easier not to use the vairable syntax for the sql statement, I build all mine explicitly to allow me to further manipulate the data before moving to the database...

insert into table (phone) values($phone);