Add user via PHP

okay so time for an update.

I believe it is time to see if i should move past wordpress and look elswhere because after probably 3 dozen hours I am not much closer than when i first started.

1) I got this to work – not sure why and then then just as strangly it quit working with NO changes to the code.
2) the only way to get it to work is to load the header which forwards me to the main page of my site whether the add user function workes or not, I would prefer it did not but had resigned myself to being ok if it did load the site, as long as it added the user. As I said it did not add the user. I tried loading just the include files I need but ended up with an error in cache.php that seems to be something which normally just appears in apache logs but in my case echos to the browser and the script dies.
3)I understand that when using opensource a person is on their own to some degree but the wordpress codex says simply that I must load registrations.php and all will work. Clearly this does not work.
4) obviously this forum is not moderated or not moderated by anyone who cares about those trying to develop something new, not trying to be mean here just saying that a once over of the forums here and there by someone who knows the product would be nice.

So to my understanding, you’re using a php based login/registration that is NOT a part of WP3, but you’re trying to hook to the Create User function of WP that will add the input information to the user tables?

If that’s the case, did you try adding :

require('../wp-blog-header.php');

To the head of the php login/registration page to tie it together with wordpress? Then create a re-direct on success or error.

That’s about all I could suggest without seeing the whole code you’ve got setup to do your functions….

Yes your inderstanding is correct. I did require the blog header after the initial code and it worked – kinda – for some time it would insert the user in the table but after the line

$wpnum = wp_create_user( $row[‘username’], $row[‘password’], $row[’email’] );

it would redirect and output the wordpress site. I would like $wpnum to be inserted into snother table but I had decided i would have to make this happen elsewhere.

then I put the wp_create_user in to a seperate class and it quit working so I drug out the original files and reverted and it has not worked since. It redirects and outputs the wordpress site but does not even get to the wp_create_user. i have tested this by placing a dir statement which never gets executed and nothing gets posted to my errors log.

Here is the code I am sure there are many places to be more efficient but this should be plenty readable

require_once("/home/workforc/www/bootcamp/php/connect.php");
//include_once ('my_wp_class.php');

include_once('/home/workforc/www/bootcamp/php/apperrors.php');

ini_set('include_path',ini_get('include_path').':/home/workforc/www/campers/campblogs/wp-includes:');

require_once('home/workforc/www/campers/campblogs/wp-blog-header.php') ;

$key = $_GET['acode'];
$person =  $_GET['uid'];
$method = $_GET['m'];

$ssql = "select id,registrant from activations where token = '$key' and registrant= '$person'";
$result = mysql_query($ssql) ;

if ($result !=0){

    While( $row = mysql_fetch_array($result)){
        $stamp = gmdate("Y-m-d H:i:s", time());
        $cid = $row["id"];
        $upsql = "update activations set used=1,valid=1,usedat='$stamp',reason='$method' where id =$cid";

            if(mysql_query($upsql)){
                $reg = $row["registrant"];
                $upsql = "update accounts set verified=1,active=1 where ident='$reg'";

                $res3 = mysql_query($upsql);
                    if ($res3 == 1) {

$ident =  $person;
// get the user info from the table
$gsql = "select username,password,email from accounts where ident = '$ident'";
//echo $gsql;
$re = mysql_query($gsql) or die(mysql_error());

//echo $re;
while ($row = mysql_fetch_array($re)){

$user= $row['username'] ;
$pass=$row['password'];
$em =$row['email'];
$fname = $row['fname'];
$lname = $row['lname'];

//
// use wp functions to add a user
// first check if the user exists

$user_id = username_exists($user) or die (" a horrible death");

if ( $user_id ) {  // exists so throw error

    if (!isset($errhandler)){
            $errhandler= new apperrors() or die ("cannot create instance of app errors ") ;
         }
          $errhandler->add('User already exists.  Password inherited.',"my_wp_class->add_user");

           if (!isset($errhandler)){
            $errhandler= new apperrors();
         }
          $errhandler->add('User already exists.  Password inherited.',"my_wp_class->add_user") or die("unable to add record to errors - $user_id");

}
else{ // does not exist lets create user

     //$user_id = wp_insert_user( array ('user_pass'=>$pass,'user_login'=>$user,'user_email'=>$em)) ;

$user_id = wp_create_user($user_name, $password, $email) ;

                // check if there was an error

 if (is_wp_error($user_id)){

                 if (!isset($errhandler)){
                        $errhandler= new apperrors() or die ("unable to creat instance of app errors") ;
                     }
                     $errhandler->add($user_id->get_error_message(),"my_wp_class->add_user") or  die("unable to add record to errors - $user_id");;

            }

            else{
            // add was succsesful so update our user table
            $isql = "update accounts set wp-userid=$user_id where ident='".$ident. "'";
            $res = mysql_query($isql);
            //return $user_id;
            }
    }
}

                        }
            }

    }

}

Thanks

OK, I see a couple things that are making an issue, but first I’m going to ask a quick question.

You say you are using WP3 Multisite. When a user is signing up through your php login and you are trying to add their info to the user tables – will the user be signing up for their own sub-blog/user (multisite)?, or just as a ‘user’ off your main site (standard user/member)?

Both ways require different operations to be preformed, so if you let me know the final outcome of your registration process I can get you in the right direction to actually process it to create a user, or new multi-site (sub-blog with user).

Regards,

Thanks for the reply and by the way ignore my early rant. it was born out of frustration after hours spent debugging something that had seemingly worked. I rarely have found the need to ask for help in matters programming, choosing instead to dig through documentation. The notes in the codex are lacking in several places. Nothing in the wp_create_user for example says anything about loading anything besides registrations.php.

To answers your questions both actually. Let me explain

I will be teaching classes on blogging and other things. when a person takes one of my classes they will be required to set themselves up as a user on the community site. Others not taking the classes can sign up here as well. I keep track of accounts in a seperate table mostly because there are other peices that come into play (moodle among them) and I want one centralized account creation process With sign up (actually during the activation of the account) they will be made a user in the WP / Buddy press system. So this code is designed to be fired during the account activation process and add the user to wordpress.

later if the user also signs up for a blogging class a blog will be created for that user. otherwise they will simply be a user on the main site itself and be allowed to comment on blogs, participate in forums etc..

Thanks again and any help will be greatly appreciated.

Ok I got it working once again. still not sure why it worked. Based on what I have found the fact that it worked for a while seems a fluke.

Here is how I made it work

1) I found that the php file that wants to create a user MUST be loaded to and executed from the top level of the wordpress install, this seemed strange to me I would think the developers would not want thigs stashed into that directory. it might be possible to put it elswhere by playing with the iniset command but I could not make it work.

2) The call to require or include the file ‘wp-blog-header.php’ must be proceeded by ./ as require_once(./wp-blog-header.php’) or including this file simply redirects output to the main page of your blog. Do not place the ./ before the include call for registration.php.

3) The order of the includes seems to matter. I have a call to require connect.php which connects to my database so I can get some info needed by this user insert. If I place the include at the very top before anything else my sql query fails. when I change it to the last of the three include files all is well. Strange

So what I have done is seperated everything into two files one does the updates to my community database and the one in the blog directory concentrates on the worppress add user only. I will call the second one with the exec command and look at the returned value to see how to proceed in the calling file.

hello compdrmt
i am working on doing the same things you have done,can you please give me the code of your registration and login page.

hello
i am trying to achieve the same..i have written the code with the help of code in this post but i am getting an error..can anyone help me out figure where I am doing wrong

<?php
//the include is working fine as i tried to echo from wp-blog-header.php and its working fine
require_once('D:\wamp/www/d2mail/wp-blog-header.php') ;

//taken this variable for testing purpose
$user_name="admin" ;
$password="admin";
$password=md5($password);
$email="[email protected]";

$user_id = wp_create_user($user_name, $password, $email) ;
// check if there was an error
if (is_wp_error($user_id)){
     if (!isset($errhandler)){
         $errhandler= new apperrors() or die ("unable to creat instance of app errors") ;
                     }          $errhandler->add($user_id->get_error_message(),"my_wp_class->add_user") or  die("unable to add record to errors - $user_id");;

            }

?>