I wish to move it to its own cPanel account so it can have its own cPanel settings eg website, SQL etc. This would all be on the same virtual server (ie the same IP address) in the same WHM

It looks like I do this by creating a new cPanel account with the domain in WHM and then removing the domain from the original cPanel. I imagine I would lose any emails saved on the server etc but as long as I use the same login credentials in the new cPanel then the email would continue to work. If I create an email with the same credentials and logon, will the server know to find it in the new account and not look in the old cPanel? It's a very important email address and although downtime is ok I can't lose it.

Is it this simple or am I missing something? What is the best sequence to avoid anything getting confused?

Hopefully this is just a meeter of changing the asp

Currently looks like this:

Quote

 

<%
  Dim adoCon2 
  Dim rsdbase
  Dim strSQL2
  Set adoCon2 = Server.CreateObject("ADODB.Connection")
  adoCon2.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("data/mydb.mdb")
  Set rsdbase = Server.CreateObject("ADODB.Recordset")
  strSQL2 = "SELECT institute.institute_title, institute.institute_id FROM institute ORDER BY institute.institute_title;"

  rsdbase.Open strSQL2, adoCon2
  Do While not rsdbase.EOF

 

Anybody got any ideas on where I can a tutorial to help write the new 'link' code?

Example:

1. This is a very long text.

2. This is a very... 

Text got truncated at certail length.

No captcha

 <form action="index.php" id="contact-form" method="post">
            <ol class="forms">
                    <li>
                        <label for="name">Name:</label>
                        <?php if($nameError != '') { ?>
                            <span class="error"><?=$nameError;?></span> 
                        <?php } ?>                
                        <input type="text" name="name" id="name" value="<?php if(isset($_POST['name'])) echo $_POST['name'];?>" class="required" />
                    </li>
                    <li>
                        <label for="email">Email:</label>
                        <?php if($emailError != '') { ?>
                            <span class="error"><?=$emailError;?></span>
                        <?php } ?>                
                        <input type="text" name="email" id="email" value="<?php if(isset($_POST['email']))  echo $_POST['email'];?>" class="required" />
                    </li>
                        <li class="textarea"><label for="textarea">Message:</label>
                        <?php if($textareaError != '') { ?>
                            <span class="error"><?=$textareaError;?></span> 
                        <?php } ?>            
                        <textarea name="textarea" id="textarea" rows="10" cols="30" class="required"><?php if(isset($_POST['textarea'])) { if(function_exists('stripslashes')) { echo stripslashes($_POST['textarea']); } else { echo $_POST['textarea']; } } ?></textarea>
                    </li>
                    </ol>
                    <ol class="button-group">
                    <li>
                        <div>
                            <input type="hidden" name="submitted" id="submitted" value="true">
                            <input type="submit" value="Submit" class="submit">
                        </div>
                    </li>
                </ol>
            </form>

Recaptcha in HTML

			<form action="index2.php" id="contact-form" method="post>
			<form id="frmContact" action="" method="POST" novalidate>
			<div class="theme-default">Name:</div>
			<div class="field">
				<input type="text" id="name" name="name" placeholder="enter your name here" title="Please enter your name" class="required">
			</div>
			<div class="label">Email:</div>
			<div class="field">			
				<input type="text" id="email" name="email" placeholder="enter your email address here" title="Please enter your email address" class="required email">
			</div>
			<div class="label">Comments:</div>
			<div class="field">			
				<textarea id="comment-content" name="content" placeholder="enter your comments here"></textarea>			
			</div>
			<div class="g-recaptcha" data-sitekey="<?php echo SITE_KEY; ?>"></div>			
			<div id="mail-status"></div>			
			<button type="Submit" id="send-message" style="clear:both;">Send Message</button>
		</form>
		<div id="loader-icon" style="display:none;"><img src="img/loader.gif" /></div>
		</div>		
			</form>

I have a couple working examples. Below.

Current non-recaptcha
http://www.decal-kreations.com/index.php

Rewritten with recaptcha - Works but that loses all formatting/style
http://decal-kreations.com/index2.php

Added recaptcha to original site
http://decal-kreations.com/index3.php

If need be, I can provide the whole site in a zip as its very small.

Any help will be appreciated. TIA

I have successfully implemented this script (PHP Directory Lister) into my workplace document management system.
What I plan to do now is to add in a simple audit trail or audit log of user activity on that system:

1. What file user download (time and date).
2. Document their IP addess
3. Login date and time

Does any of you ever did this or can anybody share some idea where to go from here?

Thanks.

text - contains all of the text from all of the spans, so the same as the text area value

words - an array containing all the text split up into words

start - the index of the start of the selection within the text

end - the index of the end of the selection within the text

selection - a substring between start and end containing the selection

selectionSplit - an array containing the selection split up by spaces

beforeSelection - contains the string that appears before the start of the selection, up to but not including the selection

textToSelectionEnd - contains the string before and including the selection

Taking these variables into account, is there a way I can detect which spans contain the selection?

USING THE

FIRST LETTER

OF YOUR NAME

TELL ME SOMETHING

THAT MAKES YOU

HAPPY!

In the above example, the user has added line breaks at the end of each line. But this is how it is displaying after the button is clicked:

USING THE

FIRST LETTER

OF YOUR NAME

TELL ME

SOMETHING

THAT MAKES YOU

HAPPY!

There is a line break after "TELL ME" that has been added automatically. This is where the automatic line break would occur if the user had not added line breaks, but since the user has added line breaks this automatic line break is not wanted. How can I prevent this line break from occurring yet still allow automatic line breaks if the user doesn't add line breaks? In other words, the text might have a mix of automatic line breaks and user-added line breaks, but the position of the automatic line breaks should be re-calculated if the user has added a line break.

Edit: I forgot to mention that there is a function that splits each character of the string into spans so that each character can have its own styling, font, size and colour. Also each line is automatically wrapped in a div so that the line heights can be customized to fit the height of the font. This is where the issues begin. If I bypass these functions the text is displayed correctly. So for some reason, when the spans and divs containing each line are created, the automatic line breaks are being added in the wrong place.

Edit: I've narrowed the issue down to the function that puts all the spans into separate divs for each line. The function that creates the spans in the first place seems to be OK.

Here is the function. Side and instance can be ignored here. Only lineNumber is important.

function textLineWrap(side, instance) {

for (let lineNumber = 1; lineNumber <= 15; lineNumber++){

// The spans are labelled in numerical order. The index increases wherever there is a line break. First check if that line exists:

if (document.querySelector('.inner' + side + instance + 'line' + lineNumber )){

// This gets all the spans with the same line number and splits them up.

let $cardHolders = $('.inner' + side + instance + 'line' + lineNumber ).unwrap('.inner' + side + instance + 'lineNumber' + lineNumber );

// wrap

let $slice = $cardHolders.slice(0,$cardHolders.length);

$slice.wrapAll('<div class="inner' + side + instance + 'lineNumber' + lineNumber + '" />')

} 

}

}

Hope that makes sense!

I'm using JavaScript with PHP, HTML and CSS.

I’m creating a basic css tab menu. I need to be able to link users to this page with specific tabs open for different use cases. Our vendor says they can’t help us with this “because it’s a php page”. I feel like this should be possible, but I don’t have deep dev knowledge.

Stripped down example: https://studiotoolkit.dmplocal.com/sites/4054/tabsforhelp.html

I appreciate any suggestions. Thank you!

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ index.php [QSA,L]

Any heklp most apprciated.

I understand I will need to learn HTML/CSS/JavaScript as front-end languages. The Jon Duckett books are highly rated but some are quite old.
HTML and CSS - published 2011.
https://www.amazon.com/HTML-CSS-Design-Build-Websites/dp/1118008189
JavaScript and iQuery - published 2014.
https://www.amazon.com/JavaScript-JQuery-Interactive-Front-End-Development/dp/1118531647/ref=d_pd_sbs_sccl_2_1/144-2012933-7847318?pd_rd_w=q4xV5&content-id=amzn1.sym.3676f086-9496-4fd7-8490-77cf7f43f846&pf_rd_p=3676f086-9496-4fd7-8490-77cf7f43f846&pf_rd_r=PNC06KZDWRSW38MYXFC8&pd_rd_wg=ImnkH&pd_rd_r=4e52d104-80b4-411c-85ab-b9c8819cdcb6&pd_rd_i=1118531647&psc=1
PHP and MySQL - published 2022 (so current).
https://www.amazon.com/PHP-MySQL-Server-side-Web-Development/dp/1119149223/ref=sr_1_1?crid=12L9VSQXP8MPL&keywords=php&qid=1672851668&s=books&sprefix=php%2Cstripbooks-intl-ship%2C155&sr=1-1

Question 1 - Would the above books, and their published years, still be current for someone learning today, or should I seek more recently published books?

Question 2 - If HTML/CSS/JavaScript are grouped together then should I purchase a book that teaches them all together, such as the below book?
https://www.amazon.com/Learning-Web-Design-Beginners-JavaScript/dp/1491960205/ref=sr_1_1?keywords=learning+web+design&qid=1672851788&s=books&sprefix=learning+web%2Cstripbooks-intl-ship%2C155&sr=1-1

I'm pretty set on needing to learn HTML/CSS/JavaScript and MySQL but the back-end programming language I am not set on. I see many books on PHP and MySQL together so I assume they are well suited to each other. I also understand that PHP (although quite often spoken negatively of on forums - even for PHP 8.x??) is suited to Web Development.
Question 3 - For my aim, is PHP and MySQL (such as the 2022 Jon Duckett book) a good choice of languages or should I choose Python, Go, Ruby, etc.. as the back-end language and why?

Question 4 - I will be paying for the software (unless freeware) and hosting myself, so it would be nice to use languages that are cheap to host by a hosting service/company.

I do not wish for a career in hardcore software/web development. I dabbled with it many years ago and didn't enjoy it. The enjoyment here will be the end result. However, should I find I do enjoy it and seek a change of career, I would be prioritising the number of opportunities rather than the high salary (meaning for instance - I'd prefer 100 job opportunities at £30k rather than 10 job opportunities at £60k). I would imagine many companies need web expertise and not necessary the full blown ASP.NET/C#/Java skillset. I am getting ahead of myself here but thought I'd mention this in case it sways the languages you suggest I use.

You may suggest I follow videos instead of purchasing books, but I find a good book will bridge the languages so it makes more sense, especially for a novice.

Finally, I'm aware a popular website has potential for generating revenue through advertisements. If my website becomes a success then I would like for this too. I'm mentioning it in case it influences what languages to use.

Thank you in advance.

I want to create a web app where the user uploads a photo and downloads it after applying the desired filter to the photo. Do I have to use the database? Is it necessary to store the photo in the database?

regards,

Saeed
 

I was following a youtube video on making a s tudent management system with codeigniter3 but

i am stuck at some point

when i click on edit on  view students page..its showing me the  details of same student whatever student i choose

here is the code for view

viewStudents.php

<?php include('inc/header.php');?>
  <div class="container mt-2">
	   <h2>Students</h2>
	   <hr>
	    <?php echo anchor('admin/dashboard','BACK',['class'=>'btn btn-warning']);?>
	   
	   <div class="table-responsive">
		   <table class="table table-hover">
			  <thead>
				<tr>
				  <th scope="col">Student Name</th>
				  <th scope="col">College Name</th>
				  <th scope="col">Course</th>
				  <th scope="col">Email</th>
				  <th scope="col">Gender</th>
				  <th scope="col">Action</th>
				</tr>
			  </thead>
		<tbody>
			  <?php if(count($students)){ ?>
			   <?php foreach ($students as $student){?>
				<tr>
				  <td><?php echo $student->studentname; ?></td>
				  <td><?php echo $student->collegename; ?></td>
				  <td><?php echo $student->course; ?></td>
				  <td><?php echo $student->email; ?></td>
				  <td><?php echo $student->gender; ?></td>
				
				 
				  <td> <?php echo anchor("admin/editStudent/{$student->id}","Edit",['class'=>'btn  btn-light']);?>
				  <?php echo anchor("admin/deleteStudent/{$student->id}","Delete",['class'=>'btn  btn-danger']);?>
				  </td>
				</tr>
				<?php } ?>
			<?php	
			    } else {?>
			    <tr>
				  <td>No Record found</td>
				 </tr>
			<?php  }  ?>
			
			  </tbody>
		   </table>
	  </div>
    
  </div>
<?php include('inc/footer.php');?>

editstudent.php (view)

<?php include('inc/header.php');?>
  <div class="container mt-2">
   <?php  echo form_open('admin/createStudent',['class'=>'form-hoizontal']);?>
	   <h3 class="text-center display-4">EDIT STUDENT</h3>
	   <hr/>
	   <?php if($msg = $this->session->flashdata('message')){
	   ?>
	   <div class="row">
	     <div class="col-md-6">
		    <div class="alert alert-dismissible fade show alert-success">
			 <button type="button" class="close" data-dismiss="alert">&times;</button>
			   <?php echo $msg;?>
			</div>
		 </div>
	   </div>
	  
	  <?php } ?>
	<div class="row">
	
	   <div class="col-md-6">
	   
		   <div class="form-group">
		     <div class="row">
			    <div class="col-md-3">
		          <label for="studentname" class="mt-2">Student name:</label>
			    </div>
				 <div class="col-md-9">
			       <!-- <input type="text" class="form-control" placeholder="User name" id="username"> -->
				   <?php 
				   $data = array(
					'type'  => 'text',
					'name'  => 'studentname',
					'value' => set_value('studentname',$studentData->studentname),
					'placeholder' => 'Enter Studentname',
					'class' => 'form-control'
                       );
				   echo form_input($data); ?>
			    </div>
			  </div>
			</div>  
			
		 </div>
	   
	   <div class="col-md-6">
	      <?php echo form_error('studentname','<div class="text-danger mt-2">','</div>');?>
	   </div>
	   
	</div><!--row-->
	
	<div class="row">
	
	   <div class="col-md-6">
	   
		   <div class="form-group">
			  <div class="row mt-3">
			    <div class="col-md-3">
		           <label for="email" class="mt-2">College Name:</label>
			    </div>
				 <div class="col-md-9">
					<select class="form-control" name="college_id">
					
					    <option value="<?php echo $studentData->college_id; ?>"><?php echo $studentData->collegename; ?></option>
					<?php if(count($colleges)) { ?>
					    <?php foreach ($colleges as $college){?>
						<option value="<?php echo $college->college_id;?>"><?php echo $college->collegename;?></option>
					    <?php }
					    } ?>
					</select>
			    </div>
			  </div>
		  </div> 
			
		 </div>
	   
	   <div class="col-md-6">
	       <?php echo form_error('college_id','<div class="text-danger mt-4">','</div>');?>
	   </div>
	   
	</div><!--row-->
	
	<div class="row">
	
	   <div class="col-md-6">
	   
		      <div class="form-group">
			  <div class="row mt-3">
			    <div class="col-md-3">
		           <label for="email" class="mt-2">Email address:</label>
			    </div>
				 <div class="col-md-9">
			        <!-- <input type="email" class="form-control" placeholder="Enter email" id="email"> -->
					 <?php 
				   $data = array(
					'type'  => 'email',
					'name'  => 'email',
					'value' => set_value('email'),
					'placeholder' => 'Enter Email',
					'class' => 'form-control'
                       );
				   echo form_input($data); ?>
			     </div>
			   </div>
		    </div>  
			
		 </div>
	   
	   <div class="col-md-6">
	      <?php echo form_error('email','<div class="text-danger mt-4">','</div>');?>
	   </div>
	   
	</div><!--row-->
	
	
	<div class="row">
	
	   <div class="col-md-6">
	   
				 <div class="form-group">
				  <div class="row mt-3">
					<div class="col-md-3">
					   <label for="gender" class="mt-2">Gender:</label>
					</div>
					 <div class="col-md-9">
						<!-- <input type="email" class="form-control" placeholder="Enter email" id="email"> -->
						 <select class="form-control" name="gender">
							<option value="">Select</option>
							<option value="Male">Male</option>
							<option value="Female">Female</option>
							
	                    </select>
					</div>
				  </div>
			  </div>
			
		 </div>
	   
	   <div class="col-md-6">
	      <?php echo form_error('gender','<div class="text-danger mt-4">','</div>');?>
	   </div>
	   
	</div><!--row-->
	
	<div class="row">
	
	   <div class="col-md-6">
	   
		   <div class="form-group">
		     <div class="row">
			    <div class="col-md-3">
		          <label for="course" class="mt-2">Course:</label>
			    </div>
				 <div class="col-md-9">
			       <!-- <input type="text" class="form-control" placeholder="User name" id="username"> -->
				   <?php 
				   $data = array(
					'type'  => 'text',
					'name'  => 'course',
					'value' => set_value('course'),
					'placeholder' => 'Enter Course',
					'class' => 'form-control'
                       );
				   echo form_input($data); ?>
			    </div>
			  </div>
			</div>  
			
		 </div>
	   
	   <div class="col-md-6">
	      <?php echo form_error('course','<div class="text-danger mt-2">','</div>');?>
	   </div>
	   
	</div><!--row-->
	
	
	
	
	<div class="row">
	 <div class="col-md-6">
	        <!--  <button type="submit" class="btn btn-dark float-right">Register</button> -->
		   <div class="float-right">
		    <button type="submit" class="btn btn-dark">ADD STUDENT</button>
		     <?php //echo form_submit('Register', 'Register',"class='btn btn-dark'"); ?>
		   <?php echo anchor('welcome','GO BACK',['class'=>'btn  btn-warning']);?>
		   </div>
	   </div>
	   
	</div>
	
	
    <?php echo form_close(); ?>
  </div>
<?php include('inc/footer.php');?>

i have joined college table and students table and getting the id of student

model

queries.php

<?php

 class Queries extends CI_model
 {
	public function getRoles()
	{
		$roles = $this->db->get('tbl_roles');
		
		if($roles->num_rows() > 0){
			return $roles->result();
		}
	}
	
	public function getColleges()
	{
		$colleges = $this->db->get('tbl_college');
		
		if($colleges->num_rows() > 0){
			return $colleges->result();
		}
	}

    public function registerAdmin($data)	
	{
		return $this->db->insert('tbl_users',$data);
	}
	
	
	public function chkAdminExist()
	{
		$chkAdmin = $this->db->where(['role_id' => '1'])
		                 ->get('tbl_users');
		
		 if($chkAdmin->num_rows() > 0){
			 return $chkAdmin->num_rows();
		 }
	}
	
	public function adminExist($email,$password)
	{
		$chkAdmin = $this->db->where(['email' => $email, 'password' => $password])
		              ->get('tbl_users');
		
		if( $chkAdmin->num_rows() > 0 ){
			 return $chkAdmin->row();
		 }
	}
	
	 public function makeCollege($data)	
	{
		return $this->db->insert('tbl_college',$data);
	}
	
	
	
	 public function registerCoAdmin($data)	
	{
		 return $this->db->insert('tbl_users',$data);
	}
	
	public function viewAllColleges()
	{
		$this->db->select(['tbl_users.user_id','tbl_users.email','tbl_college.college_id','tbl_users.username','tbl_users.gender','tbl_college.collegename','tbl_college.branch','tbl_roles.rolename']);
		$this->db->from('tbl_college');
		$this->db->join('tbl_users', 'tbl_users.college_id = tbl_college.college_id');
		$this->db->join('tbl_roles', 'tbl_roles.role_id = tbl_users.role_id');
		$users = $this->db->get();
		return $users->result();
	}
	
	 public function insertStudent($data)	
	{
		 return $this->db->insert('tbl_students',$data);
	}
	
	public function getStudents($college_id)
	{
		$this->db->select(['tbl_students.id','tbl_college.collegename','tbl_students.studentname','tbl_students.email','tbl_students.gender','tbl_students.course']);
		$this->db->from('tbl_students');
		$this->db->join('tbl_college', 'tbl_college.college_id = tbl_students.college_id');
		$this->db->where(['tbl_students.college_id' => $college_id]);
		$students = $this->db->get();
		return $students->result();
	}
	//public function getStudentRecord($id)
	public function getStudentRecord($id)
	{
		/* $this->db->select(['tbl_college.college_id','tbl_college.collegename','tbl_students.id','tbl_students.email','tbl_students.gender','tbl_students.studentname','tbl_students.course']);
		$this->db->from('tbl_students');
		$this->db->join('tbl_college', 'tbl_college.college_id = tbl_students.college_id'); */
		//$this->db->where(['tbl_students.college_id' => $id]);
		// $student = $this->db->get();
		// return $student->result();
		/* $this->db->select(['tbl_college.college_id','tbl_college.collegename','tbl_students.id','tbl_students.email','tbl_students.gender','tbl_students.studentname','tbl_students.course']); */
		$this->db->select(['tbl_college.college_id','tbl_college.collegename','tbl_students.id','tbl_students.email','tbl_students.gender','tbl_students.studentname','tbl_students.course']);
		$this->db->from('tbl_students');
		$this->db->join('tbl_college', 'tbl_college.college_id = tbl_students.college_id');
		$students = $this->db->get();
		return $students->row();
		
	}
 }
 

?>

here is the code for controller

admin.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

// class Welcome extends CI_Controller {
class admin extends My_Controller {

	
	public function dashboard()
	{   
	   //echo 'dashboard';
	  /*  if(!$this->session->userdata('user_id')){
		  return  redirect('welcome/login');
	   } */
	   $this->load->model('queries');
	   $users = $this->queries->viewAllColleges();
	 /*  echo '<pre>';
	  print_r($users);
	   echo '</pre>';
	   exit(); */
	   $this->load->view('dashboard',['users'=>$users]);
		
	}
	
	public function addCollege()
	{
		//echo 'addcollege';
		$this->load->view('addCollege');
	}
	
	public function addCoadmin()
	{
		//echo 'addCoadmin';
		$this->load->model('queries');
		$roles = $this->queries->getRoles();
		$colleges = $this->queries->getColleges();
		// print_r($roles);
		// exit();
		$this->load->view('addCoadmin',['roles'=>$roles,'colleges'=>$colleges]);
		//$this->load->view('addCoadmin');
	}
	
	public function addStudent()
	{
		//echo 'addStudent';
		$this->load->model('queries');
		$colleges = $this->queries->getColleges();
		$this->load->view('addStudent',['colleges'=>$colleges]);
		//$this->load->view('addStudent');
	}
	
	public function createCollege()
	{
		//echo 'create college';
		$this->form_validation->set_rules('collegename','College Name','required');
		$this->form_validation->set_rules('branch','Branch','required');
		$this->form_validation->set_error_delimiters('<div class="text-danger">','</div>');
		
		if($this->form_validation->run()){
			echo 'validation passed';
			$data = $this->input->post();
			/* $collegename = $this->input->post('collegename');
			$branch = $this->input->post('branch');*/
			
			$this->load->model('queries');
			//$collegeExist = $this->queries->collegeExist($collgename,$branch); 
			if($this->queries->makeCollege($data)){
				$this->session->set_flashdata('message','College Created Successfully');
			}else{
				
                $this->session->set_flashdata('message','Failed to Create College ');
				
			}
			return redirect('admin/addCollege');
			
		}else{
			//echo validation_errors();
			$this->addCollege();
		}
	}
	
	public function createCoadmin()
	{
		//echo 'create coadmin';
		$this->form_validation->set_rules('username','Username','required');
		$this->form_validation->set_rules('college_id','College','required');
		$this->form_validation->set_rules('email','Email','required');
		$this->form_validation->set_rules('gender','Gender','required');
		$this->form_validation->set_rules('role_id','Role','required');
		$this->form_validation->set_rules('password','Password','required');
		$this->form_validation->set_rules('confpwd','Password Again','required|matches[password]');
		$this->form_validation->set_error_delimiters('<div class="text-danger">','</div>');
		
		if($this->form_validation->run()){
			//echo 'validation passed';
			$data = $this->input->post();
			$data['password'] =sha1($this->input->post('password'));
			$data['confpwd'] =sha1($this->input->post('confpwd'));
			/* echo '<pre>';
			print_r($data);
			echo '</pre>';
			exit(); */
			$this->load->model('queries');
			if($this->queries->registerCoAdmin($data)){
				$this->session->set_flashdata('message','Co Admin Registered Successfully');
				
			}else{
				
                $this->session->set_flashdata('message','Failed to Register Co Admin ');
				
			}
			return redirect('admin/addCoadmin');
			
		}else{
			//echo 'validation error';
			//echo validation_errors();
			$this->addCoadmin();
		}
		
	}
	
	public function createStudent()
	{
		//echo 'create coadmin';
		$this->form_validation->set_rules('studentname','Studentname','required');
		$this->form_validation->set_rules('college_id','College Name','required');
		$this->form_validation->set_rules('email','Email','required');
		$this->form_validation->set_rules('gender','Gender','required');
		$this->form_validation->set_rules('course','Course','required');
		$this->form_validation->set_error_delimiters('<div class="text-danger">','</div>');
		
		if($this->form_validation->run()){
			echo 'validation passed';
			 $data = $this->input->post();
			/*$data['password'] =sha1($this->input->post('password'));
			$data['confpwd'] =sha1($this->input->post('confpwd')); */
			/* echo '<pre>';
			print_r($data);
			echo '</pre>';
			exit(); */
			$this->load->model('queries');
			if($this->queries->insertStudent($data)){
				$this->session->set_flashdata('message','Student Added Successfully');
				
			}else{
				
                $this->session->set_flashdata('message','Failed to Add Student ');
				
			}
			return redirect('admin/addStudent');
			
		}else{
			//echo 'validation error';
			//echo validation_errors();
			$this->addStudent();
		}
		
	}
	
	public function viewStudents($college_id)
	{
		//echo 'view college';
		//echo $college_id;
		$this->load->model('queries');
		$students = $this->queries->getStudents($college_id);
		$this->load->view('viewStudents',['students'=>$students]);
	}
	
	public function editStudent($id)
	{   
	    $this->load->model('queries');
		$studentData = $this->queries->getStudentRecord($id);
		/* echo '<pre>';
			print_r($studentData);
			echo '</pre>';
			exit(); */
		$this->load->view('editStudent',['studentData'=>$studentData]);
	  // $this->load->view('editStudent');
		//echo 'editStudent';
		echo $id;
		
	}
	
	public function __construct()
	{
		parent::__construct();
		 if(!$this->session->userdata('user_id')){
		  return  redirect('welcome/login');
	   }
		
	}
	
	
	
	
}

here is the screenshot of  what i see ..when i click edit for different students

i have echoed the id of 2 students you can clearly see at the top left but their details ae showing same on the edit page

any help will be appreciated..thanks

i was missing the where clause in queries.php in getStudentRecord function

here is the updated code

queries.php

<?php

 class Queries extends CI_model
 {
	public function getRoles()
	{
		$roles = $this->db->get('tbl_roles');
		
		if($roles->num_rows() > 0){
			return $roles->result();
		}
	}
	
	public function getColleges()
	{
		$colleges = $this->db->get('tbl_college');
		
		if($colleges->num_rows() > 0){
			return $colleges->result();
		}
	}

    public function registerAdmin($data)	
	{
		return $this->db->insert('tbl_users',$data);
	}
	
	
	public function chkAdminExist()
	{
		$chkAdmin = $this->db->where(['role_id' => '1'])
		                 ->get('tbl_users');
		
		 if($chkAdmin->num_rows() > 0){
			 return $chkAdmin->num_rows();
		 }
	}
	
	public function adminExist($email,$password)
	{
		$chkAdmin = $this->db->where(['email' => $email, 'password' => $password])
		              ->get('tbl_users');
		
		if( $chkAdmin->num_rows() > 0 ){
			 return $chkAdmin->row();
		 }
	}
	
	 public function makeCollege($data)	
	{
		return $this->db->insert('tbl_college',$data);
	}
	
	
	
	 public function registerCoAdmin($data)	
	{
		 return $this->db->insert('tbl_users',$data);
	}
	
	public function viewAllColleges()
	{
		$this->db->select(['tbl_users.user_id','tbl_users.email','tbl_college.college_id','tbl_users.username','tbl_users.gender','tbl_college.collegename','tbl_college.branch','tbl_roles.rolename']);
		$this->db->from('tbl_college');
		$this->db->join('tbl_users', 'tbl_users.college_id = tbl_college.college_id');
		$this->db->join('tbl_roles', 'tbl_roles.role_id = tbl_users.role_id');
		$users = $this->db->get();
		return $users->result();
	}
	
	 public function insertStudent($data)	
	{
		 return $this->db->insert('tbl_students',$data);
	}
	
	public function getStudents($college_id)
	{
		$this->db->select(['tbl_students.id','tbl_college.collegename','tbl_students.studentname','tbl_students.email','tbl_students.gender','tbl_students.course']);
		$this->db->from('tbl_students');
		$this->db->join('tbl_college', 'tbl_college.college_id = tbl_students.college_id');
		$this->db->where(['tbl_students.college_id' => $college_id]);
		$students = $this->db->get();
		return $students->result();
	}
	//public function getStudentRecord($id)
	public function getStudentRecord($id)
	{
		/* $this->db->select(['tbl_college.college_id','tbl_college.collegename','tbl_students.id','tbl_students.email','tbl_students.gender','tbl_students.studentname','tbl_students.course']);
		$this->db->from('tbl_students');
		$this->db->join('tbl_college', 'tbl_college.college_id = tbl_students.college_id'); */
		//$this->db->where(['tbl_students.college_id' => $id]);
		// $student = $this->db->get();
		// return $student->result();
		/* $this->db->select(['tbl_college.college_id','tbl_college.collegename','tbl_students.id','tbl_students.email','tbl_students.gender','tbl_students.studentname','tbl_students.course']); */
		$this->db->select(['tbl_college.college_id','tbl_college.collegename','tbl_students.id','tbl_students.email','tbl_students.gender','tbl_students.studentname','tbl_students.course']);
		$this->db->from('tbl_students');
		$this->db->join('tbl_college', 'tbl_college.college_id = tbl_students.college_id');
		$this->db->where(['tbl_students.id' => $id]);
		$students = $this->db->get();
		return $students->row();
		
	}
 }
 

?>

E.g. if you told me I needed to learn the MEAN stack I would say "That's going to be very difficult, as I've never used MongoDB, Express, Angular or NodeJS, so I would have to learn four new things at once". But I can use MySQL and SQLite. I don't want to get demotivated by overloading myself as I know I'll give up if that happens.

Use case

I want to be able to develop web apps for fun. In particular at a minimum I want to be confident in building a basic web application that interfaces with a database. I don't mind how exactly I go about that, but again want to make it as simple as possible for myself.

My current level of experience

• I have good experience working with Python (so Django and Flask is an option)
  • Are there any real disadvantages on using Python for the backend? E.g. is Django + some DBMS the main thing I need to get a web app + database?
• Somewhat reasonable competency with GoLang
• I'm very much at a beginner level with JS (for frontend too) but want to develop here too.
  • So Node.Js is an option, but from Googling it doesn't sound like it can interface with a database out of the box - you need something else with it?
• I'm comfortable with MySQL/MariaDB, SQLite and SQL in general
  • (I can probably swap out the DBMS, but nicer if I can use one of the ones I know)
• I can use Linux and bash but would much prefer to develop in a Windows environment
• I'm comfortable with HTML and developing my CSS knowledge.
• I've used PHP and Perl in the course of my work and could pick them up again if needed.

Basically I just need some help in narrowing down the numerous options based on my level of experience. I'm grateful for any kind of input.

Also if there is a better forum or place for this type of question, please let me know.

myweb.in is currently unable to handle this request.

Thanks in advance

I was wondering what it would take to build a "number plate search" into a website...

So when the user types in their vehicle number plate the website can work out what make/model the car is and therefore offer a service suitable for that car.

Kind regards,

Mike.

Obviously Im not that experienced and have only just got round to thinking I need to sort this out.

Reason is that I have a top level where the cookie bar shows, under this are several websites for charities.
So in theory a viewer can go directly to a particular charity page, thus bypassing the main index page.

Appreciate some guidance on this.

Where can I find good resources on how to request values and output them in a response ? most of the tutorials online are covering JSON files and how they work which is great but the actual server connections and response seems to be a little vague or really in-depth. 

We have used cURL with JSON before but this API looks a little more advanced and requires POST variables that are nested so how would you access them with a POST query.

Any help would be great.

Thanks

my php knowledge is non existent

eTags
ETag: If-None-Match: "33a64df551425fcc55e4d42a148795d9f25f89d4"

Security Headers -
 
CSP: Frame-ancesetors
     Header always append X-Frame-Options SAMEORIGIN via htaccess
or
     Content-Security-Policy: frame-ancestors 'none';
     Content-Security-Policy: frame-ancestors 'self' https://www.example.org;

Security Headers – X-Content-Type: nosniff
     Header set X-Content-Type-Options nosniff via htaccess

Strict-Transport-Security HSTS 
     Strict-Transport-Security: max-age=63072000; includeSubDomains; preload 

CPS Content Security Policy
     Header set Content-Security-Policy “script-src 'none';” via htaccess (preferred)
or 
     Content-Security-Policy: script-src 'self'; img-src ‘self’; via htaccess (allows images and js) 
Or 
     <meta http-equiv="Content-Security-Policy" content="script-src 'none';"> 

Leaked PHP version
?
 

Thank you - Rowan

[25-Jun-2021 11:53:00.220 BST 1] on ,  L_TRACE Session ID = 500qbjglhu2vsvupfp5810kmi1, $_SESSION = {"54b4368deba7f09e24d876746ae2b9db3923d76b45e772c946201c80d3b23a289c629d230a0e5493e91a048b1532df4e76cb12ffce6d065e38179519f8f067e9":{"form_security_tokens":{"account_update":{"20210624":[]},
"permalink":{"20210624":{"20210624xM1EM0WHHtO5uMOLzhdWZXl_1yiPnbaw":true, "20210624M9lPBD1YzVXM8KLaM7rwJnkDg9FtzA5f":true, "202106243aJlw_Iy5aYa4CNKcL_Q3MAfWETrYTbv":true,
"20210624PYuE8WhOh11hhby1dWNF_u1T-vUGpybi":true, "20210624_SY8MAmGOE0fqTtaXqCl5fXt4YD9sZZA":true, "20210624YjJitJu-d8mxi2Or7UyPqhlOiBE73kOT":true}},
"manage_proj_update":{"20210624":{"20210624nxz7AccWkafXoNDLOotIzKA2vm9mV6zX":true, "20210624HJk2mTiaA8uWPPrShgfpCDqY86wR4o4L":true, "202106246TiBXRhlFl1vkU_FMXbwTJr5ThV5z0S5":true,
"20210624rFq5H-wyklXbjCTY53qyoof4m_-Z44ti":true}}, "manage_proj_subproj_add":{"20210624":{"20210624efF-zupy7wW5GEJlZEI2gJAKYHtFynWL":true, "20210624ULLEQoUf1J10BUGJL259P1v-2fG20tZ-":true,
"20210624ZDAuSPp9iFSQTifA0oMLkiJEcDvrUbzI":true, "20210624vzS-75bWzKN2JcFLr4GhOwxBV1iwcX2O":true}}, "manage_proj_cat_copy":{"20210624":{"20210624nxfXyJ4QUyXHgkfozskEJO6EP6YHxp2_":true,
"20210624n7ii3c8YZGfdmH5j_NFigU9tPQbG_tVf":true, "20210624QWQmc1ZS6YGe1GnP1u1gOpmAeaYGQNyY":true, "20210624fMn693XyPFPjO5fcrlpsIgWBtiAZhQSX":true}},
"manage_proj_cat_add":{"20210624":{"20210624iOBTNfEg2p56U2Gh6bPPftTh-OndKWBm":true, "20210624o_oFXFi99uPSYWCyHcgNt-UWpbZuRhlL":true, "20210624xa7mW24mM3WI_bzBi_A3ZgJrY31w0pQA":true,
"20210624Kye9oOZtNs6IgtGaOOh58bl6cIjsE-5V":true}}, "manage_proj_ver_copy":{"20210624":{"20210624yCtwU9Eh_Q8evhj0agL2ALBX-Kdq9Y15":true, "20210624G2twCmp8OWYxAc4S6h03wsgBxdSBiaX3":true,
"20210624zk6avEJ39U0Y9Wa7kjNISNEDsmpKurCg":true, "20210624qiAANl5kjuWRaJE5_1sZ7_YZLdX14gTQ":true}}, "manage_proj_ver_add":{"20210624":{"20210624-nqc6IAVlEUacFTAUuIrq6CWefCk9CX0":true,
"20210624ijNhHiwoCkXRGz4nrrlftV0-N5ftdCN3":true, "20210624def0dPDX29RFgnLtARuvTTcN1Yfg5g8w":true, "20210624c5YBW8bEMwaeWojPW2Ld4oVeILvJ2kGY":true}},
"manage_proj_custom_field_copy":{"20210624":{"20210624uAj2gYaBAjf44O9B2z3FSDZuyaaxlrPX":true, "202106244bRi43zT77-iuuYbsnkWTEgD0Pp__tH_":true, "20210624ELSRig10sRK6oZQZQ5j4uY4zW5GPFa15":true,
"20210624Jkb9NwmjtUHF_QH9jId6OZpDlmsQR_Tx":true}}, "manage_proj_custom_field_update":{"20210624":{"20210624uy1f1wWNDxjAASnF_jpfr8HF8S2gtJqZ":true, "202106249RiEAPxF8vnRddfZuE1hpRLXxWQnxgD6":true}},
"manage_proj_custom_field_remove":{"20210624":{"20210624KPTOfkBgo6i9_a3BODrkQFWuCfnU2tmr":true, "20210624tjEFBSAbgYU-YIdW5e2zG1VEpPLYKMKl":true}},
"manage_proj_user_copy":{"20210624":{"20210624oq7p3wPpURu3pV8P7A4pU597B6meZscQ":true, "20210624Hl_UI17X9v67dtx0y65EeOX6MnPAqLHp":true, "20210624IoawzezIskw_akl379LRb287c4daJI91":true,
"20210624-0Un7BjcjUux-jXAtsQER14uHWUf-4Qm":true}}, "manage_proj_user_update":{"20210624":{"20210624wOW4WAlBbmdtXTIk4eSbRe86jzEqaLxs":true, "20210624PyMu5HrLnMv4kPZCn9V6kMdfLSyrEGTE":true,
"20210624NLbcLX1lLr7BGbtsoTDrAkpfnvMkxqUd":true, "20210624Sooy5j82uBSPT3zJhpkQlizQ59r86qlX":true}}, "manage_proj_user_remove":{"20210624":{"20210624EmCq8cpyWkaDc3t8oHybALHC3GHFiB7K":true,
"2021062498fm0EQhCh3Pk2UqBOgbdFLDz1xPuPDF":true, "20210624Nx3_Q8iQbS9ir5mBIRLd135ebsAb3Bh7":true, "20210624JYOgd9KsHTbdapnZjqMJ4WqbK1XJ8Pw2":true}},
"manage_proj_user_add":{"20210624":{"20210624hdZgCQ5e7zV3klU63iptitW_UVNDEjbq":true, "20210624XJFXAa3_t8_dY-cAEZDCY9hG7U7VFdae":true, "20210624sueykQeNx3TLvNQtMUX_vhq2_1eMR8fw":true,
"20210624Vm2b_KeiuKt8c6fh-DtG0_h6hAhAuj1Q":true}}, "manage_proj_custom_field_add_existing":{"20210624":{"20210624Zfs_GoBBDr-8AW0Co_6uEdCKMqskaTkm":true,
"20210624BGzAgv0Pk8XRHCZXCkyRf44gTHGBLA_9":true}}, "bug_report":{"20210624":{"202106244ipSFZyEUEhbs3uqXmSsdF0G-2uppMm7":true}, "20210625":{"202106255ggFqd94_Pbw7xpkNXABmuOGRbaJhqf4":true}},
"bug_update_page":{"20210624":{"20210624V6io-MDvUK9ssjsrHPWQ78SFrQkXwlhc":true, "20210624f7Yi784qQbphDLqrXWtzws73au65zvbl":true, "20210624osexaQETKElgGMRKKlUM7xgQgGUVpFXp":true,
"20210624MCQiRMhDwdAiqfS8Lp-VmSJcs5Vjy4Oc":true}}, "bug_update":{"20210624":{"20210624lrqPrbU_ol0GvDMYqe83qKlvhaq19yEo":true, "20210624el-3pG7G5wgrqexRuD3q70eYJBYLq4nS":true,
"20210624SHvD_fTljhftCaERT8EaWRcNugiHkjXD":true, "20210624nN7wbCgmVsLKXnjBi1LWgvWNsc_xs4yv":true}}, "bug_monitor_add":{"20210624":{"20210624nW2fugQ_mVszNzk4uGg1iu139FebA5Ma":true,
"202106248JuJ0JjVMQdldTKbu-fYNFblU5tnFvL3":true, "20210624LWXcYzzCWBwXxKh-vimr5FitR2ay8nCo":true, "20210624714rz70Eznm_G7KOT9OnoW8IomC_9sXq":true, "20210624CuuP4oe25zOlkKdqSuHyzE-aO81I6o2V":true,
"20210624sWqPsELaRzM3Hby9AZ8TX7BZlEcOE2qn":true, "20210624b-MN0VDt3Oi3ncMW5NYbfga_xP7OuFMI":true, "20210624V1NeI5FmUhrRpE7E8WhYZhdRr0ECbHrq":true}},
"bug_stick":{"20210624":{"20210624Dt3vMbXHZ4P5s70aRfFQv4LILeCKZXiw":true, "20210624jROSXzGJvkJaV6RNJAFiVbS3QZu0Q2Yf":true, "202106240PBIELMS28-DJ3nH9bolbKdOsEd4PI60":true,
"20210624jDRjAPEWXJsYBk7naHodkUff4UsNOuC0":true}}, "bug_report_page":{"20210624":{"20210624tb3bzzh0B90ukvVAXi3pmTNg-uTZQCvv":true, "202106246RGK405w--iYtnkJ-bfXQSBPaXrgU1sT":true,
"20210624pvMrPbu5INJjmbyYOdoqpBAaJkVwQ4gB":true, "20210624OieySVVvkZytQNNt30ivajxNclMDG13i":true}}, "bug_change_status_page":{"20210624":{"20210624rNJ-tZn4goMIqCMgAp333hAD-tM0o68Z":true,
"20210624ijZ_0iYWUuiSRZRpLYWja0hJ3RZK0OUu":true, "20210624AYyZiAa3xA17ShMBuTeyH_dR--IhBFRQ":true, "202106245tNsaVnOc9QrxsvFk3NOtIX00xu-PV-4":true}},
"bug_actiongroup_page":{"20210624":{"20210624PyA-5OyEh9VODubuE3p_uvluA5sTRj0s":true, "20210624vTDVOpfTxCL9I5QMkPI4KQeELAdKYLQZ":true, "20210624c0ndZml_Hqtm99g4TuZjVH5SqqGbMCjd":true,
"202106243Wt_k4Wk_ZJUYS8VA_Be3btlobFfktke":true, "20210624wNXldn4Rck7QE-TMmuLzoZJuMkJx6NcF":true, "20210624-py2FfN9-4I5QybdVUYSkTJLk7QyqP9-":true, "20210624_ROPaWmy6L_re-zjix-1wxAUphG-kMmO":true,
"20210624i9pdsVeviWKGxHSSsNNeM1qKre9udoXu":true}}, "tag_attach":{"20210624":{"20210624tI2mfeoH_XeYVcMB32_QVBuil6gljbU3":true, "20210624EHQKRf1j-PcCARkrNCuOJpvloMMPoRK0":true,
"20210624GJP-wgrjgOuzWdy9JbWdobFm6Ee0k6e7":true, "20210624GZ4wj5IlEwxczV1OXSkMKW6QtgPYu56M":true}}, "bug_relationship_add":{"20210624":{"202106245rEM9z8nWh-Q1xqh_PCFXkh8SX5PRH0l":true,
"20210624Fw5awNOs4F6chraP5eyXy95eWfWa2PLp":true, "20210624Vq6E57QFC0WNGaZbueVHc12s9Uz_tLbV":true, "20210624h92EOfUaAROkEkGKNaTr5b0uI6yiVKVZ":true}},
"bug_file_delete":{"20210624":{"20210624-FGHy5pbXqb11QhSlD-EVHUuH1itzTHq":true}}, "file_show_inline":{"20210624":{"20210624os6ny6dHn8D5YyI0g4wjbvdL_K7uM8HD":true}},
"bugnote_add":{"20210624":{"20210624224tdorca79kVrjJV994cRGisjiG5Eai":true, "20210624nBY25_0lRLJkqI3m9FskiwcyLTJk0vCL":true}},
"bugnote_delete":{"20210624":{"20210624VdaP5twbolVq7m0uZQewsDdSbOUF5vzw":true, "20210624AKZInAJZXScYpoeJzrbpTJ-EX3EZew65":true}},
"bugnote_set_view_state":{"20210624":{"20210624dlTy4NyaWMGwEQiLa5Vn612Ht12UNv5l":true, "20210624mBoeiw49ik4xuSFA7dF8z0PPAmuYHAaw":true}}}, "secure_session":false},
"session_id":"500qbjglhu2vsvupfp5810kmi1", "lasttouch":1624618379, "breadcrumbs":[{"shortname":"Login", "filename":"index.php"}, {"shortname":"EditMember", "filename":"edit_member.php"}],
"request_index":53, "test_mode":0, "current_role":"1", "username_entered":"test.member", "login_member":null, "login_name":"Test Member", "auth_level":3, "Redirected":true,
"redirect_time":1624618379.964, "edit_member_mode":"new_password", "edit_memberid":"136", "formdata":{"MemberId":"136", "FirstName":"Test", "LastName":"Member", "ChoirNum":"0",
"Username":"test.member", "PasswordHash":"$2y$10$kicyiCZTVCjUUy8G\/6fJ2.BokRlOUVwCK6NJP60lE2xKGkKeOJhtG", "Email":"test.member@sylvesterbradley.org", "Address1":"", "Address2":"", "Town":"",
"County":"", "Postcode":"", "Phone":"", "Mobile":"", "Student":"0", "DivisionAbbrev":"B2", "SectionId":"1", "Birthday":943920000, "Joined":943920000, "DefaultRole":"1", "MustChangePW":"0",
"LastChangedPW":1549535706, "PasswordStatus":"2", "CPKey":"8UhlbhWnJ74q3twnREPqyXLFlquqgAAo", "CPExpires":1624625572, "LastTouch":1549536507, "SendReminders":"0", "Status":"1", "ChangedBy":"4",
"ChangedOn":1493461887, "Enabled":"1", "Welcome":0, "OldPassword":"", "NewPassword":"", "ConfirmPassword":""}, "authenticated":"key", "pageerror":"There were errors in the data you entered. Please
correct them and try again.", "fielderrors":{"LastName":"You must provide a last name.", "Email":"You must supply a valid e-mail address.", "NewPassword":"If you wish to change your password,  please
enter your desired new password (twice). If you do <u>not<\/u> wish to change your password,  please leave both boxes empty."}} at line 805 in file: /home/sylvest/include/functions.php
    Called from my_session_start() at line 190 in file /home/sylvest/include/basic_init.php
    Called from require(/home/sylvest/include/basic_init.php) at line 135 in file /home/sylvest/public_html/swchoir/edit_member.php
 

The first variable with the cryptic name makes no sense to me. I am 99.9% certain that I am not creating this session variable. So what is creating it? Where is it coming from? Does it matter?

Thank you - Rowan

my hosting provider is not providing bulk mail service, so I want to setup own smtp server for bulk emailing.

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.html$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.html [L]
  
RewriteCond %{HTTP_HOST} ^address.co.uk [NC]
RewriteRule ^(.*)$ http://www.address.co.uk/$1 [L,R=301,NC]

</IfModule>

The non 'www' url forwards correctly when on the homepage, but if someone directly accesses a sub page without adding 'www' it simply just stalls on loading. Is this easy to overcome? At worst I will the second part for the time being, but would be great to know if there is a simple solution to this. 

Thanks

So, I've a bit of a pickle and I'm not 100% sure as to why. I'm using a custom 404 served via htaccess. Here's the simple htaccess setup.

Options +FollowSymlinks
RewriteEngine On
RewriteBase /
ErrorDocument 404 /404.php

The problem is when requesting a non-existent .php file in the public root I get 'File not found.' and not the custom 404. Here's some examples;

domain.com/fish - Custom 404 shows
domain.com/fish/ - Custom 404 shows
domain.com/fish.html - Custom 404 shows
domain.com/fish.jpg - Custom 404 shows
domain.com/fish.php - I get File Not Found.
domain.com/j/fish.php - Custom 404 shows

Any ideas as to why a non-existent /fish.php would not find the 404 file, yet does at a lower level like /a/fish.php?

Cheers. 

Thanks

Still new to node

I was follwing a tutorial on how touse Joi9 validation with node express

but i am getting this  error

here is my code

app.js

const express = require('express');
const path = require('path');
const Joi = require('joi');
const bodyParser = require('body-parser');
const app = express();
//const hostname = '127.0.0.1';
app.use('/public',express.static(path.join(__dirname,'static')));
app.use(bodyParser.urlencoded({extended:false}));
app.use(bodyParser.json());
//const port = 3000;
app.get('/',(req,res)=>{
	res.sendFile(path.join(__dirname,'static','index.html'));
});

app.post('/',(req,res)=>{
	console.log(req.body);
	const schema = Joi.object().keys({
		email: Joi.string().trim().email().required(),
		password: Joi.string().min(5).max(10).required()
	});
	Joi.validate(req.body,schema,(err,result)=>{
		if(err){
			console.log(err);
			res.send('an error occured');
		}
		console.log(result);
		res.send('succesfully posted data');
	})
	
});


app.listen(3000);

and index.html inside static folder

<!DOCTYPE html>
<html>
  <head>
    <meta charset="UTF-8" />
    <title>Html</title>
	<style>
	/* Forms */

[type=text],
[type=email],
[type=url],
[type=password],
select,
textarea {
  display: block;
  padding: .5rem;
  background: transparent;
  vertical-align: middle;
  width: 100%;
  max-width: 100%;
  border: 1px solid #cdcdcd;
  border-radius: 4px;
  font-size: .95rem;
}

[type=text]:focus,
[type=email]:focus,
[type=url]:focus,
[type=password]:focus,
select:focus,
textarea:focus {
  outline: none;
  border: 1px solid #1E6BD6;
} 

select {
  -webkit-appearance: none;
  -moz-appearance: none;
  background: url(data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABIAAAAJCAYAAAA/33wPAAAAvklEQVQoFY2QMQqEMBBFv7ERa/EMXkGw11K8QbDXzuN4BHv7QO6ifUgj7v4UAdlVM8Uwf+b9YZJISnlqrfEUZVlinucnBGKaJgghbiHOyLyFKIoCbdvecpyReYvo/Ma2bajrGtbaC58kCdZ1RZ7nl/4/4d5EsO/7nzl7IUtodBexMMagaRrs+06JLMvcNWmaOv2W/C/TMAyD58dxROgSmvxFFMdxoOs6lliWBXEcuzokXRbRoJRyvqqqQvye+QDMDz1D6yuj9wAAAABJRU5ErkJggg==) 100% no-repeat;
  line-height: 1
}

label {
  font-weight: 600;
  font-size: .9rem;
  display: block;
  margin: .5rem 0;
}

/* Other */

* { box-sizing: border-box; }

html {
  -webkit-font-smoothing: antialiased;
  padding: 1rem;
}

.container {
  max-width: 600px;
  margin: 0 auto;
  padding: 0 1rem;
}


/* Button */

[type=submit] {
  display: inline-block;
  vertical-align: middle;
  white-space: nowrap;
  cursor: pointer;
  margin: .25rem 0;
  padding: .5rem 1rem;
  border: 1px solid #1E6BD6;
  border-radius: 18px;
  background: #1E6BD6;
  color: white;
  font-weight: 600;
  text-decoration: none;
  font-family: sans-serif;
  font-size: .95rem;
  margin-top:1rem;
}
	</style>

  </head>
  <body>

<div class="container">
  <form action="/" method="POST" id="form">
   
    <label for="email">Email</label>
    <input type="email" id="email"  placeholder="Email Address">
	 <label for="password">Password</label>
    <input type="password" id="password"  placeholder="Password">
    <input type="submit" value="Submit">
  </form>
</div>
<script
  src="https://code.jquery.com/jquery-3.6.0.min.js"
  integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4="
  crossorigin="anonymous"></script>
  <script>

  </script>
  </body>
</html>

i'm evaluating technologies to use for a large database driven project with a lot of coding-heavy custom functionality (extensive community functions, event-calendars, APIs, etc etc ). later on there will also be mobile apps.

most data will be filled up automatically, fetched from other websites and web-services, and then maintained. many tables will be hundreds of thousands of records in size. there will be some manual creating of articles or editing of fetched data, but editing is not a main concern. 

scalability and speed is important, we do expect quite some traffic on it.

i guess what i'm looking for is a CMS that can work with a relational database, with all models in separate tables, where i can optimize keys, triggers etc. and relatively straight forward to develop functions and templates. 

i like the backend of Wordpress, but of course it would have to be done in a way that it accesses the flat tables for each model, working with Wordpress meta-fields is not going to cut it due to performance. probably wordpress is out of question for this.  

server language should be PHP, or alternatively ASP.NET

you got any input what CMS or concept to use for such project? any opinion on thunder CMS?

thanks!

Okay let me explain I'm going back over a Wordpress course I did on Udemy where the now AWOL instructor implemented a automated workflow for us to use whereby anytime we typed PHP or JS the webpage would reload automatically, and it's working, actually it's working too fast for me. This time round for some reason it's driving me bonkers cos when I'm writing my code the page is recompiled before I can even finish typing a complete line of code! A parse error is then generated and I have to manually refresh the page when I'm done to clear the error as it doesn't get automatically refreshed due to the error, which sort of defeats the purpose of the automation.

The automated workflow was basically implemented by doing the following:

• I've installed 2 files package.json & webpack.config.js into my theme folder
• Then I ran 

  npm run devFast

• Then by changing functions.php we got the WP theme to use the Node generated assets. Node serves up all of the JavaScript and CSS within one single bundled file, bundled.js

I've no idea where to start in asking for help with this so thought I'd start here in this forum. As I say any help with this would be appreciated even if you just signpost me. I'm also using Local by Flywheel to host the site locally and this has been a great tool.

webpack.config.js

I was trying to show a message using node server but

when i typed localhost:3000 in my browser  it shows nothing

here is my code

const http = require('http');
   const server = http.createServer((req,res)=>{
	   res.write('hello world from node js');
	   res.end();
   });
   server.listen('3000');

I have been following an article written by my web hosting provider on how to create a basic PHP to email script (Link Here) which is working fine when I copy and paste the code, but when I try to add my own elements (a single checkbox for example), it seems to break the code and gives me 500 errors. I managed to add a single HTML Text Input which emails me the results as required (see $messagesubject in the PHP below), but when I add a checkbox ($sub), I cannot figure out what code I need to use :/ 

The basic concept of the form is Name, Email, Subject and Message. Then I want to add a small checkbox which if enabled, will let me know via email that the user wants to sign-up for newsletters, offers etc....Initially, I added the  "checked" value to the HTML form to set it be default - which works fine - but when the checkbox is manually de-selected, it throws a 500 error at me when the form is submitted? 

<input type="checkbox" name="sub" checked>

This is the HTML I used (above). And the PHP (below)

<?php
$email_to = "name@domain.co.uk";
$name = $_POST["name"];
$email_from = "contact@domain.co.uk";
$reply_to = $_POST["email"];
$messagesubject = $_POST["messagesubject"];
$message = $_POST["message"];
$sub = $_POST["sub"];
$email_subject = "Message received from Your Site";
$headers = "From: " . $email_from . "\n";
$headers .= "Reply-To: " . $reply_to . "\n";

$message = "Subbed: ". $sub . "\r\nSubject: ". $messagesubject . "\r\nName: ". $name . "\r\nMessage: " . $message;

ini_set("sendmail_from", $email_from);
$sent = mail($email_to, $email_subject, $message, $headers, "-f" .$email_from);
if ($sent)
{
header("Location: http://www.yourdomain.co.uk/thankyou.html");
} else {
echo "There has been an error sending your comments. Please try later.";
}
?>

When I added the $sub, it works fine when set as default. The email outputs the "Subbed" as "On". But if the user de-selects it, the 500 error appears. Any help with this would be massively appreciated and sorry if it's such a basic problem I am overlooking....like I said I am fairly new to web development etc/...........Thanks, Vi =)

I am trying to count the number of items from a certain group of departments in that list, and assign that number to a variable. eg:

item 1 has qty of 1 and is from category_id 2
item 2 has qty of 1 and is from category_id 5
item 3 has qty of 1 and is from category_id 3

How would I get that to work from the following?

$group1 = function () {
    return array_sum(
        return array_map(
            function ($item) {
                return count(array_intersect($item->product->category_id, [2, 3]))
                ? $item->qty 
                : 0;
            },
        )
    ),
};

Thanks

One of my clients wants to build a file storage system (similar to Google Drive) for a mobile APP. He asked me to build an API for this (using Laravel). But I don't know where to start. I can build the authentication just fine but I don't know how to do the rest. How should I make an API for creating a Folder, Manage access, Share Links for a folder, copy, move, etc...

Please, someone, help me. I don't know which endpoints to use for this. I am posting a link to a doc file for this project.

https://drive.google.com/file/d/1w3F3nK3cGCexIVyW7FsERJ6AcqtLJFk1/view

Thanks again,
Fahim

The website was held with a company, over a decade ago, recently they went out of business (But were bought out by Plusnet - and supplied free hosting - result!) But the hosting was basic.

I set up a new wordpress site under new hosting, with Bluehost, using a temporary name until we were ready to go live. Yesterday I was asked to go live with the new design.

So I did two things at once - Transfered ownership of the domain name to a new owner, and at the new owner's side initiated the incoming transfer and also set new nameservers so once it arrived it would also be pointing to the new hosting.

For some reason the new site isn't loading on anything other than my mobile!? Two windows machines of mine, trying three browsers each, load the old site still. Yet my phone loaded the new one. And I asked family members to check on their computers and they have the new one too. But both myself and my client are only loading the old site.

EDIT - Now my phone is loading the old site again!

I spent an hour or so on chat with the hosts yesterday but they say they can see the new site fine too.

I can't access the site anywhere right now, if anyone sees a mistake I can't access wp-admin to change it! I did try a browser compatibility site and logged in to make a quick change on one page, but they are quite short sessions so I can't continue like that - and the client is asking me why they can't see their new website yet!

Any ideas?

The website is www.maisonbleue.co.uk - If you see a grey central column and a guy taking a wine bottle from the shelf then that's the old website - if you see a white design with a waitress laying a table then that's the new one. Please can anyone advise?

Are these just things that happen in the first 24 hours of a transfer? Can I advise her that it will all come to life when it's ready??

Thanks!

I have a website on Bluehost that has free 2 email address attached to a domain.

I am migrating all of my websites over to another host.

The Emails have only ever been accessed via Bluehosts online mail portal

Does anyone know of an easy way of migrating the email accounts without losing existing emails?

Regards,

Dave Rudge

Translation: Hello 
When I visit my website with Google Chrome and sometimes I get this "ERR_CONNECTION_REFUSED" error message. I thought it was because of some software or firewall blocking my site , so I did a full scan using Malwarebytes. The application did not find anything! I also thought it was because of my browser, I am still using chrome but the error occurs even with Firefox. I'm a bit lost. Any help would be greatly appreciated.

so it's currently here ns.kpk.fi
ns1.kosila.fi
and trying to change the nameservers to use with new hosting with Duda 
please see attached screen shots with info of nameservers and what duda require. 

i just need some instructions for a dummy so i know what to do - do i remove old nameservers and add new ones or.. ?

<?php
// REQUIRED
// Set your default time zone (listed here: http://php.net/manual/en/timezones.php)
date_default_timezone_set('Europe/London');
// Include the store hours class
require DIR . '/StoreHours.class.php';

// REQUIRED
// Define daily open hours
// Must be in 24-hour format, separated by dash
// If closed for the day, leave blank (ex. sunday)
// If open multiple times in one day, enter time ranges separated by a comma
$hours = array(
'mon' => array('09:30 - 18:30'),
'tue' => array('09:30 - 18:30'),
'wed' => array('09:30 - 18:30'),
'thu' => array('09:30 - 18:30'),
'fri' => array('09:30 - 18:30'),
'sat' => array('10:00 - 18:00'),
'sun' => array('10:00 - 18:00')
);

// OPTIONAL
// Add exceptions (great for holidays etc.)
// MUST be in a format month/day[/year] or [year-]month-day
// Do not include the year if the exception repeats annually
$exceptions = array(
'7/04/20' => array('10:00-17:00'),
'10/18/20' => array('10:00-17:00')
);

$config = array(
'open' => "

Yes, we're open! Today's hours are {%hours%}.
",
'closed' => "
Sorry, we're closed. Today's hours are {%hours%}.
",
'separator' => ' - ',
'join' => ' and ',
'format' => 'g:ia',
'overview_weekdays' => array('Mon ', ' Tue ', ' Wed ', ' Thu ', ' Fri: ', ' Sat ', ' Sun: '),
'hours' => "{%open%} {%separator%} {%closed%}"
);
?>

<?php
$store_hours = new StoreHours($hours, $exceptions, $config);
echo '<div>';
foreach ($store_hours->hours_this_week(true) as $days => $hours) {
echo '';
echo '' . $days . '';
echo '' . $hours . '';
echo '';
}
echo '</div>';
?>

i am trying to insert data using mysqli prepeared statement

this code works without using prepared

<!DOCTYPE html>
<html lang = "en">
 <head>
  <title>Forms</title>
	  <meta charset = "utf-8">
	  <meta name = "viewport" content = "width=device-width , initial-scale =1">
	  <link rel="stylesheet" href="css/bootstrap.min.css">
	  <script src = "js/jquery-3.4.1.min.js"></script>
	  <script src = "js/bootstrap.min.js"></script>
	  
 <style>
   
 </style>
 </head>
<body>

 <?php
   require("db.php");
   //if form submitted ,insert values into the database
   if(isset($_POST["username"])){
	 //remove backslashes
	$username =stripslashes($_POST["username"]);
	//escapes speacial character in string
    $username = mysqli_real_escape_string($conn,$username);
	
	 //remove backslashes
	$email =stripslashes($_POST["email"]);
	//escapes speacial character in string
    $email = mysqli_real_escape_string($conn,$email);
	
	//remove backslashes
    $password =	stripslashes($_POST["password"]);
	//escapes speacial character in string
    $password = mysqli_real_escape_string($conn,$password);
	$password = md5($password);
	$trn_date =date("Y-m-d H:i:s");
	$sql = "INSERT into `users_prepared` (username,password,email,trn_date) VALUES('$username' , '$password','$email','$trn_date')";
	$result = mysqli_query($conn,$sql);
	if($result){ ?>
	  <div class="container">
	  
	   <div class="alert alert-success">
         <strong>Success!</strong> You have regsitered succesfully.
         </div>
	<a href="login.php" class="btn btn-success" role="button">Click here to login</a>
		 
	   <form action="register.php" method ="post">
		 <h1>Registration</h1>
		 <div class="form-group">
		   <label for ="usr">Name:</label>
		   <input type="text" name="username" class="form-control" id="usr" placeholder="username" required>
		 </div><!--form-group-->
		  
		<div class="form-group">
			<label for ="email">Email address</label>
			<input type="email" name="email" class="form-control" id="email" placeholder="email" required>
		</div><!--form-group-->
		
		<div class="form-group">
			<label for ="pwd">Password</label>
			<input type="password" name="password" class="form-control" id="pwd" placeholder="password" required>
		</div><!--form-group-->
		
		
		<button type="submit" class="btn btn-success">Submit</button>
	   </form>
    
 </div><!--container-->
	 
<?php	}
   }else{
 ?>
  <div class="container">
   <form action="register.php" method ="post">
     <h1>Registration</h1>
     <div class="form-group">
	   <label for ="usr">Name:</label>
	   <input type="text" name="username" class="form-control" id="usr" placeholder="username" required>
	 </div><!--form-group-->
	  
    <div class="form-group">
		<label for ="email">Email address</label>
		<input type="email" name="email" class="form-control" id="email" placeholder="email" required>
	</div><!--form-group-->
	
	<div class="form-group">
		<label for ="pwd">Password</label>
		<input type="password" name="password" class="form-control" id="pwd" placeholder="password" required>
	</div><!--form-group-->
	
	
	<button type="submit" class="btn btn-success">Submit</button>
   </form>
    
	
   
   
  </div><!--container-->
   
   <?php } ?>
   
</body>

</html>

but this code using perepared statement not working all i see is blank page on submit

<!DOCTYPE html>
<html lang = "en">
 <head>
  <title>Forms</title>
	  <meta charset = "utf-8">
	  <meta name = "viewport" content = "width=device-width , initial-scale =1">
	  <link rel="stylesheet" href="css/bootstrap.min.css">
	  <script src = "js/jquery-3.4.1.min.js"></script>
	  <script src = "js/bootstrap.min.js"></script>
	  
 <style>
   
 </style>
 </head>
<body>
 <?php
   require("db.php");
   //if form submitted ,insert values into the database
   if(isset($_POST["username"])){
	 //remove backslashes
	$username =stripslashes($_POST["username"]);
	//escapes speacial character in string
    $username = mysqli_real_escape_string($conn,$username);
	
	 //remove backslashes
	$email =stripslashes($_POST["email"]);
	//escapes speacial character in string
    $email = mysqli_real_escape_string($conn,$email);
	
	//remove backslashes
    $password =	stripslashes($_POST["password"]);
	//escapes speacial character in string
    $password = mysqli_real_escape_string($conn,$password);
	$password = md5($password);
	//$trn_date =date("Y-m-d H:i:s");
	$sql = "INSERT into `users_prepared` (username,password,email) VALUES(?,?,?)";
	 //create prepared statement
	$stmt = mysqli_stmt_init($conn);
	//bind parameters to the placeholders
	 mysqli_stmt_bind_param($stmt,"sss",$data);
	 //run parameters inside database
	 mysqli_stmt_execute($stmt);
	 $result = mysqli_stmt_get_result($stmt);
	//$result = mysqli_query($conn,$sql);
	
	if($result){ ?>
	  <div class="container">
	  
	   <div class="alert alert-success">
         <strong>Success!</strong> You have regsitered succesfully.
         </div>
	<a href="login.php" class="btn btn-success" role="button">Click here to login</a>
		 
	   <form action="register2.php" method ="post">
		 <h1>Registration 2</h1>
		 <div class="form-group">
		   <label for ="usr">Name:</label>
		   <input type="text" name="username" class="form-control" id="usr" placeholder="username" required>
		 </div><!--form-group-->
		  
		<div class="form-group">
			<label for ="email">Email address</label>
			<input type="email" name="email" class="form-control" id="email" placeholder="email" required>
		</div><!--form-group-->
		
		<div class="form-group">
			<label for ="pwd">Password</label>
			<input type="password" name="password" class="form-control" id="pwd" placeholder="password" required>
		</div><!--form-group-->
		
		
		<button type="submit" class="btn btn-success">Submit</button>
	   </form>
    
 </div><!--container-->
	 
<?php	}
   }else{
 ?>
  <div class="container">
   <form action="register2.php" method ="post">
     <h1>Registration 2</h1>
     <div class="form-group">
	   <label for ="usr">Name:</label>
	   <input type="text" name="username" class="form-control" id="usr" placeholder="username" required>
	 </div><!--form-group-->
	  
    <div class="form-group">
		<label for ="email">Email address</label>
		<input type="email" name="email" class="form-control" id="email" placeholder="email" required>
	</div><!--form-group-->
	
	<div class="form-group">
		<label for ="pwd">Password</label>
		<input type="password" name="password" class="form-control" id="pwd" placeholder="password" required>
	</div><!--form-group-->
	
	
	<button type="submit" class="btn btn-success">Submit</button>
   </form>
    
	
   
   
  </div><!--container-->
   
   <?php } ?>
   
</body>

</html>

the view results page using prepared works

<!DOCTYPE html>
<html lang = "en">
 <head>
  <title>Forms</title>
	  <meta charset = "utf-8">
	  <meta name = "viewport" content = "width=device-width , initial-scale =1">
	  <link rel="stylesheet" href="css/bootstrap.min.css">
	  <script src = "js/jquery-3.4.1.min.js"></script>
	  <script src = "js/bootstrap.min.js"></script>
	  
 <style>
   
 </style>
 </head>
<body>


  
  <div class="container">
  <?php
    require("db.php");
		
		$data ="John";
		 //create template
		 $sql = "SELECT * FROM $tbl_name WHERE username =?;";
		 //create prepared statement
		 $stmt = mysqli_stmt_init($conn);
		 //prepare the prepared statement
		 if(!mysqli_stmt_prepare($stmt,$sql)){
			 echo "Sql statement failed";
		 }else{
			 //bind parameters to the placeholders
			 mysqli_stmt_bind_param($stmt,"s",$data);
			 //run parameters inside database
			 mysqli_stmt_execute($stmt);
			 $result = mysqli_stmt_get_result($stmt);
		
		 
		 // $result = mysqli_query($conn,$sql);
		 // $resultCheck = mysqli_num_rows($result);
		 // if($resultCheck>0){
			 //ouput data for each row
			 while($row=mysqli_fetch_assoc($result)){
				 ?>
				 <table class="table table-striped">
    <thead>
      <tr>
       <th>Name</th>
       <th>Email</th>
      </tr>
    </thead>
    <tbody>
      <tr>
       
        <td><?php echo $row["username"]?></td>
        <td><?php echo $row["email"]?></td>
      </tr>
     
    </tbody>
  </table>
				 
		<?php	 
			  }//while end
		     }//else end
		 // }
		

	?>
   
    
	
   
   
  </div><!--container-->
   
 
   
</body>

</html>

any help will be appreciated,thanks

Remove From Array By Value

Simply removes a given element from an array by its value

<?php

function removeFromArrayByValue($array,$valToRemove)
{
 if(!is_array($array))
{
return;
}

$newArray = array_diff($array,array($valToRemove));

return $newArray;

}

Usage

<?php

$arrayMinusVal = removeFromArrayByValue(array("red","green","blue","orange"),"blue");

//Will output red,green,orange... blue is removed
foreach($arrayMinusVal as $newVals):
echo $newVals."<br />";
endforeach;

I've designed my website in the past using coding, in Dreamweaver, though I don't know what if doing a lot of the time, Google has gotten me through! 

I added a blog to my photography business website, using WordPress, in the folder /blog/, and bought a template in both WordPress and html, so the user couldn't really tell which of the sites they were in. 

The time has come I thought, to move the whole website to WordPress, doing all the edits in the WordPress dashboard makes a lot more sense than some in Dreamweaver, plus all plugins etc would be better if they were the same site-wide. 

So I've remade my homepage, in the /blog/ folder. And in fact made the while site in there. 

I'm a bit scared if I'm honest about simply moving my whole site back from /blog/ to the root folder, as I'm sure tons of in-page links will stop working. Or perhaps the whole DB will disconnect. I've really got no clue. Anyone have any tips? Any plugin, apps or articles that will help me finding and updating loads of links? 

I tried adding a forward to my htaccess file moving visitors to the root into /blog/folder, but what I did created a redirect loop that I couldn't fix even when I removed the line! My hosts had to revert me back to an earlier backup of the whole site! 

Can anyone let me know the correct syntax fory htaccess file, to forward visitors to my homepage, off to the new one? That will tide me over until I'm brave enough to move the whole site over! 

Thanks 

On other question.. I've only discovered 1 forum software written in NodeJS. Has anyone else found any forums for Node, or is php the defacto?

Thanks in advance.

I was following atutorial on how to make a php mysql forum

i got the signup working in this thread

but stuckwith sigin now

everytime i click submit

i see this error " Something went wrong while registering. Please try again later."

here is my code

<?php
ini_set('display_errors','1');
error_reporting(E_ALL);
//create_cat.php
include 'connect.php';
include 'header.php';

echo '<div class="col-md-12">';
echo '<h3>Sign in</h3>';
/*first check if the user is already signed in */
 if(isset($_SESSION['signed_in']) && $_SESSION['signed_in'] == true)
 {
	 echo '<div class="alert alert-info">
	  You are already signed in,you can <a href="signout.php">sign out</a> if you want
	 </div>';
 }
 else
 {
	 if($_SERVER['REQUEST_METHOD'] != 'POST')
	 {
		 /*the form hasn't been posted yet,display it*/
		 echo '<form action="signin.php" method ="post">
		
		 <div class="form-group">
		   <label for ="usr">Username:</label>
		   <input type="text" name="user_name" class="form-control" id="usr" placeholder="username">
		 </div><!--form-group-->
		  
		<div class="form-group">
			<label for ="pwd">Password:</label>
			<input type="password" name="user_pass" class="form-control" id="pwd" placeholder="password">
		</div><!--form-group-->
		
		
		<button type="submit" class="btn btn-success">Sign In</button>
	   </form>';
		 
	 }
	 else
	 {
		 /*
		 so,the form has been posted ..we will process the data in three steps
		 1.Check the data
		 2.Let the user refil the wrong fields(if necessary)
		 3.Verify if the data is correct and return the correct response
		 */
		$errors = array();/* declare the array for later use */
		if(!isset($_POST['user_name']))
		{
			 $errors[] =  'The username field must not be empty';
		}
		
		if(!isset($_POST['user_pass']))
		{
			 $errors[] =  'The password field cannot be empty';
		}
		if(!empty($errors))
        {
	   echo '<div class="alert alert-danger">';
		   echo'Uh-oh..a couple of fields are not filled properly';
		   echo '<ul>';
			foreach($errors as $key => $value)/* walk through the array so all the errors get displayed */
			{
				echo '<li>' .$value. '</li>';/* this generates a nice error list */
			}
		   echo'</ul>';
		   echo'</div>';
      }
	  else
	  {
		   //the form has been posted without errors,so save it
		   //notice the use of mysqli_real_escape_string function
		   //also notice the sha1 function which hashes the password
		 $username = $_POST['user_name'];
		 $username = mysqli_real_escape_string($conn,$username);
		 $sql = "SELECT user_id,user_name,user_level FROM `forum_users` WHERE user_name = $username and user_pass= '" .sha1($_POST['user_pass'])."' ";
		 $result = $conn->query($sql);
		 if(!$result)
		 {
			 echo '<div class="alert alert-danger">
			 Something went wrong while registering. Please try again later.
		    </div>';
		 }
		 else
		 {
			 //the query was succesfully executed,there are tow possiblities
			 //1.the query returned data,the user can be signed in
			 //2.the query returned an empty result set,the credential were wrong
			 if($result->num_rows==0){
				 echo '<div class="alert alert-danger">';
			     echo 'You have supplied a wrong username/password combination.';
		         echo '</div>';
			 }
			 else
			 {
				 //set the $_SESSION['signed_in'] variable to true
				 $_SESSION['signed_in'] = true;
				 while($row=$result->fetch_assoc()){
					 $_SESSION['user_id'] = $row['user_id'];
					 $_SESSION['user_name'] = $row['user_name'];
					 $_SESSION['user_level'] = $row['user_level'];
				 }
				 echo 'WELCOME, ' .$_SESSION['user_name'].'<a href="index.php">Proceed to fourm overview</a>';
				 
			 }
		 }
		  
	  }
	 }//form posted
 }

echo '</div>';

include 'footer.php';
?>

any help will be highly appreciated ..thanks

please bare with me for using html inside echo..me new to php and still learning

I was following atutorial on how to make a php mysql forum

but the problem is after i click submit in the singup form its not adding users to database and neither it shows any errors

any idea whats wrong?

here is my code

all sql for tables

CREATE TABLE forum_users (
 user_id int(8) NOT NULL AUTO_INCREMENT,
 user_name varchar(30) NOT NULL,
 user_pass varchar(255) NOT NULL,
 user_email varchar(255) NOT NULL,
 user_date DATETIME NOT NULL,
 user_level int(8) NOT NULL,
 UNIQUE INDEX user_name_unique (user_name),
 PRIMARY KEY(user_id)
)ENGINE =INNODB;

CREATE TABLE forum_categories(
 cat_id INT(8) NOT NULL AUTO_INCREMENT,
 cat_name VARCHAR(255) NOT NULL,
 cat_desctription VARCHAR(255) NOT NULL,
 UNIQUE INDEX cat_name_unique (cat_name),
 PRIMARY KEY (cat_id)
)ENGINE =INNODB;

CREATE TABLE forum_topics(
 topic_id INT(8) NOT NULL AUTO_INCREMENT,
 topic_subject VARCHAR(255) NOT NULL,
 topic_date DATETIME NOT NULL,
 topic_cat INT(8) NOT NULL,
 topic_by INT(8) NOT NULL,
 PRIMARY KEY (topic_id)
)ENGINE =INNODB;

CREATE TABLE forum_posts(
 post_id INT(8) NOT NULL AUTO_INCREMENT,
 post_content  TEXT NOT NULL,
 post_date DATETIME NOT NULL,
 post_topic INT(8) NOT NULL,
 post_by INT(8) NOT NULL,
 PRIMARY KEY (post_id)
)ENGINE =INNODB;

table relations sql

--link the topics to the categories ..adding foreign key so that  a category gets deleted from the database, all the topics will be deleted too

ALTER TABLE forum_topics ADD FOREIGN KEY(topic_cat) REFERENCES forum_categories(cat_id) ON DELETE CASCADE ON UPDATE CASCADE;

--link the topics to the user...the user can't be deleted as long as there are still topics with the user id of the user.

ALTER TABLE forum_topics ADD FOREIGN KEY(topic_by) REFERENCES forum_users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE;

--link the  posts to the topics:...--

ALTER TABLE forum_posts ADD FOREIGN KEY(post_topic) REFERENCES forum_topics(topic_id) ON DELETE CASCADE ON UPDATE CASCADE;

--link the  posts to the users...

ALTER TABLE forum_posts ADD FOREIGN KEY(post_by) REFERENCES forum_users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;

connect.php

<?php
  $servername ="localhost";
  $username = "root";
  $password ="";
  $dbname ="projects";
 
  
  //create connection_aborted
  $conn = new mysqli($servername,$username,$password,$dbname);
  
  //check connection
  if($conn->connect_error){
	 die("Connection failed : ".$conn->connect_error);
  }
?>

header.php

<!DOCTYPE html>
<html lang = "en">
 <head>
  <title>Forms</title>
	  <meta charset = "utf-8">
	  <meta name = "viewport" content = "width=device-width , initial-scale =1">
	  <link rel="stylesheet" href="css/bootstrap.min.css">
	  <script src = "js/jquery-3.4.1.min.js"></script>
	  <script src = "js/bootstrap.min.js"></script>
	  
 <style>
   
 </style>
 </head>
<body>

  <nav class="navbar navbar-inverse">
  <div class="container">
    <div class="navbar-header">
      <a class="navbar-brand" href="#">Forum</a>
    </div>
    <ul class="nav navbar-nav">
      <li class="active"><a href="index.php">Home</a></li>
       <li><a href="create_topic.php">Create Topic</a></li>
      <li><a href="create_category.php">Create Category</a></li>
    </ul>
    <ul class="nav navbar-nav navbar-right">
	  <li><a href="#"><span class="glyphicon glyphicon-log-in"></span> Login</a></li>
	   <li><a href="signup.php"><span class="glyphicon glyphicon-user"></span> Signup</a></li>
      <!--<li><a href="#"><span class="glyphicon glyphicon-log-out"></span> Not you? Logout</a></li>-->
    </ul>
  </div>
</nav>
  <div class="container">
     <div class="row">
	 
	

footer.php

 </div><!--row-->
   
  </div><!--container-->
   
   <div id="footer">
     <div class="container">
	 </div><!--container-->
   </div><!--footer-->

   
</body>

</html>

signup.php

<?php
// ini_set('display_errors','1');
// error_reporting(E_ALL);
//create_cat.php
include 'connect.php';
include 'header.php';

echo '<div class="col-md-12">';
echo '<h3>Sign up</h3>';
/*the form hasn't been posted yet, display it
      note that the action="" will cause the form to post to the same page it is on */
if($_SERVER['REQUEST_METHOD'] != 'POST'){
	echo '<form action="signup.php" method ="post">
		
		 <div class="form-group">
		   <label for ="usr">Username:</label>
		   <input type="text" name="user_name" class="form-control" id="usr" placeholder="username" required>
		 </div><!--form-group-->
		  
		<div class="form-group">
			<label for ="email">Email address:</label>
			<input type="email" name="user_email" class="form-control" id="email" placeholder="email" required>
		</div><!--form-group-->
		
		<div class="form-group">
			<label for ="pwd">Password:</label>
			<input type="password" name="user_pass" class="form-control" id="pwd" placeholder="password" required>
		</div><!--form-group-->
		
		<div class="form-group">
			<label for ="pwd_again">Password Again:</label>
			<input type="password" name="user_pass_check" class="form-control" id="pwd_again" placeholder="retype password" required>
		</div><!--form-group-->
		
		
		<button type="submit" class="btn btn-success">Add Category</button>
	   </form>';
}else{
	/* so, the form has been posted, we'll process the data in three steps:
        1.  Check the data
        2.  Let the user refill the wrong fields (if necessary)
        3.  Save the data 
    */
  $errors = array();/* declare the array for later use */
  if(isset($_POST['user_name']))
  {
	  //the username exists
	  if(!ctype_alnum($_POST['user_name']))
	  {
		  $errors[] =  'The username can only contain letters and digits';
	  }
	  if(strlen($_POST['user_name'])>30)
	  {
		  $errors[] =  'The username cannot be longer than 30 characters';
	  }
  }
  else
  {
	  $errors[] =  'The username field must not be empty';
  }
  if(isset($_POST['user_pass']))
  {
	  if($_POST['user_pass'] != $_POST['user_pass_check'])
	  {
		   $errors[] =  'The two fields did not match';
	  }
  }
  else
	  {
		  $errors[] =  'The password field cannot be empty';
	  }
  if(!empty($errors))
  {
	  echo '<div class="alert alert-danger">';
	   echo'Uh-oh..a couple of fields are not filled properly';
	   echo '<ul>';
	    foreach($errors as $key => $value)/* walk through the array so all the errors get displayed */
		{
			echo '<li>' .$value. '</li>';/* this generates a nice error list */
		}
	   echo'</ul>';
	  echo'</div>';
  }
  else
  {
	  //the form has been posted without, so save it
        //notice the use of mysql_real_escape_string, keep everything safe!
        //also notice the sha1 function which hashes the password
		$sql = "INSERT INTO forum_users(user_name,user_pass,user_email,user_date,user_level)
		       VALUES('" .mysql_real_escape_string($_POST['user_name'])."',
			   '" .sha1($_POST['user_pass'])."',
			   '" .mysql_real_escape_string($_POST['user_email'])."',
			   NOW(),0)";
			   if($conn->query($sql) === TRUE)
			   {
				   echo '<div class="alert alert-success">';
				    echo 'Successfully registered. You can now <a href="signin.php">sign in</a> and start posting! :-)';
				   echo '</div>';
			   }
			   else
			   {
				   echo '<div class="alert alert-danger">';
				    echo 'Something went wrong while registering. Please try again later.';
				   echo '</div>';
			   }
  }
}
echo '</div>';

include 'footer.php';
?>