Posts by nav33n Page 67

First check the file type you are trying to upload. You can get the filetype of the file you are trying to upload by using $_FILES. I guess you are uploading a different file type(and checking for a different filetype).

if($_FILES['file']['type'] == "image/pjpeg" || $_FILES['file']['type']=="image/jpeg" || $_FILES['file']['type']=="image/gif") {
   //do something
} else {
  //wrong extension
}

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Fantastic word game

Reading gives me immense pleasure. Reading love letters that is.

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: Uploading multiple Images through input type="file"

:) You are welcome! I am not a guru! There are sooooo many things that I am not aware of.

isset() checks whether a variable is set, has a value (even null) in it. So, this would pass the value of that variable, only if its set.

if(isset[$_POST['name'])){
  $name=$_POST['name'];
} else {
  echo "Name is not set.";
}

As I said, If you assign null to a variable and check if it is set, it would return true.

$x="";
if(isset($x)){
echo "X is set";
} else {
echo "X is not set.";
}

In this case, it returns X is set, even though it doesn't have any value.

Cheers,
Naveen

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Fantastic word game

Raining doesnt necessary relate to water falling from sky! :)

Err! You are supposed to start a sentence with the last word of the previous post! Software, in this case.

Sky is blue, water is blue, the fishes are dumb, so are you!

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: Fantastic word game

The Gimp is an open source software.

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: TV/Movie Quotes

It's okay. He's just admiring the shape of your skull. - Fear and loathing in Las vegas.

Geeks' Lounge

nav33n 472 Purple hazed!

17 Years Ago

Re: I am asking a questions?

Simply WoW!

Geeks' Lounge

nav33n 472 Purple hazed!

17 Years Ago

Re: validation

Welcome to Daniweb! Please post your question in msaccess forum.

Databases microsoft-access

nav33n 472 Purple hazed!

17 Years Ago

Re: Need Help

You are welcome! And yep, you can use both AND and && .

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Fantastic word game

Paint is microsoft window's default picture editor. Its commonly known as Mspaint!

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: Selecting info from multiple mysql tables and display

In general, non-correlated subqueries are faster than joins, and correlated subqueries are slower than joins.

I was talking about non-correlated subqueries.

Ref: http://docs.hp.com/en/36216-90103/ch03s02.html

Oops! I didn't see your edited post !

Web Development mysql php

nav33n 472 Purple hazed!

17 Years Ago

Re: Yes or No

No.

Are you mad ?

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: Selecting info from multiple mysql tables and display

A sub-query returns only those records which matches the condition where as joins returns the cartesian product(if no condition is specified).
If you want to fetch the data from many tables, sub-queries are more efficient than joins.
:)

Web Development mysql php

nav33n 472 Purple hazed!

17 Years Ago

Re: Fantastic word game

Soul is invincible! Only the body dies.

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: only show in IE but not firefox,any clue why?

<script language="javascript" type="text/javascript">
//start display day/date code
//file:

DaysofWeek = new Array()
DaysofWeek[0]="Sunday"
DaysofWeek[1]="Monday"
DaysofWeek[2]="Tuesday"
DaysofWeek[3]="Wednesday"
DaysofWeek[4]="Thursday"
DaysofWeek[5]="Friday"
DaysofWeek[6]="Saturday"

Months = new Array()
Months[0]="January"
Months[1]="February"
Months[2]="March"
Months[3]="April"
Months[4]="May"
Months[5]="June"
Months[6]="July"
Months[7]="August"
Months[8]="September"
Months[9]="October"
Months[10]="November"
Months[11]="December"


function fixNumber(the_number){
if (the_number < 10){
the_number = "0" + the_number;
}
return the_number;
}

function fixPMHours(the_number){
if (the_number>12){
the_number = the_number - 12;
}
return the_number;
}


var dayVal;
var timeVal=new Date()
var m=timeVal.getMinutes()
var h=timeVal.getHours()
var fixed_hour = fixPMHours(h);
var da=timeVal.getDate()
var mo=timeVal.getMonth()
var year=timeVal.getYear()
var showDay=DaysofWeek[timeVal.getDay()]
var showMonth=Months[timeVal.getMonth()]
var fixed_minute = fixNumber(m);
var the_time = fixed_hour + ":" + fixed_minute;
var the_date = (showDay+", "+showMonth+" "+da+", "+year+" ")

function showTime(){
var timeValue = the_date+" ";
timeValue +=(h >= 12) ? " " : " ";
document.write(timeValue);
}


//file://end display day/date code
</script></font>
<font size="1" face="ms sans serif" color="#63C7DE">
<script language="javascript">
showTime();
</script>
</font></div>

This works in both IE and FF. The problem was file: :twisted:

Web Development javascript

nav33n 472 Purple hazed!

17 Years Ago

Re: Uploading multiple Images through input type="file"

<?php
	if(isset($_POST['submit'])) {
		for($i=0;$i<count($_FILES['fileupload']);$i++) {
			print $_FILES['fileupload']['name'][$i]."<br />";
		}
	}
	?>
<html>
<body>
<form name="upload" method="post" action="upload.php" enctype="multipart/form-data">
<table>
<tr><td>
<input type="file" name="fileupload[]">
</td></tr>
<tr><td>
<input type="file" name="fileupload[]">
</td></tr>
<tr><td>
<input type="file" name="fileupload[]">
</td></tr>
<tr><td>
<input type="file" name="fileupload[]">
</td></tr>
<tr><td>
<input type="submit" name="submit">
</td></tr>
</table>
</form>
</body>
</html>

This works for me! :)

Web Development php

OmniX commented: Gave me a working example +1

nav33n 472 Purple hazed!

17 Years Ago

Re: Intro and search

Welcome!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Fantastic Word Game-2

Someone At The Unicef Ripped Nine Insects, No Offence!

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: Uploading multiple Images through input type="file"

Can you show us your script ? What is the error that you are getting ?

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Need Help

Have 3 textboxes in your form. Call it firstname, lastname and date_of_birth. The page submits to 'somepage.php'. In somepage.php, you can access the form variables like,

$firstname = $_POST['firstname']; 
$lastname = $_POST['lastname'];
....

Then in your query, you can use these posted form variables. $query="select * from users where firstname='$firstname' AND lastname='$lastname'"; :)

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: PHP Mysql "Where" statement

You haven't shown us where you want to include a where clause. You should mention your problem in detail. :)

Web Development mysql php

nav33n 472 Purple hazed!

17 Years Ago

Re: Yes or No

Yes.

Do you like rain ?

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: Introducing myself, Colin Mallett

Welcome to Daniweb! I am sure you will learn alot from this community :)

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Hello World!! sorry....i meant hello everyone!

:P Welcome Crapodino!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Hello Everyone,

Welcome!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Fantastic word game

E is the 5th letter in English alphabet.

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: need help with query please

ah! i see.. thanks :)

Databases mysql

nav33n 472 Purple hazed!

17 Years Ago

Re: trying to make a survey for school yearbook, need help

* Do NOT display the host,username and password while posting in a public forum(Unless you want your database to be hacked!).
* You aren't closing your form.

Anyway, I think you should learn php and mysql first. Here is the script. Name it vote.php and run it. Change table name and the column names.

<?php
$conn=mysql_connect("localhost","username","password"); 
mysql_select_db("dbname");
$query="select user_id from grads";
$result=mysql_query($query);
$option="";
while($row=mysql_fetch_array($result)) {
   $option.="<option value=".$row['user_id'].">".$row['user_id']."</option>";    
}
if(isset($_POST['submit'])) {
$query="UPDATE TABLE SET VOTE = 1 WHERE USER_ID ='".$_POST['priceisright']."'";	
mysql_query($query);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Etobicoke Collegiate Institute's Grad Survey 2008</title>
</head>
<body>
<form action="vote.php" method="post">
<fieldset><legend>Please complete the following questions. Thanks!</legend>

<label>1. Be on the price is right</label><br />
<select name="priceisright">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />
<input name="submit" value="submit" type="submit">
</form>
</body>
</html>

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Fantastic word game

You wouldn't believe, but I just saw an alien.

Geeks' Lounge posting-games

nav33n 472 Purple hazed!

17 Years Ago

Re: hello

Welcome Rick!

P.S You will find help in Windows forum bout formatting your harddisk and installing windows !

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: A quick Hello

Welcome to Daniweb! You forgot to mention the programming language you work on :P

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: trying to make a survey for school yearbook, need help

Nope. It will show all the form variables that are passed. You can then use it to record the choices.

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: trying to make a survey for school yearbook, need help

ok.. That's not a problem!

<?php print_r($_POST); ?>

call that handle.php. This will print all the form variables :D !

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: trying to make a survey for school yearbook, need help

In handle.php just add print_r($_POST); at the top. You will get all the values passed from the form. You can then update your table by setting 1 for that particular person. And, the password generation script is a function. You just call the function, assign the return value to a variable, use that variable. Eg. $pass=functionname();

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: trying to make a survey for school yearbook, need help

I presume that you don't have much knowledge on php. You can go to w3schools and start learning the basics. But anyway, here is the script that you want. Make sure you enter the username and password correctly for your mysql connection,give the correct database name and specify the correct columns in the query.

<?php
$conn=mysql_connect("localhost","username","password"); 
mysql_select_db("student");
$query="select user_id,student_name from student";
$result=mysql_query($query);
$option="";
while($row=mysql_fetch_array($result)){
   $option.="<option value=".$row['user_id'].">".$row['student_name']."</option>";    
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Etobicoke Collegiate Institute's Grad Survey 2008</title>
</head>
<body>
<form action="handle.php" method="post">
<fieldset><legend>Please complete the following questions. Thanks!</legend>

<label>1. Be on the price is right</label><br />
<select name="priceisright">
  <option value="">Please Choose One Person</option>
  <option value="">Not Voting</option>
	<?php echo $option; ?>
</select>
<br />


</body>
</html>

Edit: If you encounter any errors, let me know.

Cheers,
Naveen

Web Development php

Sulley's Boo commented: jug jug jiyo =D +4

nav33n 472 Purple hazed!

17 Years Ago

Re: need help with query please

It's ok folks, I've just cracked it.
Here's the solution
SELECT username, title, COUNT(replies.comment) AS 'count'
FROM users, topics
LEFT JOIN replies
ON topics.topicid = replies.topicID
WHERE users.userid = topics.userid
GROUP BY topics.title
ORDER BY RAND()

Order by rand() ? Thats something new that I am seeing. What does it order by (which column) ?

Databases mysql

nav33n 472 Purple hazed!

17 Years Ago

Re: trying to make a survey for school yearbook, need help

Replace student_name with user_id in the query that I have given above. Then change, $row to $row.

As I said earlier, generating random password is easy. Check this site. Use that function in your script.

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: Selecting info from multiple mysql tables and display

What syntax should I use for my multiple table query? Will a JOIN be the fastest? Or would a simple multi-table query work just as quickly?

I think sub-queries are much faster than joins and also easier to understand.

What is the difference between using INNER and LEFT Joins?

Check this site. Its too confusing(for me) to explain.

And finally, when I access the information using php fetch_row functions, how do I designate which piece of data I am trying to access, since the syntax is $selectedrow and I am selecting from multiple tables, which may have some overlap of fields?

For this, you can use the table name along with the column names and use an alias. Eg.

$query="select emp.name as empname, emp.no as empno, dept.name as deptname, dept.location as deptlocation from employee emp, department dept where emp.deptid=dept.deptid";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
   $employee_name=$row['empname'];
   $department_location=$row['deptlocation'];
   .......
}

I hope that helps! :)

Web Development mysql php

nav33n 472 Purple hazed!

17 Years Ago

Re: Hello everyone

Welcome!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Hello all... Need help updating mysql with php

Phew! :) finally !

Web Development mysql php

nav33n 472 Purple hazed!

17 Years Ago

Re: J2e

Please ask in Java forum :)

Web Development php

nav33n 472 Purple hazed!

17 Years Ago

Re: hi

Welcome to Daniweb! Please post your question in respective programming forum. Read the guidelines before posting. We won't do your homework/office work. So, please show us what you have done so far.
Cheers,
Naveen

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Introductions

Welcome to Daniweb!

Say Hello!

nav33n 472 Purple hazed!

17 Years Ago

Re: Hello from Toronto

Welcome aboard!

Say Hello!