₦airaland Forum

Excellent job bro. This is exactly what I need. Keep me updated on new projects.

Anyone with all this skills should be already working with Google or Facebook. I qualify for this job, but I don't use any framework or cms. I could quickly learn them tho.

Carry on Bro.

First things first. Study hard and tight for your jamb and post-utme. You can always become the best web developer the world has ever seen, but you won't always be at the appropriate age for university education. For your web developer skills to to be taken serious, you need a good degree, atleast in this part of the world.
I just graduated from uni, and now I'm back to learning advanced stuff in web development. In a way I can say 'I totally understand the way you are feeling'. You can email me on: victorighalo 'at' live.com for more advise. Take care.

Problem solved. I had to restart my local server where my app was running. I also had to use prepared statement.

I've updated the script. Yes to your question, I have a query string in my address. The first MySQL query is matching a Where clause with '$artID' and the second is matching the variable '$ID'

chars($_SERVER["PHP_SELF"]);?>">
<?php
$ID= $_GET['id'];
$query = "SELECT * FROM music WHERE musicID = $ID";
$result= mysqli_query($connection, $query);
$row = mysqli_fetch_array($result);
$artID = $row['IDartiste'];
$query2 = mysqli_query($connection,"SELECT music.*, artiste.* FROM music INNER JOIN artiste ON music.IDartiste=artiste.artisteID WHERE artiste.artisteID = $artID";
$row2 = mysqli_fetch_array($query2);
?>
<!-- Artiste name field--> <div class="form-group">
<label for="topic" style="color: #55AAFF">Artiste name:</label>
<input type="text" class="form-control" name="artisteName" value="<?php echo $row2['artisteName'];?>" required autofocus>

<label for="sel1" style="color: #55AAFF">Artiste's continent:</label>
<select class="form-control" id="sel1" name="continent">
<option><?php echo $row2['continent'];?></option>
<option>African</option>
<option>English</option>
<option>European</option>
<option>Asian</option>
</select>
<label for="topic" style="color: #55AAFF">Artiste nationality:</label>
<input type="text" class="form-control" name="nationality" value="<?php echo $row2['nationality'];?>" required autofocus>
</div>

<!-- Article topic field--> <div class="form-group">
<label for="topic" style="color: #55AAFF">Music title:</label>
<input type="text" class="form-control" name="title" value="<?php echo $row['musicTitle'];?>" autofocus>
</div>

<!--Article textarea--> <div class="form-group">
<label for="body" style="color: #55AAFF">Content (text):</label>
<textarea name="article" class="form-control"><?php echo $row['musicArticle'];?>
</textarea>
</div>

<!-- Upload image start--> <div class="col-ms-6 col-xs-12" >
<div class="panel panel-default">
<div class="panel-heading" style="color: #55AAFF">Upload Image</div>
<div class="panel-body">
<iframe src="fileupload.php" width="100%" style="border:none"></iframe>
</div>
</div>
</div>
<!--Image link field--> <div class="form-group">
<label for="image_link" style="color: #55AAFF">Input image link: </label>
<input type="text" name="image" value="<?php echo $row2['artistePhoto'];?>" class="form-control"/>
</div>

<!-- Upload music start--> <div class="col-ms-6 col-xs-12" >
<div class="panel panel-default">
<div class="panel-heading" style="color: #55AAFF">Upload Music</div>
<div class="panel-body">
<iframe src="music_file_upload.php" width="100%" style="border:none"></iframe>
</div>
</div>
</div>

<!--Music link field--> <div class="form-group">
<label for="music_link" style="color: #55AAFF">Input music link: </label>
<input type="text" name="file" class="form-control" value="<?php echo $row['musicFile'];?>"/>
</div>
<center>....<button type="submit" class="btn btn-default" id="btnsubmit" name="btnsubmit" style="color: #55AAFF">Update</button>....</center>


<br />
</form>
</div>

<?php
if(isset($_GET['btnsubmit']
date_default_timezone_set('Africa/Lagos');

$setdate= date('Y-m-d-h-m-s');

$date= strftime($setdate);

$time= strftime('%X');

$artiste = $_GET["artisteName"];

$title = $_GET["title"];

$article = $_GET["article"];

$artisteImage = $_GET["image"];

$musicFile = $_GET["file"];

$artisteContinent = $_GET['continent'];

$nationality = $_GET["nationality"];

$sql_artiste = "UPDATE kingdomjoy.artiste SET artisteName = '$artiste', nationality = '$nationality' , continent = '$artisteContinent' WHERE artiste.artisteID='$artID'";
$artisteupdate = $connection->query($sql_artiste);
if ($artisteupdate === TRUE) {
echo"<script>swal('Success! artiste library updated')</script>";
} else {
echo "Error: " . die(mysqli_error($connection));
}
$sql_music = "UPDATE music SET musicTitle = '$title', musicFile = '$musicFile', musicPhoto = '$artisteImage', musicArticle = '$article', entryDate = '$date' WHERE musicID = $ID";
$musicupdate = $connection->query($sql_music);
if ($musicupdate === TRUE) {
echo"<script>swal('Success! music library updated')</script>";
} else {
echo "Error: " . die(mysqli_error($connection));
}
}
?>
</div>

I have a challenge with updating records in my mysql database. It only updates when I put in the row id manually but when I put the dynamic variable ($newid=&_get[`id:]) it doesn't work. Somehow the variable becomes undeclared at (if(isset($_get[`submit`] )) { //update code}.
Gurus, help me out. Thanks.

@firsteva.... You're too funny. Local governments in a romantic relationship. It sounds cool tho. You are right, I was given the subject to write on and it seems the level of cooperation among local governments is very low.

what is the fiscal, economic, administrative and political relationship among local governments in nigeria

Ask God to help through prayers and tell him to spend more time studying the bible, that's where the solution is.

Dull guy.....

Hi dear, if you cannot design the logo, you either pay someone to do it (me) or get a free logo design software (online and offline) to do it. If you don't know how to insert the image, then you can upload it to a photo storage site (photobucket) and place the link to the logo where the company name is.

Thanks guys. I would appreciate it if anyone here have had similar problem

Hello, i am a final year student of Uniben. I just checked my jamb admission letter and realized that instead of a Bachelor in Science, I was given a Bachelor in Arts. My concern is if this will affect my clearance or NYSC posting

I'll suggest using PHP. On the user's post form add a section for scheduling post-with a select button for schedule then date and time of post. Create columns for schedule(Enum), schedule date and time(Date and Time) in your database.
Thn on the page where u loop the user's post, make conditions- that checks if $shedule is ==1 and the date and time from ur db matches d current time before loop. Then and Elseif to loop all others date have $schedule ==0.

Hope this makes any sense.

thewebcraft:
What are you trying to achieve

I'm tring to sanitize my urls.... To remove those nasty "?id=66" and others. I eventually got it to work, but it doesn't modify the urls automatically.

WaffenSS:
Brazenly plagiarized by poster from the link you gave from here

http://www.sitepoint.com/8-things-wish-id-known-started-developer/

to impress the gullible.

this is shameful and unethical.

Didn't anyone see this? OP is a fraud.

I'm trying to modify my urls using .htaccess rewrite directive on my local system(running wamp). The prob is that it's not working. All I get is a "500 Internal server error"

Webcraft, abeg help me out. I'm trying to modify my urls using .htaccess rewrite directive on my local system(running wamp). The prob is that it's not working. All I get is a "500 Internal server error"

Still requesting

donbenedict:
lool bro, am doing just like the way u did. am currently in w3schools.com. can i hav your contact so you can be putting me through some things if i dont understand? please?

Cool... Keep it up.

infinitycane:
please I have interest on programming. i studied
marketing in The university. I am conversant with
PC and devices ( No Phobia ) for technology. I
want to start Learning how to programme and
develop softwares on my own due to the speed the
world is moving with ICT i need it in my discipline.
I dont know anything about programming language
( ie am a zero). How do I start?.

My brother. I started out like you, but today I make php programs for offline and online solutions. I spent hours nd nights studying and practicing. I failed so much at my attempts, but I kept strong nd refused to quit. My advise: if u wanna go into web dev, start reading books on html. Virtually, spend hours on w3schools. Goodluck.

An unresponsive web app at this time of the www?

I also have a white Q10 with every part perfect, but the panel. It has refused to boot after all d flashing attempts.

I have a Q10 with a bad motherboard. If u have a working motherboard for sale indicate. Else if u need any of its parts indicate.

DunMorris, if u snd me th data u want to insert, I can help u with it ina flash

Piece of cake. Just do it with Bootstrap rows and columns, and save urself a lot of hassles. Even in a loop it'll work like magic.

Good job @ OP. Ebooks on HTML and CSS are important for newbies. Even though there are tutorial websites, they are not still enough to acquire in-depth knowledge on the subject.
Newbies read up, the journey is far...

08062239670

08062239670