Linux, Apache, MySQL, PHP

Re: How to use 4 digit incremental serial number on mysql database using PHP on my form

26-Apr-18 2:16

Please I need help on how to use 4 digit format as incremental value using PHP. the cod below I used displays incremetally but it only in 1,2,3 instead of 001,002,003.
What is wrong with m code?

$query = "Select Max(Serial_Number) From captain_order";
	$returnD = mysql_query($query);
	$result = mysql_fetch_assoc($returnD);
	Print mysql_error();
	$maxRows = $result['Max(Serial_Number)'];
  if(empty($maxRows)){
	    $lastRow = $maxRows = 1;       
    }else{
		$lastRow = $maxRows + 0001 ;
    }

Jochen Arndt26-Apr-18 2:31

Re: How to use 4 digit incremental serial number on mysql database using PHP on my form

26-Apr-18 2:31

Computers don't know about leading zeroes. That is just a form of representing numbers to humans (being shown on screen, printed, or even written on a piece of paper).

So just use

PHP

$lastRow = $maxRows + 1;

If you want to show the number with leading zeroes, use a corresponding formatting function like PHP: sprintf - Manual[^]:

PHP

echo sprintf("%03d", $lastRow);

Member 1369186126-Apr-18 2:42

How to use PHP global processing script action to process sumbitted data and display form data entered on the text on another page

26-Apr-18 2:42

Thanks Jochen.

Member 1369186126-Apr-18 2:13

Re: How to use PHP global processing script action to process sumbitted data and display form data entered on the text on another page

26-Apr-18 2:13

How to use PHP global processing script action to process sumbitted data and display form data entered on the text on another page

. Please provide an easy way out of this. Thanks

Richard MacCutchan26-Apr-18 2:49

Richard MacCutchan

26-Apr-18 2:49

PHP global processing script - Google Search[^].

How to use a php $_SERVER['PHP_SELF'] to insert form data into Mysql database and redisplay data entered on another form

Member 1369186126-Apr-18 2:11

How to call a reply forms using php.

26-Apr-18 2:11

Please I need a guide on how to use a php $_SERVER['PHP_SELF'] to insert form data into Mysql database and redisplay data entered on another form. 

My form action is <pre><form method="post" name="form1" action="<?php echo $editFormAction; ?>

While the print button should be able to open another page with contents of the main form on it. I used this

<input name="Print receipt" type= "button" onclick = "Openform();" value="Print reciept" /></td>

Please assist

Password Verify

Valecia_cho30-Mar-18 13:32

Valecia_cho

30-Mar-18 13:32

So I'm building a website and I've got alot of the core functionality sorted. Been trying to make a register and login system. Everything on the front end works ok. Registering is fine but I can't get the password_verify function to recognise a correct password.

So here's the registration part:

PHP

$res = $conn->query("SELECT * FROM `users` WHERE `email`= '$email'");

if (mysqli_num_rows($res) != 0) {
  echo "<br>  Sorry this email already is registered with us!!!  <br>";
  $start = microtime(true);
  do {
    $stop = microtime(true);
  } while ($stop - $start < 5);
  header("location: index.php");
}
else {
  // Password hashing
  $cost = 8;
  $target_time = 0.05;
  // When microtime is set to true it returns a float
  // If set to false then returns a string

  do {
    $start = microtime(true);
    $password = password_hash( $password, PASSWORD_BCRYPT, ["cost" => $cost] );
    $stop = microtime(true);
    $cost++;

  } while ($stop - $start < $target_time);


  $date = date("Y-m-d ");

  $sql="INSERT INTO `users` (`username`, `email`, `password`, `sign_up_date`)
  VALUES ('$username', '$email', '$password', '$date')";

  if ($conn->query($sql)) {
    echo "Registration Successful!!!";
    header( "location: index.php" );
  }

}

That's just the part where a hash is generated and stored on an SQL database. Now here's the login part:

$conn = new mysqli( "localhost", $user, $pass, $db ) or die("Unable to connect");

$email = mysqli_real_escape_string($conn, $_POST['email']);

$res = $conn->query("SELECT * FROM `users` WHERE `email`= '$email'");

if (mysqli_num_rows($res) == false) {
  echo "Sorry no such user exists :(";
}
else {
  $user = $res->fetch_assoc();

  if ( password_verify(  $_POST['password'], $user['password']) ) {
    echo " Password login accepted. Redirecting...";
    $_SESSION['username'] = $user['username'];
    $_SESSION['email'] = $user['email'];

    $_SESSION['logged_in'] = true;
    header("location: testFront.php");
  }
  else {
    echo "<br>Sorry Wrong Password!!!<br>";
  }

}

For some reason the password_verify keeps returning false and I have no idea why. Have I overlooked something in the code. Is it my fundamental understanding of hashes?

Thanks

Member 1370467720-Mar-18 20:45

Member 13704677

20-Mar-18 20:45

I am creating a platform where users sends requests using forms(in a database) to the admin and the admin should reply them when he has finished the job.

Can anyone help me on how to make the admin view form by form and reply to its specific sender.

dynamic question in php and mysql

antonio_dsanchez9-Feb-18 10:24

antonio_dsanchez

9-Feb-18 10:24

Hello

I'm doing a survey web where I keep my questions in a database and then I call them when the user selects which survey will answer and my questions are shown.

This is my code where I show my questions and add raddiobuttons and textareas.

PHP

<pre><table>
            <tr>
                <!--Mostramos el titulo de la encuesta-->
                <td colspan="2"> <h3><?php echo $titulo; ?></h3></td>
            <input type="hidden" name="id" value="<?php echo $id; ?>">
            </tr>
            <?php
            //consulta que captura el texto , id de la tabla respuestas
            $sql = "SELECT texto,id FROM respuestas WHERE idenc='$id'";
            $sql = mysqli_query($conexion,$sql);
            //ahora recorremos los datos texto, id que estan vinculadas a la cuenta seleccionada
            while ($row = mysqli_fetch_array($sql)){
                $texto = $row["texto"];
                $idres = $row["id"];
                 
            ?>
            
        
            <tr>
              <!--  <td width="50"><input type="radio" name="opcion" value="<?php echo $idres; ?>" required</td>
                <td width="470"><?php echo $texto; ?></td>-->
                <td width="50"><?php echo $idres; ?></td>
                <td width="470"><?php echo $texto; ?></td>
                <td> SI <input type="radio" name="radio<?php echo $idres; ?>" value="SI"></td>
                <td> NO <input type="radio" name="radio<?php echo $idres; ?>" value="NO"></td>
                <td><textarea name="comentarios<?php echo $idres; ?>" rows="5" cols="20">Escribe aquí tus Hallazgos</textarea></td>
                <td><textarea name="acciones<?php echo $idres; ?>" rows="5" cols="20">Escribe aquí tus Acciones Correctivas</textarea></td>
            </tr>
            <?php } ?>

and here I want to save the answers

PHP

<pre><?php
/*$opcion = $_POST["opcion"];*/
$respuesta = $_POST["radio$idres"];
$comentarios = $_POST["comentarios$idres"];
$acciones = $_POST["acciones$idres"];
require 'conexion.php';

//obtenemos la fecha del sistema
$fecha_actual = date("y-m-d");

//obtenemos el numero actual de votos para la opcion elegir
//comprovamos si $opcion no esta vacio
if(!empty($respuesta)){
    $sql = "INSERT INTO opciones(ID, idenc, valor, Accion, hallazgo, fecha) VALUES ('$respuesta' ,'$comentarios' ,'$acciones' ,'$fecha_actual')";
    $sql = mysqli_query($conexion,$sql);
}
header("Location: verEncuesta.php");
?>

I just do not know how to save the questions by id question and id survey. I suppose it's a cycle but I do not know how to structure that cycle

Get the html content from a website using php

Joshin Joy17-Dec-17 20:51

Joshin Joy

17-Dec-17 20:51

Hai,

<!DOCTYPE html>
<html >
<head>
	<style type="text/css">
	.centerDiv
	{
		width: 1000px;
		height:600px;
		margin: 0 auto;
	}
	.div1
	{
		width: 500px;
		height:600px;
		float:left;
	}
	.div2
	{
		width: 500px;
		height:600px;
		float:left;
	}
	</style>
</head>
<body>
	<div class="centerDiv">
		<div class="div1">
		<object type="text/html" data="https://Somewebsite.com" width="500px" height="600px" style="inline-block:auto;border:5px ridge blue">
    </object>
		</div>
		<div class="div2">
		<object type="text/html" data="https://Somewebsite.com" width="500px" height="600px" style="inline-block:auto;border:5px ridge blue">
    </object>
		</div>
	</div>
</body>
</html>

this is a html code I created. when this page is loaded. the two links in the 'div' will also be loaded. In the original link page there will be a username and password to enter. the user will manually enter this username and password and submit it. then a new page will be loaded which will display the current temperature of two sites. what I need is get that temperature value and load it to a MySQL database. this is my problem. what I plan is to get the html of the loaded link. and search for the element temperature and get the temperature value. but I don't know how to grasp the HTML code of the link.

Can Any one help me to grasp the html of link site using php or any other methods!!
Please help.

Jochen Arndt17-Dec-17 22:38

17-Dec-17 22:38

You can use PHP: file_get_contents - Manual[^] when enabling the fopen wrappers[^].

For HTTPS, php_openssl must be installed and enabled.

Joshin Joy18-Dec-17 20:15

Joshin Joy

18-Dec-17 20:15

Thank you for your reply. but how can i get the url from div?

after entering the username and password. url in the div will be changed because a new page will be loaded.

Please help!

Jochen Arndt18-Dec-17 21:02

18-Dec-17 21:02

You wrote

Quote:
this is a html code I created

so I thought that you know the URLs and just want to load them to get the temperatures.

If you want to load a page from a login form, you have to pass the URL with parameters as send by the form when submitting. If this works depends on the form (how the the login parameters are passed). If it is not your site, it is probably intended by the site owner that you can't automate the process. Then you can only ask him if he provides an API to do such.

function to display content with php does not work as intended

Member 1387615717-Jun-18 20:01

Member 13876157

17-Jun-18 20:01

https://somewebsite.com/

this site is null

CHrispho15-Dec-17 9:46

CHrispho

15-Dec-17 9:46

I'm trying to create a generic template for multiple pages by retrieving them in the database but it does not work. My database is properly enable at the top of my page.

PHP

function stmt_query2(){

        $conn = pdo_con();

        $query = '
            SELECT * FROM layout_template as lt 
            INNER JOIN page_layout as pl ON lt.page_layout_id = pl.page_layout_id
            WHERE pl.page_layout_id = 1';

        $result = $heidisql->query($query);

        return $result;
    }

  function item_detail() {

      $output = '';

      $result = stmt_query2();

      while($rows = $result->fetch(PDO::FETCH_ASSOC)) {

          $output .='<div class="row">';

          $output .= '<div class="col-md-3">'
                  . '<a href="#"><img class="img-fluid rounded mb-3 mb-md-0" src="'.$rows["mainsub_layout_img"].'" alt="'.$rows["mainsub_layout_alt"].'"></a>'
                  . '</div>';

          $output .= '<div class="col-md-5">';

          $output .= '<h3>'.$rows["mainsub_layout_heading"].'</h3>';

          $output .= '<p class="sub_description">'.$rows["mainsub_layout_txt"].'</p>';

          $output .='<a class="btn btn-primary" href="#">Read More</a>';

          $output .=' </div>'
                  . '</div>';

          } 

          return $output;

          }

But it work if I did it like that

PHP

$conn = pdo_con();

      $query = '
          SELECT * FROM layout_template as lt 
          INNER JOIN page_layout as pl ON lt.page_layout_id = pl.page_layout_id
          WHERE pl.page_layout_id = 1';

      $result = $heidisql->query($query);

while($rows = $result->fetch(PDO::FETCH_ASSOC)) {

              $output .='<div class="row">';

              $output .= '<div class="col-md-3">'
                      . '<a href="#"><img class="img-fluid rounded mb-3 mb-md-0" src="'.$rows["mainsub_layout_img"].'" alt="'.$rows["mainsub_layout_alt"].'"></a>'
                      . '</div>';

              $output .= '<div class="col-md-5">';

              $output .= '<h3>'.$rows["mainsub_layout_heading"].'</h3>';

              $output .= '<p class="sub_description">'.$rows["mainsub_layout_txt"].'</p>';

              $output .='<a class="btn btn-primary" href="#">Read More</a>';
              $output .='</div></div>';
              
              $output .='<hr>';
              } 

              echo $output;

Re: function to display content with php does not work as intended

Jochen Arndt17-Dec-17 22:50