PHP - Contact Directory Database - Pull Unique Values

I have a simple db with values.

I want to find all duplicate values and rename them 1,2,3 - so if I have these values for a 'colour' field:

pID / color

1 / brown
2 / blue
3 / red
4 / red
5 / brown

...would result in:

1 / brown1
2 / blue
3 / red1
4 / red2
5 / brown2

...is this possible?

I have a form that is submitting to a database currently.  I would like to check the data and be able to update it with a notes section. 

The form is currently 80 text boxes, dropdowns, and text areas being submitted to the database.  I need this info to populate after the user id is entered and a button is pressed.  I will have to update this page frequently with notes.  I am going to create a new table just for the notes  and will attach the customer id to it also.

If you can help me out with this i would appricate it.  I can post my current code or an example of the code.

Hi I am new this forum and looking for some much appreciated help with something that has me stumped.

I have extracted regions from image names in a directory.

example: 'edinburgh_castle_(Edinburgh).jpg' (Extracted Edinburgh from in-between the brackets)

So I have a list of Regions, extracted from all the various image names in the directory which I want to populate into a dynamic drop down menu for filtering purposes.

Here's my issue...

I want there to be only one 'Edinburgh' option appearing in my drop down menu. I don't want duplicates.
  Here is my code so far.
  php: [Select]

Hi all,

I have a situation where I need to remember what check boxes where checked over pagination, I have managed to do this via the use of this:

http://jamesfunk.com/wordpress/?p=65

The problem is that as the code stood:

Code: [Select]
<input type="checkbox" name="compare" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
It was treating one ticked checkbox as them all because they all have the same name and are in the a while loop!

I countered this by changing the code to:

Code: [Select]
<input type="checkbox" name="compare<?php echo $list['jobseeker_id']?>" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
Which effectively now makes the checkbox name unique... i.e. compare{id}.

The problem with this is that I can now no longer process it. This is my processing code:

$jobseekers = $_POST['compare'];
$i = 0;
for($i; $i<count($jobseekers); $i++){
$query = "SELECT * FROM jobseekers WHERE jobseeker_id = '$jobseekers[$i]'";
$result = mysql_query($query) or die (mysql_error());

while ($row = mysql_fetch_array($result)) {
// Spit out the required data
}
}

As you can see I am trying to get the data from $_POST['compare'], which will obviously now be blank as I have had to make the name unique.... the trouble is I'm not sure how to actually process this.

Can anyone help me out here? any help or advice would be greatly appreciated!

many thanks,

Greens85

Hi there!
On a page of mine, random tables get generated. The tables consist of 8 characters, so there's 5 . 10^13 possibilities. Yet ofcourse there is a possibility that 2 tables with the same name can be generated, which ofcourse is not desired. So I need an adjustment that can see whether there is already a name that's the same, and if so, make another random name. And if that one also exists, make a new one again. Untill the name doesn't exist yet and it remains.

Here's the script I have right now:

function createName($length) 
{
$chars = "abcdefghijkmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
$i = 0;
$password = "";
while ($i <= $length) 
{
$password .= $chars{mt_rand(0,strlen($chars))};
$i++;
}
return $password;
}
 
$name = createName(8);

mysql_select_db($database, $con);

$sql = "CREATE TABLE " . $name . "(
id int NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
devraag varchar(500),
weergave varchar(500),
naam varchar(500),
inhoud varchar(500),
tijd varchar(100))";
mysql_query($sql, $connection)or die(mysql_error());


I'm not goot with the combination of PHP and mysql, and really have no Idea how to do this.

Any help?

hi!, is it possible to use rand() to generate unique number that will be saved in a database as a primary key? Since i dont want to have numbers like 00001 incrementing on the table. They dont look like real account numbers... i need something like 45642  or 95452 and the like.

thanks in advance.

Hey guys,
I m not yet an experienced coder. SO faced alot of problems. Here, I'm trying to generate a UNIQUE RANDOM NUMBER set between two numbers. Repetative occurance must be avoided by all means as I want every number so generated bears a unique value. In other words, every values that made entry into the field of my database should be differant from each others.


<?php
$conN=mysql_connect("localhost","root","");
if(!$conN)
{
die('error'.mysql_error());
}
mysql_select_db("freebie_allusers",$conN);
$UIN=mt_rand(1,5);
$locateUIN="SELECT UIN FROM user_info WHERE UIN='".$UIN."'";
$fetchUIN=mysql_query($locateUIN);
$resultUIN=mysql_num_rows($fetchUIN);
if($resultUIN>0)
{



WHAT CODE IS REQUIRED HERE SO AS TO GENERATE UNIQUE RANDOM NUMBER?






}

else 
echo $UIN;
?>

Thanx in advance

Hi all,

I'm trying to create a PHP script for user's profile to display the amount of times they've been viewed. I'm looking to have this script increase on a unique view, and it should update the variable in the database.

Profiles are accessed by the following link: userprofile.php?userid=X (where X is the ID, e.g. 1, 2, 1001, 345982, etc.).

The database variable I'm looking to update is called ProfileViews.

I began developing the script, which is as follows:

Code: [Select]
$_SESSION['Viewed'] = 0;

if ($_SESSION['Viewed'] == 0) {

$profileViewsQuery = mysql_query("SELECT ProfileViews FROM Users WHERE UserID='????'");

$getProfileViews = mysql_fetch_array($profileViewsQuery);

$profileViews = $getProfileViews['ProfileViews'];

$profileViews = $profileViews + 1;

mysql_query("UPDATE Users SET ProfileViews='$profileViews' WHERE UserID='????'");

$_SESSION['Viewed'] = 1;

}

However, I'm stumped on a couple things. Could you possibly help me out?

1. How can I get the script to recognize the link accessed's ID? E.g. when a user goes to userprofile.php?userid=1001, how can I get the script to identify the ID to update should be 1001? This is where the "????" would be replaced in the code.
2. On page load, the variable is always going to be $_SESSION['Viewed'] = 0, which isn't going to produce unique hits. Do you have any recommendations how I could achieve unique hits using this method?

Thanks very much for reading.

I'm just learning about PHP and I'm diving in head first by attempting to modify our web site's contact form.  I'm wishing to stop the form from erasing previously entered values upon "failed" data validation.  It's of course going to be annoying to our visitors if their hardworked entries disappear just because they left out a name or entered an illegal email address.  I regret that some potential solutions found on this forum and other locations on Google didn't seem to help on my page.

As you can see, the validation is done with PHP's version of if-elseif-else.  Later I'll be adding a reCAPTCHA and I hope that whatever I learn here might be useful for the potentially same problem when I am adding the CAPTCHA. 

The actual contact form is at http://www.woofwoofwoof.org/contact/index.php.  Thank you in advance for your taking the time to help me what originally appeared to be a simple problem.  I have read the rules and I hope I've followed the rules -- please let me know if I committed any sins of omission or commission.  Now, for your Sunday reading pleasure, here's the code:

CODE STARTS HERE ====================================

<?php include("../common/docType.php"); ?>
<?php include("../common/htmlOpen.php"); ?>

<head>

   <title><?php include("../common/titleBar.php"); ?> - Contact us!</title>
        <meta name="description" content="Call or email us with questions or orders.">
        <meta name="keywords" content="Barking Dog Chocolatiers, Charlotte NC, chocolate, contact us, telephone, email, e-mail">

   <meta name="geo.placename" content="Charlotte, North Carolina">
   <meta name="geo.region" content="US-NC">

        <meta name="author" content="Joal Fischer">


   <meta name="verify-v1" content="1aqZs7xrrfI3lp1RaWDkHHjY9UQZIbq2z/mIVdFeXiI=" />

   <?php include("../common/headInclude.php"); ?>
   <script src="../common/common.js" type="text/javascript"></script>

   <link rel="Stylesheet" href="../css/contact.css" />

</head>

<?php

   // Success/Fail message
   $msg = "";
   $brisket = "";

   // Target Email
   $targetEmail = "barkingdog@bellsouth.net";


   // Process Submissions
   if(isset($_POST['submitted'])) {
      if($_POST['submitted']) { // process form.
   
         $guestName = $_POST['guestName'];
         $cityState = $_POST['cityState'];
         $emailAddress = $_POST['emailAddress'];
         $phone = $_POST['phone'];
         $msgSubject = "Barking Dog Chocolatiers Inquiry";
         
         $msgContent = "FROM: $guestName\n";
         $msgContent .= "City/State: $cityState\n";
         $msgContent .= "Phone & time to call: $phone\n";
         $msgContent .= "\nInquiry:\n";
         $msgContent .= stripslashes($_POST['msgContent']);

   // Trial if then else reversed from Dan's original allowing maybe multiple tests in sequence -- in action

         if($guestName == "") {
            $keepvar = "1";
            $msg = "<p style='color: red; font-weight: bold; font-size: 14px; margin: 12px 0px 0px 0px;'>Please enter a name!</p>";

         }  elseif($emailAddress == "") {
            $msg = "<p style='color: red; font-weight: bold; font-size: 14px; margin: 12px 0px 0px 0px;'>Please enter a valid email address!</p>";

         } else {
            mail($targetEmail, $msgSubject, $msgContent, "From: $guestName <$emailAddress>\nX-Mailer:PHP/" . phpversion());
            $msg = "<p style='color: darkgreen; font-weight: bold; font-size: 14px; margin: 12px 0px 0px 0px;'>Thank you! Your message has been sent.</p>";
            $brisket = "<img src='../images/Brisket180x180web.jpg' width='180px' height='180px' alt='Brisket Says Hi' />";
         }


   // Original if then else all commented out

//         if($emailAddress != "") {
//            mail($targetEmail, $msgSubject, $msgContent, "From: $guestName <$emailAddress>\nX-Mailer:PHP/" . phpversion());
//            $msg = "<p style='color: darkgreen; font-weight: bold; font-size: 14px; margin: 12px 0px 0px 0px;'>Thank you! Your message has been sent.</p>";
//            $brisket = "<img src='../images/Brisket180x180web.jpg' width='180px' height='180px' alt='Brisket Says Hi' />";
//         } else {
//            $msg = "<p style='color: red; font-weight: bold; font-size: 14px; margin: 12px 0px 0px 0px;'>Please enter a valid email address!</p>";
//         }
      }
   }

?>


<body onload="loadMe('contact')">

   
   <div id="container">
      <div id="header">
         <a href="../home/index.php" style="border:none"><div id="logo"></div></a>

         <div id="navBG"><?php include("../common/mainNav.php"); ?></div>
      </div><!--End Header-->

      <div id="contentArea">
            <br /><img class="sideBox" src="../images/sideBox.jpg" width="12px" height="12px"><p class="sideItemSelected">contact us</p><br style="clear:both" />
            <p class="sideItem"><a class="sideLink" href="./shipping.php">useful q & a</a></p>
                  
            <div id="mainContent">
               
                  <h1>contact us</h1><br />
                  
                  <h2>Have questions? Ready to order?<br />
                  <span style="color:#b5a072">Call 704.333.1595 Mon-Fri 9am - 5pm EST</span></h2>
                  <p id="contactText" class="text">It's not business, it's personal! For instant answers to many questions about ordering, shipping, and other good stuff, please check the <a href="shipping.php">useful q&a</a> page.  Nonetheless, we'll always be happy to answer your questions by phone or through the form below. We look forward to hearing from you.</p><br />
                  
                  <div id="contactFormContainer">

                     <form method="post" id="contactForm" action="<?php echo($_SERVER['PHP_SELF']); ?>" >
                        <div id="formContainer">
                           <input type="hidden" name="submitted" value="true" />
                           <input type="hidden" name="formname" value="contact" />
                           

                           <div class="formRow">

                              <div class="itemSet">
                                 <p class="itemLabel">Name</p>
                                 <input tabindex="1" class="itemContent" type="text" name="guestName" value='<?php echo $_POST[Name]; ?>' />

                              </div>


                              <div class="itemSet">
                                 <p class="itemLabel">City & state</p>
                                 <input tabindex="2" class="itemContent" type="text" name="cityState" />
                              </div>

                              <br class="clearMe" />
                           </div>

                           <div class="formRow">
                              <div class="itemSet">
                                 <p class="itemLabel">Email Address</p>
                                 <input tabindex="3" class="itemContent" type="text" name="emailAddress" />
                              </div>

                              <div class="itemSet">
                                 <p class="itemLabel">Phone & best local time to call</p>
                                 <input tabindex="4" class="itemContent" type="text" name="phone" />
                              </div>

                           
                           </div>
                        
                           <div class="formRow">
                              <div>
                                 <p class="itemLabel">Your question</p>
                                 <textarea tabindex="5" id="msgContent" type="text" name="msgContent">Please telephone us to submit an order</textarea>
                              </div>
                           </div>

                           <div class="formRow">
                              <div style="position: relative;">
                                 <div style="float: left; margin-right: 40px;">
                                    <input tabindex="6" id="submitButton" type="submit" name="submit" value="Submit" />
                                 </div>

                                 <div style="float: left; margin-top: -10px;">
                                    <?php //echo($msg); ?>
                                 </div>

                                 <br style="clear: both;" />

                                 <div style="clear: both; position: absolute; top: -350px; left: -217px; width: 180px;">
                                    <?php
                                       echo($msg);
                                       echo($brisket);
                                    ?>
                                 </div>


                                 <br style="clear: both;" />
                              </div>
                           </div>

                     </div> <!-- End Form Container -->
                     
                  </form>


               </div> <!-- End Contact Form -->
         </div>
               
      </div><!-- End Content Area-->

      <div id="bottomBar"></div>
   

      
   
      <?php include("../common/footer.php"); ?>

   </div><!-- End Container -->

</body>

</html>

CODE STOPS HERE=====================================

after cloasing connection of database i still got the values form database.

Code: [Select]
<?php
session_start();
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
require_once '../database/db_connecting.php';
$dbname="sahansevena";//set database name
 $con=  setConnections();//make connections use implemented methode in db_connectiong.php
 mysql_select_db($dbname, $con);
//update the time and date of the admin table
 $update_time="update admin set last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname'limit 3,4";
 //my admin table contain 5 colums they are id, username,password, last_logged_date, last_log_time
 $link= mysql_query($update_time);
 // mysql_select_db($dbname, $link);
//$con=mysql_connect('localhost', 'root','ijts');

       $result="select * from admin where username='a'";

        $result=mysql_query($result);
mysql_close($con);
//here i just check after closing data baseconnection whether i do get reselts but i do, why?
echo "after the cnnection was closed";
if(!$result){
echo "cont fetch data";

}else{

   $row= mysql_fetch_array($result);
   echo "id".$row[0]."usrname".$row[1]."passwped".$row[2]."date".$row[3]."time".$row[4];
}
//  echo "<html>";
//echo "<table border='1' cellspacing='1' cellpadding='2' align='center'>";
//      echo "<thead>";
//           echo"<tr>";
//                   echo "<th>";
//                   echo ID;
//                   echo"</th>";
//                   echo" <th>";echo Username; echo"</th>";
//                    echo"<th>";echo Password; echo"</th>";
//                    echo"<th>";echo Last_logged_date; echo "</th>";
//                   echo "<th>";echo Last_logged_time;  echo "</th>";
//               echo" </tr>";
//           echo" </thead>";
//           echo" <tbody>";
//while($row= mysql_fetch_array($result,MYSQL_BOTH)){
//             echo "<tr>";
//              echo "<td>";
//              echo $row[0];
//               echo "</td>";
//                   echo "<td>";
//              echo $row[1];
//              echo "</td>";
//                  echo "<td>";
//              echo $row[2];
//               echo "</td>";
//                   echo "<td>";
//                echo $row[3];
//              echo "</td>";
//                  echo "<td>";
//              echo $row[4];
//               echo "</td>";
//            echo "</tr>";
//     }
//         echo" </tbody>";
//         echo "</table>";
//         echo "</html>";
     session_destroy();
session_commit();

echo "session and database are closed but i still get values from doatabase session is destroyed".$_SESSION['admin'];
?>

session is destroyed but database connection is not closed.

thanks

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=353621.0

Hi All

I have a contact form whcih works great - its has a little validation on it and sends me all the information I need via email.
I now want to store all data submitted via the form to be stored in a MySQL database.

What is the best way to do this??

Attached is my form as it is, just being emailed to the relevent accounts.

Look forward to your replies.

Adi

I have been looking around and have not been able to find any useful information on this.  I am trying to transfer files from a folder in the directory to a table in a database.  Eventually they will be images but for right now I am just trying to get text files to transfer.  Any help/code/ideas would be a lot of help.  This is going to be triggered a button on a page by the way.

images are uploaded to a directory and the sql database contains the filename. I added 'url' field and am trying to link the two

I have used on of the posts to help me adapt some script however I'm not sure I have the syntax right.  The image in DW live view looks ok and I get the link finger ok but when previewed in browser the image is not shown at all or any link.

Any ideas


<? echo !empty($row['pic']) ?  "<a href=\"{$row['url']}\" <img src=\"js/images/{$row['pic']}\">" : ''; ?>


it echos out to a table

Mike