PHP - Want To Change The Qrcode Details

Hello, I am new to PHP and am trying to make a script that will ftp into the server via a cron of every hour or so and save the data to a mysql table. The first step is to draw variables out of information in the file via ftp. Its a ban list for a game server I run.

How could I get php to single out the ban reason, admin, etc.

the looks like this

Code: [Select]
"STEAM_0:0:42741441"
{
"name" "good mom"
"unban" "0"
"time" "1329161245"
"admin" "(Console)"
"reason" "no more trolling for you"
}
"STEAM_0:1:40563669"
{
"unban" "0"
"admin" "Headcrap(STEAM_0:1:42287608)"
"time" "1332855999"
"reason" ""
}
"STEAM_0:1:17693550"
{
"name" "ʎɖɑɱ"
"time" "1323055427"
"modified_time" "1323221308"
"unban" "0"
"modified_admin" "Strategos(STEAM_0:0:26662109)"
"admin" "Strategos(STEAM_0:0:26662109)"
"reason" "And so died the trolling"
}
Example: Code: [Select]
<?php
$bannedid = "STEAM_0:0:42741441";
$bannedby "(console)";
// and so on
?>

Hi,

I am writing a little code that would populate the server name based on $_SERVER['HTTP_HOST']. My code and the error I encounter are given below. Can we ever use $_SERVER in a class?


class Get_server_name {

if ($_SERVER['HTTP_HOST'] == 'localhost'):
   $hostname = 'localhost';
else:
   $hostname = 'my remote server';
endif;

}

Error I get: Parse error: parse error, expecting `T_FUNCTION' in

Hi all,

I am trying to write a script where the user can update their details.

The html form sends the details across to this php file below. All the php variables echo after the query however the values do not replace the current values in the mysql database.

Also for some reason the fname is the only one that changes no matter what the value is. It is entered in to mysql as '0'.

I think the problem will be in the php below.

As all the information below is echoed correctly, and because the value of 'fname' changes I know the connection is working fine.
I guess the error must be in the query I have written, however there is no error that comes up...

Hope you can point me in the right direction.

Thanks


<?php
include("../cxn.php");

$fname = $_POST['fname'];
$lname = $_POST['lname'];
$newemail = $_POST['newemail'];
$telephone = $_POST['telephone'];
$icao = $_POST['icao'];
$newpassword = $_POST['newpassword'];
$id = $_POST['id'];

$sql = "UPDATE Members SET fname='$fname' AND lname='$lname' AND email='$newemail' AND telephone='$telephone' AND password='$newpassword' AND icao='$icao' WHERE id='$id'";
$result = mysqli_query($cxn,$sql)
or die ("Couldn't execute query");

echo "Your new details a  <p>";
echo "$fname <br> $lname <br> $newemail <br> $telephone <br> $icao <br> $newpassword";

?>

Perhaps this is a rather lay question, but, is there a way to gather specific connection details about an open MySQL connection in php?

Example:

<?php
    $connect = mysql_connect('localhost', 'username', 'password');
?>

Using the $connect variable, could I run a command that dumps the host, and username to a log file??

Thanks in advance, I'm still searching.

E

I need some help please.  I have a project that has a login script that is required before moving to a shopping cart and each use a session.  I have a login script that i know works separate of the cart and vice versa.  The problem is that when i access the cart i get the session errors and it quits working.  So i need help with getting the 2 combined so i can run the cart script while a user is logged in.  Here is the code i have.

This is the login script session:
<? ob_start(); session_start();include_once"config.php";

if(!isset($_SESSION['username']) || !isset($_SESSION['password'])){

header("Location: login.php");
}else{
$user_data = "".$_SESSION['username']."";
$fetch_users_data = mysql_fetch_object(mysql_query("SELECT * FROM `members` WHERE `username`='".$user_data."'"));
}
?>



This is the script session for the shopping cart:
<?php
require_once 'library/config.php';
require_once 'library/category-functions.php';
require_once 'library/product-functions.php';
require_once 'library/cart-functions.php';

$_SESSION['shop_return_url'] = $_SERVER['REQUEST_URI'];

$catId  = (isset($_GET['c']) && $_GET['c'] != '1') ? $_GET['c'] : 0;
$pdId   = (isset($_GET['p']) && $_GET['p'] != '') ? $_GET['p'] : 0;

require_once 'include/header.php';
?>  

and any help is very much appreciated.

Hi,
Im developing a program and it contains bank details in some of the fields stored in the MySQL database.
As part of the upload, I need to find bank details and then mask them by replacing them with XXXXXX for security purposes.

An example of a field could be "TRANSFER 540021 61782457" and I need to replace to "TRANSFER XXXXXX XXXXX457"

Any ideas to the best possible method?

Maybe I would mask blocks of numbers (ie numbers in blocks of 6 or 9) to cover this...im not sure what the best possible way is.

Thanks!

Hello.  I just created a product gallery containing thumbnails of items that I will be selling.

When a user click on on of the thumbnails, I want a product details page to appear with more details about the chosen product

Could use some feedback if I am going about things the right way...

Step 1: User goes to my gallery located he   www.mysite.com/store/product-gallery.php

Step 2: System displays a page of thumbnails representing items that I am selling.

Step 3: User click on a given thumbnail which is a hyperlink to:  www.mysite.com/store/products/4571

Step 4: System rewrites the URL as such:  www.mysite.com/store/products.php?sku=4571

Step 5: System queries MySQL and retrieves record for sku 4571

Step 6: System displays product details for the chosen item in Step 3 which is sku 4571

 

How does that sound?

 

i am working on a project in which i am facing a problem.
 my question is that

is it possible to get information/details of a user who is not logged in or who is not registered.

if a user logged in then we can find get details easily. but how can i do this. is it possible. 

Code: [Select]
$sql= ("INSERT INTO custcards (username,Card_Number,Card_Type,Card_Name,Card_End) VALUES('$username','$cardnumber','$cardtype','$cardname','$cardend')");

if (isset($_GET['submitted'])) {
  if (checkCreditCard ($_GET['CardNumber'], $_GET['CardType'], $errornumber, $errortext)) {
    $errortext = 'This card has a valid format'; // Default text if card is VALID
$result = mysql_query($sql)){
echo "$errortext"; // Echo/Show this text
     
}
}
else
{
 echo '<p align=center>';echo "$errortext"; // Display ERROR Type/Text
 echo "ERROR: ".mysql_error();
}

}
The code is to check details beign entered and to make sure thier correct and then print the correcrt message but i also want it to store the details into a table

i know i havent got the syntax correct was wondering is anyone can help ?

If I were to write a code where the browser details and resolution are to be displayed, would the following code work?


Code: [Select]
//Here, I am using the "</body>" tag to end the body of the webpage and the "</html>" tag to end the HTML script
</body>
</html>


 
//By using the "<?php" code, I am creating a PHP script and when I use the  "function" keyword here, I am creating a function called Identification with no arguments in the parameters
<?php function Identification() 
//Here, I am creating a variable called "$viewer" 
//The value of this variable uses the "getenv" library function and the "HTTP_USER_AGENT" is what the "getenv" library function will be performed on and the value of this is that value of the $viewer attribute
//The code uses the ";" to end the command
$viewer = getenv ("HTTP_USER_AGENT");
$width= $_get['width'];
$height=$_get['height'];
//Here, I am using the "echo" library function and the "$viewer" attribute as well as the "<b> (bold)" tags to write a formatted string to the webpage
//I then use the ";" to end the command and I use "?>" to end the PHP script
$msg = "Browser details: $viewer";
$msg .= "Resolution is $width pixels long and $height pixels high";
echo ($msg);
?>
//Here, I am using the "<html>"<head"> and "<title>" tags as well as the "</head"> and "</title>" so that I can write a title (Browser + Platform Identification Script) for the webpage that the script will be shown on   
<html><head><title>Browser + Platform Identification Script</title></head>
//Here, I am using the "<body>" tag to create the body of the webpage
<body>
//Here, I am using the "<?php" code so that I can start a PHP script that will run the Identifcation script and show the results on a webpage
<?php Identification()
//I then use the "}?> to end the PHP script
?>
//Here, I am using the "</body>" tag to end the body of the webpage and the "</html>" tag to end the HTML script
</body>
</html>

Thanks,

Andrew

Hi guys,

The supervisor of my system wants to modify my customer details if something incorrect inserted into the database. The process of the system is looked like this. The user enters customer data and and it stores in the customer table.
 customer(customer_id, nic, full_name, name_with_initials, address, contact_number, gender)

Then when supervisor logged in he wants to approve or modify the details based on my the accuracy of data. When he types the customer ID and clicks on search button ( customer page) the relevant record details have been displayed. That part is worked properly.(approve_account.php)

Then in that same page there is a button called "Modify Account" which is linked to modify_form.php
But it does not work. This is that page.Can anyone correct myself...

The error message is saying undefined nic, full_name etc......


      <?php
  
   
      $connect=mysql_connect("localhost","root","");
      mysql_select_db("bank",$connect) or die ("could not select database");
   
                 
  
                $nic =$_POST['nic'];
                $full_name =$_POST['full_name'];
                $name_with_initials =$_POST['name_with_initials'];
                $address =$_POST['address'];
                $contact_number =$_POST['contact_number'];
                $gender =$_POST['gender'];
  
 
                 if(isset($_POST['customer_id'])) {
                 $customer_id=(int)$_POST['customer_id'];
 
                
   
$result = mysql_query("UPDATE * from customer SET nic = '$nic', full_name = '$full_name', name_with_initials =                                     '$name_with_initials', address = '$address', contact_number = '$contact_number', gender  = '$gender'") ;                  

               if($result){
                  echo "Your information has been successfully added to the database.";
              }else{
                 echo "Failed";
              }    
   

}
   
   
  ?>


Thanks,
Heshan

Hi there...

I am working on a PHP web form. I have Group name and its Member details stored in the database.

The Group names from the database table gets populated in a combo box. Now what I'm trying to accomplish is, as soon I select a Group name, all its members should appear in a Label (or something) under the combo box with a textbox field next to the member name for me to assign the member position.

How can we go about doing this. Please see the Screenshot I've attached and you'll have the idea as to what we're trying to accomplish here.

All comments and feedback are welcomed!

Thank you!

This topic has been moved to Third Party PHP Scripts.

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

I have created a button which when pressed should present the user with their details (whoever is logged in), here is the form code:

<form id="form1" name="form1" method="post" action="getdetails.php">
 
  <input type="submit" name="Get Details" value="Get Details" />
   </label>
   
  </p>
</form>

Here is the getdetails.php file

<?php
 mysql_connect("localhost","root","");
 mysql_select_db("test");
 $username = $_POST['textfield'];
  echo '</br>';
 $query = mysql_query("SELECT * FROM membersdetails WHERE name=`$username` ");

while($result = mysql_fetch_array($query)) {
//display
echo $result['firstname'];
echo $result['surname'];
}
?>

Its not workin at all I have attacthed the error i am getting

Any help please?

Hi, am having abit of a problem.Can anyone help me in programming  my form to send it's details to an email address.The form should be able to detect unfilled fields,unselected items all in all the form should work as a effectively according to how i designed it 
The email sending processing should be handled by a separate file known as process.php

 below is the HTML coding...
<form name="myform" action="process.php" method="POST">
    Name: <input type="text" name="Name" /><br />
    Email: <input type="text" name="Email"  /><br />
    Select something from the list: <select name="Seasons">
      <option value="Spring" selected="selected">Spring</option>
      <option value="Summer">Summer</option>
      <option value="Autumn">Autumn</option>
      <option value="Winter">Winter</option>
    </select><br /><br />
    Choose one:
      <input type="radio" name="Country" value="USA" /> USA
      <input type="radio" name="Country" value="Canada" /> Canada
      <input type="radio" name="Country" value="Other" /> Other
    <br />
    Choose the colors:
      <input type="checkbox" name="Colors[]" value="green" checked="checked" /> Green
      <input type="checkbox" name="Colors[]" value="yellow" /> Yellow
      <input type="checkbox" name="Colors[]" value="red" /> Red
      <input type="checkbox" name="Colors[]" value="gray" /> Gray
    <br /><br />
    Comments:<br />
    <textarea name="Comments" rows="10" cols="60">Enter your comments here</textarea><br />
    <input type="submit" />
  </form>