[JQuery Validation Engine - User Age Check]

Build the date of birth from the current date and the birthday that the user provided.  Then use something like this: http://stackoverflow.com/questions/327429/whats-the-best-way-to-calculate-date-difference-in-javascript to calculate the difference between the two.

 

~juddster

[drop down and insert into mysql]

Does your $query variable's query return any results?  i.e. if you throw it into phpmyadmin then do you see the user id and usernames?

 

I disagree with Ivan's suggestion of using the {} I personally prefer if I'm doing it that way either string concatenation or using sprintf.

 

$sql2 = sprintf ( "INSERT INTO mailbox VALUES ( '', 'locked', '', '%s', '', NOW(), '', 'locked', '')", mysql_real_escape_string ( $_POST [ 'username' ] ) );

 

You are adding in lots of empty strings could those not be NULL?

 

~juddster

[relatively simple question]

It didn't help because you didn't copy it correctly.  Please re-read my previous post and you'll see the differences.

 

~juddster

[Moved Web Hosts]

Anywhere before you actually try to use $ca_id.

 

~juddster

[Display login name]

$_SESSION['username'] = $username;

 

You are overwriting your previous value with an empty string.

 

~juddster

[phpmyadmin not running]

No the server is not up and running, no the server isn't running on port 3406, or no phpmyadmin isn't working?  Or no something entirely different?

 

~juddster

[User Registration issue]

You need to provide mysqli_query the connection object that you get from mysqli_connect because of this the other errors are showing up.

 

~juddster

[phpmyadmin not running]

Is your mysql server up and running on port 3406?  If yes, have you updated the phpmyadmin configuration file accordingly?

 

~juddster

[phpmyadmin not running]

What port is your MySQL server running on?  Is this the port that you tell phpmyadmin?

 

~juddster

[phpmyadmin not running]

Both servers cannot run connected to the same port.  Either the server you stopped failed to start up again, or you didn't restart the server after adjusting the configuration.

 

~juddster

[phpmyadmin not running]

$cfg['Servers'][$i]['port'] = '90';

 

That should be your MySQL server port not your web server port.

 

~juddster

[WebCam clicking a picture when the page submits]

Just before the auto submit is done trigger the click event for the other thing?

 

~juddster

[phpmyadmin not running]

There should be a configuration file for phpmyadmin somewhere (http://webmaster.iu.edu/tool_guide_info/phpmyadmin/phpmyadmin.shtml).  Make sure that is using the correct port for your MySQL server (http://www.coderanch.com/t/298301/JDBC/java/which-port-mySQL-running)

 

~juddster

[Moved Web Hosts]

No ... registered_globals was deprecated and turned off by default for a reason.  Your code should handle it, not assume the server will.

 

~juddster

[Moved Web Hosts]

It looks like you might have been previously using registered_globals.  I don't see anywhere in your code where you set the variable $ca_id.

 

You are going to need to adjust the code so that it does grab that value.

$ca_id = $_GET['ca_id'];

 

My guess is that your old host had it enabled but your new one does not.

 

~juddster

[phpmyadmin not running]

Sorry for wrong link .. skimmed through it and thought it mentioned the server's port.  As for the server's port, is MySQL server running on it's default port or a different one?

 

~juddster

[phpmyadmin not running]

Has the server's port changed?

 

http://veerasundar.com/blog/2009/01/how-to-change-the-root-password-for-mysql-in-xampp/

 

~juddster

[Moved Web Hosts]

I believe that this is a PHP issue and not a MySQL one.  Can you please provide some code where it isn't working?

 

~juddster

[Passing PHP variables to jQuery?]

PHP is server side, jQuery is client side.  There is no way to directly use the PHP variables in JavaScript.

 

Indirectly, you could do something like this:

<script type="text/javascript">
    var foo = "<?php echo $superSpecialVariable; ?>";
</script>

 

To assign client-side variables at run time.

 

~juddster

[phpmyadmin not running]

If your mysql server running?

 

~juddster

[Accessing variables in a required folder when using AJAX]

I would try to remove the requirement of the main page being reloaded in order for the sidebar to work properly.  Maybe you can extract it out into another php file which they can require?

 

~juddster

[Accessing variables in a required folder when using AJAX]

Are you trying to use PHP values in your JavaScript call?  If yes, then you don't have access to them since JavaScript is all client-side.  Your best bet would be to assign the values of your PHP variables to values in your JavaScript.

 

<script type="text/javascript">
    var foo = "<?php echo $superSpecialVariable; ?>";
</script>

 

Or I completely misread your post ...

 

~juddster

[Display login name]

Then yes, use the session variable.  You shouldn't hit the database with queries if not necessary

 

~juddster

[is using htmlentities() to sanitize $_posts adequate protection?]

If you are using database parameters for your query there is no need to escape them.

 

Or if you aren't you would do something like what you have at the bottom.

 

~juddster

[is using htmlentities() to sanitize $_posts adequate protection?]

You shouldn't be using htmlentities to prevent SQL injection.  There are other functions to do that for you (i.e. mysql_real_escape_string) or better yet, use database parameters.

 

~juddster