Location: PHPKode > projects > JaxBlog > JaxBlog/app/install/install_database/install_database.html
<div class="story">
	<div class="story_title">Database Check</div>
	<div class="story_content">
		<form action="install_database.php" name="check_form">
		<input type="hidden" id="check_action" name="check_action" value="">
		
		<p style="margin-bottom: 20px;">
			The following is a set of installation checks.  Once all checks have passed you will 
			be allowed to proceed to the installation confirmation page.
		</p>
		<table>
			<tr>
				<td>Changed Database and Admin Credentials</td>
				<td id="database_credentials"></td>
			</tr>
			<tr>
				<td>Connect to database</td>
				<td id="database_check_connection"></td>
			</tr>
			<tr>
				<td>Access tables specific to JaxBlog</td>
				<td id="database_check_table_access"></td>
			</tr>
		</table>
		<p id="message_stage_0" style="display: none; visibility: hidden; font-size: 1.4em;">
			JaxBlog will not install until you have changed the database and administrative 
			login usernames and passwords below.  Please make your changes and click the update 
			button at the bottom of the page.
		</p>
		<p id="message_stage_1" style="display: none; visibility: hidden; font-size: 1.4em;">
			JaxBlog is unable to create a connection to the database.  Please update the database
			connection information listed below and click Update Configuration, or check that
			your database is running and rerun the database check.<br /><br />
			<input type="submit" name="check_rerun_1" value="Rerun Database Check" onClick="document.getElementById('check_action').value = 'rerun';" />
		</p>
		<p id="message_stage_2" style="display: none; visibility: hidden; font-size: 1.4em;">
			JaxBlog is able to connect to the database but cannot find the tables it needs. If you
			would like to create these tables from scratch, allow me to do so for you:<br /><br />
			<input type="submit" name="check_create" value="Create JaxBlog Tables" onClick="document.getElementById('check_action').value = 'create';" /><br /><br />
			
			If you have connected to the wrong database by accident, please update the database
			configuration information listed below.<br /><br />
			
			If you would like to rerun the database check, use the following button to do so.<br /><br />
			<input type="submit" name="check_rerun_2" value="Rerun Database Check" onClick="document.getElementById('check_action').value = 'rerun';" />
		</p>
		<p id="message_stage_3" style="display: none; visibility: hidden; font-size: 1.4em;">
			Success! You have passed the database check. Please continue on to the 
			<a style="font-weight: bold; color: green;" href="../install_confirm/install_confirm.php">Installation Confirmation</a> 
			page.
		</p>
		
		</form>
	</div>
	<div class="story_footer"></div>
</div>

<div class="story">
	<div class="story_title">Database Configuration</div>
	<div class="story_content">
		<form name="form1" action="install_database.php?request=configure" method="POST">
		
		<h2>Database</h2>
		<p style="margin-bottom: 20px;">
			JaxBlog will not attempt to connect to a database until you have changed the username
			and password listed below from the default.  You MUST change them.
			
			<span id="note_postgres" style="font-size: .8em; color: red; display: none; margin-top: 10px;">
				Note: in order to pass this page, you must have a Postgres database running, and 
				you must have the php extension enabled in your php.ini file.  On a Windows machine, 
				you would uncomment the line "extension=php_pgsql.dll" in php.ini.
			</span>
			<span id="note_mysql" style="font-size: .8em; color: red; display: none; margin-top: 10px;">
				Note: in order to pass this page, you must have a Mysql database running, and you 
				must have the php extension enabled in your php.ini file.  On a Windows machine, 
				you would uncomment the line "extension=php_mysql.dll" in php.ini.
			</span>
			<span id="note_sqlite" style="font-size: .8em; color: red; display: none; margin-top: 10px;">
				Note: in order to pass this page, you must have two php extensions enabled in your 
				php.ini file, one for sqlite and another for pdo, but do not uncomment the pdo-sqlite 
				extension.  On a Windows machine, you would uncomment the lines "extension=php_pdo.dll" 
				and "extension=php_sqlite.dll" in php.ini.<br>
				Also: a sqlite database (version 2) file with the name you give here will appear in 
				your upload folder once you have completed installation.
			</span>
		</p>
		<table>
			<tr>
				<td>
					Database Vendor
				</td>
				<td>
					<select name="database_vendor" id="database_vendor" onChange="flipVendor();">
						<option value="postgres"   >PostGres</option>
						<option value="postgres64" >PostGres 6.4</option>
						<option value="postgres7"  >PostGres 7</option>
						<option value="postgres8"  >Postgres 8</option>
						<option value="mysql"      >MySql</option>
						<option value="mysqli"     >MySql Improved</option>
						<option value="mysqlt"     >MySql w/transactions</option>
						<option value="sqlite"     >SqLite</option>
						
						<!-- Databases that don't work
						<option value="fbsq"       >Frontbase</option> 
						<option value="maxdb"      >Max DB</option>
						<option value="msql"       >Mini SQL</option>
						<option value="mssql"      >Microsoft SQL</option>
						<option value="sybase"     >Sybase</option>
						<option value="sybase_ase" >SyBase ASE</option>
						<option value="sqlitepo"   >SqLite Pro</option>
						-->
					</select>
				</td>
			</tr>
			<tr>
				<td>
					<span id="database_server_label">Database Server</span>
				</td>
				<td>
					<input type="text" value="" name="database_server" id="database_server" />
				</td>
			</tr>
			<tr>
				<td><span id="database_name_label">Database Name</span></td>
				<td><input type="text" value="" name="database_name" id="database_name" /></td>
			</tr>
			<tr>
				<td>Database User</td>
				<td><input type="text" value="" name="database_username" id="database_username" /></td>
			</tr>
			<tr>
				<td>Database Password</td>
				<td><input type="text" value="" name="database_password" id="database_password" /></td>
			</tr>
		</table>

		<h2>Admin Credentials - JaxBlog Login</h2>
		<p style="margin-bottom: 20px;">
			JaxBlog will also not allow you to complete installation until you have
			entered an administrative username and password for logging in to JaxBlog.
		</p>
		<table>
			<tr>
				<td>Admin Username</td>
				<td><input type="text" value="" name="admin_username" /></td>
			</tr>
			<tr>
				<td>Admin Password</td>
				<td><input type="text" value="" name="admin_password" /></td>
			</tr>
		</table>
		
		<p>
			<input type="submit" name="update" value="Update Configuration" />
		</p>
		</form>
	</div>
	<div class="story_footer"></div>
</div>
Return current item: JaxBlog