PHP - Need Some Help With The Include Statement On Xampp 1.7.7

I am trying to insert a record into a mysql database which has a $ as part of the value of a field.  But it seems that when the INSERT query is processed its actually looking for a variable with that name and not just inserting the raw text.  Here is the insert query


$query = "INSERT mytable SET myfield='I would like to have this field contain this information with a $matches[1] showing in the field value as well'";


$matches[1] has no value.  Its not a variable which is in this script.  I am not trying to insert the value of it.  I just want to insert the actual text characters $matches[1]

How can I do that?

Hello can anyone help with my code, it bombs out if I dont add in a file for attachment but i want to be able to add to the database with just comments (sometimes without a file) Any help appreciated!!!


$timestamp = time();
$tbl_name="guestbook"; // Table name
$email = $_REQUEST["email"];
$name = $_REQUEST["name"];
$comment = $_REQUEST["comment"];
$datetime = date("dmy");
$uploaddir = "upload/";
$filename = $timestamp.$file['file']['name'];
$filename = strtolower($filename);
$final_location = "$uploaddir$filename";
$pathinfo = pathinfo($_FILES['userfile1']['name']);
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 2000000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $filename . "<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($final_location))
{
echo $filename . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
$final_location);
echo "Stored in: " . $final_location . "<br>";

mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="INSERT INTO $tbl_name(name, email, comment, datetime, upload)VALUES('$name', '$email', '$comment', '$datetime', '$final_location')";
$result=mysql_query($sql);
}
}
//}
else
{
echo "Invalid file";
}

if($result){
echo "Successful added update to the Board";
echo "<BR>";
echo "<a href='HomePage4.php'>View Bulletin Board</a>"; }

else {
echo "ERROR";
}

mysql_close();
?>

This topic has been moved to CSS Help.

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

I'm trying to create a INSERT query statement that makes use of the content of 'include' files. When I call up the include it simply echos it to the screen but I can't seem to capture the text string and actually make it function as part of the query. I've tried setting the include as a variable but again it only outputs to the screen. Help please! Here's a portion of the code...

if (($_POST['sched_templates']) == "sched_TestingOnly.htm") {
   $query = include 'sched_TestingOnlyQuery1.htm';   
   }
      if (@mysql_query ($query)) {
         mysql_close(); // End adding Registration to the database
         header ('Location: redirectfile.htm');
         exit();
      } else {
      print "<p><b>Sorry, your entry could not be entered.
      }

can abybody tell where to write php code & sql statements in Xampp

Hi, i had today problem with my script. Everything worked well on my localhost(xampp server) and when i uploaded on dedi machine functions with MySQL database stoped working. Problem was with mysql_real_escape_string and i forgot that i must first open connection and then mysql_real_escape_string...

But strange thing is that on xampp server i dont need to open connection for mysql_real_escape_string, and everything worked well... is there any solutio to php scripts on xampp worke same as php script on linux apache server?

This topic has been moved to PHP Installation & Configuration.

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

This topic has been moved to Miscellaneous.

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

Please help. I am running xampp for windows - it contains apache, ssl, php, mysql. I am unable to generate  a key/cert via php even though everything is apparently set up and running correctly. I ran a script and it said the following

Quote

Warning: openssl_csr_sign() [function.openssl-csr-sign]: cannot get CSR from parameter 1 in C:\xampp\htdocs\cert.php on line 31

Warning: openssl_csr_export() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\cert.php on line 40

Warning: openssl_x509_export() [function.openssl-x509-export]: cannot get cert from parameter 1 in C:\xampp\htdocs\cert.php on line 41

Warning: openssl_pkey_export() [function.openssl-pkey-export]: cannot get key from parameter 1 in C:\xampp\htdocs\cert.php on line 42

error:02001003:system library:fopen:No such process error:2006D080:BIO routines:BIO_new_file:no such file error:0E064002:configuration file routines:CONF_load:system lib error:02001003:system library:fopen:No such process error:2006D080:BIO routines:BIO_new_file:no such file error:0E064002:configuration file routines:CONF_load:system lib error:02001003:system library:fopen:No such process error:2006D080:BIO routines:BIO_new_file:no such file error:0E064002:configuration file routines:CONF_load:system lib error:02001003:system library:fopen:No such process error:2006D080:BIO routines:BIO_new_file:no such file error:0E064002:configuration file routines:CONF_load:system lib




cert.php
<?php
$configargs = array(
    'config' => '../apache/bin/openssl.cnf',
    'digest_alg' => 'md5',
    'x509_extensions' => 'v3_ca',
    'req_extensions'   => 'v3_req',
    'private_key_bits' => 666,
    'private_key_type' => OPENSSL_KEYTYPE_RSA,
    'encrypt_key' => false,
    );

$dn = array(
    "countryName" => "IE",
    "stateOrProvinceName" => "cork",
    "localityName" => "cork",
    "organizationName" => "org",
    "organizationalUnitName" => "Organizational Unit Name",
    "commonName" => "example.com",
    "emailAddress" => "Email Address"
);

// Generate a new private (and public) key pair
$privkey = openssl_pkey_new($configargs);

// Generate a certificate signing request
$csr = openssl_csr_new($dn, $privkey);

// You will usually want to create a self-signed certificate at this
// point until your CA fulfills your request.
// This creates a self-signed cert that is valid for 365 days
$sscert = openssl_csr_sign($csr, null, $privkey, 365);

// Now you will want to preserve your private key, CSR and self-signed
// cert so that they can be installed into your web server, mail server
// or mail client (depending on the intended use of the certificate).
// This example shows how to get those things into variables, but you
// can also store them directly into files.
// Typically, you will send the CSR on to your CA who will then issue
// you with the "real" certificate.
openssl_csr_export($csr, $csrout) and var_dump($csrout);
openssl_x509_export($sscert, $certout) and var_dump($certout);
openssl_pkey_export($privkey, $pkeyout, "mypassword") and var_dump($pkeyout);

// Show any errors that occurred here
while (($e = openssl_error_string()) !== false) {
    echo $e . "\n";
}
?>

I have a Xampp Timezone Error

Error

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for '-5.0/no DST' instead in C:\Users\cory j\Desktop\xampp\htdocs\NoXIp\Toplist\inc\vote.php on line 56
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' NOW())' at line 1

Line 56
              $diffrence = time() - strtotime($getDate['lastVoteDate']);


The Date Function in Php.ini
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = "America/New_York"
date.timezone = "America/New_York"
; http://php.net/date.default-latitude
;date.default_latitude = 31.7667

; http://php.net/date.default-longitude
;date.default_longitude = 35.2333

; http://php.net/date.sunrise-zenith
;date.sunrise_zenith = 90.583333

; http://php.net/date.sunset-zenith
;date.sunset_zenith = 90.583333

Hey, practicing my PHP for the first time, starting with a simple upload script with Xampp.

Script:

Code: [Select]
$target = '/Uploads';
$uploadedfile = $target . basename($_FILES['file']['name']);

if(move_uploaded_file($_FILES['file']['tmp_name'], $target)){

echo "The file ". basename($_FILES['file']['name'])." has been uploaded.";
}
else
{
echo 'Failed';
}
error_reporting(E_ALL);
It echos out a successful, but the file is nowhere? Uploads is inside htdocs. Checked my php.ini file:

file_uploads = On
upload_tmp_dir = "C:\xampp\tmp"
upload_max_filesize = 128M

Just wondering if there are any permission i may have missed?

This topic has been moved to Miscellaneous.

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

This topic has been moved to Installation in Windows.

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

This topic has been moved to Third Party PHP Scripts.

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