how to call variable in next page

2017-06-17 18:14 maffidesigners imported from Stackoverflow

Am getting Notice: Undefined index: getdobcval in C:\xampp\htdocs\bgtest\buy_test.php on line 11

Am trying call variable, how to call variable from page1.php to page2.php

am using below form action

<form action="" method="POST">
  <input type="text" name="getdobcval">
  <input type="submit">
</form>

when user click submit value, it'l store the value in database and show the values in same page, i used page redirectory option after function finish (after 5 seconds). page redirectory working but after page am getting error

how to call <input type="text" name="getdobcval"> value ?

this is my database

if(isset($_POST['submit'])){                                                    

$getdob_cval = $_POST['getdobtcval'];                                               

$conn = mysqli_connect("localhost", "root", "", "bgtest");
$sql = "INSERT INTO bgtest(getdobtcval) VALUES('$getdob_cval')";
if (mysqli_query($conn, $sql)){
    echo "Please wait, We are redirecting another page!";
    echo '<script> setTimeout(function(){
                    window.location.href="buy_test.php"
        },3000);
     </script>';
}else{
    echo "error";
 }      
    mysqli_close($conn);
}

1 answer

answered 2017-06-17 18:14 InfiniteStack
This is usually done via a server-side script. Let's say script.php
```
<form action = "script.php"...
```
Or make sure that
```
<form action = ""...
```
Is specified in from on a .PHP page itself.

When the script refreshes, the values will be available via following array:
```
<?php
    $a = $_POST["getdobcval"];  // Submitted as POST
    $b = $_GET["getdobcval"];    // Submitted as GET
?>
```
Or alternatively you can receive it regardless of how it was submitted by:
```
<?php
    $c = $_REQUEST["getdobcval"];
?>
```

See also questions close to this topic

PHP 7 syntax with HHVM

I am using PHP with HHVM (HipHop Virtual Machine) instead of Zend Engine. My question is: Can HHVM support PHP 7 syntax?

Thanks

How do I retreive information from MySql ignoring special characters?

I have the following simple search query code:

function explode_search($squery, $column, $db, $link) {
global $conn;

$ven = explode(' ', safeInput(str_replace(',', '', $squery)));
$ven2 = array_map('trim', $ven);
$qy = ''.$column.' LIKE "%'.implode('%" AND '.$column.' LIKE "%', $ven2).'%"';

$query = 'SELECT DISTINCT '.$column.', id, work_composer FROM '.$db.' WHERE '.$qy.' ORDER BY '.$column.' LIMIT 100';
$result = mysqli_query($conn, $query);
while ($row = mysqli_fetch_assoc($result))  {

    echo '<div><span class="mdmtxt" style="margin-bottom:5px;"><a href="'.$link.'.php?id='.$row['id'].'">'.$row[$column].'</a></span> <span class="mdmtxt" style="opacity:0.6;">('.fixcomp(cfid($row['work_composer'], 'cffor_composer', 'composer_name')).')</span></div>';
}   
}

(The safeInput function removes ' and " and other possible problematics)

It works alright up to a point.

When someone looks for 'Stephane' I want them also to find 'Stéphane' (and vice versa) or if they are looking for 'Munich', 'Münich' should show up in the list as well.

Is there a way to make MySQL match those search queries, irrespective of the special characters involved?

How to forward an email with an embedded image using php imap_mail
The message is an html message with the embedded image already encoded. I'm assuming it has to do with the headers. I have used a random number for the boundary and used the original boundary sent in the original email. The image does not show up, but the message looks correct. If I change the Content_Type to multipart/mixed then the message doesn't show up correctly.
```
$headers .= "Content-Type: text/html; boundary=\"_$random_\"; type=\"multipart/alternative\"";
```

Error on insert data from another table into an existing partition

I am trying to insert on a partitioned table like:

 insert into table select * from table@dblink
 where date = 2016702003;

At first, I created the correct partition: TP_201702003 values (201702003)

And got this error:

Error report -
SQL Error: ORA-14400: a chave de partição inserida não corresponde a nenhuma partição
14400. 00000 -  "inserted partition key does not map to any partition"
*Cause:    An attempt was made to insert a record into, a Range or Composite
           Range object, with a concatenated partition key that is beyond
           the concatenated partition bound list of the last partition -OR-
           An attempt was made to insert a record into a List object with
           a partition key that did not match the literal values specified
           for any of the partitions.
*Action:   Do not insert the key. Or, add a partition capable of accepting
           the key, Or add values matching the key to a partition specification

This is the only month with this problem. Can you see anything wrong?

Thanks in advance.

Update merged Datatable to Database
Hey I want to save a Datatable(only with strings in it and also a primary key) into my Access Database.

I have written this code:
```
        // Datatable that is connected to the database---------------------------------------------------------
        conn = new OleDbConnection(conn_string);
        conn.Open();

        OleDbCommand com = new OleDbCommand(q, conn);

        a = new OleDbDataAdapter(com);

        db = new DataTable();


        a.SelectCommand = com;

        a.Fill(db);
        db.Merge(dt);

        db.AcceptChanges();


        bindingSource.DataSource = db;


        bindingNavigator.BindingSource = bindingSource;
        dataGridView1.DataSource = bindingSource;

    }
```
So this works and gives me the merged Table.

This is the Table unmerged:

http://imgur.com/vOrTNxE

And this the merged:

http://imgur.com/J2SHmGk

So now i want to save that merged datatable that is displayed in the datagridview in the Database.

What I did is :

//Butten that saves data

private void toolStripButton1_Click(object sender, EventArgs e)
```
    {
         OleDbCommandBuilder cmbl = new OleDbCommandBuilder(a);


         a.Update(db);

    }
```
But that dont updates the changes the merge made but everything else.

If add a new Line that is no problem and gets saved in the Database, but not the new Rows from the Merge.

Does someone how i can save also the merged data? :)

Thanks

Getting Chat Conversations without having a separate conversations table in MySQL

I have following MySQL tables.

Messages
Message Users

And there schema is as follows:-

+-----------+---------------------------------+-----------+
|message_id | message                         | sender_id |
+-----------+---------------------------------+-----------+
| 1         | Hello Jason!                    | 1         |
+-----------+---------------------------------+-----------+
| 2         | Hi Tim!                         | 2         |
+-----------+---------------------------------+-----------+
| 3         | When will you be here?          | 1         |
+-----------+---------------------------------+-----------+
| 4         | At around 11 O'Clock            | 2         |
+-----------+---------------------------------+-----------+
| 5         | Hey Jake!                       | 2         |
+-----------+---------------------------------+-----------+
| 6         | I'm going to Tim's. Wanna join? | 2         |
+-----------+---------------------------------+-----------+
| 7         | Nah man! Some other time..      | 3         |
+-----------+---------------------------------+-----------+

+--------+------------+---------+
| mu_id  | message_id | user_id |
+--------+------------+---------+
| 1      | 1          | 1       |
+--------+------------+---------+
| 2      | 1          | 2       |
+--------+------------+---------+
| 3      | 2          | 2       |
+--------+------------+---------+
| 4      | 2          | 1       |
+--------+------------+---------+
| 5      | 3          | 1       |
+--------+------------+---------+
| 6      | 3          | 2       |
+--------+------------+---------+
| 7      | 4          | 2       |
+--------+------------+---------+
| 8      | 4          | 1       |
+--------+------------+---------+
| 9      | 5          | 2       |
+--------+------------+---------+
| 10     | 5          | 3       |
+--------+------------+---------+
| 11     | 6          | 2       |
+--------+------------+---------+
| 12     | 6          | 3       |
+--------+------------+---------+
| 13     | 7          | 3       |
+--------+------------+---------+
| 14     | 7          | 2       |
+--------+------------+---------+

Now what I want to implement is to show the conversations history list. So for user_id 2, it should contain 2 entries:- One for conversation between user_id 2 and user_id 1 AND another for conversation between user_id 2 and user_id 3.

Similarly for user_id 1, it should contain only 1 entry for conversation between user_id 1 and 2. And similarly for user_id 3, it should contain only 1 entry for conversation between user_id 2 and 3.

How can I achieve it? Any solution with multiple queries would work for me because I need to implement it in either PHP or Node.js at a later stage.

django set global variable in template
I am using a banner image that needs to change on each page, I would like to set the banner in the html template, so that it is easy for the person I am building it for to easily add new pages.

I am developing it in django, but I can't figure out how to get it to work, please help!

example:

index.html
```
set image url here
{% extends 'base.html' %}
```
base.html
```
<html>
  <body>
    {% include 'top.html %}
  </body>
</html>
```
top.html
```
<div>
  <img src="{{ image url }}">
</div>
```
Issue passing a variable through a Powershell script
Trying to create a powershell script to perform the following tasks: - Asks for a username to use when creating folder and assigning permissions - Create folder on our NAS with that username for a name - Create DFS folder with same name and assign it a target path - Assign explicit permissions for the user to that DFS folder

My script looks like the following:
```
$Username = read-host "Type Username"

#Create new folder on the NAS and set necessary permissions
New-Item -Path \\NAS\USER_SHARE\$Username -ItemType Directory

#Create new DFS folder and target
New-DfsnFolder -Path "\\DOMAIN.local\user\$Username" -TargetPath "\\NAS\USER_SHARE\$Username"

#Assign explicit permissions to DFS folder for user
dfsutil property SD grant \\DOMAIN.local\user\$Username DOMAIN\$Username:F protect
```
It performs everything but the last line. It creates the DFS folder but doesn't give permissions. No error message is given, just prints out the help info for the dfsutil command. When I run the last line independently with a static username, it is successful. So I believe there is something with the syntax of the $Username:F part of that last line of code messing it up.

How can I separate that last section to make this work?
How to use function to change variables value in Java
I want to make a function in java that will take an variable as an argument for example an int, and will change its value.

In c++ it would look like this:
```
void function(int* var){
*var = 20;
}
```
But i searched for pointers in java and found that there aren't any similar to this as in c++; Thanks in advance.
Retrieve result from mysqli query
Retrieve from mysqli query, here if I run this query in database I will get answer as 1 or 0;

How can I get this 1 and 0 from $result in php myadmin? Can anyone help me to retrieve it? Thanks in advance
```
$qry = "SELECT EXISTS(SELECT email FROM tb_login WHERE email ='$email' LIMIT 1)";

$result = mysqli_query($con, $qry);
```

Google Line Charts interpolateNulls: false breaks chart

I knew the answer was going to be much simpler then I was making it out to be. I added the following if statement to the while loop.

<?php
                echo "['Month', '$year1' , '$year2' , '$currentYear'],";
                require('./PHPConnect.php');        
                $statement1 = @mysqli_query($dbc, $query1);
                while($row = mysqli_fetch_array($statement1)){
                    if($row["Year3"] == NULL ? $row["Year3"] = 'null' : $row["Year3"] = $row["Year3"]);
                    echo "['".$row["Month"]."', ".$row["Year1"].", ".$row["Year2"].", ".$row["Year3"]."],";
                }
                mysqli_close($dbc);
                ?>

As an update we now know that the problem is MySql spits out NULL and javascript requires null. Any thoughts on how to accomplish getting MySql NULL int value into lowercase null.

*I was wondering if anyone can help me with this. I created a line chart to visual show company sales by month for the current year and the previous 2. It works fine, but because at this point there is 0 sales for the remaining months of the year it shows a steep drop off for that line. We don't want to see that, so I tried changing the 0s to nulls in the database and using interpolateNulls false. However when I add the interpolateNulls option the line chart breaks and no longer displays anything. Any ideas?

<script type="text/javascript">
        var data;
        var chart;
        google.charts.load('current', {'packages':['corechart']});
        google.charts.setOnLoadCallback(drawChart);
        function drawChart(){
                data = google.visualization.arrayToDataTable([ 
                <?php
                echo "['Month', '$year1' , '$year2' , '$currentYear'],";
                require('./PHPConnect.php');        
                $statement1 = @mysqli_query($dbc, $query1);
                while($row = mysqli_fetch_array($statement1)){
                    echo "['".$row["Month"]."', ".$row["Year1"].", ".$row["Year2"].", ".$row["Year3"]."],";
                }
                mysqli_close($dbc);
                ?>
            ]); 
            var options = {
                backgroundColor: 'transparent',
                title:'Total Sales By Month',
                width:600, 
                height:500,
                interpolateNulls: false,
                legend: {position: 'bottom'}
            };
            var chart = new google.visualization.LineChart(document.getElementById('chart_div'));
            chart.draw(data, options);
        }

Will a LIKE function give me better results when Match Against function does not give any results in Mysql

Currently, When I type 'M' in the search engine I do not get any results inspite of having a 'Math' value in my database. (I am using Match Against function of mysql on my website). So I decided to make a code that first runs a Match Against function and if no output is obtained, it again runs the search but this time using 'LIKE' function of my sql and if still no result is obtained it shows alert 'no values found'. the gist of code is somewhat like this..

mysql(Match against function)
If (mysqli_num_rows > 0) 
{output}
elseif (mysqli_num_rows < 1)
{ mysqli (LIKE function)
  then show output}
else {show alert'no results'}

Will this code give the result 'Math' when I enter 'M' in the search engine.

The actual code.

<?php   
            if (isset($_POST['go']))
                    {  $search = $_POST['search'];
                       $college = $_POST['colleges'];
                        if (!empty($search))
                        {
                           if(isset($_POST['colleges']) )
                           {

                            $query1 = "Select filename, description, groupid, emailid, college, upload_date FROM images WHERE MATCH(description) AGAINST('$search') AND college = '$college' group by groupid order by MATCH(description) AGAINST('$search') DESC";
                            $query_run1 = mysqli_query($con, $query1) ; 


                           }
                           else
                          {

                        $query1 = "Select filename, description, groupid, emailid, college,upload_date FROM images WHERE MATCH(description) AGAINST('$search') group by groupid order by MATCH(description) AGAINST('$search') DESC";
                            $query_run1 = mysqli_query($con, $query1) ; 



                            $searchresults = mysqli_num_rows($query_run1);
                            ?><p class = "totalresults"> <br />
                              <br /> &nbsp &nbsp <font size= "4" >Total Results : 
                             <?php
                            echo $searchresults ;
                            ?>
                            </font> </p> 
                            <?php
                            if(mysqli_num_rows($query_run1)>0)
                            {

                                ?>
                                 <table class="searchenginelist" style="color: black;">
                                       <tr>
                                        <th> Uploader </th>
                                        <th> Title </th>
                                        <th> Date </th>
                                        <th> Upvotes </th>
                                        <th> Downvotes </th>
                                        <th> College </th>
                                        </tr>
                                <?php
                                   while( $rows = mysqli_fetch_assoc($query_run1))
                                   { 
                                       //$imagedisplay = $rows['file'];
                                       $imagename = $rows['filename'];
                                      // mysqli_real_escape_string($con,$imagedisplay);
                                       $descrip = $rows['description'];
                                       $groupid = $rows['groupid'];
                                       //$groupid = $_SESSION['groupid'] ;
                                       $uploader_emailid = $rows['emailid'];
                                       $college = $rows['college'];


         ?>


                    <tr>
                    <td width="70px"> <?php 
                       $query = " SELECT username from userinfo WHERE emailid = '$uploader_emailid' " ;
                           $query_run = mysqli_query($con,$query );
                       $raw = mysqli_fetch_assoc($query_run);
                       echo  $raw['username']; ?>
                   </td>
                   <td width="450px">  <a href="imagespace.php?groupid=<?php echo $groupid ;?>"> 
                       <?php echo $descrip ; ?> 
                    </a>
                   </td>
                   <td style="font-size:15px;" width="85px">    
                   <?php echo $rows['upload_date'] ; ?>
                   </td> 
                   <td align="center" style="color:green;" width="50px">
                     <?php
                      $query = "SELECT vote from votes where groupid = '$groupid' and vote = '1' "; 
                                     $query_run= mysqli_query($con, $query);
                                      $upvote=mysqli_num_rows($query_run) ;
                                      echo $upvote;
                                     ?> 
                </td>
                <td align="center" style="color:red;" width="50px">
                   <?php
                      $query = "SELECT vote from votes where groupid = '$groupid' and vote = '0' "; 
                                     $query_run= mysqli_query($con, $query);
                                      $downvote=mysqli_num_rows($query_run) ;
                                      echo $downvote;
                                      ?>
                   </td>
                   <td style="font-size:13px;" width="130px">
                     <?php echo $college; ?> 
                    </td>
                   </tr>
                                   <?php
                                   }
                                   ?>
                                   </table>
                                   <?php
                            } 
                            elseif(mysqli_num_rows($query_run1) < 1)
                            {
                            $query12 = "Select * FROM images WHERE description LIKE '%".mysqli_real_escape_string($con,$search)."%' group by groupid order by groupid DESC";
                            $query_run12 = mysqli_query($con, $query12) ; 
                             ?>  <table class="searchenginelist" style="color: black;">
                                       <tr>
                                        <th> Uploader </th>
                                        <th> Title </th>
                                        <th> Date </th>
                                        <th> Upvotes </th>
                                        <th> Downvotes </th>
                                        <th> College </th>
                                        </tr>
                            <?php       
                             while( $rows = mysqli_fetch_assoc($query_run12))
                                   { 
                                       //$imagedisplay = $rows['file'];
                                       $imagename = $rows['filename'];
                                      // mysqli_real_escape_string($con,$imagedisplay);
                                       $descrip = $rows['description'];
                                       $groupid = $rows['groupid'];
                                       //$groupid = $_SESSION['groupid'] ;
                                       $uploader_emailid = $rows['emailid'];
                                       $college = $rows['college'];

                ?> 
                    <tr>
                    <td width="70px"> <?php 
                       $query = " SELECT username from userinfo WHERE emailid = '$uploader_emailid' " ;
                           $query_run = mysqli_query($con,$query );
                       $raw = mysqli_fetch_assoc($query_run);
                       echo  $raw['username']; ?>
                   </td>
                   <td width="450px">  <a href="imagespace.php?groupid=<?php echo $groupid ;?>"> 
                       <?php echo $descrip ; ?> 
                    </a>
                   </td>
                   <td style="font-size:15px;" width="85px">    
                   <?php echo $rows['upload_date'] ; ?>
                   </td> 
                   <td align="center" style="color:green;" width="50px">
                     <?php
                      $query = "SELECT vote from votes where groupid = '$groupid' and vote = '1' "; 
                                     $query_run= mysqli_query($con, $query);
                                      $upvote=mysqli_num_rows($query_run) ;
                                      echo $upvote;
                                     ?> 
                </td>
                <td align="center" style="color:red;" width="50px">
                   <?php
                      $query = "SELECT vote from votes where groupid = '$groupid' and vote = '0' "; 
                                     $query_run= mysqli_query($con, $query);
                                      $downvote=mysqli_num_rows($query_run) ;
                                      echo $downvote;
                                      ?>
                   </td>
                   <td style="font-size:13px;" width="130px">
                     <?php echo $college; ?> 
                    </td>
                       </tr>


                            }
                            ?>
                            </table>
                            <?php
                            }
                            else
                            {
                                echo '<script type="text/javascript"> alert ("No results found") </script>' ;
                            }
                        }
                        else
                        { echo '<script type="text/javascript"> alert ("No data entered") </script>';
                        }
                        }
                    }

Related questions

how to call variable in next page

1 answer

See also questions close to this topic