₦airaland Forum

It is an evolution of VB6 am asking for.
And 'evolution'implies upwards compatibility. Any
VB6 code should be able to be taken forward into
a new product. migrating code from VB6
to VB.Net for a large application is a costly and far
from trivial task. The migration tools I've looked at
have been disappointing. That's why VB is the 7th most popular language and it hasn't had a new release since
1998 whilst VB.Net

I believe in Nairaland for advocacy #giveusenhancedvb6

if VB6 isn't your language of choice, they could be coming for your language next. And I'm not asking for an updated VB6 instead of VB.Net or C# or any other language. I want it as well as those languages. (the last release of VB6 was 1998) is too bad.
#giveusenhancedvb6

dhtml18:
I am not in agreement with your post as such because I use all versions of VB till date. From Visual Basic 6 to 2013.
And what I have to say is that VB.NET and VB 6 are 2 different languages entirely (in a manner of speaking) - the moment you accept that, the better for you.
It is almost like comparing QBasic with Visual Basic 6. Or JavaScript with JAVA (I use all these languages mind you).
Look at JavaScript for example, it is not an object-oriented language, but makes use of object. Compared to JAVA that is a fully featured OOP language.

please note that vb6 was upgraded to vb7 (VB.net)
They are two different language by the same developer. while the stoppage of support in vb6 but keep upgrading VB.net ?

if you code in VB.net that means you will keep buying a newer version every year.
why should we have to migrate it to a new
language ? The Microsoft Office developers
refused to migrate to .Net (OK they are more
powerful than us mere Microsoft customers).
VB6, by the way, works fine on Windows 7 and
8 (and as it uses the C++ compiler it is very
fast).

#giveusenhancedvb6

Yes I am a vb6 coder and I enjoy it.

The failure of VB.Net to be upward compatible with classic VB6 is the main reason. Many support VB6 software - and as you know support includes modifications and enhancements - yet with large application it isn't feasible to migrate them the
Vb.Net.

kindly pledge your support on VB6 until at least 2023 but am are looking for some enhancements to VB6 too. As a minimum we'd like the same modifications that were added to VB7 (64 bit support) to be included in an enhanced VB6.

After all, Microsoft never updated Office to .Net,
why should VB6 coders have to update to .Net ?

@Microsoft #giveusenhancedvb6

dhtml18:
^^^The codes will start showing up very show up very shortly. Please standby. . . .and dont lose your hat (and do stay out of politicks)

I am happy you said you started from visual Basic 6.0.
Please how long do you glue with it before migrating to C and how old are you in coding.

I married VB 6.0 and am enjoying it, with the experience please who should I get married to next?

Just incase you have someone


Already made Final Year project for computer science and as well
design and develop a new program.

08032950881
The list includes:
Final year project documentation management
system
exam malpratice record keeping system
Electronic library
student information management system
online result cheching
computerize school fees payment
membership registration system

To mention but few

All are available

we have already make project and we can as well design and develop a new one for you.

call 08032950881.

The list includes:
Final year project documentation management system
exam malpratice record keeping system
Electronic library
student information management system
online result cheching
computerize school fees payment

membership registration system

To mention but few

uninstall and reinstall your xamp if you backup your tables by exporting it. After installation just import it back

web Design company
www.admotek.com

www.admotek.com
for software development

for your website design
www.admotek.com

caoalvin:
am sorry dere is no way u can get ur money back. fine another host and pay again but ask well this time around. sorry

just like that? what in future to come since I have transaction reference number.

hmm please can you suggest a good web host company for me

His number 07067458707
08091820866

BBC pin 231d163f

caoalvin:
thts why it's good to find out which Hosting company is reliable ask people around you before u pay money. are you sure thts the URL of the company u paid?

I am absolutely sure sir.
9jahoster.com

That is what surprise me. The website was working fine until I paid.

Please nairalander how do I get my money back

That is what surprise me. The website was working fine until I paid.

Please nairalander how do I get a refound

There site as been going true even yestday that I paid until this morning. please what do I do to get my money back ? I use my ATM card to pay

I just paid for hosting yesterday only for to check to and got nothing.

The website is not going, All there numbers are switched off.

The lesson is innovative indeed.
please text me WYSIWYG 10.3 email and serial number am still using trial version.

opeyemiademon@yahoo.com

The lesson is innovative indeed.
please text me WYSIWYG 10.3 email and serial number am still using trial version.

good to catch you here

please I want to upload my form to database using local host Apache and mysql. how do I do that using WYSIWYG?

thanks in anticipation

Dlastofmykind:
I'm also a beginner at web development, but with the little experience that I've had, starting web development with dreamweaver IDE will do you more harm than good.
Peradventure, you wanna code or you wanna correct someone's else code and you're unable to get access to dreamweaver, does that means that you'll not be able to code?
Even if u wanna use dreamweaver, I'll advice you've gotten the basic concepts of all these web languages wella, then dreamweaver will make your work faster.

I guess the above code that you pasted was generated for you by dreamweaver.
Anyway, you can save yourself the headache of trying to figure out the function of each line of the above code with this little explanation of mine.

If you wanna upload any file, these are the procedures:

1). In your HTML form code, ensure that you include this attribute 'enctype='multipart/form-data'.
The form code can then look like this : <form action='' method='post' enctype='multipart/form-data'>

2). set a name for your HTML input type='file' ... I mean in this format : <input type='file' name='photo'/>.
Change the 'photo' to any name of your choice.

3). In your PHP code, to get the name of the file selected, you can use declare a variable for that and use $_FILES to get the name and the tmp name.
e.g $tmp_name = $_FILES['photo']['tmp_name'];
$file_selected = $_FILES['photo']['name'];

where 'photo' is the name set for your input type='file'.

4). Declare a variable for the destination (folder) that the file will be uploaded to.
e.g $folder = 'avatars/';

5). Then, declare a variable for the file path to be saved in the database or in the folder depending on your choice with the extension that you want to use.
e.g $path = $file_selected.'.jpg';

NOTE: If you do this, the file name saved on the client's device (pc or phone) will be the name to be saved into the database.
If you wanna change the name to your desired own, there are many methods for doing that.
You can let it be the logged username or you can generate any unique random numbers.

6). Then, to upload the file to the folder that you specified, u can use move_uploaded_file(parameter1, parameter2) function.
where parameter1 is the tmp location and parameter2 is the path.
e.g move_uploaded_file($tmp_name, $path);

7). Then use your sql insert query to save the path to the db.
e.g "INSERT INTO `files` (path) VALUES('$path')"


If you follow these 7 steps appropriately, I'm very sure that your problem will get solved.

There are other things that can be done to this, like restricting the file to be uploaded to accept only pictures, or videos, or musics, resizing the picture to a particular size before been uploaded, checking if the destination folder exists, making sure that the file to be uploaded does not exceed a particular size.
Your PHP manual is your best friend and you can as well get that in google, but don't always resort to googling for source codes, it'll make you lazy programmer.

CHEERS!!!

Thankx I will give it a try

thewebcraft:
Can write this code in 20 lines..Na wa oh! for Image Upload?........ and besides you dont comment your code.

actually it is dreamweaver that generate the code for me i can only explain little about it.

please find time to review my script

onyengbu:
Ol boy, he is not here for reviews. So keep your bragging for someone else.




Let me go through it...

Edit:
All your form inputs but one is file upload and your script do not have a file upload script. If you get any submissions in the database at all it will just be names of the files attached and not the actual file. There are a couple of questions that will help anyone to work on your script. Like:

What exactly are you trying to submit the files or the file names? What will students or staff do with submitted files?

Thanks for your response.
i have file upload here is the code:


if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1") {
$insertSQL = sprintf("INSERT INTO photograph (RegNo, Passport, Undertaking, Sorigin, Addletter, declaration, Olevel) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['RegNo'], "text",
GetSQLValueString($_POST['Passport'], "text",
GetSQLValueString($_POST['Undertaking'], "text",
GetSQLValueString($_POST['Sorigin'], "text",
GetSQLValueString($_POST['Addletter'], "text",
GetSQLValueString($_POST['Declaration'], "text",
GetSQLValueString($_POST['Olevel'], "text");

mysql_select_db($database_SIMSDatabase, $SIMSDatabase);
$Result1 = mysql_query($insertSQL, $SIMSDatabase) or die(mysql_error());

$insertGoTo = "congratulation.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_SIMSDatabase, $SIMSDatabase);
$query_photograph = "SELECT * FROM photograph";
$photograph = mysql_query($query_photograph, $SIMSDatabase) or die(mysql_error());
$row_photograph = mysql_fetch_assoc($photograph);
$totalRows_photograph = mysql_num_rows($photograph);
?>

To answer your questions
1. I am trying to submitted the file itself but someone suggested file reference (i.e to create a folder and link it to db) anyone that work for me i will take it for the purpose of this project

2. Title "development of student information management system a case study of my school" student information can only be access by staff. this project is to remove the manual method of registration in my school. (i.e paper record) with web base student can upload there information online and School management can get access to it.

please dont mind my typo

Please note "photograph" is my database name it contains 7 tables namely:
1. Registration number - regno
2. passport photograph to be uploaded by student - passport
3. Declaration of age - Scan copy
4. O level result - olevel
5. Certificate of origin - Sorigin
6. Admission letter - addletter
7. Letter of under taking - undertaking

HERE IS MY SCRIPT

<?php
mb_http_input("iso-8859-1";
mb_http_output("iso-8859-1";
?>
<?php require_once('Connections/SIMSDatabase.php'); ?>
<?php
if (!function_exists("GetSQLValueString") {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string" ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "" ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "" ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1") {
$insertSQL = sprintf("INSERT INTO photograph (RegNo, Passport, Undertaking, Sorigin, Addletter, declaration, Olevel) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['RegNo'], "text",
GetSQLValueString($_POST['Passport'], "text",
GetSQLValueString($_POST['Undertaking'], "text",
GetSQLValueString($_POST['Sorigin'], "text",
GetSQLValueString($_POST['Addletter'], "text",
GetSQLValueString($_POST['Declaration'], "text",
GetSQLValueString($_POST['Olevel'], "text");

mysql_select_db($database_SIMSDatabase, $SIMSDatabase);
$Result1 = mysql_query($insertSQL, $SIMSDatabase) or die(mysql_error());

$insertGoTo = "congratulation.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_SIMSDatabase, $SIMSDatabase);
$query_photograph = "SELECT * FROM photograph";
$photograph = mysql_query($query_photograph, $SIMSDatabase) or die(mysql_error());
$row_photograph = mysql_fetch_assoc($photograph);
$totalRows_photograph = mysql_num_rows($photograph);
?>

</style>
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<meta name="save" content="" />
<meta name="keywords" content="adeleke" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="description" content="" />
<script src="jQueryAssets/jquery-1.8.3.min.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
</head>

<body>
<div id="Layer19">
<table width="100%" border="1">
<tr>
<td><form action="<?php echo $editFormAction; ?>" id="form1" name="form1" enctype="multipart/form-data" method="POST">
<p> NOTE: All your document should not be more than 60kb</p>
<p>&nbsp;</p>
<p>
<label for="Passport">Passport</label>
<input name="Passport" type="file" id="Passport" size="40" />
</p>
<p>
<label for="Undertaking">Letter of Undertaking</label>
<input name="Undertaking" type="file" id="Undertaking" size="40" />
</p>
<p>
<label for="Sorigin">Certificate of Origin</label>
<input name="Sorigin" type="file" id="Sorigin" size="40" />
</p>
<p>
<label for="Addletter">Admission Letter</label>
<input name="Addletter" type="file" id="Addletter" size="40" />
</p>
<p>
<label for="Declaration">Certicate of birth/declaration of age</label>
<input name="Declaration" type="file" id="Declaration" size="30" />
</p>
<p>O Level Result
<input name="Olevel" type="file" id="Olevel" size="30" />
</p>
<p>
<label for="RegNo">Reg No</label>
<span id="sprytextfield1">
<input type="text" name="RegNo" id="RegNo" />
<span class="textfieldRequiredMsg">Please Insert Your Registration Number.</span></span></p>
<p>&nbsp;</p>
<p>
<input type="radio" name="radio" id="radio" value="radio" />
<label for="radio"></label>
I hereby certify that to the best of my knowledge and belief, that the information given as above are correct. </p>
<p>&nbsp;</p>
<p>
<input name="Submit" type="submit" class="style15" id="Submit" value="Upload" />
</p>
<input type="hidden" name="MM_insert" value="form1" />
</form></td>
</tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</div>
<div class="style12" id="Layer1"> <marquee>
<span class="style12"> <span style="font-size: 24px; color: #0000FF;">.::::STUDENTS INFORMATION MANAGEMENT SYSTEM::::.</span></span>
</marquee></div>
<p><img src="Picture/p1.jpg" width="1200" height="242" alt="PORTAL" /></p>
<p>&nbsp;</p>
<div id="Layer21"><a href="homepage.php">LOG OUT</a> </div>
<script type="text/javascript">
var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1";
</script>
</body>
</html>
<?php
mysql_free_result($photograph);
?>

Guyson:
They advised you correctly but if youu still want to do it that way, your insert statement will be

Example

$sql = "INSERT INTO tableName(image, name) VALUES ('{$imgData}','{$_FILES['userfile']['name']}');";

error message "passport can not be null " even when I upload pix

onyengbu:
Your problem is common with beginners because you will want to insert image data into the database just like you inserted every other thing in your form. Even though that is possible, it is not the best approach as you will soon find out in your web development journey.
The better approach as someone has already pointed out is to "UPLOAD" the image file to a directory (folder) in your server, give it a unique name and then save the path (link) to the uploaded image inside your database alongside other details from your form. So that instead of a blob data type, you may create a "text" or "varchar" data type for your image in the table.
With this method, you are not saving the raw image data in the database but the "link" to the image so that when you want to display the image anywhere, you you write you normal <img tag and where you will put the src="" part, you put the "link" you saved in the database there and by so doing, you display the image from the "folder" where it was uploaded.

The summary of the simplest approach to the problem is:

1. Within your form submit script, create a file upload function to check if a picture is attached in the form and if so upload it to a folder in your sever

2. The function above should also be able to get details of the uploaded image like name, size and type. Get the name of the image and join it to the PATH to the upload folder and that becomes the image path.

3. Insert the image path alongside other student details collected from the form to the table. For e.g, if the name of your folder is "uploads" and the name of image being attached is "picture.jpg"; what will be saved in your database becomes "uploads/picture.jpg"

All these might appear confusing but just with a few questions and little bit of googling, you will be good to go.

hmmmmm sound simple but difficult to implement. please note that this project is not computerize I.e software but web base whereby student will supply information themselves.

I do as you said but it only save the directory and when I click on it. it display bulk of codes. This project will display acknowledgement slip for each student containing their passport. These are instruction from my supervisor.

I appreciate your concern