[MYSQL]

sure.

 

$q = mysql_query("SELECT * FROM videos ORDER BY id DESC");
while($f = mysql_fetch_assoc($q)){
  echo $f['id']."<BR>";
}

 

I'm not sure if that is what you are looking for. That while loop returns an array names $f.

[Unpleasant end to an awesome week.]

As developers we must learn to accept that our actions get people fired. Think of those many people a company would need to hire if they didn't had:

 

1) A CMS System

2) A CRM System

3) ..

What's a CRM System?

[Two Questions]

Okay gotcha, sorry I was tired when I was responding. I just woke up. I will finish writing my class and post it here for inspection.

[How did you learn php, how long did it take?]

I started when I was about 15, creating my own website in PHP, for no reason really. I would download code of the internet and take a look at it, and try to reproduce it. I then eventually became to the point where I could write code on my own without looking. I am now to the point where I can write clean, efficient code, I am now learning OOP. I figured it was time. I am 19 now. Oh, and this forum helped me out tons with my problems, I mean tons! PHP was my first language,  I now C, C++,  and Java. I do think learning a different language does help you grasp the concept in beginner programmers.

[Two Questions]

Okay Thanks for the help.

 

So do I not need to connect? Or are you just showing me an example? I am a bit new to mysqli as well.

[Two Questions]

1.OpenID, if I add it to my website, will I be able to gather data such as email, first name, last name, etc.

 

2.I am leaning OOP in PHP and I am trying to make a mysqli class, I'm not very good at it. Maybe you guys can help me here is what I have so far. Am I doing okay?

 

<?php
class database{
	var $mysqli;
	function __construct($host, $user, $pass, $db){
		$this->mysqli = new MySQLi($host, $user, $pass, $db);
	}
	function query($query){
		return mysqli_query($this->mysqli, $query);
	}
	function fetchAssoc($query){
		return mysqli_fetch_assoc(mysqli_query($this->mysqli, $query));
	}
	function numRows($query){
		return mysqli_num_rows(mysqli_query($this->mysqli, $query));
	}
	function delete($table, $where){
		return $this->query("DELETE FROM $table WHERE ".$where);
	}
}
?>

[foreach question.]

Gosh, how could I miss that. Thanks. I feel so dumb after you guys fix my mistakes.

[letting users post any image then administer, or i review them then post them]

I have actually seen a free script out there that detects adult images, what you could do is have that analyze the images uploaded if one is found to be an adult image, have the website email you and you can login and take a look at it, and approve it or delete it.

 

I would do a search for you, but I am at work and I am afraid something naughty will result in my quest for this script.

[best way to find out if there is a spyware?]

A Trojan Horse is a virus that attaches itself to other programs that are known to NOT be harmful, and then when the program is executed, the Trojan horse starts doing whatever it was programmed to do. 

 

The best thing to do is when you start seeing your mouse move again, unplug yourself from the internet. Doing so by, unplugging your ethernet cable, unplugging external wireless receivers, or somehow disconnecting yourself through hardware, not software. That way if you do have a intruder they don't know you are disconnecting them.

 

If the mouse has stopped moving, they are accessing you over the internet, and you need to remove any software that allows direct access to your computer. (Any remote desktop protocols: RDP's, Logmein, VNC, etc.)

 

If the mouse still is moving, it might be something interfering with your wireless mouse, as mentioned above. Remove the wireless receiver.

 

If the mouse has stopped moving, you have found your problem.

 

If the mouse is still moving, chances are they you have some sort of playful virus (I doubt it, since most viruses want to be incognito). It could be faulty mouse drivers, or improper mouse drivers. If you are on a laptop, it might be you accidentally touching the track pad while using your other mouse or something of that nature.

[check if its not in db]

You can do something like this

$q = mysql_query("SELECT song FROM table WHERE artist = '$artist'");
if(mysql_num_rows($q) == 0){
  echo "Song Exists";
}

 

[foreach question.]

I could post the entire form, lol - not, but I will post this:

 

<?php 
$id = $f['id'];
?>
<input type="checkbox" name="del" id="del" value="<?php echo $id; ?>">

[foreach question.]

Hmm, something like this?

 

		if(is_array($_POST['del'])){
			foreach($_POST['del'] as $id){
				mysql_query("DELETE FROM ".TBL_ADMINS." WHERE id = '$id'");
			}
		}else
			mysql_query("DELETE FROM ".TBL_ADMINS." WHERE id = '$id'");

[foreach question.]

I have a multiple checkbox page. I have handled these before, well. However, this time I am getting a strange error.

 

Here it is:

Warning: Invalid argument supplied for foreach() in C:\wamp\www\TheSportZone Store\admin\manageAdmin.php on line 10

 

Here is Line 10:

foreach($_POST['del'] as $id){

 

Entire foreach body:

		foreach($_POST['del'] as $id){
			mysql_query("DELETE FROM ".TBL_ADMINS." WHERE id = '$id'");
		}

 

Any ideas? I have done this before, as such, and it worked well.

[How to take user input and run it.]

Never mind.

[How to take user input and run it.]

What is the best way of taking a user's input and running it directly in PHP? So I have a textarea and the user puts in: echo "hi";

how can I run that?

 

Any ideas?

[My first script!]

Lol I like how this was posted on May 6th. So you are still not a noob ? Learning takes time.

Here is how I validate emails:

function validEmail($email){
return filter_var($email, FILTER_VALIDATE_EMAIL);
}

 

Good ol' one liners.

[What does this actually do?]

Not sure on the trim function, but the first line takes out the spaces of the string and mashes it all into one for easier checking.

 

See the manual for the second function: http://php.net/manual/en/function.ctype-alnum.php

 

I've used it before, can't remember for what.

[My Compare Function, It too simple, I don't see the error.]

Gosh, how come I did not see that. Thanks!

[What does this actually do?]

I think it checks to see if the string contains any letters or digits. If it does not, it returns 2

[My Compare Function, It too simple, I don't see the error.]

I'm more or less getting a logic error, so I cannot provide any syntactical errors.

 

The function in question is suppose to take two variables and compare them. I also have a boolean variable to see if I care about the case of the variables. However if I do something like this:

 

compare("NAME", "name", false);

The function returns false.

 

Here is the function:

function compare($var1, $var2, $caseMatters){
if(!$caseMatters && !is_numeric($var1) && !is_numeric($var2)){
	strtolower($var1);
	strtolower($var2);
}
return md5($var1) === md5($var2);
}

 

Any thoughts?

[How long did it take you to learn php?]

I knew several different languages before I picked up PHP. It really is just adjusting to the language. I'm still learning better ways to write programs. I love being a programmer and a CS major.

[Difference between Disk and Disc]

I've always wondered when to use them in proper context. I found this from google.

 

http://support.apple.com/kb/HT2300

 

It's an support article from Apple. It helped me, maybe I can spread the word now.

 

[Is my Logic Correct?]

I revised my functions like so:

function startTime($min){ //Starts the time clock (TC), should only be used in the loginAdmin and updateTime functions.
$min *= 60;
if(!isset($_SESSION['~TC:Min']) || $_SESSION['~TC:Min'] != $min)
	$_SESSION['~TC:Min'] = $min;
//$_SESSION['~TC:Time'] = time() + $_SESSION['~TC:Min'];
updateTime();
}
function updateTime(){
//startTime($_SESSION['~TC:Min']); //No need to do the same thing twice. Resets the clock per page.
$_SESSION['~TC:Time'] = time() + $_SESSION['~TC:Min'];
}
function expiredTime(){//True if time has expired; false otherwise.
 return time() > $_SESSION['~TC:Time'];
}

 

Then I forgot to refresh the page, so it works great now!

[Is my Logic Correct?]

Okay, so I printed out the timestamps. I am doing something wrong:

 

Here is time(): 1272660826

Here is $_SESSION['~TC:Time']: 1.6926659444736E+30

I got that large number after I refreshed the page a couple times. Any suggestions?

[Upload Forum Help!]

add "/files/". to name.

like so

$name = "/files/".$_FILES['filename']['name'];

 

or wait do this instead:

   $name = $_FILES['filename']['name'];
   $folder = "/files/".$_FILES['filename']['name'];
   move_uploaded_file($_FILES['filename']['tmp_name'], $folder);