blokelover@hotmail.com Posted March 3, 2005 Share Posted March 3, 2005 Hi, i have been trying to solve the problem of uploading, the code i have works in one page, but not in the other, and i have no idea why. The only notable difference is that one is an update form, and the other is a record insertion form. I am trying to upload the filename in the database, so that i can use it along with path, to diplay the image. But at the moment it doesnt upload, while my other page does. any help would be great. p.s. i am working with the university macromedia mx software, therefore i wont be able to upgrade or apply any add ons.... code: <?php require_once('Connections/mysql.php'); ?> <?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 != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } $editFormAction = $HTTP_SERVER_VARS['PHP_SELF']; if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) { $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING']; } if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) { $insertSQL = sprintf("INSERT INTO artistmembers (email, membernameid, membername, memberpicture, membertext, memberposition) VALUES (%s, %s, %s, %s, %s, %s)", GetSQLValueString($HTTP_POST_VARS['email'], "text"), GetSQLValueString($HTTP_POST_VARS['membernameid'], "int"), GetSQLValueString($HTTP_POST_VARS['membername'], "text"), GetSQLValueString($_FILES['memberpicture']['name'], "text"), GetSQLValueString($HTTP_POST_VARS['membertext'], "text"), GetSQLValueString($HTTP_POST_VARS['memberposition'], "text")); mysql_select_db($database_mysql, $mysql); $Result1 = mysql_query($insertSQL, $mysql) or die(mysql_error()); } mysql_select_db($database_mysql, $mysql); $query_loadmember = "SELECT * FROM artistmembers"; $loadmember = mysql_query($query_loadmember, $mysql) or die(mysql_error()); $row_loadmember = mysql_fetch_assoc($loadmember); $totalRows_loadmember = mysql_num_rows($loadmember); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <!-- DW6 --> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <!-- TemplateBeginEditable name="doctitle" --> <title>Untitled Document</title> <!-- TemplateEndEditable --><link rel="stylesheet" href="3col_leftNav.css" type="text/css"> <style type="text/css"> <!-- .style1 {color: #FFFFFF} .style8 {font-size: 10px} .style9 {font-size: 12px} --> </style> <!-- TemplateParam name="Headline1" type="boolean" value="true" --> <!-- TemplateBeginEditable name="head" --><!-- TemplateEndEditable --> </head> <body> <div id="masthead"> <h1 id="siteName">Soundstage</h1> <div id="globalNav"> <a href="register.html">register</a> | <a href="login.html">login</a> | <a href="logout.html">logout</a> | <a href="#">basket</a> | <a href="#">checkout</a> | </div> <h2 class="style1" id="pageName">reviews...</h2> <div id="breadCrumb"> <a href="#">breadcrumb</a> / <a href="#">breadcrumb</a> / <a href="#">breadcrumb</a> / </div> </div> <div id="navBar"> <div id="search"> <form action="#"> <label>search</label> <input name="searchFor" type="text" size="10"> <input name="goButton" type="submit" value="go"> </form> </div> <div id="sectionLinks"> <h3>Section Links</h3> <ul> <li><a href="index.html">Home</a></li> <li><a href="artists.html">Artists</a></li> <li><a href="genre.html">Genre</a></li> <li><a href="city.html">City</a></li> <li><a href="reviews.html">Reviews</a></li> <li><a href="#">Section Link</a></li> </ul> </div> <div class="relatedLinks"> <h3>Related Link Category</h3> <ul> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> </ul> </div> <div class="relatedLinks"> <h3>Related Link Category</h3> <ul> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> <li><a href="#">Related Link</a></li> </ul> </div> </div> <!--end navBar div --> <div id="headlines"> <h3>Artist of the week:</h3> <p> </p> <div id="advert"> <img src="" alt="" width="107" height="66"> Ad copy ad copy ad copy. Ad copy ad copy. </div> </div> <!--end headlines --> <div id="content"> </div> <!--end content --> <table width="53%" height="34" border="0"> <tr> <td><a href="bandsection1.php"></a> <p align="center"><a href="bandsection1.php">back to edit band</a></p></td> </tr> </table> <form method="post" name="form1" action="<?php echo $editFormAction; ?>"> <table align="center"> <tr valign="baseline"> <td nowrap align="right">Membername:</td> <td><input type="text" name="membername" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right">Memberpicture:</td> <td><input type="file" name="memberpicture" value="uploadfile" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right" valign="top">Membertext:</td> <td> <textarea name="membertext" cols="50" rows="5"></textarea> </td> </tr> <tr valign="baseline"> <td nowrap align="right">Memberposition:</td> <td><input type="text" name="memberposition" value="" size="32"></td> </tr> <tr valign="baseline"> <td nowrap align="right"> </td> <td><input name="submit" type="submit" value="Insert Record"></td> </tr> </table> <input type="hidden" name="email" value=""> <input type="hidden" name="membernameid" value=""> <input type="hidden" name="MM_insert" value="form1"> </form> <p> </p> <div align="left"> <p> </p> </div> <div id="siteInfo"> <img src="" width="44" height="22"> <a href="#">About Us</a> | <a href="#">Site Map</a> | <a href="#">Privacy Policy</a> | <a href="#">Contact Us</a> | ©2003 Company Name </div> <br> <p> </p> </body> </html> <? echo $HTTP_POST_VARS['memberpicture']; $uploaddir = '//ftpserver/www/bla/bla/bla/bla/'; $uploadfile = $uploaddir . basename($_FILES['memberpicture']['name']); echo $uploadfile; echo '<pre>'; if (move_uploaded_file($_FILES['memberpicture']['tmp_name'], $uploadfile)) { echo "Your a mastermind.....\n"; } else { echo "Possible file upload attack!\n"; } echo 'Here is some more debugging info:'; print_r($_FILES); print "</pre>"; ?> <?php mysql_free_result($loadmember); ?> Quote Link to comment Share on other sites More sharing options...
delr2691 Posted March 12, 2005 Share Posted March 12, 2005 You can use this script, I modified it a little to fit your needings... Tell me if it doesnt work... (I speak spanish, so some things are in spanish) This code is to upload an image into a specific directory [C:/uploaded/] and stores the processed name of the file, the size, the mime type and description in a table called uploads... [column names: ID for the file ID; Nombre for the name of the file; mimeType for the mime type; Tamaño for the size; and Descrìpcion for the description] here it is... [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]require_once([/span][span style=\"color:#DD0000\"]\'../Connections/notas.php\'[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> <?php mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$database_notas[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$notas[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$query_view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"SELECT * FROM uploads order by Nombre\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_view_uploaded[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$notas[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); [/span][span style=\"color:#0000BB\"]$row_view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$view_uploaded[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$totalRows_view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_num_rows[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$view_uploaded[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> <?php [/span][span style=\"color:#007700\"]if (isset([/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'delupload\'[/span][span style=\"color:#007700\"]])) { [/span][span style=\"color:#0000BB\"]$delupload [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'delupload\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"C:/uploaded/\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$query_delete_file_name [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"select Nombre from uploads where (id=\'$delupload\')\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$query_delete_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"delete from uploads where (id=\'$delupload\')\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$doSelect [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_delete_file_name[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$row_delete_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$doSelect[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$delNombre [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_delete_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Nombre\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$delFile [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"$uploaddir$delNombre\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$delFisFile [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]unlink[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$delFile[/span][span style=\"color:#007700\"]); if ([/span][span style=\"color:#0000BB\"]$delFisFile [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#0000BB\"]FALSE[/span][span style=\"color:#007700\"]) { exit(); } if (@[/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_delete_uploaded[/span][span style=\"color:#007700\"])) { [/span][span style=\"color:#0000BB\"]header[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"Location: \" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$_SERVER[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'PHP_SELF\'[/span][span style=\"color:#007700\"]]); } } [/span][span style=\"color:#0000BB\"]?> [/span] <!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\"> <html> <head> <title>Ver los archivos subidos</title> <script language=\"JavaScript\" type=\"text/JavaScript\"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> </head> <body bgstyle=\"color:white\"> <h1>Uploaded files</h1> <h3>Click <a href=\"upload.php\">here</a> to upload another image.</h3> <!--// THIS WILL DISPLAY THE UPLOADED FILES AND IF THEY ARE IMAGES //IT WILL SHOW THE IMAGE IN A SMALL SIZE AND IF ITS TEXT IT WILL SHOW //AN IMAGE THAT SAYS TEXT FILE AND IF IT ISNT IMAGE OR A TEXT FILE //IT WILL SHOE AN IMAGE THAT SAYS OTHER TYPE FO FILE... //IF YOU CLICK ON THEM IT WILL OPEN ANOTHER WINDOW WITH THE FILE //PREVIEW ONLY IF ITS A TEXT OR AN IMAGE FILE... //4 THAT YOU NEED A FILE THAT\'S CALLED view-uploaded_script.php //--> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]if ([/span][span style=\"color:#0000BB\"]$row_view_uploaded [/span][span style=\"color:#007700\"]&[/span][span style=\"color:#FF8000\"]#33;== 0): [/span][span style=\"color:#0000BB\"]?> [/span] <table border=\"1\"> <tr> <td><b>ID</b></td> <td><b>Name</b></td> <td><b>Description</b></td> <td><b>Image</b></td> <td><b>Delete?</b></td> </tr> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]while ([/span][span style=\"color:#0000BB\"]$row_view_uploaded [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$view_uploaded[/span][span style=\"color:#007700\"])) { [/span][span style=\"color:#0000BB\"]$fileID [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'id\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileDesc [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Descripcion\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'mimeType\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"C:/uploaded/\"[/span][span style=\"color:#007700\"]; if ([/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'image/pjpeg\' [/span][span style=\"color:#007700\"]|| [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'image/bmp\' [/span][span style=\"color:#007700\"]|| [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'image/gif\' [/span][span style=\"color:#007700\"]|| [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'image/jpeg\'[/span][span style=\"color:#007700\"]) { [/span][span style=\"color:#0000BB\"]$fileNom [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Nombre\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileDir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$fileNom[/span][span style=\"color:#007700\"]; } elseif ([/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'text/plain\' [/span][span style=\"color:#007700\"]|| [/span][span style=\"color:#0000BB\"]$fileType [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\'application/msword\'[/span][span style=\"color:#007700\"]) { [/span][span style=\"color:#0000BB\"]$fileNom [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Nombre\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileNom2 [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"text.jpg\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$fileDir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$fileNom2[/span][span style=\"color:#007700\"]; } else { [/span][span style=\"color:#0000BB\"]$fileNom [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$row_view_uploaded[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Nombre\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$fileNom2 [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"other.jpg\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$fileDir [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$uploaddir [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$fileNom2[/span][span style=\"color:#007700\"]; } echo [/span][span style=\"color:#DD0000\"]\"<tr>\n\" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#DD0000\"]\" <td>$fileID</td>\" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#DD0000\"]\" <td onClick=\\"[/span][span style=\"color:#0000BB\"]MM_openBrWindow[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\'view-uploaded_script.php?file=$fileID&action=popup\'[/span][span style=\"color:#007700\"],[/span][span style=\"color:#DD0000\"]\'$fileName\'[/span][span style=\"color:#007700\"],[/span][span style=\"color:#DD0000\"]\'width=500,height=500\'[/span][span style=\"color:#007700\"])&[/span][span style=\"color:#FF8000\"]#092;\"><a href=\\"#\\">$fileNom</a></td>\n\" . [/span][span style=\"color:#DD0000\"]\" <td><textarea onFocus=\\"[/span][span style=\"color:#0000BB\"]this[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]value[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#DD0000\"]\'$fileDesc\'[/span][span style=\"color:#007700\"];&[/span][span style=\"color:#FF8000\"]#092;\" onBlur=\\"this.value=\'$fileDesc\'\\">$fileDesc</textarea></td>\n\" . [/span][span style=\"color:#DD0000\"]\" <td onClick=\\"[/span][span style=\"color:#0000BB\"]MM_openBrWindow[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\'view-uploaded_script.php?file=$fileID&action=popup\'[/span][span style=\"color:#007700\"],[/span][span style=\"color:#DD0000\"]\'$fileName\'[/span][span style=\"color:#007700\"],[/span][span style=\"color:#DD0000\"]\'width=500,height=500\'[/span][span style=\"color:#007700\"])&[/span][span style=\"color:#FF8000\"]#092;\"><a href=\\"#\\"><img src=\\"$fileDir\\" width=\\"46\\" height=\\"35\\"></a></td>\n\" . [/span][span style=\"color:#DD0000\"]\" <td><center><a href=\\"\" . $_SERVER[\'PHP_SELF\'] . \"[/span][span style=\"color:#007700\"]?[/span][span style=\"color:#0000BB\"]delupload[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]$fileID[/span][span style=\"color:#007700\"]&[/span][span style=\"color:#FF8000\"]#092;\">Delete!</a></center></td>\n\" . [/span][span style=\"color:#DD0000\"]\"</tr>\n\"[/span][span style=\"color:#007700\"]; } [/span][span style=\"color:#0000BB\"]?> [/span] </table> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]else: [/span][span style=\"color:#0000BB\"]?> [/span] <h3>No files to show</h3><br> [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]endif; [/span][span style=\"color:#0000BB\"]?> [/span] </body> </html> [span style=\"color:#0000BB\"]<?php mysql_free_result[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$view_uploaded[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> [/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--] I can send you the view-uploaded_script.php file by mail, or you can tell if me anything's wrong with the code... my email is delr_91@hotmail.com [in subject put: phpfreaks.com] see ya, Diego Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.