Posts by Stefano Mtangoo Page 45

Stefano Mtangoo 455 Senior Poster

15 Years Ago

I have a question
right now I'm writting generic method to clean POST variables. What are necessary thing to sanitize for any text variable? What do I need to do?
Thanks

Web Development javascript javascript-jquery

Stefano Mtangoo 455 Senior Poster

15 Years Ago

Re: PHP MYSQL login system - From the ground up

Yep if you want to follow the code, simpla database will be used throughout is done via this

CREATE TABLE `loginsys`.`login` (
`id` INT( 25 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 25 ) NOT NULL ,
`password` VARCHAR( 100 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM ;

Web Development mysql php

Stefano Mtangoo 455 Senior Poster

15 Years Ago

Re: Form - JQuery and highlighting

I missed your post
I have tested and it greatly work.
Thanks Priteas. I'm just beginning JQuery thing and I appreciate
Solve!!

Web Development javascript javascript-jquery

Stefano Mtangoo 455 Senior Poster

15 Years Ago

Re: Form - JQuery and highlighting

Ok with this great tutorial I made it!
Thanks for the guy!
One thing, make sure you link JQuery first then your JS file that uses JQuery in that order

Web Development javascript javascript-jquery

Stefano Mtangoo 455 Senior Poster

15 Years Ago

Re: Form - JQuery and highlighting

I see nothing happening
What might be wrong?

Web Development javascript javascript-jquery

Stefano Mtangoo 455 Senior Poster

15 Years Ago

Re: PHP MYSQL login system - From the ground up

It seems this one function is ok. The reason I wanted your input on this is because I wanted it to go right. I know it is almost 0.5 of big number but I see it is ok and I will now proceed. No sooner I will start my coding

Thanks

Web Development mysql php

Stefano Mtangoo 455 Senior Poster

15 Years Ago

Form - JQuery and highlighting

Hi all,
I want to add some yellow background when focus turns to text input and remove it when it moves. Here is my code for JQuery

$(document).ready(
	function(){
	 //make form display yellow color when mouse is focused on item
	 $("input").focus( function(){
			$(this).css('background-color' : 'yellow');
		} );//end focus
	
	});

a HTML form

<html>
	<head>
		<title>Login in Site</title>
		<link rel="stylesheet" type="text/css" href="/loginsys/site.css" />
		<script type="text/javascript" src="/loginsys/lib/form.js">	</script>
	</head>

	<body>
	<div id="form">
		<form action="/loginsys/include/login.php" method="POST">
			<p><b>Username:</b> <input type="text" name="usrname" /></p>
			<p><b>Password:</b> <input type="text" name="passwd" /></p>
			<p><input type="submit" value="Login" /></p>
		</form>
	</div>
	</body>

</html>

Web Development javascript javascript-jquery

Stefano Mtangoo 455 Senior Poster

15 Years Ago

Re: PHP MYSQL login system - From the ground up

Here is my inc.db.php which contains all database related classes/methods
Should I keep all functions in the same file or separate?

Allright,
I have made only a constructor before I go to login issues please tell me if this is best way to do it if not what do you suggest?

<?php
        //class for db connections and manipulations
	class Connectdb{
		//private values
		private $dbuser="testuser";
		private $dbpass="testpass";
		private $dbhost="localhost";
		private $dbname="testdb";
		
		private function __construct(){
			$conn = mysql_connect($this->dbuser, $this->dbpass , $this->dbhost) or die("Cannot connect to database: Error - ".mysql_error());
			mysql_select_db($this->dbname);
			return $conn;
		}
	
	}
?>

Web Development mysql php

Stefano Mtangoo 455 Senior Poster

15 Years Ago

PHP MYSQL login system - From the ground up

As I said,
I would like to make a PHP login /Register system that would be free for anyone. Here I have started. Since Iam not expert, then I will be adding small pieces until something emerges.

I hope DW guys will help until it grows to mature. I want to apply some OOP.

Feel free to criticize and add/remove anything, but state why you did that and explain where you do complex stuffs so that I don't get lost. After it mature I will do host it somewhere (google code or SF)

Thanks

Web Development mysql php

Stefano Mtangoo 455 Senior Poster

15 Years Ago

Re: Cross-Platform Troubles

Curiously Snack seems to be dead project that supports Python 2.2
Iam I right?