Posts by nav33n Page 32

When the user registers, set the value for activation column as 0 (for that user) in the user table. When the user activates, update activation column to 1 for that user. Then, when the user tries to log in, while checking for username and password, also check if activation=1. If it isn't 1, promt him to activate first.

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: PHP Variable in mySQL query

You are welcome! Btw, php parser doesn't parse a variable if you put it within ' '. More about it here .

Web Development mysql php

nav33n 472 Purple hazed!

17 Years Ago

Re: me?

Welcome!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Hi friends, this is Annajee............

Welcome to Daniweb annajee and tonydestiny1988 ! :)

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: HI yall

Welcome to Daniweb !

how do I post in the forums, I don't see a post button in hardware?

Just like you posted here ! :-/

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: PHP Variable in mySQL query

Try this.

mysql_query("SELECT * FROM $quiz_name");

If this doesn't work, print out the query and run it in phpmyadmin/mysql console. See what the problem is.

Web Development mysql php

nav33n 472 Purple hazed!

17 Years Ago

Re: PHP Variable in mySQL query

Do you have the database connection in your script ? And Check if $quiz_name isn't empty.

Web Development mysql php

nav33n 472 Purple hazed!

17 Years Ago

Re: PHP Variable in mySQL query

$result = mysql_query("SELECT * FROM '$quiz_name'");
$num_rows = mysql_num_rows($result12);

$result12 should be $result.

Web Development mysql php

nav33n 472 Purple hazed!

17 Years Ago

Re: Trouble with password recovery emal script

Oh thanks.. But wouldn't it affect the query if we do it like

select team_ID,teamname,teampassword from teams where teamemail='{$email}'

Because, anything between ' ' will be considered as a value.. isn't it ?

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: want to pass php variable to javascript

:) You are welcome!

Web Development javascript php

nav33n 472 Purple hazed!

17 Years Ago

Re: Trouble with password recovery emal script

$teampassword=getvar("teampassword")

Missing ; at the end. Didn't you get any parse error ? Hmm! And

select team_ID,teamname,teampassword from teams where teamemail='{$email}'

shouldn't that be

select team_ID,teamname,teampassword from teams where teamemail='$email'

And also here,

<input type='text' name='email' value='{$email}'>

Why is value='{$email'} ? When you query the table, it will look for email, for example, {test@test.com} !

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: want to pass php variable to javascript

Umm.. you are passing the id as a parameter. Why are you trying to assign the value of $id to t (in javascript function) ?

<html>
<head>
<SCRIPT LANGUAGE="JAVASCRIPT" TYPE="TEXT/JAVASCRIPT">
<!--
function login(t) {
alert(t);
}
-->
</SCRIPT>
</head>
<body> 
<?php
$id=$_GET['id'];
print "<input type='button' name='button' value='button' onClick=login('$id')>";
?>
</body>
</html>

This works just fine !

Web Development javascript php

peter_budo commented: Another great snippet +7

nav33n 472 Purple hazed!

17 Years Ago

Re: Count Down Game

-950

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: Hi there ! I am Anan

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Hello :D

Welcome!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Hi there! I am Asim

Welcome!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Count Down Game

-947

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: Problems with form submition

You are welcome ;)

Web Development javascript

nav33n 472 Purple hazed!

17 Years Ago

Re: sending a array to next page

Almost correct. When you submit the page, the checkboxes which were checked will be passed on to the next page. You can use foreach to get the checked values. Query the table and get the rows for these ID's.

<?php
foreach($_POST['checkboxname'] as $value){
$query = "select * from table where id='$value'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
 $school = $row['school'];
$date = $row['date']; //and so on..
//Then insert these values to the table
$insert = "insert into table2 (col1,col2) values ('$school','$date')";
mysql_query($insert);
}
}
//so, it will insert a row in the table for every checked checkbox value

I hope thats clear..

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Hello all! Bobby checkin in.....

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Hello Everyone

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Hi am Nobert

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: HI all, this is Navin

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: hi everyone!!!

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: I am new

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: sending a array to next page

Then query the table with the ID's passed.. Get the row and insert it to another table.

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: sending a array to next page

I dont understand.. You already have a record in the table and you want to insert another record for the same ID ? Can you explain in detail what exactly are you trying to do ?

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: sending a array to next page

What are you doing with the ID ? Are you using it to do anything important ? Like updating/inserting any value to a table ? If so, you need ID field. Umm.. Hey, why not do it this way. ID represents a row in the table. For example, If ID = 1, all the other details, $a_row, $a_row and $a_row will have the relevant value. Why not query the table and get the data when the user submits the form ?
Ie., from your code, you have passed 2 values to the next page.

Array ( [0] => 9 [1] => 14 )

Query the table and get the rows where ID = 9 and 14 respectively.

<?php
foreach($_POST['checkboxname'] as $value){
$query = "select * from table where id='$value'";
//execute the query and get the rows and print it..
}

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: How to retrieve table names

Thanks :)

Databases mssql

nav33n 472 Purple hazed!

17 Years Ago

Re: sending a array to next page

Well, if you wish to use sessions, its going to be a lil tedious because, say for example, there are 10 checkboxes and the user selects 5. You need to have an array of session variables and get only the selected index of the checkbox. Thats going to be very difficult !
But you can try this alternative. Instead of,

<input type="checkbox" name="hello[]" value="'.$a_row.'">

pass $row, $row and $row as the value.

$value = $row['date']. ";".$row['school'].";".$row['people'];
<input type="checkbox" name="hello[]" value=".$value.">

So, when a checkbox is checked, all these values are passed onto the next page as the checkbox value.

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Looking for email script

Umm.. you want a php script that sends email, but dont want to install php on the server ?
:-/ I am not sure where you will find one like that!

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: sending a array to next page

You mean, you want to see all the other details like

<td style=\"color:Black\">".$a_row."</td>".
"<td style=\"color:Black\">".$a_row."</td>".
"<td style=\"color:Black\">".$a_row."</td>".

? You cant. If you want all these details to be passed onto the next page, have textboxes assign these values to the textboxes and then you can get these values in the next page. Or, use session.

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: New Member Greeting...

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Looking for email script

I searched google for days and I couldn't find anything that works for me.

Did you search in php.net ?

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: sending a array to next page

In the next page, if you do, print_r($_POST); you will see ONLY the list of checkboxes which were checked..

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Displaying PHP result within HTML?

I dont see line 30 in that code snippet !
And btw, instead of echo "<td>$row['last_name']</td>"; Try, echo "<td>".$row['last_name']."</td>";

Web Development html-css php

nav33n 472 Purple hazed!

17 Years Ago

Re: php mailto () fuction

hmm.. All the best !

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Inroduction - New Member

Welcome Tring!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Introduction

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: php mailto () fuction

can the $_request variable be used to recall a page instead of an textarea?

Nope.. You can only use $_REQUEST to get the value from a form.
Umm.. I think you can try, $message = implode("",file("broad_prev.php")); Not sure, but you can try that.

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: php mailto () fuction

Why not write a new script ? You can check this example here to send mails with attachments.
http://www.webcheatsheet.com/PHP/send_email_text_html_attachment.php

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: php mailto () fuction

i think that is how you wanted me to put it. it is now giving me an error when i try to load the page saying unexpected $ at the end of the code but this must have something to do with the $message=. within the html code.

No.. there is an unclosed bracket.. Find it and close it !

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: how to assign javascript variable to php variable

AFAIK, Its not possible.

Web Development javascript php