PHP - My Select String With Variables Is Not Showing Correct.

When i use this code it show everything except for the first record in the table. I have also tried it with the users for the login system im using and then it doesnt show the person im logged in to or also the first record in the table and i need it too show all the records

How do i solve this? I thought it had something to do with:

Code: [Select]
                                                                             <?php while ($rij = mysql_fetch_array($result)){
echo ("<tr><td>". $rij['ID'] . " </td> " .
"<td>" . $rij['naam'] . " " . 
$rij['telefoon'] . " </td> " .
"<td>" . $rij['adres'] . " </td> " .
"<td>" . $rij['mobiel`'] . " </td>".
"</td></tr>\n ");
}
?>
But i dont know how to solve it.

Code: [Select]
                                                                       <?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}


mysql_select_db("root123", $con);

$sql= "SELECT * FROM root123 ORDER BY ID;";
$result = mysql_query($sql, $con);
$rij = mysql_fetch_array($result);

?>

<table width="80%" align="center">
<tr>
<th>ID</th>
<th width="150px">Naam</th>
<th>Gebruikersnaam</th>
<th width="300px">Wachtwoord</th>

</tr>
<?php while ($rij = mysql_fetch_array($result)){
echo ("<tr><td>". $rij['ID'] . " </td> " .
"<td>" . $rij['naam'] . " " . 
$rij['telefoon'] . " </td> " .
"<td>" . $rij['adres'] . " </td> " .
"<td>" . $rij['mobiel`'] . " </td>".
"</td></tr>\n ");
}
?>
</table>

PHP date and time function is not showing correct time on my local system

I have the following php code

date_default_timezone_set("Africa/Lagos");

$date = date('d-m-y h:i:s');

echo "Server Time ".$date ."<br>";

echo "The time is " . date("h:i:sa")."<br>";

$current_datetime = date("Y-m-d") . ' ' . date("H:i:s", STRTOTIME(date('h:i:sa')));

echo "Current time1: ".$current_datetime . "<br>";

 

Output

Server Time 21-05-21 09:55:39
The time is 09:55:39am
Current time1: 2021-05-21 09:55:39

 

Expected Output

Server Time 21-05-21 10:55:39
The time is 10:55:39am
Current time1: 2021-05-21 10:55:3

 

Any help would be appreciated.

 

Edited May 21 by Ponel

I am writing a CRON job that will execute daily.  First it will identify from a MySql table the date in a field 'FAPforSale_repost35'  If the date is the today date it will then execute commands to delete photo images in a directory, delete the directory, and finally remove the record from the database.   I am on step one which is to build the array of records that match the days date.  When I run the code, there are no errors but I am not getting results even though the records in the test table are set for today.  Below is the select

<?php

 define( "DIR", "../zabp_employee_benefits_processor_filesSm/", true );
 
 require( '../zipconfig.php' );
 require( DIR . 'lib/db.class.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/configRecognition.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/libRecognition/MailClass.inc' );
 
 
 
$todayRepost35 = date("Y-m-d");
echo $todayRepost35;



function repostEndSelect()
 
      {
        
        global $db;
            
    $this->db = $db;
        
            
     $data = $this->db->searchQuery( "SELECT `FAPforSale_IDnumber`,  `FAPforSale_image1`,  `FAPforSale_image2`,  `FAPforSale_image3`,  `FAPforSale_repost35`  FROM  `FAP_forSaleTest` Where `FAPforSale_repost35` = '$todayRepost35' ");
    
    
         $this->FAPforSale_IDnumber = $data[0]['FAPforSale_IDnumber'];
        $this->FAPforSale_image1 = $data[0]['FAPforSale_image1'];
        $this->FAPforSale_image2 = $data[0]['FAPforSale_image2'];
        $this->FAPforSale_image3 = $data[0]['FAPforSale_image3'];
        $this->FAPforSale_repost35 = $data[0]['FAPforSale_repost35'];
        
        echo $this->FAPforSale_IDnumber;
        echo $this->FAPforSale_image1;
        echo $this->FAPforSale_image2;
        echo $this->FAPforSale_image3;
        echo $this->FAPforSale_repost35;
        
    } // ends function...
        
echo( ' Finished...' );

?>

Thanks in advance for any suggestions or direction.  Chapter two will be when I start testing the commands to delete.

hello, im wondering how to properly code the following.

Code: [Select]
$stdate = date( 'Ymd', strtotime($pdate) );
$sttime = date( 'His', strtotime($tstart1) );

$dtStart = ".$stdate.'T'.$sttime.'Z'";

echo "$dtStart";

i would like the echo to read 20110309T050000Z

Hi,

I have a string with the value of

{ "success": true, "delivered": true, "contactDetailsRequired": false, "message": "Signed For by: D ANDERSON ", "signature": "https://webservices.thedx.co.uk/PodImage/ImageHandler.ashx?tn=906732192165", "date": "21-07-2020", "serviceLevelName": "Consigned", "time": "13:33:19", "trackedProductName": "DataExchange" }

How do i go about placing the values into variables so for example:

$success = "true";
$delivered = "true";
$message = "Signed for by: D ANDERSON";
etc....

My mind has gone blank and im having one of those days, any help would be greatly appreciated. Thanks

I have the following code which has deliimiters of |||| and I need to break it apart into three strings and have a variable assigned to each string.

I've tried exploding it but won't dynamically increase the variable.  I know at one point about a year ago I used something like $var.=$foo and the $var would increase $var1, $var2, etc...

Here's the string I need to break.j (And the string will be different every time, and some will have 2 string delimited  some will have 20, and some inbetween.

The rich contemporary style of the "Theo" Counter Height Table combines faux marble and a warm finish to create dining room furniture that adds an exciting style to the decor of any home. The thick polyurethane coated faux marble table top perfectly accentuates the warm brown finish flowing over the straight-lined contemporary design of the apron and legs to help create an exceptional dining experience. With the beautiful stitching and button tufting details of the faux leather upholstered bar stools, the "Theo" Counter Height Table is a refreshing addition to any home.||||Table top made with polyurethane coated print marble. Aprons and legs made from select veneer and solids with a warm brown finish. Chair is upholstered in a brown PVC with accent top stitching. D158-233 bar stool dimension: 18"W x 21"D x 40"H.||||Click here for complete image download listing for series D158.

In a perfect world it would be:
Code: [Select]
$desription1="The rich contemporary style of the "Theo" Counter Height Table combines faux marble and a warm finish to create dining room furniture that adds an exciting style to the decor of any home. The thick polyurethane coated faux marble table top perfectly accentuates the warm brown finish flowing over the straight-lined contemporary design of the apron and legs to help create an exceptional dining experience. With the beautiful stitching and button tufting details of the faux leather upholstered bar stools, the "Theo" Counter Height Table is a refreshing addition to any home.";
$description2="Table top made with polyurethane coated print marble. Aprons and legs made from select veneer and solids with a warm brown finish. Chair is upholstered in a brown PVC with accent top stitching. D158-233 bar stool dimension: 18"W x 21"D x 40"H.":
$description3="Click here for complete image download listing for series D158.";

$id[] = 12345;
$id[] = 12345;
$id[] = 12345;
$id[] = 12345;
$id[] = 12345;

how would I combine these into a string

"12345,12345,12345,12345,12345"

Hi

I am trying to get all variables passed in a url string and wondered how would i do it?
I dont know what they are yet and i need to set key as value.
Any help?

I have a string that looks like /index.php?g1=111&g2=222&g3=333.  How can I obtain the value of g1 (i.e. 111)?  It does not represent the current state of the server thus I cannot just use $_GET.  It also is not necessarily the first item.

The script below appears to work, however, http://php.net/manua...n.parse-url.php states
  This function is intended specifically for the purpose of parsing URLs and not URIs. However, to comply with PHP's backwards compatibility requirements it makes an exception for the file:// scheme where triple slashes (file:///...) are allowed. For any other scheme this is invalid.  
It appears that my string is a URI and not a URL, but I might be wrong.

How should this be accomplished

<?php
$str='/index.php?g1=111&g2=222&g3=333';

$array=parse_url($str);
parse_str($array['query'],$get);
echo("<p>{$get['g1']}</p>");
?>

Pretty simple I would think but I'm unsure on the syntax. I have a variable, $ename. It's actually data from a form that I pass to said variable. What I want is to then in turn use this string in a mkdir() function. Something like

Code: [Select]
mkdir("dir/folder/$ename/");
Obviously that doesn't work. I'd imagine I have to use some sort of . syntax.

I need to echo out some string variables in a form. I also want to add some validation for Name, email etc. I think I have the code right or close, but I can an error on the index.php page which is.
"Fatal error:  Call to undefined function  form_row_class() in index.php on line 14"

here is the code for the form


<!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>
    <title>String Tester</title>
    <link rel="stylesheet" type="text/css" href="main.css"/>
</head>

<body>
    <div id="content">
        <h1>String Tester</h1>
        <form action="submit.php" method="post">
  <table>
    <tr class="<?php echo form_row_class("name") ?>" >
      <th><label for="first_name">Name</label></th>
      <td>
        <input name="first_name" id="first_name" type="text" value="<?php echo h($_POST['name']); ?>" />
        <?php echo error_for('name') ?>
      </td>
    </tr>
    
    <tr class="<?php echo form_row_class("email") ?>">
      <th><label for="email">Email Address</label></th>
      <td>
        <input name="email" id="email" type="text" value="<?php echo h($_POST['email']); ?>" />
        <?php echo error_for('email') ?>
      </td>
    </tr>
   
    <tr>
      <th></th>
      <td><input type="submit" value="submit" /></td>
    </tr>
  </table>
</form>

        <h2>Message:</h2>
        <?php 
echo "<table>";
echo "<tr><td>";
echo $name;
echo "</td></tr>";
echo "<tr><td>";
echo $email;
echo "</td></tr>";
echo "<tr><td>";
echo $phone;
echo "</td></tr>";
echo "</table>";
?>

    </div>
</body>
</html>


and the submit portion

<?php

// If request is a form submission
if($_SERVER['REQUEST_METHOD'] == 'POST'){
  // Validation

  // Check first_name is non-blank
  if(0 === preg_match("/\S+/", $_POST['name'])){
    $errors['name'] = "Please enter a name.";
  }
  
  // Check email is valid (enough)
  if(0 === preg_match("/.+@.+\..+/", $_POST['email'])){
    $errors['email'] = "Please enter a valid email address.";
  }
  
  // validate a phone number
if( !preg_match("/^([1]-)?[0-9]{3}-[0-9]{3}-[0-9]{4}$/i", $phone) ) {
echo 'Please enter a valid phone number';
}


 // If no validation errors
  if(0 === count($errors)){
    
    // Sanitize first, last, and email
    $name = mysql_real_escape_string($_POST['name']);
    $email= mysql_real_escape_string($_POST['email']);
    $email= mysql_real_escape_string($_POST['phone']);
  }

// Helpers
function form_row_class($name){
  global $errors;
  return $errors[$name] ? "form_error_row" : "";
}

function error_for($name){
  global $errors;
  if($errors[$name]){
    return "<div class='form_error'>" . $errors[$name] . "</div>";
  }


function h($string){
  return htmlspecialchars($string);
}

?>





probably something simple I am missing.

Hi Guys and Girls,

Long time lurker, first time poster!

I am usually able to read through the forums and find and answer without having to start a new thread but I've tried my best to no avail.

I am having trouble with the following code:
$afname="Gareth";
$alname="B";
$awayoption.="<OPTION VALUE=\"".$afname." \"".$alname."\">".$afname."&nbsp;".$alname;

I would want that to produce the following:

Code: [Select]
<OPTION VALUE=Gareth B">Gareth B
The actual result at the moment is:

Code: [Select]
<OPTION VALUE="Gareth "B">Gareth&nbsp;B
It has an extra " in the middle. Any ides or help would be great!

Cheers

$var = @$_GET['q'] ;
$trimmed = trim($var);
$table = @$_GET['field'];
$query="SELECT * FROM contacts WHERE @'table' contains @'trimmed' order by id";
$result=mysql_query($query);
$num=mysql_numrows($result);


Why wont this work?

Zacron

What I'm wanting to do is pass the $propertyid = "1";  threw my select value as you can see. so it passes variable so to speak.'



Code: [Select]
print "<td>Control:<form action=\"dashboard.php\" method=\"GET\" target=\"_self\">
        <select name=\"control\" onChange=\"this.form.submit()\">
        <option selected></option>
        <option>Take a Payment</option>
        <option>Print Ledger </option>
        <option>-----------------</option>
        <option value=\"comadd?propid=$propertyid\">Add Communication</option>
        <option>----------------</option>
        <option>Modify Property</option>
        <option>Remote Property</option>
        </select></td>";