A Mississippi district attorney has pleaded guilty to bribery conspiracy and resigned his post