Search found 9 matches

by Mixamajic
Tue Feb 11, 2003 5:50 pm
Forum: PHP & MySQL Security
Topic: AES
Replies: 0
Views: 2375

AES

I have been asked to implement the AES (Rijndael) algorithm for a PHP/mySQL based internal application. I guess that the security for the DB is really tight. Has anyone used the new AES, Rijndael not Triple DES, or come across any good sites that would help is designing the code? I have found the co...
by Mixamajic
Tue Feb 11, 2003 5:45 am
Forum: PHP & MySQL Security
Topic: show(print) value from the database
Replies: 2
Views: 2887

You have the right idea

$test = mysql_query("SELECT myfield FROM mytable WHERE id = 1"); $row=mysql_fetch_array($test); echo $row["NameofIntField"]; //Leave the quotes in when you substitute the name of your DB field. The 4 you are getting I think is a result resource. There are a couple other ways to do what you need, bu...
by Mixamajic
Mon Feb 10, 2003 10:46 pm
Forum: PHP coding => General
Topic: Please help, drag additional value from mysql
Replies: 1
Views: 1166

When you set the value of the drop downs make them the ID (dbModelId), and then when you need the Database name use $Query = "SELECT * FROM model where dbModelId = $value" where $value = 'model' $form_pres. Then the usual query and fetch array. $Row = mysql_fetch_array ($Result)) Now you have both t...
by Mixamajic
Mon Feb 10, 2003 10:33 pm
Forum: PHP coding => General
Topic: Multi dimensional Array
Replies: 2
Views: 1205

Try this

The problem is that userpw is an array and cannot be referenced directly. It will nly return and Object pointer. You can add []s to decide which element of the array you want. Here's a quick modification, $name="tom"; $allowed=array("tom"=>array("abc",12)); $name="tom"; $pw="abc"; foreach($allowed a...
by Mixamajic
Thu Feb 06, 2003 7:15 pm
Forum: mySQL & php coding
Topic: Semaphores
Replies: 2
Views: 1685

I agree with your suggestion. It doesn't look like any PHP functions are directly going to help. Thanks for your input. on record open -> if id already exists in table verify two hours have passed. If so, update id, time, user in DB, else no access. If row does not exist add row and open session. on...
by Mixamajic
Thu Feb 06, 2003 3:01 pm
Forum: mySQL & php coding
Topic: Semaphores
Replies: 2
Views: 1685

Semaphores

I have a website/program that allows users to edit information in a mysql database. I would like to implement some sort of session control. What happens is when a person clicks on a link a form appears where they can edit/add information. I do not want two users to open the same form at the same tim...
by Mixamajic
Mon Feb 03, 2003 8:05 pm
Forum: JavaScript
Topic: Window Focus Problem
Replies: 1
Views: 2400

Window Focus Problem

I have a few links on a page that I would like to bring up a new small window. This window contains some basic definitions and I would like for it to stay focused in front of the main page until the user decides to close the smaller window. Furthermore when the user clicks on other definition links ...
by Mixamajic
Sun Feb 02, 2003 7:46 pm
Forum: Free time
Topic: Human Clonation
Replies: 4
Views: 4368

I need to wear a what?

Imagine that it was possible to make a clone and transfer all knowledge. Man, the first 10 years would be so weird. You have to go back to the tiny diaper stage and relearn all your motor skills for the new body. Everyone would pinch your cheek and tell you how cute you were... that is unless your m...
by Mixamajic
Sun Feb 02, 2003 7:07 pm
Forum: mySQL & php coding
Topic: INSERT INTO - problem!? please help
Replies: 2
Views: 1520

Parse Error

Try this,

$query="INSERT INTO cstats VALUES ('$Rip','$Rport','$b','$r', NULL)";

Your example recieved a parse error because of the placement of the quotes. You were recieving a PHP error, not a mysql error. You will also need a semi-colon after the mysql_query.