Nov 8, 2009
Pages: 1, 2

Need Help With A PHP - MySQL Registration Script - Wont INSERT into the database

free web hosting

Read Latest Entries..: (Post #13) by Arbitrary on Jul 20 2008, 03:17 AM.
QUOTEAfter thinking about it I can see the advantage of writing a script that does what you're talking about vujsa. Have a function like build_db_query or something that builds the actually query and returns it as a string perhaps. You pass a table name, and an array of values in an assoc array indexing the related tables in the fields. You could make it even more flexible and add flag to determine whether it's a select, insert, update, or delete statement. Just have a switch on the flag...
read more.
Read the FIRST post of this Topic. - Express your Opinion! Contribute Knowledge :-).

Open Discussion & Free Web Hosting > Computers & Tech > Programming > Scripting > PHP

Need Help With A PHP - MySQL Registration Script - Wont INSERT into the database

wannabeeaweak
hey well can some one helpme make this code work it won't INSERT INTO THE DATABSE

CODE
<?php
# register1.php
# common include file to MySQL
include("DB.PHP");

$Username=$_POST['Username'];
$Password=$_POST['Password'];
$Name=$_POST['Name'];
$Last=$_POST['Last'];
$Sex=$_POST['Sex'];
$Month=$_POST['Month'];
$Day=$_POST['Day'];
$Year=$_POST['Year'];
$Adresse=$_POST['Adresse'];
$City=$_POST['City'];
$State=$_POST['State'];
$Zipcode=$_POST['Zipcode'];
$Country=$_POST['Country'];
$Phone=$_POST['Phone'];
$Email=$_POST['Email'];
$Father_Name=$_POST['Father_Name'];
$Mother_Name=$_POST['Mother_Name'];
$Parent_Phone=$_POST['Parent_Phone'];
$Parent_Email=$_POST['Parent_Email'];
$Level=$_POST['Level'];
$Academic=$_POST['Academic'];
$Image_Link=$_POST['prevImage'];


$sql9="INSERT INTO User
SET id = 'NULL',
   Username = '$Username',
   Password = '$Password',
Name='$Name',
   Last='$Last',
Sex='$Sex',
Month='$Month',
Day='$Day',
Year='$Year',
Adresse='$Adresse',
City='$City',
State='$State',
Zipcode='$Zipcode',
Country='$Country',
Phone='$Phone',
Email='$Email',
Father_Name='$Father_Name',
Mother_Name='$Mother_Name',
Parent_Phone='$Parent_Phone',
Parent_Email='$Parent_Email',
Level='$Level',
$Academic='$Academic'";
$sql3="SELECT * FROM User WHERE Username='$Username' AND Password='$Password'";
$sql4="SELECT * FROM User WHERE Email='$Email'";

# insert login/password
 $result = mysql_query($sql);
    if (!$result) {
      echo "Please Try Again";
    } else {
   echo"Thank you for sign up";
}
mysql_close($connection);
?>

 

 

 


Comment/Reply (w/o sign-up)

Houdini
Did I miss something in the above or did you connect to the database somewhere else? It needs to connect first then it can insert, do you get an error with the above.

Usually you would start with
CODE
$connect = mysql_connect($host,$user,$password)
 die ("Couldn't connect to server!");
$db = mysql_select_db($database,$connect)
 die("Couldn't select databse!");

Comment/Reply (w/o sign-up)

wannabeeaweak
QUOTE(Houdini @ Nov 17 2005, 03:44 AM)
Did I miss something in the above or did you connect to the database somewhere else? It needs to connect first then it can insert, do you get an error with the above.

Usually you would start with
CODE
$connect = mysql_connect($host,$user,$password)
 die ("Couldn't connect to server!");
$db = mysql_select_db($database,$connect)
 die("Couldn't select databse!");

*




CODE
include("DB.PHP");
thats where that is

Comment/Reply (w/o sign-up)

vujsa
So Houdini's question was the first one I had too the first time I looked at this. Next time be sure to include any external code that we may need to help debug.

Next I found another problem.
You run an mysql query on $sql but $sql doesn't exist.

QUOTE(wannabeeaweak @ Nov 16 2005, 11:26 PM)
CODE

# insert login/password
 $result = mysql_query($sql);  <--------------------------------- HERE!!!!!!
    if (!$result) {
      echo "Please Try Again";
    } else {
   echo"Thank you for sign up";
}
mysql_close($connection);
?>

*


QUOTE(wannabeeaweak @ Nov 16 2005, 11:26 PM)
hey well can some one helpme make this code work it won't INSERT INTO THE DATABSE
CODE

$sql9="INSERT INTO User .....
$sql3="SELECT * FROM User WHE.....
$sql4="SELECT * FROM User WHE.....

*



You actually need to run the seperate querries on $sql9, $sql3, and $sql4!

I suggest writting a function that could be generic enough to handle any variable.

Maybe:
CODE

function boogy_down($sql){
   $result = mysql_query($sql);
   if (!$result) {
       echo "Please Try Again";
   } else {
       echo"Thank you for sign up";
   }
}


With the funtion call of:
CODE

boogy_down($sql9);
boogy_down($sql3);
boogy_down($sql4);


Now keep in mind that that particular function will output "Thank you for sign up" 3 times if successful. It would be better to put the variables in an array and add a loop to the function then if all commands are successful, echo "Thank you for sign up"!

I'm not going to write the whole thing for you but this should at least get you back on track.

Hope This Helps! cool.gif

vujsa

 

 

 


Comment/Reply (w/o sign-up)

Hercco
Yep, you're basically entering an empry query as $sql is not defined.

But a generic function for different types of queries might be a bit useless as the return values of mysql_query can be very different, ranging from simple boolean values of a say INSERT to big results of SELECT queries.


I don't if you meant to do it but although otherwise a possible thing to do would be to send multiple queries tot the databse at once, separated by semicolons this is not possible with PHP as it is considered a security threat. You code would miss the appending of the quesries anyways so you probably weren't thinking about this.

Comment/Reply (w/o sign-up)

vujsa
QUOTE(Hercco @ Nov 23 2005, 07:49 AM)
Yep, you're basically entering an empry query as $sql is not defined.

But a generic function for different types of queries might be a bit useless as the return values of mysql_query can be very different, ranging from simple boolean values of a say INSERT to big results of SELECT queries.
I don't if you meant to do it but although otherwise a possible thing to do would be to send multiple queries tot the databse at once, separated by semicolons this is not possible with PHP as it is considered a security threat. You code would miss the appending of the quesries anyways so you probably weren't thinking about this.
*



I didn't look closely enough to see that there was both INSERT and SELECT commands being sent as a result, the very least you should use a different function for each type unless you are pretty good with your function writing.

vujsa

Comment/Reply (w/o sign-up)

Hercco
QUOTE(vujsa @ Nov 24 2005, 01:30 AM)
I didn't look closely enough to see that there was both INSERT and SELECT commands being sent as a result, the very least you should use a different function for each type unless you are pretty good with your function writing.

vujsa
*



I guess there could be alternative methods inside the function. It would check whether the query starts with SELECT or INSERT and the select the proper action. Would be a bit messy function but on the other hand the actual code would look neat with only single type of function calls for database queries.



Comment/Reply (w/o sign-up)

vujsa
I tend to write a perfectly good function for one use. Then later when I need a similar function, I just modify the first function. Then later, I need yet another similar function and repeat the process. I tend to write very complex functions as a result which are able to handle several different requests and then the function call is very simple to write as a result.

Since most of my database functions are all-in-one, I just need to use the same call each time with different variables. Then I tend to name my function something like deal_with_the_db() which is what it does and I don't have to think about the DB anymore. LOL

I tend to get frustrated with the mySQL commands so I remove myself a little.

By the way, why is it so difficult to get information out of the database even if you have all of the required information and you only want one entry. wink.gif

vujsa

Comment/Reply (w/o sign-up)

TavoxPeru
QUOTE(wannabeeaweak @ Nov 16 2005, 11:26 PM) *

hey well can some one helpme make this code work it won't INSERT INTO THE DATABSE

CODE
<?php
# register1.php
# common include file to MySQL
include("DB.PHP");

$Username=$_POST['Username'];
$Password=$_POST['Password'];
$Name=$_POST['Name'];
$Last=$_POST['Last'];
$Sex=$_POST['Sex'];
$Month=$_POST['Month'];
$Day=$_POST['Day'];
$Year=$_POST['Year'];
$Adresse=$_POST['Adresse'];
$City=$_POST['City'];
$State=$_POST['State'];
$Zipcode=$_POST['Zipcode'];
$Country=$_POST['Country'];
$Phone=$_POST['Phone'];
$Email=$_POST['Email'];
$Father_Name=$_POST['Father_Name'];
$Mother_Name=$_POST['Mother_Name'];
$Parent_Phone=$_POST['Parent_Phone'];
$Parent_Email=$_POST['Parent_Email'];
$Level=$_POST['Level'];
$Academic=$_POST['Academic'];
$Image_Link=$_POST['prevImage'];
$sql9="INSERT INTO User
SET id = 'NULL',
   Username = '$Username',
   Password = '$Password',
    Name='$Name',
   Last='$Last',
    Sex='$Sex',
    Month='$Month',
    Day='$Day',
    Year='$Year',
    Adresse='$Adresse',
    City='$City',
    State='$State',
    Zipcode='$Zipcode',
    Country='$Country',
    Phone='$Phone',
    Email='$Email',
    Father_Name='$Father_Name',
    Mother_Name='$Mother_Name',
    Parent_Phone='$Parent_Phone',
    Parent_Email='$Parent_Email',
    Level='$Level',
    $Academic='$Academic'";


Your SQL Insert statement is wrong, you confused it with the UPDATE SQL Statement, the correct way to write it is:
CODE
$sql9="INSERT INTO User(
Username, Password, Name, Last, Sex, Month, Day, Year,
Adresse, City, State, Zipcode, Country, Phone, Email,
Father_Name, Mother_Name, Parent_Phone, Parent_Email,
Level, Academic)
Values('$Username', '$Password', '$Name', '$Last', '$Sex', '$Month', '$Day', '$Year',
'$Adresse', '$City', '$State', '$Zipcode', '$Country', '$Phone', '$Email',
'$Father_Name', '$Mother_Name', '$Parent_Phone', '$Parent_Email',
'$Level', '$Academic')";

mysql_query($sql9) or die(mysql_errno(). ": " . mysql_error() );


I dont include the id field because i think it is an integer autonumeric field, let me know if im wrong about it, also you must verify all your data prior to your insertion, maybe using javascript in your forms page and another good practice to prevent sql injections is the use of the mysql_real_escape_string function if your system has the magic_quoutes_gpc off.

Best regards,

Comment/Reply (w/o sign-up)

minnieadkins
QUOTE(TavoxPeru @ May 5 2006, 08:30 PM) *

Your SQL Insert statement is wrong, you confused it with the UPDATE SQL Statement, the correct way to write it is:
CODE
$sql9="INSERT INTO User(
Username, Password, Name, Last, Sex, Month, Day, Year,
Adresse, City, State, Zipcode, Country, Phone, Email,
Father_Name, Mother_Name, Parent_Phone, Parent_Email,
Level, Academic)
Values('$Username', '$Password', '$Name', '$Last', '$Sex', '$Month', '$Day', '$Year',
'$Adresse', '$City', '$State', '$Zipcode', '$Country', '$Phone', '$Email',
'$Father_Name', '$Mother_Name', '$Parent_Phone', '$Parent_Email',
'$Level', '$Academic')";

mysql_query($sql9) or die(mysql_errno(). ": " . mysql_error() );


I dont include the id field because i think it is an integer autonumeric field, let me know if im wrong about it, also you must verify all your data prior to your insertion, maybe using javascript in your forms page and another good practice to prevent sql injections is the use of the mysql_real_escape_string function if your system has the magic_quoutes_gpc off.

Best regards,


Actually you can do a traditional
CODE
INSERT INTO table(value1, value2) VALUES('SomeValue', 'SomeValue2')

But I think in mysql it'll let you address an insert statement as if you're updating, which isn't the same for postgres. Try it and let me know what you find out, but I'm pretty sure it's allowed. In this case he's wating to insert, not update. I was looking at a previous script that one of my professors wrote usuing a mysql database and his insert scripts looked a lot like the update statements. When we switched over to postgres we had to redo the insert statements to match to the traditional insert statement. It would probably be wise to stick with traditional unless you plan on staying with mysql.

Vujsa, you don't actually use a dbi? You just right your own code to supplement the use of db connections/queries? I was introduced to a dbi that's based on perl's standard dbi or something like that. I like it a lot better than all the php functions to deal with mysql/postgres. It standardizes everything, so whatever you want to do (use mysql, or postgres) you use same function call. You just change the inital connection's function to receieve a string argument of what database. I believe that's the way it's done, but with the script I'm working on there's about 10 different includes to every page in order to make it work right. Good experience tho.

After thinking about it I can see the advantage of writing a script that does what you're talking about vujsa. Have a function like build_db_query or something that builds the actually query and returns it as a string perhaps. You pass a table name, and an array of values in an assoc array indexing the related tables in the fields. You could make it even more flexible and add flag to determine whether it's a select, insert, update, or delete statement. Just have a switch on the flag, then build the appropriate sql statement.

I'm rather new to OOP and php, but can't this be done with polymorphism? (rather new to OOP in general)

Comment/Reply (w/o sign-up)

Latest Entries

Arbitrary
QUOTE
After thinking about it I can see the advantage of writing a script that does what you're talking about vujsa. Have a function like build_db_query or something that builds the actually query and returns it as a string perhaps. You pass a table name, and an array of values in an assoc array indexing the related tables in the fields. You could make it even more flexible and add flag to determine whether it's a select, insert, update, or delete statement. Just have a switch on the flag, then build the appropriate sql statement.

This has been done before in the CakePHP framework (see http://api.cakephp.org/class_model.html#eb...b5a35dd428f5c81 and I'm sure numerous other PHP frameworks that I don't work extensively with as well), except that Cake didn't take advantage of PHP's OOP because it also wanted to be PHP 4 compatible. It just requires that you pass in the variables in a certain format (in Cake's case it's an array) and then parse based on the fields and values in that format. It is really quite flexible and makes saving data a lot faster than writing the same old INSERT functions. Especially in this case where the insert function is exceptionally huge, having a function like that would be a huge advantage.

Hey hotsam!

I'd say for your firearms and reviews, you don't need a many-to-many relationship. After all, each review only has one firearm; each review wouldn't have multiple firearms, would they? Then each firearm would have many reviews, which would make sense. As for the business to firearm relationship, I'm not sure if a firearm can have many businesses--that would depend on the license, right? Aren't many firearms licensed so that they're only made by one business? (Then again, I'm not familiar with their creation...)

Everything else makes sense to me. :-) Good luck!

Comment/Reply (w/o sign-up)

hotsam
Hi,

Below is a picture of my database tables, and their relationships. I was hoping someone might have a quick look and tell me if I'm on the right track, or if I need to:

Change PRIMARY keys
Change INDEX / FOREIGN keys
Change Table Structures

Also, I'd like to add a table that stores the various CALIBERS that firearms are available in. I'm thinking the relationship would be many-to-many, as a firearm can have many calibres, and a calibre is available for many firearms...?

How would I make the CALIBRE table? What fields should the table contain, and how should it relate to the FIREARMS table? I'd like to be able to output a list of firearms, and show available calibres for each of those firearms.

Just to help out, the database will be used to:
- search for firearms and their available calibres
- show retailers that sell a particular make of firearm
- show reviews that owners (users) submit. These will be shown alongside each firearm searched for


http://home.exetel.com.au/jazzy/relationships.png

Thanks for any help!
Jarrad





Comment/Reply (w/o sign-up)

iGuest
business logic validation
Need Help With A PHP - MySQL Registration Script

How to do business logic validation to check whether duplicate username is already existing in database using php

-question by kalai

Comment/Reply (w/o sign-up)


Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Pages: 1, 2
Similar Topics

Keywords : php, mysql, registration, script, insert, database

  1. Php Script Organizer
    (3)
  2. Myspacetv Download Php Script Help
    (6)
    I was trying to make a php script that can view myspace videos with jw flv player and wont to know
    how to do so if i put in
    "http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=38105626" it show the video
    "http://cache01-videos02.myspacecdn.com/11/vid_e382054c036835500bacfef1ebb5157e.flv(its the flv
    video file from myspacetv), I cant see the similarity with the links please help, thanks for viewing
    this topic /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />....
  3. Php Login Script
    (0)
    login script click the link to get your free php login script installer just follow the
    instuctions the exe gives you and it will give you the script just place the code in the sever and
    open index.html and follow on from there. what it has: it has reg page, login protection code ect.
    it is simple to use and i think quite fun but im BORN TO BE WEIRD,you will need at least one working
    mysql data base /biggrin.gif" style="vertical-align:middle" emoid=":D" border="0" alt="biggrin.gif"
    /> hope you enjoy it. iknow i did from the alexmedia crew....
  4. Make A Script Run Even If No User Is Online
    (6)
    Hey! Is there any way to make a script run, even if no user is online. Because at the moment, my
    scripts run, only when a user is online. And another thing: How can i make the following: (this is
    just an example) mysql_query"SELECT maxhp FROM users WHERE username = 'allusers'"; How can I
    select all users maxhp, in the same query? Thanks //Feelay....
  5. Letting Users Add Mysql Data With Php
    (1)
    I'm curious as to the best methods of letting users submit data to a MySQL database, displaying
    that data, and removing any unwanted tags etc. from it. Currently, there's a handful of PHP
    functions that I know of to help with this: mysql_real_escape_string() - perhaps the best known
    and most commonly used function, it should be used in pretty much any MySQL query. It escapes
    characters that have SQL significance. QUOTE(php.net) ...which prepends backslashes to the
    following characters: \x00, \n, \r, \, ', " and \x1a I like to think I made a pretty....
  6. Writing And Testing My Own Login Script [solved]
    (20)
    i have this error QUOTE Warning: session_start() : Cannot send session cache limiter - headers
    already sent (output started at /home/eggie/public_html/race.php:2) in
    /home/eggie/public_html/race.php on line 5 in every page i have with session start...what's
    the problem?? CODE Race include("style.css"); include("config.php"); session_start();
    if(!session_is_registered(myusername)){ echo 'Your Session has Expired!'; exit;} //If you
    click race... if ($_GET =='race') { $asa=$_POST ; if(!isset($asa)) { echo 'You
    didn\'t select an....
  7. Mysql Question(inserting Number From A Textfield)
    (3)
    Hey! I am trying to do a "Admin give EXP script". But I can't make it work. The value is not
    updating, but the update query is correct.( I think:P) I think the fault is here: CODE
    $expcomp=$givexpp += $givexp; The $givexp is the variable for the amount of Xp the admin wants
    to give. the $givexpp is the variable for the user info (in this case, the experince he already
    have). The datatype for the XP in the database is INT. So I have no idea if it can take data from a
    normal textfield. If you need to see all the code, here you go: CODE session_start();....
  8. Making Something In Mysql Happen Only Once
    (10)
    Hey! I know I am asking alot. But much is happening theese days. Sorry if I disturb with my
    questions. The thing I am trying to do is: Ex. If the user becomes level 2, he should get 5 skill
    points. I can't do this: CODE if($userlevel=5){ mysql_query("UPDATE user SET skillpoints
    =$points+5");} because then it would update everytime the code was loaded. I hope you understand
    what I am trying to do. If not, tell me /smile.gif" style="vertical-align:middle" emoid=":)"
    border="0" alt="smile.gif" /> and i'll try to explain better. Thanks //Feelay....
  9. Making A Link = Mysql_query
    (8)
    Hey! I will try to make this as clear as possible. how can I make the following. I have a list,
    of all members on my site. If I press on a members name(link), I will come to his profile. To come
    to his profile, I need to get out some vaule from the database, but to get out some value from the
    database, I must tell the code, how it should know who the user is (hard to understand?). To do
    that, I must add a mysql_query in the code ( I think), like "SELECT user FROM dbname WHERE
    user=link".. This is just how I think it works. I know it is kinda wrong.. but I don't k....
  10. Script Request
    script request (2)
    another script request i am looking for a file manger tutorial with edit delete search upload move
    copy and a WYSIWYG(What You See Is What You Get) editer like on on freewebs.com and css editor plz
    help! i need on badly vmkrightpoint Edit"i keep search google and msn and yahoo i can't find
    on!! lol"....
  11. Free Forum Hosting Type Script Help!
    Free forum hosting type script help!!! (2)
    i want to make something like http://invisionfree.com/ that makes an dir with your phpbb 3 forum
    in it with an admin CP plz help i really want to make something like it!! i was thinking of coding
    my own with file handling but i'm not good at some of it like "when u click submit to register
    a forums it will move the phpbb3 file that leads to the users dir then it will rename the dir to
    your username so like my.site.com/username it might work" with the admin username and pass and
    admin's email it will open the config.php then edit all the data but it will ke....
  12. Login Script
    (8)
    I have another question--- i downloaded script of a game and it worked until my server changed to
    newer version of php after which it didn't work... the most probable reason is that globals are
    not enabled... now i need someone who can tell me what to put instead of what to make it work...
    this is my login.php script CODE if (!$user || !$pass) {     include("head.php");     print
    "Please fill out all fields.";     include("foot.php");     exit; } include("head.php"); $password =
    md5($pass); $password2 = md5($password); $password3 = md5($password2); $password4 =....
  13. How To Make A Value In The Database Raise Every Minute.
    (50)
    Hi. I am trying to figure out how to make a value in the database raise every minute. Lets say, I
    want the HP to raise every minute. The max HP is 100. I want it to raise 5 HP/ Hour. And the player
    don't have to be online. Anyone who know how I can do it =? Thanks for any help. //Feelay....
  14. Password Recovery Script
    (7)
    While trying to make password recovery script for "bhupinunder" i run into a problem... i made this:
    CODE $dbh = mysql_connect('localhost','jaskaran_gc','gc') or die
    ("Cannot Connect: " . mysql_error()); mysql_select_db('jaskaran_gc',$dbh); ?> ";?>
    if ($recover=answer) print"$email"; ?> and it doesn't print anything...but if i put it
    like this CODE $dbh = mysql_connect('localhost','jaskaran_gc','gc') or
    die ("Cannot Connect: " . mysql_error()); mysql_select_db('jaskaran_gc',$dbh....
  15. Warning: Mysql_result(): Supplied Argument Is Not A Valid Mysql Result Resource In ...
    This Is for My attack Script. (4)
    Hey. I am making a "Version 2.0" For my attack script, but I can't make it work. This is the
    error I am gettin: Warning: mysql_result(): supplied argument is not a valid MySQL result resource
    in And here is the code: CODE $dbQueryHealth = mysql_query("SELECT temphealth FROM
    characters WHERE user =". $_POST ."");           $currentHealth = mysql_result($dbQueryHealth, 0);
            $dbQueryExp = mysql_query("SELECT exp FROM characters WHERE user = ".$_POST ."");  
            $currentExp = mysql_result($dbQueryExp, 0); I have checked the PHP Manual,....
  16. Warning: Mysql_num_rows()
    What is the error :S (1)
    Hey! I've made a register script.. Some time ago it worked. And I ain't sure if I changed
    something since then.. The error I am getting is this: Warning: mysql_num_rows(): supplied argument
    is not a valid MySQL result resource in /home/feelay/public_html/regcheck.php on line 31 Here is
    the code on theese lines: CODE $sqlCheckForDuplicate = "SELECT username FROM user WHERE username
    = '". $username ."'";                 if( mysql_num_rows( mysql_query(
    $sqlCheckForDuplicate ) ) == 0 )         {             $sqlRegUser =     "INSERT INTO            ....
  17. SQL Doesn't Connect In PHP Script
    I made some code updates now the script is broken. (19)
    i have created a website and it is not working properly... i have had a website on sphosting.com and
    everything worked fine till i got some errors(i got the errors because of the crappy host)...now the
    fun part starts...they said they solved the problem but i got another one..i said them to repair it
    again and they did...now i tried to login but as i entered the info it said the info isn't
    correct...i checked the SQL and everything seemed fine..i tried again and again the error came...i
    tried than to register,entered ALL info and when this was suppose to come out "Yo....
  18. Php Script Help
    help with scripting of php (1)
    Ok first a little back story of what happened and why I am asking for help. I have been playing text
    based rpgs and found that I really like them. Well I have also found that most programers don't
    want to listen to their clients in the sugestion box and when u make a content sughesstion they get
    rude or make fun of your idea. So I decided I would sart my own and make it where the users had say
    so in added content. Not saying all sugestions will get added but I will not make fun or get mad at
    them. Any who when I bought the script I was under the impression it was fu....
  19. Run A Script When Expires A Session
    (6)
    For example, when a user logins to a page -with a login form- and after validating and verifying
    it's credentials i store some information related to this user in session variables and a table
    with his state -connected- is updated, then i use it in other pages, etc. When this user logouts
    -by clicking a logout link- i release -unregister, destroy, etc- all the session variables stored
    and the same table is updated with his state -disconnected-. All of this funcionality works very
    well, the problem comes when the user do not click on the logout link and the session ....
  20. Automated Product Suggestion Script
    Compare user lists and suggest related items based on pattern matching (2)
    I recently got an idea for a project and one of the features I wanted the project to have was an
    automated suggestion service. If anyone has been to Amazon, it would work much like their
    recommended product feature. What I want to do is take several users lists of whatever but for this
    example, I'll use web links like from the browser history. I would want to suggest links to a
    user based on common links in many other users lists. User A: Amazon, Ebay, Excite, Google, Yahoo,
    MySpace, Walmart User B: Amazon, Ebay, Google, Yahoo, You Tube, MySpace, CVS User C: Amazo....
  21. Anyone Know Of A Really Good Mysql Class?
    Looking for something easy but full featured. (4)
    Generally speaking, when I write a script, it either utilizes the MySQL class of the parent system
    (like Mambo or Joomla) or I use basic functions and snippets to perform the database queries I need.
    I really like the Joomla database class as it allows you to simply pass a regular query string to
    it and the data is returned without the need for extra work! The Invision Power Board (IPB)
    database class which is what is used for this forum is kind of a pain to use since it wants the
    query string in a non-MySQL standard format. Nonetheless, it does work and I could use i....
  22. PHP & MySQL: Displaying Content From A Given ID
    (6)
    Okay so I got this sample link (not working): http://www.acosta.com/joo.asp?id=654 Now suppose
    I have a PHP file that would use MySql in order to get all values in the row where id 654 is found.
    Here's a sample DB: Table: demnyc ______________________________________ | id |
    Name | Age | Email | *----------------------------------------------------* | 1
    | Albert | 17 | no email |
    *----------------------------------------------------* | 2 | YaPow | 888 |
    no email | |__________....
  23. Need MySQL Alternative To The Syntax "or die()"
    (9)
    Hello again /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />
    I'm facing a problem with PHP and MySQL... I want, when a MySQL error occurs, to let the script
    continue. Here's the script: CODE $query = "SELECT * FROM menus ORDER BY id ASC";
    $menus_result = mysql_query($query) or die("Error!"); while( $menu=mysql_fetch_array($menus_result)
    ) {    echo $menu ." "; } Now if the table "menus" doesn't exist, this would echo "Error!"
    where it's placed and terminate the whole script. But I want it to echo "Error!" and....
  24. What Would Make A Good Registration Script?
    (4)
    I see newbies all the time looking for either a login script or after a little querying you find
    they really would like to have a registration script. The first thing for such a script for a
    members area would of course be a form and being kind of old fashioned I still like to format my
    forms with a table but I do use inline CSS to make it a little nicer. I never did like forms that
    had an asterick * by a field and then a Note: Fields marked with * are required. So what I do
    instead is add a background color to those areas and then use a CSS background color statin....
  25. A Simple Checking & Validation PHP Script
    (8)
    Hi, there is sometimes that you need to password protect a directory in your site but you dont have
    access to a database or you dont need it because only a few users will access this directory, well
    the following script i develop will help in this situation. With only 2 files you can implement a
    basic security, the first file is a simple txt file where you store your users information and the
    second file is the php script. You can name the files whatever you want and can be used in any site
    with php support. The users.txt file: In this file simply put one line at the....
  26. Important: Basics Of Using PHP And MySQL
    (10)
    I generally notice confusion with new users to PHP and or MySQL and first of all I believe that
    unlike HTML which is automatically associated with a IE browser in a Microsoft system. HTML is
    automatically rendered with whatever browser is the default browser, be it Internet Expolrer Firefox
    Netscape or any other browser that has been set. PHP is a different matter to view the output of a
    PHP file it must be run on a webserver, and if you do not have one set up on your local PC it simply
    will not work. (Note serverside langauge requies a server) HTML is client side and ....
  27. PHP Script To Upload A File
    with password-protection. (15)
    Problem: Upload a file to the AstaHost account (that I have been granted here) throught the
    webpage I would like to know, how should I proceed on this particular problem. I know this has
    been done through cPanel, but I want to write a PHP functionality. The cPanel is accessed through
    the 2082 port, and most of the places I access internet from does not give me access through that
    port. I can access http://www.kmaheshbhat.astahost.com/ but not
    http://www.kmaheshbhat.astahost.com/cpanel or http://www.kmaheshbhat.astahost.com:2082/ . I need
    to go to one particu....
  28. [PHP + MySQL] Encrypting Data
    To protect the password of your DB, for example. (13)
    Hi! This is my 2nd code of PHP + MySQL. This code is VERY simple: it encript the data in the MySQL
    DB. Here we go! ------------------------------------------------------------------------ CODE
    $password = "abc"; $new_password = md5($password); echo $new_password; ?> The password "abc"
    was codfied using md5() This will be: 900150983cd24fb0d6963f7d28e17f72 CODE $normal_pass =
    "abc"; $encripted_pass = "900150983cd24fb0d6963f7d28e17f72"; if(md5($normal_pass) ==
    $encripted_pass)   echo "Login Sucessful!"; else   echo "Incorrect password."; ?> This c....
  29. Php Script To Download File From Another Site
    (11)
    hi i need a php or java script code for downloading files from other sites to my site for example:
    http://download.com/file.zip to http://mysite.com/file.zip thanks....
  30. Tell-a-friend script
    Make a tell-a-friend script with php!! (6)
    Hi!! I'll show you how to make a simple tell-a-friend script using php. If you put this on
    your site, your visitors will be able to recommend your site to a friend. This can be good promotion
    for your site. It's quite easy to set up too. Just copy and past the script below. Put this
    where you want the form to appear: friendtell.php " method="get"> Tell a friend:
    Put this in the file friendtell.php Your friend has been told! $myname = $from;
    $myemail = $from; $contactemail = $to; $message = " Hi!! \nI wanted to tell y....

    1. Looking for php, mysql, registration, script, insert, database

See Also,

*SIMILAR VIDEOS*
Searching Video's for php, mysql, registration, script, insert, database
Similar
Php Script Organizer
Myspacetv Download Php Script Help
Php Login Script
Make A Script Run Even If No User Is Online
Letting Users Add Mysql Data With Php
Writing And Testing My Own Login Script [solved]
Mysql Question(inserting Number From A Textfield)
Making Something In Mysql Happen Only Once
Making A Link = Mysql_query
Script Request - script request
Free Forum Hosting Type Script Help! - Free forum hosting type script help!!!
Login Script
How To Make A Value In The Database Raise Every Minute.
Password Recovery Script
Warning: Mysql_result(): Supplied Argument Is Not A Valid Mysql Result Resource In ... - This Is for My attack Script.
Warning: Mysql_num_rows() - What is the error :S
SQL Doesn't Connect In PHP Script - I made some code updates now the script is broken.
Php Script Help - help with scripting of php
Run A Script When Expires A Session
Automated Product Suggestion Script - Compare user lists and suggest related items based on pattern matching
Anyone Know Of A Really Good Mysql Class? - Looking for something easy but full featured.
PHP & MySQL: Displaying Content From A Given ID
Need MySQL Alternative To The Syntax "or die()"
What Would Make A Good Registration Script?
A Simple Checking & Validation PHP Script
Important: Basics Of Using PHP And MySQL
PHP Script To Upload A File - with password-protection.
[PHP + MySQL] Encrypting Data - To protect the password of your DB, for example.
Php Script To Download File From Another Site
Tell-a-friend script - Make a tell-a-friend script with php!!
advertisement



Need Help With A PHP - MySQL Registration Script - Wont INSERT into the database

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com