adrianle

So I have a client that wants me to add a function to her site that when she clicks a mailto href on a page to spawn an email child, some canned data chunk gets inserted into a form's textarea field.. something like: "Email sent to [email protected] on 8/14/14". I'm drawing a blank on how this might be handled.. any ideas out there??

Yup, just changed it to: GetSQLValueString($_FILES['uploadedfile']['name'], "text"), and things are much happier now. THanks for the pointers..

Here's the entire chunk currently ... <?php function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . date("Y-m-d",strtotime($theValue)) . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if (!isset($mm_abort_edit) || !$mm_abort_edit) { if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $target_path = "tagImages/"; $target_path = $target_path . basename( $_FILES['uploadedfile']['name']); if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) { echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded"; $uploaded_file = $target_path; // or $_FILES['uploadedfile']['name'] $insertSQL = sprintf("INSERT INTO TAGS (ImageName, TagTitle, Difficulty, LM, BU, BM, MT, VPLUS, Short, Voice, Favorite, Added) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['uploadedfile'], "text"), GetSQLValueString($_POST['TagTitle'], "text"), GetSQLValueString($_POST['Difficulty'], "int"), GetSQLValueString($_POST['LM'], "text"), GetSQLValueString($_POST['BU'], "text"), GetSQLValueString($_POST['BM'], "text"), GetSQLValueString($_POST['MT'], "text"), GetSQLValueString($_POST['VPLUS'], "text"), GetSQLValueString($_POST['Short'], "text"), GetSQLValueString($_POST['Voice'], "text"), GetSQLValueString(isset($_POST['Favorite']) ? "true" : "", "defined","1","0"), GetSQLValueString($_POST['Added'], "date")); mysql_select_db($database_DNSTags, $DNSTags); $Result1 = mysql_query($insertSQL, $DNSTags) or die(mysql_error()); } else{ echo "There was an error uploading the file, please try again!"; } $insertGoTo = "list_tags_new.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); }} ?>

Well I tried having the upload chunk in with the insert, and it DOES upload the file, but the filename is still null in the table.. $target_path = "tagImages/"; $target_path = $target_path . basename( $_FILES['uploadedfile']['name']); if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) { echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded"; } else{ echo "There was an error uploading the file, please try again!"; } ...is what I'm using...

So the code $_FILES['uploadedfile']['name'] you mentioned isn't IN my INSERT code.. so I'm unsure where you're getting this from. It does exist in the upload portion of the code but i'm not there yet. I'm just trying to get the insert working.

Yes, but then all that got inserted into the column was the word "Array"...

Yes, I'm primarily just focusing on the INSERT right now and will deal with the actual UPLOAD portion once I get this fixed. So what changes to this INSERT would you recommend to be sure that filename gets inserted?

So here's the form field in question: <form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="form1"> <table width="500" border="0" cellspacing="0" cellpadding="4"> <tr> <td>Choose Tag Image: </td> <td><input name="uploadedfile" type="file" /></td> </tr> <tr>...and the rest of the form code continues as normal and here's the insert... the behavior is that the column that's supposed to take the value from "uploadedfile" is NULL after insert: <?php function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue; switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . date("Y-m-d",strtotime($theValue)) . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if (!isset($mm_abort_edit) || !$mm_abort_edit) { if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO TAGS (ImageName, `Description`, Difficulty, LM, BU, BM, MT, VPLUS, Short, Voice, Favorite, Added) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['uploadedfile'], "text"), GetSQLValueString($_POST['Desc'], "text"), GetSQLValueString($_POST['Difficulty'], "int"), GetSQLValueString($_POST['LM'], "text"), GetSQLValueString($_POST['BU'], "text"), GetSQLValueString($_POST['BM'], "text"), GetSQLValueString($_POST['MT'], "text"), GetSQLValueString($_POST['VPLUS'], "text"), GetSQLValueString($_POST['Short'], "text"), GetSQLValueString($_POST['Voice'], "text"), GetSQLValueString(isset($_POST['Favorite']) ? "true" : "", "defined","1","0"), GetSQLValueString($_POST['Added'], "date")); mysql_select_db($database_DNSTags, $DNSTags); $Result1 = mysql_query($insertSQL, $DNSTags) or die(mysql_error()); $insertGoTo = "list_tags_new.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); }} ?>

Hi.. sorry, not following. Are you making an obtuse comment suggesting that you would have preferred to see code of some sort? I really wasn't looking for something that in-depth, it was just a general question about the "file" field types... I didn't want to load up a ton of code if this was a known "issue".. Some guidance is appreciated.

I've got the standard PHP file up load functionality working properly. The problem is that while the other fields contained in the same upload form get INSERTed into mySQL properly as expected, the filename field does not. everything LOOKS fine to me.. and all I can think of is that for some reason, the field TYPE (which is to say: type="file") is the roadblock. Is there something in PHP that says "yes, I know you're a file to be uploaded, but I won't actually recognize the value in this field as something I can insert into the filename column". ???? Help!

Hi all- I need some help figuring out a select query... I have a view made from two tables with a user ID as the common key. I need to retrieve all rows from the view where the email address is NOT equal to the session variable stated . I built it using what I thought was a fairly simple query, and what it gives me back are any rows where the EMAIL field has a value (not equal to the session variable) which is fine.. but I ALSO need to get the other rows where the email field has NO value assigned to it currently. How can I write this?

Damn. you guys are good.

Hi gurus.. so I have a session variable (called "RID") already living on a site, but I need a PHP chunk that would automatically UPDATE a specific table/row related to that session ID, setting a given field to '1'. Suggestions?

ok.. makes sense.. unfortunately, I only know barely enough PHP to get into trouble.. can you point me to where I would find a reference to this method you're describing?

OK, very odd.. I've got it working.. mostly.. but the value of the session variable that gets generated and then inserted into the table record, does NOT match the 6-character session variable value displayed on the next page!! It's almost like the second page is displaying a separately generated variable value .. but why?? All I'm asking it to do is echo the session variable....???

Yes I do...

$valid_chars = 'abcdefghijklmnopqrstuvwxyz0123456789'; echo generate_password( 6, $valid_chars ); function generate_password( $length, $valid_chars ) { $count = strlen( $valid_chars ) - 1; $pass = ''; for( $i = 0; $i < $length; $i++ ) { $pass .= $valid_chars[rand( 0, $count)]; } return $pass;} $_SESSION['PSSWD'] = $pass; This DOES generate the value.. I can see it on this page.. but on the next page where it should pull form the session variable "PSSWD" it doesn't display anything!

Odd.. that's exactly how I coded it and it's just not showing on the page... total blank space.. grrr

Thanks guys.. now how do I display (print?) that session variable value on a subsequent php page? I know it's simple but I'm having trouble finding the answer in the docs..

hey all.. I need to come up with a PHP chunk that randomly generates a 6 digit "password" and then assigns it to a session variable of my choice. Any pointers??

For any interested.. I figured it out. Probably an elementary mistake really.. anyways, the test files that always worked were in the same directory as the file setting the cookie, and the page calling/checking the cookie was in a different directory.

This all actually works beautifully if it's in a php page all by itself. For some reason, when I implement it on the page where it's meant to show, it fails and only shows the code after "else"... any thoughts on what might prevent the isset portion to be functional?

It gives me this (which looks right to me?) array(1) { ["April09"]=> string(9) "confirmed" }

well, that's actually more than I've gotten from others on this topic, so thanks.. I appreciate the confirmation and suggestion..

hi oni-kun... I was hoping Thorpe could continue his previous thread of help.. thanks though