PHP - Sql Server 2008 R2 - Database Upon Installation

I am trying to add a second image upload to a form I have, but I can't figure out how to get the insert statement and upload statement working properly. The first file uploads and inserts to the database properly, but can anyone tell me how to add a second image to the mix? Here is what I currently have:


Code: [Select]
//if ((($_FILES["file"]["type"] == "image/gif")
//|| ($_FILES["file"]["type"] == "image/jpeg")
//|| ($_FILES["file"]["type"] == "image/pjpeg"))
//&& ($_FILES["file"]["size"] < 20000))
//  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    //echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    //echo "Type: " . $_FILES["file"]["type"] . "<br />";
    //echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    //echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";


     if (file_exists("upload/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);
      //echo "Stored in: " . "http://www.webdesignsbyliz.com/wdbl_wordpress/wp-content/themes/twentyten_2/upload/" . $_FILES["file"]["name"];
     
     $image = $_FILES["file"]["name"];
     
      $query = "INSERT INTO gallery VALUES ('', '$cut', '$color', '$carats', '$clarity', '$size', '$metal', '$other', '$total', '$certificate', '$value', '$image', '$name', '$desc', '$item_no', '$type', '$image2')";
$query_res = mysql_query($query) or die(mysql_error());
      }
    }


I thought I could simply add a second move_uploaded_file line and replace "file" with "file2" (the name of my second file upload field from the form), but it's not working. Can anyone tell me the right way to do this, please? Thanks in advance! I'm not experienced with file uploads yet :-(

Hi,

When i am trying to run one script on my web server, i get following error

Cannot connect to the database using the info you provided
Access denied for user 'My_Username'@'localhost' (using password: NO)

I filled all info like Host(localhost) Database name(created in cpanel) Username(created in cpanel) Password(i kept blank dont know where to find this)


You help will highly appreciate

Thanks,
Ravindra

Hello. I just inherited a game stats system but it's not working properly. I'm gonna post the entire script:

<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE);
$servername = "127.0.0.1";
$username = "";
$password = "";
$dbname = "";
 
$addresses = Array();
$nicknames = Array();
$servers = Array();
$times = Array();
 
$find_ip = $_GET["ip"];
$find_name = $_GET["nick"];
 
if(isset($_GET["format"]))
{
	$format = $_GET["format"];
}
else
{
	$format = "include";
}
 
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error)
{
    ReturnError("NO_CONNECTION");
}
 
function ReturnError($error)
{
	global $format;
	if($format == "mod")
		die("!DATA!ERROR:" .$error. "!DATA!");
	else
		die("ERROR:" . $error);
 
}
 
function ReturnData($data)
{
	global $format;
	if($format == "mod")
		die("!DATA!SUCCESS:" .$data. "!DATA!");
	else
 
		die("SUCCESS:" .$data);
}
 
function GetServerIP()
{
	if (!empty($_SERVER['HTTP_CLIENT_IP']))
		return $_SERVER['HTTP_CLIENT_IP'];
	else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
		return $_SERVER['HTTP_X_FORWARDED_FOR'];
	else
		return $_SERVER['REMOTE_ADDR'];
}
 
function GetTimestamp()
{
	$now = DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''));
	$now->format("m-d-Y H:i:s.u");
	$local = $now->setTimeZone(new DateTimeZone('Europe/Prague'));
	return $local->getTimestamp();
}
 
function GetFormatedTime()
{
	$now = DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''));
	$now->format("m-d-Y H:i:s.u");
	$local = $now->setTimeZone(new DateTimeZone('Europe/Prague'));
	return $local->format("Y-m-d H:i:s.u");
}
 
function AddAddress($addr)
{
	global $addresses;
	if(in_array($addr, $addresses, true))
	{
		return false;
	}
	else
	{
		array_push($addresses, $addr);
		return true;
	}
}
 
function AddTime($time)
{
	global $times;
	if(in_array($time, $times, true))
	{
		return false;
	}
	else
	{
		array_push($times, $time);
		return true;
	}
}
 
function AddNickname($nick)
{
	global $nicknames;
	if(in_array($nick, $nicknames, true))
	{
		return false;
	}
	else
	{
		array_push($nicknames, $nick, true);
		return true;
	}
}
 
function AddServer($server)
{
	global $servers;
	if(in_array($server, $servers, true))
	{
		return false;
	}
	else
	{
		array_push($servers, $server, true);
		return true;
	}
}
 
function LookForIPs($ip)
{
	global $conn;
 
	$sql = "SELECT * FROM  `connections` WHERE `IP` = '".$ip."'";
	$result = $conn->query($sql);
 
	if ($result->num_rows > 0)
	{
		while($row = $result->fetch_assoc())
		{
			AddAddress($row["IP"]);
			AddServer($row["serverIP"]);
			AddTime(Array($row["datestamp"], $row["datestring"], $row["serverIP"]));
 
			if(AddNickname($row["nickname"]) && $row["nickname"] != "Player" && $row["nickname"] != "A_Edition_V2")
			{
				LookForNicknames($row["nickname"]);
			}
 
		}
		return true;
	}
	else
	{
		return false;
	}
}
 
function LookForNicknames($nick)
{
	global $conn;
 
	$sql = "SELECT * FROM  `connections` WHERE `nickname` LIKE '".$nick."'";
	$result = $conn->query($sql);
 
	if ($result->num_rows > 0)
	{
		while($row = $result->fetch_assoc())
		{
			AddNickname($row["nickname"]);
			AddServer($row["serverIP"]);
			AddTime(Array($row["datestamp"], $row["datestring"], $row["serverIP"]));
 
			if(AddAddress($row["IP"]))
			{
				LookForIPs($row["IP"]);
			}
		}
		return true;
	}
	else
	{
		return false;
	}
}
 
function SortTimes()
{
	global $times;
	$good = false;
 
	while($good == false)
	{
		$good = true;
		for($i = 0; $i < count($times); $i++)
		{
			if($i+1 == count($times))
				continue;
 
			if($times[$i][0] < $times[$i + 1][0])
			{
				$tmp = $times[$i];
				$times[$i] = $times[$i + 1];
				$times[$i+1] = $tmp;
 
				$good = false;
			}
		}
	}
}
 
function GenerateLastSeenString($fromTime)
{
	$time_now = GetTimestamp();
 
	if($time_now < $fromTime)
	{
		return "N/A";
	}
	if($fromTime == 0 || $fromTime =="")
	{
		return "N/A";
	}
 
	$ss = $time_now - $fromTime;
 
	$seconds = $ss%60;
	$minutes = floor(($ss%3600)/60);
	$hours = floor(($ss%86400)/3600);
	$days = floor(($ss%2592000)/86400);
	$months = floor($ss/2592000);
 
	$str = "";
 
	if($months != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($days == 1)
			$str = $str . $months . " month";
		else
			$str = $str . $months . " months";
	}
 
	if($days != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($days == 1)
			$str = $str . $days . " day";
		else
			$str = $str . $days . " days";
	}
 
	if($hours != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($hours == 1)
			$str = $str . $hours . " hour";
		else
			$str = $str . $hours . " hours";
	}
 
	if($minutes != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($minutes == 1)
			$str = $str . $minutes . " minute";
		else
			$str = $str . $minutes . " minutes";
	}
 
	if($seconds != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($seconds == 1)
			$str = $str . $seconds . " second";
		else
			$str = $str . $seconds . " seconds";
	}
 
	return $str. " ago";
}
 
function ClearResult($arr)
{
	for($i = 0; $i < count($arr); $i++)
	{
		if(gettype($arr[$i]) == "boolean")
		{
			 //echo "Found bool at $i";
			 array_splice($arr, $i, 1);
		}
	}
 
	return $arr;
}
 
function PrintArray($arr)
{
	for($i = 0; $i < count($arr); $i++)
	{
		echo $arr[$i];
		if($i + 1 != count($arr))
		{
			echo ", ";
		}
	}
}
 
if($format == "mod")
{
	LookForNicknames($find_name);
	LookForIPs($find_ip);
 
	$nicknames = ClearResult($nicknames);
	$addresses = ClearResult($addresses);
	$servers   = ClearResult($servers);
	$conn->close();
 
	/*if (!filter_var($find_ip, FILTER_VALIDATE_EMAIL) && $find_ip != "")
	{
	    $find_ip = $addresses[0];
	}*/
 
	if($find_ip == "")
	{
		$find_ip = $addresses[0];
	}
 
	if($find_ip == "")
	{
		$find_ip = "0.0.0.0";
	}
 
 
	if(count($nicknames) == 0 && count($addresses) == 0)
	{
		ReturnError("NOT_FOUND");
	}
 
	echo "!DATA!";
	echo "Nicknames used: "; PrintArray($nicknames); echo "*-*";
	echo "Total IPs used: "; echo count($addresses); echo "*-*";
	echo "Location: "; echo file_get_contents("http://127.0.0.1/db/getlocation.php?ip=$find_ip"); echo "*-*";
	echo "Connected: ";  echo count($times); echo " times*-*";
	SortTimes();
 
	if(GetTimestamp() - $times[0][0] < 60 * 60)
		echo "Last seen: " . GenerateLastSeenString($times[1][0]) . "*-*";
	else
		echo "Last seen: " . GenerateLastSeenString($times[0][0]) . "*-*";
 
	echo "First seen: " . GenerateLastSeenString($times[count($times)-1][0]);
	echo "!DATA!";
}
else if($format == "debug")
{
	LookForNicknames($find_name);
	LookForIPs($find_ip);
 
	$nicknames = ClearResult($nicknames);
	$addresses = ClearResult($addresses);
	$servers   = ClearResult($servers);
	$conn->close();
 
	/*if (!filter_var($find_ip, FILTER_VALIDATE_EMAIL) && $find_ip != "")
	{
	    $find_ip = $addresses[0];
	}*/
 
	if($find_ip == "")
	{
		$find_ip = $addresses[0];
	}
 
	if($find_ip == "")
	{
		$find_ip = "0.0.0.0";
	}
 
	if(count($nicknames) == 0 && count($addresses) == 0)
	{
		ReturnError("NOT_FOUND");
	}
 
	echo "Nicknames used: "; PrintArray($nicknames); echo "<br>";
	echo "IPs used: "; PrintArray($addresses); echo "<br>";
	echo "Location: "; echo file_get_contents("http://127.0.0.1/db/getlocation.php?ip=$find_ip"); echo "<br>";
	echo "Connected: ";  echo count($times); echo " times<br>";
	SortTimes();
	echo "Last seen: " . GenerateLastSeenString($times[0][0]) . "<br>";
	echo "First seen: " . GenerateLastSeenString($times[count($times)-1][0]) . "<br>";
	echo $find_name;
}
?>

The problem is that for some nicknames it returns a proper output which should look like this:

But sometimes it just returns lots and lots of data even if the nickname I ask for is unique enough:

Here's how the database looks:

I don't know what's wrong with the script because I'm a PHP beginner. If someone could take a look at it and tell me what's the issue I'd appreciate.

Edited September 22, 2020 by jevgienij

This topic has been moved to Installation in Windows.

http://www.phpfreaks.com/forums/index.php?topic=358758.0

Okay guys I have finished my db and I want to upload it to a live server but don't know exactly what to change in the code to get the ODBC_connect to open the path at the new server location please help.

my database  is located in a subfolder called Databases

i.e. "www.mydomain.com/Databases/myEvents.mdb"

what do i change in the connection string below to get it to open the file on the live server? Thanks in advance.


$conn = odbc_connect('myEvents','','');

This topic has been moved to Installation in Windows.

http://www.phpfreaks.com/forums/index.php?topic=312024.0

Im looking to use this library but if i use this sample:
<?php
// test_cairo.php
$s = new CairoImageSurface(CairoFormat::ARGB32, 400, 400);
$c = new CairoContext($s);
$c->fill();
$c->setSourceRGB(1, 0, 0);
$c->setLineWidth(50);
$c->arc(200, 200, 100, 0, 2 * M_PI);
$c->stroke();
$c->setSourceRGB(0, 0, 0.6);
$c->rectangle(0, 160, 400, 75);
$c->fill();

$s->writeToPng(dirname(__FILE__)  . '/test.png');


It dont works, seems undefined, and checking for the url that php manuals tells to visit i dont work:

http://perisama.net/cairo/

How i can install and test it? I use php 6.

Hello,

I am attempting to get the base URL of the directory that the CMS was installed, not the main directory. Here's what I mean:

For example, let's say my domain is http://www.example.com but I install my CMS under http://www.example.com/test/cms and on another occasion I install it under http://www.example.com/cms, and on another occasion http://www.example.com/my/new/cms/

I would like my base url for the http://www.example.com/cms installation, to be "http://www.example.com/cms" and my base url for the http://www.example.com/test/cms installation to be "http://www.example.com/test/cms" and so on, without me having to manually change anything.

How do I go about obtaining the directory that corresponds to that particular installation? I know it is possible because Joomla does it automatically.

I have already tried numerous combinations using $_SERVER['HTTP_HOST'], $_SERVER['REQUEST_URI'], $_SERVER['SCRIPT_NAME'], and so on, no luck.

Hi i am trying to use xdebug 2.1.0, i have installed it on linux wth php version 5.2.5,
Can any one tell me the correct php version for 2.1.0 this .

What is this phpize and php-config tools.....where to find and how........tell some examples to use xdebug.

Thanks,

Hi All! I'm totally new to website design and do not know much about it. I installed a MYUPB forum on my website, but I got an error concerning timezone in the file upb.initialize.php on line 124. It was to Europe/London so I changed it to Americe/Montreal. (I'm in GMT-5)

After this modification, I get this error when trying to access my forum.

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /www/110mb.com/m/k/7/4/j/e/e/p/mk74jeep/htdocs/forum/includes/upb.initialize.php on line 21

I tried to correct for any mistake but could not find any since I do not know much. I need your help please. Here is the file section. BTW, Is line 1 <?php ???

Code: [Select]
<?php
function RemoveXSS($val) {
$before_val = $val;

// remove all non-printable characters. CR(0a) and LF(0b) and TAB(9) are allowed
// this prevents some character re-spacing such as <javaA533;script>
// note that you have to handle splits with n, r, and t later since they *are* allowed in some inputs
//echo "COMMA COUNT: ".substr_count($val,'x2C')."<br>";
$val = preg_replace('/([x00-x08x0b-x0cx0e-x19])/', '', $val);
// straight replacements, the user should never need these since they're normal characters
// this prevents like <IMG SRC=@avascript:alert('XSS')>
$search = 'abcdefghijklmnopqrstuvwxyz';
$search .= 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
$search .= '1234567890!@#$%^&*()';
$search .= '~`";:?+/={}[]-_|'';
for ($i = 0; $i < strlen($search); $i++) {
// ;? matches the ;, which is optional
// 0{0,7} matches any padded zeros, which are optional and go up to 8 chars

// @ @ search for the hex values
$val = preg_replace('/(&#38;#[xX]0{0,8}'.dechex(ord($search[$i])).';?)/i', $search[$i], $val); // with a ;
// @ @ 0{0,7} matches '0' zero to seven times
$val = preg_replace('/(&#65533;{0,8}'.ord($search[$i]).';?)/', $search[$i], $val); // with a ;
}

// now the only remaining whitespace attacks are t, n, and r
Etc etc etc...

Please, let me know what is wrong!

My website location is mk74jeep.110mb.com/forum

I have no problem starting all over again and reinstalling it, if someone feel like helping me step by step with this. This would be really appreciated.

Thanks in advance!

Hi folks,   Please go easy on me - total newbie. I've read all sorts of stuff on the web about how to get up and running with PHP but even the basic instructions are too complicated for me!   Here's what I want to do:   I want to use PHP to generate dynamic web pages linked to a Microsoft Access 2007 database as a test on my laptop (no need to publish to the actual Internet). I am running Windows 7 Professional SP1.   I know I need to install PHP and a web server of sorts. I tried to get IIS7 working but was foxed by the requirement to use an admin account (I don't have the admin password and didn't know how to run things as admin from my own account).   I basically need a step-by-step guide that assumes I know nothing.   Sorry if this is a big ask,   Matt

Code: [Select]
<?php
$myServer = "<remote ip>";
$myUser = "<username>";
$myPass = "<password>";
$myDB = "FAP2"; 
//create an instance of the ADO connection object
$conn = new COM ("ADODB.Connection")
  or die("Cannot start ADO");
 
?>

No error messages reported, but page "dies" at this point.
The ubuntu machine can see the sql machine, but yet this is happening.

Say I have an installation file, and they type in all their database information & click submit. How would I get that information to open up a file called config.php, and write to the $db_host, $db_pass, $db_user, and $db variables only?

Is this possible? Thanks!

Dear forum wrestlers:            Finally found a good mix of MySQL 5.1.65, win8.1, Apache 2.4.9 ssl-win32,0.9.8-VC9 (from Apachelounge), and php-win32-VC9-x86 (thread safe!).  Openssl seems to be working also.  But somehow lost the headers and trailers on the menus!  Does anyone know what may be wrong?   Thanks always, Yshua

 linux-file-structu what needs to be saved while moving the installation   well this is one of the best place to ask  joomla-related question.

today i have no question regarding joomla.

today i want to ask a linux-question: i am preparing a upgrade from opensuse 13.1 to 13.2

and i want to do a fresh installation.

first of all - as a preliminary task i will do a saving of all the files - that are in the home of the current installation

what else shoud i safe - more than the /home/my_name

should i save anyting else ...

http://tldp.org/LDP/...sect_03_01.html

Table 3-2. Subdirectories of the root directory
Directory    Content
/bin    Common programs, shared by the system, the system administrator and the users.
/boot    The startup files and the kernel, vmlinuz. In some recent distributions also grub data. Grub is the GRand Unified Boot loader and is an attempt to get rid of the many different boot-loaders we know today.
/dev    Contains references to all the CPU peripheral hardware, which are represented as files with special properties.
/etc    Most important system configuration files are in /etc, this directory contains data similar to those in the Control Panel in Windows
/home    Home directories of the common users.
/initrd    (on some distributions) Information for booting. Do not remove!
/lib    Library files, includes files for all kinds of programs needed by the system and the users.
/lost+found    Every partition has a lost+found in its upper directory. Files that were saved during failures are here.
/misc    For miscellaneous purposes.
/mnt    Standard mount point for external file systems, e.g. a CD-ROM or a digital camera.
/net    Standard mount point for entire remote file systems
/opt    Typically contains extra and third party software.
/proc    A virtual file system containing information about system resources. More information about the meaning of the files in proc is obtained by entering the command man proc in a terminal window. The file proc.txt discusses the virtual file system in detail.
/root    The administrative user's home directory. Mind the difference between /, the root directory and /root, the home directory of the root user.
/sbin    Programs for use by the system and the system administrator.
/tmp    Temporary space for use by the system, cleaned upon reboot, so don't use this for saving any work!
/usr    Programs, libraries, documentation etc. for all user-related programs.
/var    Storage for all variable files and temporary files created by users, such as log files, the mail queue, the print spooler area, space for temporary storage of files downloaded from the Internet, or to keep an image of a CD before burning it.

well - reagarding the thunderbird and other things more.
note:  i have thunderbird and enigmail up and running.

so i need to save
a. the passwords
b. the mails.


question: is there a need to save more than the home/my_name ?!

love to hear from you

greetings