代码之家  ›  专栏  ›  技术社区  ›  SidC

如何在mysqli成功运行后重定向到另一个页面?

  •  0
  • SidC  · 技术社区  · 14 年前

    我在我的日记里写了以下内容reginsert.php. 目标是从index.php 并插入到我的regdata表中。成功插入完成后,我希望用户重定向到感谢_you.html. 我将在何处/如何将其合并到以下代码块中?

    <?php
    $Database = array(
    "Host" => 'myhost',
    "User" => 'myuser',
    "Password" => 'mypass',
    "Name" => 'mydb'
    );
    
    if ($mysqli->connect_error) 
    {
        $error = true;
        echo $mysqli->connect_error;
    }
    else    
    
    $mysqli = new mysqli($Database['Host'], $Database['User'], $Database['Password'], $Database['Name']);
    $stmt=mysqli->prepare("INSERT into regdata     (Username,Password,Confpassword,Status,Salutation,Firstname,Lastname,Jobtitle,Telephone,Companyname,industry,Address,City,Country,State,PostalCode,Regtype,Interests,Hdsprovider,PasswordRemindQuestion,PasswordRemindAnswer)
    VALUES(
    $_POST['email_address'],
    $_POST['create_password'],
    $_POST['confirm_password'],
    '0',
    $_POST['salutation2'],
    $_POST['first_naem'],
    $_POST['last_name'],
    $_POST['job_title'],
    $_POST['telephone'],
    $_POST['company_name'],
    $_POST['industry'],
    $_POST['address'],
    $_POST['city'],
    $_POST['state'],
    $_POST['country'],
    $_POST['state'],
    $_POST['postal_code'],
    $_POST['partner_customer_other'],
    $_POST['interests'],
    $_POST['provider_partner'],
    $_POST['password_reminder_question'],
    $_POST['password_reminder_answer']
    )");
    $stmt->execute();
    
    $stmt->close();
    
    ?>
    

    锡德

    3 回复  |  直到 14 年前
        1
  •  3
  •   Stoosh    14 年前
    if ($stmt->execute()) {
        header("Location: /path/to/thank_you.html");
    }
    
        2
  •  0
  •   user386431 user386431    14 年前

    if(mysql受影响的行($stmt)>0)
    {

    }

        3
  •  -1
  •   Michael Petrotta user3140870    14 年前
    if($stmt=mysqli->prepare("INSERT into regdata ...."))
    {
      //Above code ....
    } else 
    { 
       header ('Location: http://www.example.com/';
    }