PHP - Simple Question About Html Form's, Php And Mysql Inserts

hi,
i made my own page, but when i do an insert using mysql, jquery and php, the arabic text does not show properly
it is a comments page.
here is the DB structure
Code: [Select]

CREATE TABLE IF NOT EXISTS `app_comments` (
  `comment_id` int(20) NOT NULL auto_increment,
  `comment` text NOT NULL,
  `user_id` int(20) NOT NULL,
  `comment_date` date NOT NULL,
  `app_id` int(20) NOT NULL,
  PRIMARY KEY  (`comment_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
here is the jquery piece that transfers to php code.
Code: [Select]
    function submit_comment(){
        $(".post_comments_button").click(function() {
            var post_comments = $('.post_comments').val();
            var app_id = $('#app_id').val();
            //alert (app_id);
           
            if(confirm('Add Comment?')) {
               
                var string = "task=add_comment&app_id=" + app_id + "&comment="+post_comments;
                            $.ajax({
                url : "appajax.php",
                type : "POST",
                data : string,
                success : function(data) {
                    alert(data);
                    window.location.reload(true);
                   
                }
            });
               
               
               
            }
            /**/
            });
    }and here is the acutal insert code in php
$new_appquery = 'INSERT INTO app_comments (comment, user_id, app_id,comment_date)
                          VALUES ("' . $comment . '",' . $user_id . ',  ' . $app_id . ',NOW());';
                         
                          and the actual problem is, the arabic text shows like this in my application:
                         
                          Quote

بالتوفيق للريال

                         
how can i solve this issue?

Well, basically I am making my log in script. This is my first website with php and MySQL... actually, its my first website I have done that isn't for a school project.

Anywho, the problem I am having is I can't seem to verify the password of the account I am trying to log into.

Here is the code snippet I am having trouble with:

$usr = $_REQUEST['Username'];
$pass = $_REQUEST['Password'];
$pass = md5($pass);
if(mysql_query('SELECT Password FROM Accounts WHERE Username = "' .$usr . '"') == $pass)
{
session_start();
$_SESSION['loggedin'] = yes;
$_SESSION['User'] = $usr;
$_POST['info'] = ("You have successfully logged in " . $usr . ".");
} else { $_POST['info'] = "Username and password do not match.";}


The problem is that it doesn't seem to matter if the username and password are correct, it always prints "Username and password do not match.".

So, here is the table layout of 'Accounts':


Did I type the mysql query wrong?

Hi all.

Im trying to insert from one form 3 items of data into to different tables.  I will post the code as most of my notes are in there but first.......

What is happening is the form is filled in then the first part of the form where it updates my clubs table with category ID's works fine. Nothing in the
if ($result) {   }
seems to run.
I have create some fake groups so the drop down is populated with groups already created and I have tried to select one of these groups so it can be entered into the clubs table and nothing.  No errors just no answers.  Does anybody no what I am doing wrong?


first Ill post the form and the querys that make fields in the form... 

Querys

//gets
$validation = $_GET['new_club'];
//Querys
    $qGetClub = "SELECT * FROM clubs WHERE validationID = '$validation'"; 
$rGetClub = mysql_query($qGetClub);
$Club = mysql_fetch_array($rGetClub);
//Query for category by name
$qGetCat = "SELECT * FROM club_category WHERE catID = ".$Club['cat']."";
$rGetCat = mysql_query($qGetCat);
$CatName = mysql_fetch_array($rGetCat);
//query for related sub categorys.
$qGetSub = "SELECT * FROM sub_categorys WHERE catID =".$Club['cat']."";
$rSubCat = mysql_query($qGetSub);
// query for groups created
$Groupq = mysql_query("SELECT * FROM groups WHERE memberID = '".$User['memberID']."'");



  then we have the form


<form action="" method="post"  id="insert_clubfrm">
  
                        <tr valign="baseline">
                                <td colspan="2"  valign="top"><br/><p>Your Chosen category was <strong><?php echo $CatName['categorys'];?></strong> Please select a sub category.</p><br></td>
                              </tr>
                              
                              <tr valign="baseline">
                                <td width="132"  valign="top" >Club Sub Category:</td>
                                <td width="256"  valign="top"  ><select name='subcat'>
                            <option value="None">Please Select One</option>
<?php while ($New_SubCat = mysql_fetch_assoc($rSubCat)) { ?>

                                <option value="<?php echo $New_SubCat['subID']; ?>"><?php echo $New_SubCat['sub_categorys']; ?></option>"<?php  }  ?>

</select>
  </td>
                              </tr>
                              <tr valign="baseline">
                                 <td colspan="2"  valign="top" ><br/><p>If your sub category does not exist in the list please select "none" above and enter your new sub categroy below.</p><br></td>
                              </tr>
                              <tr valign="baseline">
                                <td  valign="top" class="left_padding">New Sub Category</td>
                                <td valign="top" class="left_padding"><input type="text" name="newSubCat" id="new_cat" value="" /></td>
                              </tr>
                              <tr valign="baseline">
                                <td colspan="2"  valign="top" class="left_padding"><br/>
                                 If you had/have more than one site and you had to give your group of companies a name what would that name be?
                                <br/></td>
                              </tr>
                              <tr valign="baseline">
                                <td  valign="top" class="left_padding">Group Name:</td>
                                <td  valign="top" class="left_padding"><label for="other_groups"></label>
                                  <select name="other_groups" id="other_groups">
                                  <option>None</option>
                                  <?php while ($group = mysql_fetch_assoc($Groupq)) { ?>
                                    <option value="<?php echo $group['groupID']; ?>"><?php echo $group['group']; ?></option>"<?php  }  ?>  
                                </select></td>
                              </tr>
                              <tr valign="baseline">
                                <td  valign="top" class="left_padding">Group Name:</td>
                                <td  valign="top" class="left_padding"><label for="new_groups"></label>
                                 <input type="text" name="new_group" value="">

  
</td>
                              </tr>
                                                        <tr valign="baseline">
                                <td valign="top" nowrap="nowrap">&nbsp;</td>
                                <td valign="top"><div align="left">
                                  <input type="submit" id="insert_clubbtn1" name="insert_clubbtn1" value="Insert record" />
                                </div></td>
                              </tr>
                            </table>
                            </form>






now the code to make the form work...



if(isset($_POST['insert_clubbtn1'])){ 
//Process data for validation     
$subcat     = trim($_POST['subcat']);  
$NewSubCat = trim($_POST['NewSubCat']); 

$otherg = trim($_POST['other_groups']);
$newg = trim($_POST['new_groups']);     
//Prepare data for db insertion      
$newg = mysql_real_escape_string($newg);  
$subcat = mysql_real_escape_string($subcat); 
//find the new category 
//insert
$result = mysql_query("UPDATE clubs  SET 
`sub_category` = '$subcat'
WHERE validationID ='$validation'") or die(mysql_error());
if ($result) {
//if an item other than none from the list is selected then update the club with an ID relating to the group it belongs to
if ($otherg !=='None') { $groupsq = mysql_query("UPDATE `clubs` SET groupID ='$otherg' WHERE validationID ='$validation')") or die (mysql_error()); }
// If none is selected then $newg must have a value so create a new group in the groups table and then on the next page I will add the group in the club table 
if ($otherg == 'None') {
$groupsq = mysql_query("INSERT INTO `groups` (memberID, group, clubID) VALUES ('".$User['memberID']."', '$newg', ''".$Club['clubID']."')");
} }


if ($NewSubCat !="") { mail("email","New Sub Category Request","Dear Owner,
\n\nThe club in the name of $name with a validation code of $validationID would like a new sub category called $new_cat\n\n  
\nTeam Me\n\n\n\n"); }

$url = "/create/create_clubp3.php?new_club=$validation";  
header("Location: $url");     

Is it possible - and reasonable - to have one Form which allows Users to create a new record (i.e. do an INSERT) and which also allows Users to modify an existing record (i.e. do an UPDATE)?   

When a User registers at my website, not only do they create a record in the "member" table, but one of the required fields is "First Name". 

What that means is that when I allow Users to edit details in their Profile - most of which were not included in registration to streamline the process - I don't have to worry about doing an INSERT, because I already created a "member" record and on the "Edit Details" page the first field is "First Name" so that is a hook so to speak where they can enter more info about themselves like...
Code: [Select]
- Location
- Date of Birth
- Interests
- Bio
and so on...


So here is my problem which I just discovered...

Also in my User Profile, I allow Users to answer several open-ended questions like...
Code: [Select]
1.) Why did you decide to start your own business?

2.) What advice would you share with others on what NOT to do?

The problem is that these questions exist in the "bio_question" table and the answers that I am trying to get from Users will be stored in the "bio_answer" table but no record currently exists?!

So do I need both an "INSERT Answers Form" *and* an "UPDATE Answers Form", or can I combine things into one form?!

Hope that all makes sense?!


Debbie

Hi there,

I've just started learning php and mysql today. I'm putting things together in dreamweaver and everything is running smoothly (ish).

I've got a form written in php that sends data to a database. All fine.

I need to send the time of submission to the database. I've put in a hidden field, what code should I use to set the field value to a mysql field of type DATETIME?

Cheers.