首页 \ 问答 \ 来自PHP数据库（PDO）的MySQL数据库的自动填充数据（输入字段）(Auto fill-in data (input field) from MySQL Database in PHP (PDO))

来自PHP数据库（PDO）的MySQL数据库的自动填充数据（输入字段）(Auto fill-in data (input field) from MySQL Database in PHP (PDO))

 这篇文章包含： 
 

     
 
  •  3个PHP页面 
    •  
 
  •  MySQL表图片 
    •  
 
  •  表格的图片 
    •  

 

 

 正如标题所说，我需要从我的数据库中 提取一些信息 。 
 

 到目前为止，我有以下内容： 
 

     
 
  •  索引页 < - 您需要使用个人代码登录此处。 （这是我从联系页面上获得的“会话用户名”） 
    •  
 
  •  配置页 < - 用于数据库访问和所有 
    •  
 
  •  联系页面 < - 在这里我想自动填写用户数据。 
    •  

 

 数据库表包括： 
 

     
 
  •  用户名; 电子邮件; realName（以及其他一些我不需要的东西） 
    •  

 

 所以在联系页面中我想看到以下内容： 
 

     
 
  •  卡号=用户名（这已经有效） 
    •  
 
  •  自动填写：realName和电子邮件根据用户名。 
    •  

 

 

 也许有可能在登录时提取信息并将其存储在POST变量中？ 但是怎么样？ 
 

 

 数据库： 
 

     
 
  •  表我需要使用： '成员' 
    •  

 

 会员 
 

 

 用户自己给出的信息= 用户名 
 

 我需要自动填写的信息= realName和email 
 

 

 表格的图片。 
 

 电子邮件应该在SESSION语句中，因此我可以向该人发送确认电子邮件，并且应该从数据库输入realName。 
 

 表格的图片 
 

 

 这些是当前运行的文件： 
 

 config.php文件： 
 

<?php
ob_start();
session_start();

//set timezone
date_default_timezone_set('Europe/Brussels');

//database credentials
define('DBHOST','*****');
define('DBUSER','*****');
define('DBPASS','*****');
define('DBNAME','*****');

//application address
define('DIR','http://*****/');
define('SITEEMAIL','noreply@*****');

try {

//create PDO connection
$db = new PDO("mysql:host=".DBHOST.";dbname=".DBNAME, DBUSER, DBPASS);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

} catch(PDOException $e) {
//show error
echo '<p class="bg-danger">'.$e->getMessage().'</p>';
exit;
}

//include the user class, pass in the database connection
include('classes/user.php');
include('classes/phpmailer/mail.php');
$user = new User($db);
?>

 

 联系表： 
 

<?php require('includes/config.php'); 

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: index.php'); } 
?>
<html>
<head>
    <title>*****</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1"        />
    <!--[if lte IE 8]><script  src="siteassets/assets/js/ie/shiv.js"></script><![endif]-->
    <link rel="stylesheet" href="siteassets/assets/css/main.css" />
    <!--[if lte IE 8]><link rel="stylesheet" href="siteassets/assets/css/ie8.css" /><![endif]-->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
 <script>
$(document).ready(function(){
$('#next').keyup(calculate);
$('#nextprice').keyup(calculate);
$('#current').keyup(calculate);
$('#currentprice').keyup(calculate);
});
 function calculate(e)
{
$('#total').val($('#next').val() * $('#nextprice').val() + $('#current').val() * $('#currentprice').val());
}
</script>

</head>
<body class="landing">
    <div id="page-wrapper">

        <!-- Header -->
            <header id="header" class="alt">

                <nav id="nav">
                    <ul>
                        <li>
                            <a href="#" class="icon fa-angle-down">Menu</a>
                            <ul>
                                <li><a href="home.php">Current Project</a></li>
                                <li><a href="newproj.php">Next Projects</a></li>
                                <li><a href="prev.php">Previous Projects</a></li>
                                <li><a href="who.php">Who are we?</a></li>
                            </ul>
                        </li>
                        <li><a href="contact.php" class="button">contact</a></li>
                        <li><a href='logout.php'>Logout</a></li>
                    </ul>
                </nav>
            </header>

        <!-- Banner -->
            <section id="banner">
                <h2>*****</h2>
                <p>Slogan.</p>
                <ul class="actions">
                    <li><a href="home.php" class="button">Current Project</a></li>
                    <li><a href="newproj.php" class="button">Next Projects</a></li>
                    <li><a href="prev.php" class="button">Previous Projects</a></li>
                    <li><a href="who.php" class="button">Who are we?</a></li>
                    <li><a href="contact.php" class="button special">contact</a></li>
                </ul>
            </section>

        <!-- Main -->




            <section id="main" class="container 75%">
                <div class="box">
<? 
if($_SERVER['REQUEST_METHOD']=="POST")
{ 
if(strlen($_POST['name2']) == 0)
{ $error_msg ="- Please, provide us with your name.<br>"; } 

if(!empty($error_msg))
{ 
//Een van de velden werd niet goed ingevuld 
echo "<b>Your message can't be send due to the following reason:</b>    <br><br>"; 
echo $error_msg; 
echo "<br>Click on <a href='javascript:history.back(1)'>Go back</a> and  provide us with your name.<br><br>"; 
}
else 
{ 
$recipient = "*****"; 
$subject = "******"; 
$header = "From: " . $_POST['uwemail'] . "\n"; 
$mail_body = "Contact script werd op " . date("d-m-Y") . " om " . date("H:i") . " uur uitgevoerd.\n"; 
$mail_body .= "*****:\n\n"; 
$mail_body .= "Naam: " . $_POST['name2'] . "\n"; 
$mail_body .= "Met als kaartnummer: " . $_POST['card2'] . "\n"; 
$mail_body .= "******: " .  $_POST['current2'] . "\n"; 
$mail_body .= "******: " .  $_POST['next2'] . "\n"; 
$mail_body .= "Voor een totaal van: " . $_POST['total2'] . " EUR.";   
$mail_body .= "\n\n -- ****** --"; 
mail($recipient, $subject, $mail_body, $header); 
print "<b>IMPORTANT!</b>";
print "<br><br>*****.";
print "<br><br>***** ";
print $_POST['total2'];
print " *****";
print "<br><br>******.";
print "<br><br>******";
}
} 
else 
{ 
?>      
        <form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST" name="contact">
                        <div class="row uniform 50%">
                            <div class="6u 12u(mobilep)">
                            Your personal card number
                                <input type="text" name="card2" id="card" value="<?php echo $_SESSION['username']; ?>" placeholder="Card Number" readonly/>
                            </div>
                            <div class="6u 12u(mobilep)">
                            Please enter your name. (mandatory)
                                <input type="text" name="name2"  id="name" value="" placeholder="Your name" />
                            </div>
                        </div>
                        <div class="row uniform 50%">
                            <div class="6u 12u(mobilep)">
                            Current Project - Smile
                                <input type="text" name="current2" id="current" value="" placeholder="How many tickets would you like?" />
                            </div>
                            <div class="6u 12u(mobilep)">
                            Next Project - Sand
                                <input type="text" name="next2" id="next" value="" placeholder="How many tickets would you like?" />
                            </div>
                        </div>
                        <div class="row uniform 50%">
                            <div class="6u 12u(mobilep)">
                                <input type="hidden" id="currentprice" value="10" />
                            </div>
                            <div class="6u 12u(mobilep)">
                                <input type="hidden" id="nextprice" value="10" placeholder="" />
                            </div>
                        </div>
                                        <div class="6u 12u(mobile)">
                                            <input name="uwemail" placeholder="Email" type="hidden" value="******"/>
                                        </div>
                        <div class="6u 12u(mobilep)">
                        Total price.(In EUR)
                                <input type="text" name="total2" id="total" value=""  readonly/>
                            </div>
                        </div>

                        <div class="row uniform">
                            <div class="12u">
                                <ul class="actions align-center">
                                    <li><input type="submit" name="submit"value="Place Order"/></li>
                                </ul>
                            </div>
                        </div>
                    </form>


<?php 
} 
?> 

                </div>
            </section>


        <!-- Footer -->
            <footer id="footer">

                <ul class="copyright">
                    <li>&copy; *****. All rights reserved.</li>
                </ul>
            </footer>

    </div>

    <!-- Scripts -->
        <script src="siteassets/assets/js/jquery.min.js"></script>
        <script src="siteassets/assets/js/jquery.dropotron.min.js"></script>
        <script src="siteassets/assets/js/jquery.scrollgress.min.js"></script>
        <script src="siteassets/assets/js/skel.min.js"></script>
        <script src="siteassets/assets/js/util.js"></script>
        <!--[if lte IE 8]><script src="siteassets/assets/js/ie/respond.min.js"></script><![endif]-->
        <script src="siteassets/assets/js/main.js"></script>




</body>
</html>

 

 索引页面（他们必须登录） 
 

<?php
//include config
require_once('includes/config.php');


//process login form if submitted
if(isset($_POST['submit'])){

$username = $_POST['username'];
$password = $_POST['password'];

if($user->login($username,$password)){ 
    $_SESSION['username'] = $username;
    header('Location: home.php');
    exit;

} else {
    $error[] = 'Wrong username or password or your account has not been activated.';
}

}//end if submit


?>

<html>
<head>



    <title>******</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1"     />
    <!--[if lte IE 8]><script src="assets/js/iv.js"></script><!    [endif]-->
    <link rel="stylesheet" href="assets/css/main.css" />
    <!--[if lte IE 9]><link rel="stylesheet" href="assets/css/ie9.css"     /><![endif]-->
    <!--[if lte IE 8]><link rel="stylesheet" href="assets/css/ie8.css"     /><![endif]-->
    <noscript><link rel="stylesheet" href="assets/css/noscript.css" />        </noscript>
</head>
<body class="is-loading">

    <!-- Wrapper -->
        <div id="wrapper">

            <!-- Main -->
                <section id="main">
                    <header>

                        <h1>*****</h1>
                        <h1><a style="color:#FFFFFF" href=''>Coming soon.</a></h1>



<div class="container">

<div class="row">

    <div class="col-xs-12 col-sm-8 col-md-6 col-sm-offset-2 col-md-offset-3">
        <form role="form" method="post" action="" autocomplete="off">
            <h2>Please Login</h2>

            <hr>

            <?php
            //check for any errors
            if(isset($error)){
                foreach($error as $error){
                    echo '<p class="bg-danger">'.$error.'</p>';
                }
            }

            if(isset($_GET['action'])){

                //check the action
                switch ($_GET['action']) {
                    case 'active':
                        echo "<h2 class='bg-success'>Your account is now active you may now log in.</h2>";
                        break;
                    case 'reset':
                        echo "<h2 class='bg-success'>Please contact us for a new card.</h2>";
                        break;
                    case 'resetAccount':
                        echo "<h2 class='bg-success'>Password changed, you may now login.</h2>";
                        break;
                }

            }


            ?>

            <div class="form-group">
                <input type="text" name="username" id="username"     class="form-control input-lg" placeholder="Enter your card number" value="    <?php if(isset($error)){ echo $_POST['username']; } ?>" tabindex="1">
            </div>

            <div class="form-group">
                <input type="hidden" name="password" id="password" class="form-control input-lg" value="*****" tabindex="3" >
            </div>

<br>

            <div class="row">
                <div class="col-xs-6 col-md-6"><input type="submit"    name="submit" value="Login" class="btn btn-primary btn-block btn-lg"     tabindex="5"></div>
            </div>
<hr>
                <div class="row">
                <div class="col-xs-9 col-sm-9 col-md-9">
                     <a style="color:#FFFFFF" href='*********'>Lost your card? Contact us.</a>
                </div>
            </div>

        </form>
    </div>
</div>



</div>




                    </header>

                </section>

            <!-- Footer -->
                <footer id="footer">
                    <ul class="copyright">
                        <li>&copy; ******</li>
                    </ul>
                </footer>

        </div>

    <!-- Scripts -->
        <!--[if lte IE 8]><script src="assets/js/respond.min.js"> </script><![endif]-->
        <script>
            if ('addEventListener' in window) {
                window.addEventListener('load', function() {  document.body.className = document.body.className.replace(/\bis-loading\b/,  ''); });
                document.body.className +=  (navigator.userAgent.match(/(MSIE|rv:11\.0)/) ? ' is-ie' : '');
            }
        </script>

</body>
</html>


This post contains:
 

     
 
  • 3 PHP pages
    •  
 
  • MySQL table picture
    •  
 
  • Picture of the form
    •  

 

 

As the title says, I need to extract some information from my database.
 

So far I have the following:
 

     
 
  • Index page <-- You need to login here with a personal code. (this is where I get the 'Session username' from that already works at the contact page)
    •  
 
  • Config page <-- Used for database access and all
    •  
 
  • Contact page <-- In here I would like to auto fill-in the users data.
    •  

 

Database table consists of:
 

     
 
  • username; email; realName (and some other stuff I don't need here)
    •  

 

So in the contact page I would like to see the following:
 

     
 
  • Card number = username (this already works)
    •  
 
  • Auto fill-in: realName and email according to the username.
    •  

 

 

Maybe it is possible to extract the info when logging in and storing these in the POST variable already? But how?
 

 

Database:
 

     
 
  • Table I need to use: 'members'
    •  

 

members
 

 

The info given by the user himself/herself = username
 

The info I need to auto fill-in = realName and email
 

 

Picture of the form.
 

The email should be in the SESSION statement, so I can send a confirmation email to the person, and the realName should be entered from the database.
 

Picture of the form
 

 

These are the files currently running:
 

config.php:
 

<?php
ob_start();
session_start();

//set timezone
date_default_timezone_set('Europe/Brussels');

//database credentials
define('DBHOST','*****');
define('DBUSER','*****');
define('DBPASS','*****');
define('DBNAME','*****');

//application address
define('DIR','http://*****/');
define('SITEEMAIL','noreply@*****');

try {

//create PDO connection
$db = new PDO("mysql:host=".DBHOST.";dbname=".DBNAME, DBUSER, DBPASS);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

} catch(PDOException $e) {
//show error
echo '<p class="bg-danger">'.$e->getMessage().'</p>';
exit;
}

//include the user class, pass in the database connection
include('classes/user.php');
include('classes/phpmailer/mail.php');
$user = new User($db);
?>

 

contact form:
 

<?php require('includes/config.php'); 

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: index.php'); } 
?>
<html>
<head>
    <title>*****</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1"        />
    <!--[if lte IE 8]><script  src="siteassets/assets/js/ie/shiv.js"></script><![endif]-->
    <link rel="stylesheet" href="siteassets/assets/css/main.css" />
    <!--[if lte IE 8]><link rel="stylesheet" href="siteassets/assets/css/ie8.css" /><![endif]-->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
 <script>
$(document).ready(function(){
$('#next').keyup(calculate);
$('#nextprice').keyup(calculate);
$('#current').keyup(calculate);
$('#currentprice').keyup(calculate);
});
 function calculate(e)
{
$('#total').val($('#next').val() * $('#nextprice').val() + $('#current').val() * $('#currentprice').val());
}
</script>

</head>
<body class="landing">
    <div id="page-wrapper">

        <!-- Header -->
            <header id="header" class="alt">

                <nav id="nav">
                    <ul>
                        <li>
                            <a href="#" class="icon fa-angle-down">Menu</a>
                            <ul>
                                <li><a href="home.php">Current Project</a></li>
                                <li><a href="newproj.php">Next Projects</a></li>
                                <li><a href="prev.php">Previous Projects</a></li>
                                <li><a href="who.php">Who are we?</a></li>
                            </ul>
                        </li>
                        <li><a href="contact.php" class="button">contact</a></li>
                        <li><a href='logout.php'>Logout</a></li>
                    </ul>
                </nav>
            </header>

        <!-- Banner -->
            <section id="banner">
                <h2>*****</h2>
                <p>Slogan.</p>
                <ul class="actions">
                    <li><a href="home.php" class="button">Current Project</a></li>
                    <li><a href="newproj.php" class="button">Next Projects</a></li>
                    <li><a href="prev.php" class="button">Previous Projects</a></li>
                    <li><a href="who.php" class="button">Who are we?</a></li>
                    <li><a href="contact.php" class="button special">contact</a></li>
                </ul>
            </section>

        <!-- Main -->




            <section id="main" class="container 75%">
                <div class="box">
<? 
if($_SERVER['REQUEST_METHOD']=="POST")
{ 
if(strlen($_POST['name2']) == 0)
{ $error_msg ="- Please, provide us with your name.<br>"; } 

if(!empty($error_msg))
{ 
//Een van de velden werd niet goed ingevuld 
echo "<b>Your message can't be send due to the following reason:</b>    <br><br>"; 
echo $error_msg; 
echo "<br>Click on <a href='javascript:history.back(1)'>Go back</a> and  provide us with your name.<br><br>"; 
}
else 
{ 
$recipient = "*****"; 
$subject = "******"; 
$header = "From: " . $_POST['uwemail'] . "\n"; 
$mail_body = "Contact script werd op " . date("d-m-Y") . " om " . date("H:i") . " uur uitgevoerd.\n"; 
$mail_body .= "*****:\n\n"; 
$mail_body .= "Naam: " . $_POST['name2'] . "\n"; 
$mail_body .= "Met als kaartnummer: " . $_POST['card2'] . "\n"; 
$mail_body .= "******: " .  $_POST['current2'] . "\n"; 
$mail_body .= "******: " .  $_POST['next2'] . "\n"; 
$mail_body .= "Voor een totaal van: " . $_POST['total2'] . " EUR.";   
$mail_body .= "\n\n -- ****** --"; 
mail($recipient, $subject, $mail_body, $header); 
print "<b>IMPORTANT!</b>";
print "<br><br>*****.";
print "<br><br>***** ";
print $_POST['total2'];
print " *****";
print "<br><br>******.";
print "<br><br>******";
}
} 
else 
{ 
?>      
        <form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST" name="contact">
                        <div class="row uniform 50%">
                            <div class="6u 12u(mobilep)">
                            Your personal card number
                                <input type="text" name="card2" id="card" value="<?php echo $_SESSION['username']; ?>" placeholder="Card Number" readonly/>
                            </div>
                            <div class="6u 12u(mobilep)">
                            Please enter your name. (mandatory)
                                <input type="text" name="name2"  id="name" value="" placeholder="Your name" />
                            </div>
                        </div>
                        <div class="row uniform 50%">
                            <div class="6u 12u(mobilep)">
                            Current Project - Smile
                                <input type="text" name="current2" id="current" value="" placeholder="How many tickets would you like?" />
                            </div>
                            <div class="6u 12u(mobilep)">
                            Next Project - Sand
                                <input type="text" name="next2" id="next" value="" placeholder="How many tickets would you like?" />
                            </div>
                        </div>
                        <div class="row uniform 50%">
                            <div class="6u 12u(mobilep)">
                                <input type="hidden" id="currentprice" value="10" />
                            </div>
                            <div class="6u 12u(mobilep)">
                                <input type="hidden" id="nextprice" value="10" placeholder="" />
                            </div>
                        </div>
                                        <div class="6u 12u(mobile)">
                                            <input name="uwemail" placeholder="Email" type="hidden" value="******"/>
                                        </div>
                        <div class="6u 12u(mobilep)">
                        Total price.(In EUR)
                                <input type="text" name="total2" id="total" value=""  readonly/>
                            </div>
                        </div>

                        <div class="row uniform">
                            <div class="12u">
                                <ul class="actions align-center">
                                    <li><input type="submit" name="submit"value="Place Order"/></li>
                                </ul>
                            </div>
                        </div>
                    </form>


<?php 
} 
?> 

                </div>
            </section>


        <!-- Footer -->
            <footer id="footer">

                <ul class="copyright">
                    <li>&copy; *****. All rights reserved.</li>
                </ul>
            </footer>

    </div>

    <!-- Scripts -->
        <script src="siteassets/assets/js/jquery.min.js"></script>
        <script src="siteassets/assets/js/jquery.dropotron.min.js"></script>
        <script src="siteassets/assets/js/jquery.scrollgress.min.js"></script>
        <script src="siteassets/assets/js/skel.min.js"></script>
        <script src="siteassets/assets/js/util.js"></script>
        <!--[if lte IE 8]><script src="siteassets/assets/js/ie/respond.min.js"></script><![endif]-->
        <script src="siteassets/assets/js/main.js"></script>




</body>
</html>

 

Index page (where they have to login)
 

<?php
//include config
require_once('includes/config.php');


//process login form if submitted
if(isset($_POST['submit'])){

$username = $_POST['username'];
$password = $_POST['password'];

if($user->login($username,$password)){ 
    $_SESSION['username'] = $username;
    header('Location: home.php');
    exit;

} else {
    $error[] = 'Wrong username or password or your account has not been activated.';
}

}//end if submit


?>

<html>
<head>



    <title>******</title>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1"     />
    <!--[if lte IE 8]><script src="assets/js/iv.js"></script><!    [endif]-->
    <link rel="stylesheet" href="assets/css/main.css" />
    <!--[if lte IE 9]><link rel="stylesheet" href="assets/css/ie9.css"     /><![endif]-->
    <!--[if lte IE 8]><link rel="stylesheet" href="assets/css/ie8.css"     /><![endif]-->
    <noscript><link rel="stylesheet" href="assets/css/noscript.css" />        </noscript>
</head>
<body class="is-loading">

    <!-- Wrapper -->
        <div id="wrapper">

            <!-- Main -->
                <section id="main">
                    <header>

                        <h1>*****</h1>
                        <h1><a style="color:#FFFFFF" href=''>Coming soon.</a></h1>



<div class="container">

<div class="row">

    <div class="col-xs-12 col-sm-8 col-md-6 col-sm-offset-2 col-md-offset-3">
        <form role="form" method="post" action="" autocomplete="off">
            <h2>Please Login</h2>

            <hr>

            <?php
            //check for any errors
            if(isset($error)){
                foreach($error as $error){
                    echo '<p class="bg-danger">'.$error.'</p>';
                }
            }

            if(isset($_GET['action'])){

                //check the action
                switch ($_GET['action']) {
                    case 'active':
                        echo "<h2 class='bg-success'>Your account is now active you may now log in.</h2>";
                        break;
                    case 'reset':
                        echo "<h2 class='bg-success'>Please contact us for a new card.</h2>";
                        break;
                    case 'resetAccount':
                        echo "<h2 class='bg-success'>Password changed, you may now login.</h2>";
                        break;
                }

            }


            ?>

            <div class="form-group">
                <input type="text" name="username" id="username"     class="form-control input-lg" placeholder="Enter your card number" value="    <?php if(isset($error)){ echo $_POST['username']; } ?>" tabindex="1">
            </div>

            <div class="form-group">
                <input type="hidden" name="password" id="password" class="form-control input-lg" value="*****" tabindex="3" >
            </div>

<br>

            <div class="row">
                <div class="col-xs-6 col-md-6"><input type="submit"    name="submit" value="Login" class="btn btn-primary btn-block btn-lg"     tabindex="5"></div>
            </div>
<hr>
                <div class="row">
                <div class="col-xs-9 col-sm-9 col-md-9">
                     <a style="color:#FFFFFF" href='*********'>Lost your card? Contact us.</a>
                </div>
            </div>

        </form>
    </div>
</div>



</div>




                    </header>

                </section>

            <!-- Footer -->
                <footer id="footer">
                    <ul class="copyright">
                        <li>&copy; ******</li>
                    </ul>
                </footer>

        </div>

    <!-- Scripts -->
        <!--[if lte IE 8]><script src="assets/js/respond.min.js"> </script><![endif]-->
        <script>
            if ('addEventListener' in window) {
                window.addEventListener('load', function() {  document.body.className = document.body.className.replace(/\bis-loading\b/,  ''); });
                document.body.className +=  (navigator.userAgent.match(/(MSIE|rv:11\.0)/) ? ' is-ie' : '');
            }
        </script>

</body>
</html>


原文：
更新时间：2022-02-11 10:02

最满意答案

 在这里回答我自己的问题。 此问题是由mysql2 gem版本（0.3.18）与gemfile（0.3.16）中指定的版本不匹配引起的。 

Answering my own question here. This problem was caused by a mismatch between the mysql2 gem version (0.3.18) and the version specified in the gemfile (0.3.16).

相关问答

更多

相关文章

更多
  • Becoming a data scientist
  • Solr 3.6.2索引MySQL数据库配置过程
  • Solr 3.6.2索引MySQL数据库配置过程
  • 关于mysql数据库memory表数据重复问题
  • data-config
  • （二）solr data import
  • 数据库设计 Step by Step (1)
  • solr4.4 索引mysql数据库数据(DataImport DIH QuickStart)
  • Mysql错误:Ignoring query to other database解决方法
  • NoSQL数据库大全收集整理

    • 最新问答

    更多
  • 您如何使用git diff文件，并将其应用于同一存储库的副本的本地分支？(How do you take a git diff file, and apply it to a local branch that is a copy of the same repository?)
  • 将长浮点值剪切为2个小数点并复制到字符数组(Cut Long Float Value to 2 decimal points and copy to Character Array)
  • OctoberCMS侧边栏不呈现(OctoberCMS Sidebar not rendering)
  • 页面加载后对象是否有资格进行垃圾回收？(Are objects eligible for garbage collection after the page loads?)
  • codeigniter中的语言不能按预期工作(language in codeigniter doesn' t work as expected)
  • 在计算机拍照在哪里进入
  • 使用cin.get（）从c ++中的输入流中丢弃不需要的字符(Using cin.get() to discard unwanted characters from the input stream in c++)
  • No for循环将在for循环中运行。(No for loop will run inside for loop. Testing for primes)
  • 单页应用程序：页面重新加载(Single Page Application: page reload)
  • 在循环中选择具有相似模式的列名称(Selecting Column Name With Similar Pattern in a Loop)
  • System.StackOverflow错误(System.StackOverflow error)
  • KnockoutJS未在嵌套模板上应用beforeRemove和afterAdd(KnockoutJS not applying beforeRemove and afterAdd on nested templates)
  • 散列包括方法和/或嵌套属性(Hash include methods and/or nested attributes)
  • android - 如何避免使用Samsung RFS文件系统延迟/冻结？(android - how to avoid lag/freezes with Samsung RFS filesystem?)
  • TensorFlow：基于索引列表创建新张量(TensorFlow: Create a new tensor based on list of indices)
  • 企业安全培训的各项内容
  • 错误：RPC失败;(error: RPC failed; curl transfer closed with outstanding read data remaining)
  • C＃类名中允许哪些字符？(What characters are allowed in C# class name?)
  • NumPy：将int64值存储在np.array中并使用dtype float64并将其转换回整数是否安全？(NumPy: Is it safe to store an int64 value in an np.array with dtype float64 and later convert it back to integer?)
  • 注销后如何隐藏导航portlet？(How to hide navigation portlet after logout?)
  • 将多个行和可变行移动到列(moving multiple and variable rows to columns)
  • 提交表单时忽略基础href，而不使用Javascript(ignore base href when submitting form, without using Javascript)
  • 对setOnInfoWindowClickListener的意图(Intent on setOnInfoWindowClickListener)
  • Angular $资源不会改变方法(Angular $resource doesn't change method)
  • 在Angular 5中不是一个函数(is not a function in Angular 5)
  • 如何配置Composite C1以将.m和桌面作为同一站点提供服务(How to configure Composite C1 to serve .m and desktop as the same site)
  • 不适用：悬停在悬停时：在元素之前[复制](Don't apply :hover when hovering on :before element [duplicate])
  • 常见的python rpc和cli接口(Common python rpc and cli interface)
  • Mysql DB单个字段匹配多个其他字段(Mysql DB single field matching to multiple other fields)
  • 产品页面上的Magento Up出售对齐问题(Magento Up sell alignment issue on the products page)

    • Copyright ©2023 peixunduo.com All Rights Reserved.粤ICP备14003112号

    本站部分内容来源于互联网，仅供学习和参考使用，请莫用于商业用途。如有侵犯你的版权，请联系我们(neng862121861#163.com)，本站将尽快处理。谢谢合作！