Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('max_execution_time', 3000);
- $time_start = microtime(true);
- require("connect.php");
- $conn = mysqli_connect("127.0.0.1","root","psswd");
- mysqli_select_db($conn,"db_test");
- $results = mysqli_query($conn,"SELECT * FROM test");
- $i = 0;
- while ($row = mysqli_fetch_array($results,MYSQL_ASSOC)) {
- $post = array();
- $post['post_status'] = 'publish';
- $post['ID']=$row['idNew'];
- $post['post_date']=$row['date'];
- $post['post_date_gmt']=$row['date'];
- $post['post_content']=$row['body'];
- $post['post_title']=$row['title'];
- $posts[$i] = $post;
- $i++;
- }
- mysqli_free_result($results);
- mysqli_close($conn);
- require('C:xampphtdocstestwordpresswp-load.php');
- foreach ($posts as $post) {
- wp_insert_post($post);
- }
- echo '<br>Time elapsed: ' . (microtime(true) - $time_start);
- ?>
- <?php
- $username = "root";
- $password = "psswd";
- $hostname = "127.0.0.1";
- $dbhandle = mysqli_connect($hostname, $username/*, $password*/)
- or die("Can not connect");
- echo "Conected";
- ?>
Add Comment
Please, Sign In to add comment